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

Thoughts On The 2014 PASS Summit Selections

The session lineup for the 2014 PASS Summit was announced today and I'm honored to be selected as a presenter....

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

The Great Escape-Question of The Day

The Great Escape is the question today, one I think you will like because…it’s about LIKE! It’s a head scratcher....

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

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

Speaking at the SQL PASS 2014 Summit

I’m happy to announce that I will be speaking at the SQL PASS Summit this fall.  The summit will be...

The Utility of Execution Plans in Natively Compiled Procedures

I’m actually having problems identifying the utility of execution plans when working with natively compiled procedures. Or, put another way,...

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

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