What happens if I disable the clustered index?

You are probably already aware that you can disable an index. This can be handy when you have a large ... Continue reading

What is the Merit of the Job?

One tries to climb the ladder of success but at the cost of being an approachable human being. Nice people don't need to finish last.
Related Posts:

It's an Honor:...

What is the Merit of the Job?

One tries to climb the ladder of success but at the cost of being an approachable human being. Nice people don't need to finish last.
Related Posts:

To Influence or...

Who needs data access? Not You!

With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:

When Too Much is Not a Good Thing December 13,...

Where is that Mask?

In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.
Related Posts:

Failed to Create...

Where is that Mask?

In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.
Related Posts:

Encrypting a Database...

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