Remote Desktop Workflow Improvements

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

SQL Azure, Hekaton, and Bob Dorr is Awesome

Hello Dear Reader!  I had recently written a blog for the PFE blog, "How Many Tables Can I Have In...

SQL Azure, Hekaton, and Bob Dorr is Awesome

Hello Dear Reader!  I had recently written a blog for the PFE blog, "How Many Tables Can I Have In SQL Azure DB & SQL Server".   It was...

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

Using Extended Events to Visualize Availability Group Replication Internals

SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release.This isn’t just a collection of...

Using Extended Events to Visualize Availability Group Replication Internals

SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and...

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

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

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

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