billg.sqlteam.comBill's SQL Server Blog

SQLTeam.com Consulting RSS Subscribe Menu Page 1 of 25 Older Posts IsItSQL 2.0 Bill Graziano on Is It SQL , SQL Server | 20 Jan 2024 I’ve been making small improvements in IsItSQL and finally released a new version. The goal of the application is for non-SQL Server experts to be able to see quickly if SQL Server is having a problem. It also works for my clients to send screen shots so I can see what is happening.… SQL Server Desired State Configuration Bill Graziano on Desired State Configuration | 01 Jul 2020 At one of my clients, I’ve seen the benefits of using tools like Puppet to push configurations to servers. I’ve long tried to write idempotent configuration scripts for my servers. Those are scripts that can be run multiple times without changing the end result. They try… Naming Linked Servers v2 Bill Graziano on SQL Server , linked-servers | 28 Apr 2020 I’ve always had a love-hate relationship with linked servers. On one hand, they are very easy to use and query. On the other they can be a pain to configure, secure, and performance tune. I wrote about naming linked servers [https://billg.sqlteam.com/2011/08/15/how-to-name-linked-servers/… ClearTrace for Extended Events Bill Graziano on ClearTrace , SQL Server | 07 Jul 2019 I found the time to update ClearTrace to support Extended Events. You can download ClearTrace for Extended Events [https://www.scalesql.com/cleartrace/download/] from my corporate site. A few notes about this build * It’s a very early release. Everything seems to work for me and it passes… Running GO as a Windows Service Bill Graziano on go | 16 Jul 2018 Lately I’ve been spending time writing GO (or GOLANG) applications. I’m a big fan of the language. Often what I write needs to run as a Windows service. I’ve found a few things you can do to make your life easier. Use a Shell… Send SQL Server Extended Events to Logstash (ELK) Bill Graziano on SQL Server | 13 Jun 2018 ELK (or Elastic Search, Logstash, Kibana) is taking over one of my clients. And I have to admit it’s a very handy tool. They are pushing all their logs into it and it’s ver easy to search them. Fair warning: My ELK skills and knowledge are… SQL Server Extended Events in Production Bill Graziano on sql , audit , logging | 16 May 2018 I have finally jumped on the Extended Events bandwagon. It was tough to pry Trace and Profiler from my cold, legacy hands! But I’m mostly there. I’m still working on a good way to hook up ClearTrace to these things. It might be as simple as… Is It SQL - 1.0.28 now with better AG backups Bill Graziano on Is It SQL | 15 May 2018 It’s finally time to push another release of Is It SQL [https://www.scalesql.com/isitsql/] out the door. This has a few big features I’ve been working on. Backups First, it handles remote Availability Group backups properly. In an AG, you can run a backup… Get a Phone Alert When a Query Finishes Bill Graziano on SQL Server | 04 Oct 2017 Today, through various snafus and situations, I found myself waiting a LONG time for a lock to clear up. Here’s how I got an alert to pop up on my phone (an iPhone) when that stupid SPID finally rolled back. You’ll need to have database mail… Is It SQL - 1.0.27 Bill Graziano on Is It SQL | 27 Jul 2017 I’d like to tell you this release has some great unifying theme. It doesn’t. It’s just a bunch of things I felt like fixing. But let’s start with tags. That’s what I originally wanted to focus on for this release.… Page 1 of 25 Older Posts Theme Attila by zutrinken Published with...