Clustered Columnstore Indexes – part 53 (“What’s new for Columnstore in SQL Server 2014 SP1”)

Continuation from the previous 52 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a very small blog post...

Creating a SQL Agent Job Wrapper with PowerShell and SMO

Some Background
“Is there any way to start a SQL Agent job using a script or program?”
I’ve seen this question asked...

DDL Auditing - Article on SQL Server Central

My article on SQL Server Auditing has been published on www.SQLServerCentral.Com. Article discusses how default trace can be used effectively...

Enabling Instant File Initialization

Found a couple good walkthroughs on enabling instant file initialization. However, I’m becoming more familar with the nuances of various...

How I Got Started in Software Development-A Tribute to Ed

Steve:
Happy Memorial Weekend everyone. This is a time to remember those who have gone before and in some cases have...

I Spoke at SQLSat (and I Liked It)

That is the first and last Katy Perry reference you will find on this blog or anywhere else in my life.
Last weekend I spoke at the 4th edition of my “home”...

Reblog - Memorial Day in US - Freedom is Never Free

Originally published May 2014:

Well, as all folks in the United States know, this weekend we celebrate Memorial Day,
Monday May...

Reframing to Overcome Filtered Index Limitations

I’m continuing on with the Blogger’s challenge in this post.

Turning the Problem Around
In the last post, I wrote about limitations...

Speaking at SQLSaturday Rheinland, Germany 2015

It is always a very special moment whenever you receive a notification of being selected to present at any event....

Unit Testing in Philadelphia

I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an...