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...

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:

Correlate Trace...

Behind the Scenes: How I Create Weekly Technical Videos

Be sure to watch this week’s video to get the full behind the scenes experience! Today I want to share my process for blogging and making weekly YouTube videos....

Behind the Scenes: How I Create Weekly Technical Videos

Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...