Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...

SQLSaturday Portugal 2015 – Above & Beyond

At the same day, 4 years ago me & my team were already in the process of organising the very first...

Azure Columnstore, part 2 – Snapshot Isolation & Batch Mode DOP

Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1...

‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office

not a creature was stirring, not even the bosses.

The code was checked in,...

Load Balanced IIS Machines

I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the...

WordPress, Project NAMI, and Azure

I’ve been running WordPress for years now and find it to be a solid solution for what I want to...

ROW_NUMBER SQL Server

Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number()...

SQL Server Developer Tips that Can Save Your XXX

Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for...

RegEx Those Dates

Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing....

Transaction Isolation Level Blues

Have you ever had a mental block in one particular area when learning something? It might be the simplest thing,...