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...

Friday Followup For June 20, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium

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

Building The SQLSaturday Orlando Marketing Plan-Part 20

Next week will begin our weekly planning call, so ahead of that (and perhaps a bit later than I should...