Come See the Future of Database DevOps at SQL Sat Austin

I’ll be coming to SQL Saturday #890 – Austin in just over a week. Austin is a great technology town, and this should be one of the larger SQL...

Renewed As A Microsoft Data Platform MVP

I am so excited and honored to have been awarded my second Data Platform MVP from Microsoft on Monday.  It’s been a crazy busy 18 months and the next...

Is That Database in Use?

This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:

Monitor Database Offline Events November 15, 2018

Audit Logons...

Is That Database in Use?

This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:

Finding Deprecated Uses in SQL Server November 7, 2016...

Performance Tuning Steps a Query by looking an execution plan and effectiveness of the index creation Part-1

The index is very important and powerful object...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Chaos engineering for SQL Server running on AKS using KubeInvaders

A couple of weeks ago I came across an awesome GitHub repo called KubeInvaders which is brilliant work of Eugenio Marzo (b|t) KubeInvaders allows you to play Space Invaders...

T-SQL Tuesday #116 Invitation – SQL on Linux

T-SQL Tuesday #116 Invitation – SQL on Linux

T-SQL Tuesday #116 Invitation – SQL on Linux

Ever since Microsoft said SQL would run on Linux, I was excited.  Finally, all the Linux administrators I had worked with could be quiet and the Oracle DBAs that...

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Finding Data...