Sql Server - Index Utilization Report

Index Utilization Report

One day my manager came and told me that he need Index Utilization Report.
He felt that during...

Why SQL Server Database Is In Recovery Mode?

The SQL Server whenever it restarts all the databases goes into the recovery mode. In this state the database comes...

Remote Desktop Workflow Improvements

Remote server management is a fact of life for folks involved with sql server. Since we work so often with...

Making Start-Demo work with multi-line commands without a backtick

I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...

Remote Desktop Workflow Improvements

Remote server management is a fact of life for folks involved with sql server. Since we work so often with...

CISL 1.3.1 is released

I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!
Do...

When should I use a CTE?

If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...

Understanding the Different States of SQL Database

Overview
There are multiple numbers states of a SQL Database. These states determine the current status or mode of database in...

Organizing a SQL Saturday – Part 1 – Why Do It?

To kick off this series, I thought it would be worthwhile to discuss why it is I step up to...

An MCM teaches COMMENTS at SQL Saturday OKC

Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...