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

Continuation from the previous 65 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing writing about the improvements added to...

Creating Time Calculations in Power BI

One of the current issues in Power BI is the inability to specify a Date table. The Date table is...

Custom Placeholders in SQL Prompt 7

I love my snippets in SQL Prompt. Adding some snippets can make work go so much quicker.  I add new...

Extended Events Objects

So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started...

Free SQL Training in Seattle

Free Training in Seattle!
Related Posts:

Seattle SQL Pro Workshop 2017 October 19, 2017

Seattle SQL Pro Workshop 2017 Schedule October 26, 2017

T-SQL Tuesday 109: Influence Somebody Invite December 4,...

Free SQL Training in Seattle

The annual SQL Server Professional migration is about to begin. Many of us will be descending upon the city of...

Hekaton Part 7 - Hash Collisions & Hash Buckets

As explained in the earlier post, a hash index places pointers to the rows in hash buckets, depending upon the value returned...

Load Testing Your Storage Subsystem with Diskspd

One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On a new system this is critical because I want...

Load Testing Your Storage Subsystem with Diskspd

One of the primary activities I do before bringing SQL Server into production is load testing the storage subsystem. On...

MDS 2016 CTP 2.3: tiles greyed out in Manager

I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI...