Reblog: July 18 to July 24

Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...

Speaker Buddy System

SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in...

Speaking on ETL Security

I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.
Securing...

SQLBits XII Recap

There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.

There is a technological event...

SQLSaturday Porto Edition 2014 Selection Process Results & Voting

This blog post is a continuation of the initial announcement almost a month ago about the session selection process that...

SSIS: Value does not Fall Within the Expected Range

Every now and again I find myself working with SSIS for one reason or another.  Every now and again I...

Thank You SQLBits!

Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...

Thank You SQLBits!

Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...

Webinar Q&A: Getting Started with Change Data Capture

Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics...

Clustered Columnstore Indexes – part 35 (“Trace Flags & Query Optimiser Rules”)

Continuation from the previous 34 parts, starting from http://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/
This blog post is about controlling some of the Columnstore Indexes behaviours...