SQLpassion BLOG

I’m a lazy person. I just want to do as little work as possible. I don’t want to think too much when I work. Yes, I know that sounds very terrible and will probably disqualifies me as a SQL Server consultant, but in today’s blog posting I want to show you how you can delegate …

How I tune SQL Server queries + read more

In today’s blog posting I will talk about how you can have Lock Escalations in the isolation level SERIALIZABLE, and how they can be avoided. I have already blogged back in February 2014 about the basic concept of Lock Escalations and why they are needed in SQL Server. So please go back to this blog …

Lock Escalations in the Isolation Level SERIALIZABLE + read more

I’m very happy to announce today that I will be back with my already famous SQL Server Performance Tuning Workshop in London this year! This 5-day long workshop is scheduled from June 1 to June 5 in Central London. Besides London I also run this workshop in Utrecht/Netherlands from April 13 – 17. There are …

SQL Server Performance Tuning Workshop in London, June 2015 + read more

In today’s blog posting I want to talk about 2 kinds of deadlocks that can occur when you run transactions in the Transaction Isolation Level Repeatable Read. When you set your transaction to use the isolation level Repeatable Read, SQL Server holds acquired Shared Locks for reading data until the end of the transaction (COMMIT …

Possible Deadlocks in the Isolation Level Repeatable Read + read more

Today I’m very happy and proud to announce the SQLpassion workshop schedule around Europe for 2015. The following locations are currently scheduled and planned: SQL Server Query Tuning Workshop in Vienna/Austria (March 16 – 19, 2015) SQL Server Performance Tuning Workshop in Utrecht/Netherlands (April 13 – 17, 2015) SQL Server Query Tuning Workshop in Zurich/Switzerland …

Announcing the SQLpassion workshop schedule for 2015 + read more