PowerShell Function to Get Query Store Data Across Multiple Databases

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 the one that has the […]

Read More »

Uploading New R Library Packages

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 to six different servers but […]

Read More »

Monitoring Availability Groups Part 2 – SQL Agent Alerts

This entry is part 2 of 2 in the series Monitoring Availability Groups

This entry is part 2 of 2 in the series Monitoring Availability GroupsIn 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 […]

Read More »

Monitoring Availability Groups Part 1 – Perfmon Counters

This entry is part 1 of 2 in the series Monitoring Availability Groups

This entry is part 1 of 2 in the series Monitoring Availability GroupsMonitoring 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 […]

Read More »

Running SQL Scripts Against Multiple Servers Using PowerShell

In this post I’m going to share a function I use run scripts against multiple instances of SQL servers and run the data into a GridView. I use this mainly for a replacement of the CMS feature of running against a folder and to put the output to a GridView that I can sort and […]

Read More »