Introduction to Latches in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

Plagiarism: A Community Destroyed

Personal Thoughts

Just to be clear, I don't expect everyone to have my same thoughts. I personally fully support SQLServerCentral and...

ExpressProfiler: Yet another "when and why" story.

Core of ExpressProfiler  was born about 8 years ago when I worked for a company whose mission was the migration...

Microsoft Azure Data Services

Azure Data Services
Microsoft’s Azure data services provides you with a method to enhance your enterprise architecture and business intelligence options. ...

Clustered Columnstore Indexes – part 31 (“Memory Pressure and Row Group Sizes”)

Continuation from the previous 30 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This blog post is focusing on one of the most important real...

Baton Rouge SharePoint Saturday 2014: SQL Server Best Practices for SharePoint Databases

Thanks for joining us at the first annual Baton Rouge SharePoint Saturday!

Here is my presentation for the 1:15 presentation in...

Clustered Columnstore Indexes – part 30 (“Bulk Load API Magic Number”)

Continuation from the previous 29 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It has been a long time (almost a year) since Microsoft revealed...

Reblog: June 13 to June 19

Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...

Poecilonym Madness-Question of the Day

Poecilonym Madness! is my latest question that tests your knowledge of creating/dropping tables, views, and synonyms. Here’s the fun part...

Partitioning Basics – Part 3 – Switching Data

This post follows on from Partitioning Basics – Part 2
In this final part, I want to go through how partitions can...