Recently I was asked about diagnosing deadlocks in SQL Server – I’ve done a lot of work in this area way back in 2008, so I figure it’s time for a refresher. If there’s a lot of interest in exploring SQL Server and deadlocks further, I’m happy to write an […]
T-SQL
3 posts
Intro If you have used or are deciding on using an Azure hosted SQL Server database, you might also want the ability to govern the identities and credentials used to access your data. When you create a SQL Database in SQL Azure, initially credentials are created for you, but they […]
There are times when you want to get a little creative about your investigative work when it comes to SQL Server. In this case, this is a very short article highlighting some efficiencies in locating information about specific programmatic resources within a database. If you haven’t used the INFORMATION_SCHEMA views […]