Using SQL Server Management Studio Projects

One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can...

A Business Lesson from an Oil Change

When I first moved to the city where I now live, I found an oil change place just a couple...

How to Get Estimated Completion Time of SQL Server Database Backup OR Restore

“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of...

SSRS won’t bind HTTPS to new certificate — “We are unable to create the certificate binding”

This blog post is around the situation where you have SSRS setup to use HTTPS and thus using a certificate...

AHHH I need a Blog Topic!!!

One of the hardest things you can do as a blogger is to come up with a post topic. Do...

Capture Index Maintenance Operations

One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...

Capture Index Maintenance Operations

If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
Related Posts:

Where is that Mask? December 28,...

Disable, don’t delete those indexes

A quick post this week, since it’s that time of the year when people do gift exchanges and put up...

Interview with Guy In A Cube’s Adam Saxton and Patrick Leblanc

Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for...

Making a Difference: Andy Warren

Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...