Category Archives: database

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

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

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