Recently I came across on Twitter a question from Chad Smith asking for advise on attending his first SQLSaturday. The fact is asking means he is already ahead of the game and he is on Twitter. I got him to follow me on Twitter and offered him the following the
As part of upgrading our SQL Servers to 2017 CTP 2.1 we have a process that runs afterwards that uses Invoke-Sqlcmd cmdlet but with SQL Server 2017, SQL Server PowerShell 2017 is a separate install from the PowerShell Gallery. So I wrote a process to that will install the SQL
I had a recent project to enable backup encryption on all our servers. Then question from the storage team came up will this required additional space. Well by then I had already enabled in all our test servers so I wrote a query that would compare the average size of
In SQL Server 2016, Microsoft introduced to us the Query Store. This has been proven to be a very beneficial feature especially at my job, saved the day on Christmas Eve. One of the limitations if see is when you have server with several databases on it trying to find
Somehow I have become the R DBA at my job which I don’t mind, I plan on taking Microsoft’s Professional Program on Data Science to be familiar with it. But recently I’ve had to upload files to our R servers which the first time wasn’t too bad. Copy these files
In my last post on monitoring Availability Groups I covered looking at Perfmon Counters now we take a look at getting alerts from SQL Agent. When it comes to checking on your Availability Groups one of the easiest ways to keep track at a high level of the health of
At my first official DBA job, I was being trained the current DBA on deploying stored procedures. They had system where you received a ticket with the SQL file attached. You proceed to see if the procedure existed and if it did. You right click on it and look at
Monitoring Availability Groups can be tricky. The DMVs don’t update the log_send_rate and redo_rate all the time especially if nothing is happening so if you try to use those for calculations when monitoring you could false results worse yet pages in the middle of the night. In order to calculate the log_send_rate
Update: From time to time I get questions on this blog post and since I have wrote it dbatools has come out with method do this and if you have not checked out dbatools you should. Click here to get started with dbatools and here (Invoke-DbaQuery) to see the function