Monthly Archives: October 2012

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

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

Memoirs of SQLSaturday #162 Part II: Speaker Dinner

Posted on October 1, 2012 by

Probably one of the most over-looked parts of any big or small SQL Event can sometimes be the speaker dinner -which essentially boils down to one thing… the organisers way of showing their appreciation to the speakers who have traveled … Continue reading →

Posted in personaldevelopment, publicspeaking, sql, sqlsaturday, SQLServerPedia Syndication | Leave a comment