Power BI Confusion

Just a quick post on some Power BI material that I believe should reach as many people as possible. I get...

8 Hours of Free Performance Training

How could you possibly argue with getting 8 straight hours of SQL Server Performance training for FREE?
You can’t!  Go check...

Automating SSIS Design Pattern: Load Flat File Into Staging Table

Delimited flat files are commonly used to move data from one system to the other.
In this two part series published...

Columnstore Indexes – part 60 (“3 More Batch Mode Improvements in SQL Server 2016”)

Continuation from the previous 59 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to some...

TSQL2sday #68 – Defaults

A big thank you goes out to Andy Yun (b|t) for hosting this month’s TSQL2sday party. This month’s topic is...

T-SQL Tuesday #68: Just Say No to Defaults

Using PowerShell and SMO to set MinServerMemory and MaxServerMemory Programatically

Here is a link to the official #tsql2sday invitation from Andy...

TSQL Tuesday #68: What is my configuration?

It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just...

SQL Server and Defaults

What is that default setting? SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the...

SQL Server and Defaults

What is that default setting?
SQL server does a fantastic job of having numerous settings at the server level and at...

Database Version Control Workshops

We’ve got more Workshops coming this fall from Redgate Software to help you get the most out of our tools...