Category Archives: database

The Curious Case of the Non-Escalating transaction locks

Posted on October 17, 2012 by

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?

Posted on January 30, 2012 by

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 | Leave a comment

T-SQL Tuesday #25 – The Best Tool You’ve Never Used

Posted on December 13, 2011 by

Wow, it’s been a long time since my last T-SQL Tuesday post and I have disappointingly missed it 5 times for one reason or another. Still, the important thing is that I am back people! This month’s T-SQL Tuesday is … Continue reading →

Posted in database, reporting, SQLServerPedia Syndication, storage, t-sql tuesday, windows | 4 Comments