Microsoft Master Data Services in SQL Server 2012

Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft.  Master Data Services is...

Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?

Is it just me, or does there seem to be a lot of discussion these days about testing backups and...

How to Drop One Plan from Cache

While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...

Tips to avoid deadlocks?

A database server should be able to service requests from a large number of concurrent users. When a database server...

Database In Recovery

What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...

Database In Recovery

What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...

SQL Server Professionals: NYC Summer Spectacular! Training & Events

This is a very exciting summer to be in New York City!  We’re not just talking Central Park, the Theatre...

“Green” Database Administration

For the past few years, I have seen tens of sql server boxes added in my work environment every year,...

Jacksonville IT Pro Camp

Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...

SQL Server Service Broker Explained

What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.

What are message queues?
Message queues are a...