Live Query Statistics In SQL Server 2016 CTP 2.0

Hi friends, today we will learn another new feature Live Query Statistics which gets introduced in SQL Server 2016. It’s...

Looking Back at a Sabbatical – One Year Later

Last year at this time I was nearing the end of my sabbatical. I’ve been using the Timehop app on...

Cortana Analytics Suite

Yesterday at the Microsoft World Wide Partner Conference in Orlando Microsoft announced the Cortana Analytics Suite, which is a new package...

Be a PASS NomCom Candidate!

Today is the last day to submit your name as a candidate for the NomCom. If you’re a PASS member...

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