-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Niko's blog

Niko Neugebauer is Microsoft Data Platform professional. A SQL Server MVP, he is very passionate about Data Platform (with a focus on Columnstore) and Community. He is a founder and a leader of the Portuguese SQL Server User Group, SQLPort and a co-founder of 2 more Data Platform User Groups in his home country. His passion for community led him to organise the first SQLSaturday outside of North America – #78 Portuga. Niko presented at a number of different conferences, including PASS Summit, SQLRallys, SQLBits, and SQLSaturdays around the world.

Columnstore Indexes – part 113 (“Row Groups Merging Limitations”)

Continuation from the previous 112 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

This blog post serves as the continuation of the original blog post on the Row Group Merge functionalities that I have described in Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server… Read more

0 comments, 148 reads

Posted in Niko's blog on 24 September 2017

Columnstore Indexes – part 112 (“Linked Servers”)

Continuation from the previous 111 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

This blogpost is focusing on the Server Object functionality of the SQL Server – the Linked Servers. Almost everybody knows that the Linked Servers are evil (yeah, I know of some exceptions), almost everybody loves… Read more

3 comments, 1,342 reads

Posted in Niko's blog on 14 September 2017

CISL 1.5.0 is released

I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released.
The biggest news is the initial support for the Azure SQL DataWarehouse, with the 5 scripts (Alignment, Dictionaries, Fragmentation, Row Groups & Row Groups Details) providing the first blick into this… Read more

2 comments, 163 reads

Posted in Niko's blog on 4 September 2017

Columnstore Indexes – part 111 (“Row Group Elimination – Pain Points”)

Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

The topic of the Segment Elimination (aka Row Group Elimination) is something that I keep on blogging on through all the years, but given that Joe Obbish has written an incredibly valuable blog post on… Read more

0 comments, 210 reads

Posted in Niko's blog on 30 August 2017

We won vs They Lost

Competitive Sports is one of the incredible miracles to me and I love them greatly. I can watch almost any competition where the good sportsmanship is real (Feel free to imagine here your own doping/cheating/stupid exceptions), but there is one thing I can never understand.

WE WON

My countries top… Read more

0 comments, 116 reads

Posted in Niko's blog on 29 August 2017

Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)

Continuation from the previous 109 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best possible Segment Elimination for the queries with predicates against… Read more

0 comments, 237 reads

Posted in Niko's blog on 27 August 2017

TSQL Tuesday #93: 2 Job Interviews

T-SQL Tuesday #93

I decided to join the T-SQL Tuesday blog series that Kendra Little is leading this month, on the topic that is called “Interviewing Patterns & Anti-Patterns

The Job I HAD to skip

Please, take this first part in the context of somebody, who was largely… Read more

2 comments, 257 reads

Posted in Niko's blog on 8 August 2017

Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

Do you remember one of the major problems in SQL Server 2014 using Columnstore Indexes ? It was the lack of the support for the Batch Execution Mode with just a single core. We would… Read more

2 comments, 1,135 reads

Posted in Niko's blog on 30 July 2017

Columnstore Indexes – part 108 (“Computed Columns”)

Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/

As we are approaching the RTM (release to manufacturing) of the SQL Server 2017, I decided to focus on the implemented features in the upcoming release, thinking that if they are in the RC (release candidate)… Read more

0 comments, 354 reads

Posted in Niko's blog on 29 July 2017

Columnstore Indexes – part 107 (“Dictionaries Deeper Dive”)

Continuation from the previous 106 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

I would like to thank Sunil Agarwal (Program Manager) & Vassilis Papadimos (Software Engineer) for all their patience and explanations, helping me to get to the bottom of the faced issues and delivering me a… Read more

0 comments, 247 reads

Posted in Niko's blog on 25 June 2017

Speaking at 24 Hours of PASS – PASS Summit 2017 Preview

I am glad to share that I will be speaking at 24 Hours of PASS – PASS Summit 2017 Preview that will take place on 19th & 20th of July 2017.

As I already announced before, I will be delivering a precon at PASS Summit 2017 and now to promote… Read more

0 comments, 492 reads

Posted in Niko's blog on 24 June 2017

Precon at PASS Summit 2017 – Columnstore Indexes: Practical Solutions & Techniques

It is with an incredible joy and gratitude that I am able to share that I will be delivering a full-day precon (workshop) at PASS Summit 2017: Columnstore Indexes – Practical Solutions & Techniques on 31st of October 2017 in Seattle.

What should you expect ? A lot of technical… Read more

0 comments, 308 reads

Posted in Niko's blog on 13 June 2017

SQL Graph, part I

This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically focused on the SQL Graph, that is the newest extension to the SQL Server engine, as well as the Azure SQL Database (upcoming).

What are Graph Databases

Graph databases are… Read more

7 comments, 484 reads

Posted in Niko's blog on 3 June 2017

Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)

Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

One of the most important and recurring topics for any type of indices is their Building/Rebuilding/Reorganzing processes – after all we do load more data into our tables and we want all of the bits… Read more

1 comments, 422 reads

Posted in Niko's blog on 30 May 2017

Columnstore Indexes – part 105 (“Performance Counters”)

Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

For a very long time I was intending to write some of the unsung & almost hidden improvements of the SQL Server 2016 – the performance counters. To my knowledge, the only person mentioning them,… Read more

2 comments, 440 reads

Posted in Niko's blog on 27 May 2017

Resumable Online Index Rebuild

I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it.

The new version of SQL Server (2017) introduces a very exciting feature for the DBA’s – the Resumable Online Index Rebuild.
This feature is targeting the installations that… Read more

0 comments, 529 reads

Posted in Niko's blog on 23 April 2017

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

This blog post is a logical continuation of the blog post that I have published in December 2016 – Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”), but this time I… Read more

4 comments, 353 reads

Posted in Niko's blog on 22 April 2017

Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)

Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

I have been wanting to write on this topic for quite some time, but with all the exciting themes that I have on my todo list and as drafts on this blog post, prevented me… Read more

2 comments, 257 reads

Posted in Niko's blog on 5 April 2017

Columnstore Indexes – part 102 (“CCI with Secondary Rowstore Indexes on SQL 2014”)

Continuation from the previous 101 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

In SQL Server 2014 we have received a possibility to update the Columnstore Index directly with an addition of the Clustered Columnstore Index. This addition had some important limitations, between which were the impossibility of… Read more

0 comments, 270 reads

Posted in Niko's blog on 3 April 2017

Tuga IT 2017 Tickets are on sale

I am glad to announce thatTuga IT 2017 Tickets are finally on sale!
Wait a second, you might think – on sale? How on earth and why in this galaxy (TM) are we asking for the money? What are we going to do with them ?
This blog… Read more

0 comments, 223 reads

Posted in Niko's blog on 3 April 2017

Older posts