Monthly Archives: March 2014

Quick Tip: Migrating a SQL Server Mirroring Witness server.

If you’re like me, you might be thinking “I want some more things to think about when I migrate between SQL Servers.” … No? Okay, fair enough. There’s a whole listĀ of things to think about when migrating from one SQL … Continue reading

Posted in Database options, Disaster Recovery, SQL Server, T-SQL | Tagged , , | 3 Comments

Quick tip: Querying AD with xp_logininfo

We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through an issue our mind quickly rejects some plans because of these blind spots. This happened to me recently when I … Continue reading

Posted in Security, SQL Server, T-SQL | 1 Comment