Source control isnt just a backup

In the second part of this series on getting more agile and bringing our Sql Server development practices up to date I am going to talk about why you...

Source control isn't just a backup

In the second part of this series on getting more agile and bringing our Sql Server development practices up to...

Speaking at SQLSaturday Pordenone

Next week, on Saturday 28, make sure you don’t miss SQLSaturday Pordenone!

Pordenone is the place where the Italian adventure with SQLSaturday...

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

T-SQL Tuesday #63 – Security

It’s T-SQL Tuesday time again and this month we look at security. Kenneth Fisher has chosen this as his topic...

TSQL Tuesday #63: – DBA Myths: You can’t deny something to a member of db_owner database role

So I’m hosting T-SQL Tuesday this month and decided that since security is something everyone has to deal with it...

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

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

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