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

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

T-SQL Tuesday #63 - Managing Security - Enforce SQL Login Policies

Today, February 10, 2015 is TSQL
Tuesday, no.63! (Click on the highlighted link for the Invitation.)
 Hosted this month, by Student of...

T-SQL Tuesday #63: How do you manage security

This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security.
Security is one of...