SQLpassion BLOG

Announcing the SQLpassion Performance Tuning Training Plan

You are a developer and/or DBA and want to learn in a very compact way the essential things about performance tuning & troubleshooting SQL Server installations? In our new free 6 month long SQLpassion Performance Tuning Training Plan we give you week by week via email all the essential knowledge you need to know about …

Announcing the SQLpassion Performance Tuning Training Plan + read more

Myths and Misconceptions about Transaction Isolation Levels

In todays blog posting I want to talk about myths & misconceptions about the various Transaction Isolation Levels that exists in SQL Server. I mainly want to talk about the following topics: Transaction Isolation Levels – What? NOLOCK never blocks!? Read Committed doesn’t holds locks!? Key Range Locks are specific to Serializable!? So let’s get …

Myths and Misconceptions about Transaction Isolation Levels + read more

How to throttle your Storage with Resource Governor in SQL Server 2014

In todays blog posting I want to talk about a very cool enhancement in SQL Server 2014: you are now finally able to throttle queries regarding their needed IOPS! Resource Governor was introduced back in SQL Server 2008, but the feature set was somehow limited: you were just able to limit CPU times (which is …

How to throttle your Storage with Resource Governor in SQL Server 2014 + read more