“A good DBA is a lazy DBA”

I’m borrowing from Andy Leonard (blog | twitter) who says all the time, “Good engineers are lazy.”
If you’re thinking, “Why would I want (to...

5 Things to Know About Indexes for SQL Server

One of the first questions I got while interviewing for a potential position as a DBA was “If there is...

Clustered Columnstore Indexes – part 32 (“Size Does Matter, but how ?”)

Continuation from the previous 31 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/

The Columnstore Row Group Size Question:
What is better for SQL Server performance:...

Dealing with a long string

Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...

Final Summer Precon for Me – Portland Maine

This coming weekend is the SQL Saturday #293 in Portland, Maine with my precon on Friday. I am really looking forward to attending...

I am speaking at the PASS Summit 2014

I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is...

PASS Summit 2014 – I’m speaking!

On June 25, 2012, I set a goalfor myself.  It was this:
In the next 3 years, I want to present...

Speaking at PASS Summit 2014

Achievement unlocked.
I am more than delighted to announce that I was selected to speak at the upcoming PASS Summit 2014...

Speaking at SQLSaturday Oslo, Norway 2014

I am extremely delighted to announce that I was selected to present a Deep Dive session on Clustered Columnstore Indexes...

Speaking at the 2014 PASS Summit

Finally the email we’d all been waiting for arrived yesterday, the results of session selection for the 2014 PASS Summit....