Category Archives: tsql

Baby baby baby, where did our love/ data go?

Posted on October 23, 2012 by

Possibly one of the very first things we learn as fledgling DBA’s is that transactions are used to provide “all or nothing” operations. If you ever go for a SQL Server job interview, you are almost guaranteed to be asked … Continue reading →

Posted in Concurrency, error, sql, sqlbits, sqlpass, SQLServerPedia Syndication, tsql | 2 Comments

Who’s active on SQL 2000

Posted on April 17, 2012 by

Yes yes yes I *know* we are currently on SQL 2012 but just hear me out for a second… I think I am probably one of the only people on the planet who has not (yet) used Adam Machanic’s (blog|twitter) … Continue reading →

Posted in Concurrency, connectivity, dmv, SQLServerPedia Syndication, tsql | 3 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