Still not using RCSI?
If you still leave your databases at default settings, namely default isolation (READ COMMITTED – does …
Have SUM() fun!
Did you know that SUM() aggregate can be used together with OVER() clause? A short intro …
High Speed Storage in Azure?
Have you noticed that storage is a major bottleneck in all cloud providers (Azure, AWS, Google …
SQLPLUS.net – an interview with Alan Hyneman
Introduction If you are in search for a good ORM, keep reading. Alan Hyneman, the author …
Insert if NOT exists – duplicate key problem
When multiple sessions insert into the same table, and something unique is there (uq index, uq …
8 Myths about Storage Spaces
Introduction EVERYBODY should read this! Whether you have a big database that needs speed, or other …
My favourite indicator to Monitor SQL
Introduction There are thousands of indicators (Perfmon Counters, system views, …) one can track to monitor …
sp_xdetails – index and table info
While ago I wrote SSMS Addin called SQL XDetails. It was not updated long time because …
Speaking in Finland
In 2 days, 11th of May, I speak in Helsinki, Finland about SQL Server Magic. The …
Speaking in Sweden
In less than two weeks I will speak at SQL Saturday conference in Stockholm, Sweden. I …
