Columnstore Indexes – part 65 (“Clustered Columnstore Improvements in SQL Server 2016”)

Continuation from the previous 64 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This article is dedicated to the improvements...

Use Twitter to get #PowerShell help

A quick post today just to add some weight to something that Mike Fal b | t has kicked off. The #SQLHelp...

How to deploy SSIS Package ? Step by Step SSIS TIP #114

Dear Friends,
In last post we have successfully created our fist basic package. So, Now the next thing is how...

018 – Learn Like A Pro! - Syndication – WaterOx Consulting

Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like...
The post 018 – Learn Like A Pro! appeared first on WaterOx...

Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations

One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...

Speaker of the Month: September 2015

Feast or famine.
The last several months I just haven’t seen that many speakers, let alone that many community speakers. Then,...

XEvent Session Supporting Cast

Beyond the metadata in the the catalog views and DMVs, there are a few more objects that come in handy when dealing with Extended Events. I call these the...

XEvent Session Supporting Cast

So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...

Hekaton Part 5: Introduction to Indexes in "In Memory Tables"

After a short little break on Hekaton series, we are now back with the 5th post.

Two new index types...

Executing DBCC for SQL Server Analysis Services 2016

In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...