The Three T’s of Backups

I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume,...

Turning ANSI_PADDING off, and why you shouldn’t

I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...

Columnstore Indexes – part 107 (“Dictionaries Deeper Dive”)

Continuation from the previous 106 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I would like to thank Sunil Agarwal...

Reflecting on the Last Year of Microsoft’s OpenSource Technologies

This past year has certainly been interesting in the world of Linux. Microsoft has taken a new strategy and is embracing the open source model. It’s releasing it’s key...

Speaking at 24 Hours of PASS – PASS Summit 2017 Preview

I am glad to share that I will be speaking at 24 Hours of PASS – PASS Summit 2017 Preview that...

#SQLChat on Performance Issues

Twitter can often be a great source of information for the SQL Community, especially with the #SQLHelp hashtag. Another resource...

A Big July Planned in Baton Rouge

Three big events planned in Baton Rouge this year that everyone can be a part of:

User Groups Networking Night at...

Data Science Virtual Machine

The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data...

Friday Reading 2017-06-23

The weather has been absolutely boiling here in Dublin all week, I’m dying for a cold beer! Anyway, whilst drinking...

Speaking at SQLSaturday Sacramento – 650!

Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 15th 2017! And wow, 650 SQLSaturdays! This one won’t let you down. Check...