Easy Audit Index Changes

When looking for an easy method to audit Index changes, one of the first technologies to try really should be Extended Events (xevents).
Related Posts:

Monitor Database Offline Events November 15,...

Free SQL Server Training Videos

Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...

Free SQL Server Training Videos

Hello everyone! This is your SQL Server Consultant in Austin, TX and due to some posts on twitter about SQL PASS recordings costing $999 I wanted to share some...

I’m Speaking at #SQLSatCleveland

I am so excited and honored to have been selected to speak at SQL Saturday Cleveland #930 on February 1, 2020.  This will be my second time speaking at...

Merry Christmas

Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time.  May the holidays...

Resolving Merge Conflicts in SQL Source Control – the Basics (video)

In this 35 minute livestream recording, I commit conflicting code to a Git repo in Azure DevOps Services using Redgate’s SQL Source Control, then step through options to fix...

SQLSaturday Tampa 2020 (On Leap Day!)

Feb 29, 2020 is the date for SQLSaturday Tampa, number 951. The call for speakers is open through January 10th, so you don’t have much time to get something...

T-SQL Tuesday 121 – Gifts received – Summary

I got several responses for the last T-SQL Tuesday of the year that am honored to host. My topic was to blog on whatever you considered to be a...

Understanding Azure Geo-Redundant Storage

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform.  In that session, I talked about Azure storage and the...

Xmas tree in T-SQL

This is a very simple version of a Xmas tree using T-SQL, also is a good example to learn how recursive CTE works.So, if you are in front of...