On the continuity of business

With entire countries shutting their borders, and people being forced to stay home and isolate themselves for as long as possible while health departments ramp up to handle this...

Telecommute Resources

This is a summary of potential resources for any tech person who is interested in working from home – temporarily or full time. It came about from a twitter...

T-SQL Tuesday #124 – Monitoring Query Store’s Impact on Your System

This month’s T-SQL Tuesday blogging party is brought to you well by me and I wanted to talk more about Query Store.  I did write a book on it...

"What did it take to become a MVP?"

@william_a_dba what did it take to become a MVP?— kennyb7322 (@kennyb7322) March 3, 2020

This tweet made me pause. I'll explain.Backstory (skip if you're not interested):On Sunday March 1,...

Modernizing Your T-SQL: Trimming Strings

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...

Modernizing Your T-SQL: Trimming Strings

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...

T-SQL Tuesday #124 – Query Store Summary

Happy St. Patrick’s Day (are you wearing something green)!  For March I asked everyone to blog something related to Query Store, here is a summary of in alphabetical order...

T-SQL Tuesday #124 Query Store and Spin Locks #tsql2sday

This month’s T-SQL Tuesday invitation comes from Tracy Boggiano  and she’s asking us to write about our experiences with Query Store. I thought about what I should write, I’m...

Azure SQL DB – An instance-specific error occurred while establishing a connection to SQL Server.

The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this...

Extended Events: system_health and a Long Running Query

Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...