SQL Cruise Caribbean 2015 Wrap Up

I just returned home from this year’s SQL Cruise in the Caribbean. WOW!

This trip was our first SQL Cruise, but it...

Parsing SQL Saturday Data – Looping Through And Loading All XML Files

After my last post on parsing the XML, I decided to continue forward and get ready to put the data...

Power BI Made Simple

In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to...

VMware vExpert 2015

VMware has announced the list of 2015 recipients of the vExpert award, and I am humbled and honored to have been...

Triggering a System Center Configuration Manager deployment task

A slightly different topic today.
Once you have built up knowledge, you become the person that people ask to solve things....

Free Video for Accidental DBA’s

Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills...

Test your UPDATEs and DELETEs before you run them

This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...

Clustered Columnstore Indexes – part 48 (“Improving Dictionary Pressure”)

Continuation from the previous 47 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to one of the most complex problems in...

The Vacation Conundrum

Would I want unlimited time off? It’s an interesting question. I think I might like something more like a minimum...

SQL Code Guard v2.7 released

Hola!
SqlCodeGuard v2.7 is just released.
To be brief - major changes:1. Added command line utility
2. Added scgallow(issue)/scgignore(issue`)to control which issues should be...