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

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

Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.

Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...

Cluster Headache - Applying Service Pack and SQL Fails to Come On-line

Having
applied dozens and dozens of Service Packs to various SQL Server clusters, I
still never cease to learn that not everything...

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

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

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

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

Building The SQLSaturday Orlando Marketing Plan-Part 19

Below is the chart Kendal Van Dyke maintains for us in Orlando showing year over year registration counts. Don’t I...