Category Archives: database

10 reasons why I HAte you!

(or My Top Ten High Availability annoyances) Designing, planning, deploying, administrating and recovering (known from now on as DePlanDeAR – and pronounced in the tone of a Caribbean Grandma :) ) a SQL Server High Availability and Disaster Recovery (HADR) solution is really … Continue reading

Posted in availability, business, clustering, database, sql, SQLServerPedia Syndication, storage, virtualization, windows | Leave a comment

The Curious Case of the Non-Escalating transaction locks

SQL Server has many facets and behaviors that are often misunderstood and do not always work quite as we may have expected. At first you may believe that you understand the mechanics, only to realize after a little bit of … Continue reading

Posted in Concurrency, database, sql, SQLServerPedia Syndication | 2 Comments

What are the impersonation rights for my database users?

From time to time I get thrown the odd request to provide various bits of information from the SQL Server environment and most recently I was asked about a group of databases that required migrating to another instance. For some … Continue reading

Posted in database, dmv, reporting, security, SQLServerPedia Syndication, tsql