Why Don't I have a Preferred Replica?

The client reported that the log file on their main database was growing unusually large, and when they checked the...

Working with Consultants

After being immersed into the consulting world again for 6 months now, I’ve gotten to work with clients in several...

YouTube Channel Update: 27 April 2018

Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos...

180 – Is It Time For A Turnaround?

What needs to change? The challenge to explore is are there things in your current day to day that needs...

Check health and status of Availability Group using DMVs

-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members

-- Health of the AGsSELECT...

dbachecks – Going parallel – Cut off your execution times

On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...

Embeded PowerBI

Embeded PowerBI

Execution Plan Shortcoming in Extended Events

I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...

Gather Always On Configuration using a DMV query

If you were like me, you would know your AG configuration by heart. However, what if you get busy with...