Powershell script to get list of databases on a server

At one of my clients I received an email from one of the IT Project Managers asking a simple question:"Can you please let us know which databases reside on...

sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points

We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...

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