Thanks, Vets

Tracking Progress of SQL Server Index Builds and Rebuilds

Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when...

T-SQL Tuesday #60 – Something New Learned

It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL...

T-SQL Tuesday #60 Something New Learned

So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough...

TSQL Tuesday #60: Something Learned This Way Comes

It is once again time to come together as a community and talk about a common theme.  This monthly gathering of the community has just reached it’s 5th anniversary....

TSQL Tuesday #60: Something Learned This Way Comes

It is once again time to come together as a community and talk about a common theme.  This monthly gathering...

TSQL Tuesday #60: Something New Learned – What permissions does have?

What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to...

Using Bookmarks in SQL Server Management Studio

In SQL Server one way we optimize code is by adding indexes. Indexes help queries by essentially letting the engine...

#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...

Add Witness to Existing SQL Server Database Mirroring

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security...