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

What was I thinking? Deleting myself from localdb?

Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...

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

It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know...