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

Faster

In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.
Maybe within our DNA we have some need for the speed. The one that makes us run faster, eat faster, drive faster, fly faster, compete with each other …
Because we want to… Read more

0 comments, 227 reads

Posted in Niko's blog on 19 January 2018

Jack of ALL Trades

Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about something that is important & sensitive.
And if it has not, then this blog post was not written for you

In the past number of years, there has been… Read more

5 comments, 321 reads

Posted in Niko's blog on 18 January 2018

Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)

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

As a logical continuation from the blog post Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”), this blogpost will focus on the SQL Server 2017 and different editions – in my… Read more

1 comments, 738 reads

Posted in Niko's blog on 5 January 2018

Presentations & Blogging of 2017 in Review

And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life, this time focusing on the past year of 2017. Like in the previous years (2016, 2015, for example), I am including the information from the previous years,… Read more

2 comments, 505 reads

Posted in Niko's blog on 29 December 2017

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

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

An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of Clustered Columnstore Indexes. It seems that there is enough confusions… Read more

0 comments, 797 reads

Posted in Niko's blog on 29 December 2017

Columnstore Indexes – part 116 (“Partitioning Specifics”)

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

After delaying for a couple of years (yes, strangely there is other priority in my life, besides this blog post series) – I am finally putting a couple of the notes on the partitioning for the… Read more

2 comments, 419 reads

Posted in Niko's blog on 28 December 2017

Precon at SQLKonferenz 2018

One of my favourite conferences (and so far I was incredibly lucky to have spoken at every edition) is SQLKonferenz, which is a middle-range sized conference, located in Darmstadt, Germany. Sized at 400-500 people, it is not the biggest conference in Europe, nor it is a regular SQLSaturday (at… Read more

0 comments, 302 reads

Posted in Niko's blog on 27 December 2017

Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)

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

This blog post is dedicated to the Bulk Load API and the sudden changes that might take place and affect it during the loading process into Columnstore Indexes. I have already blogged about the “Magic… Read more

0 comments, 328 reads

Posted in Niko's blog on 8 November 2017

Columnstore Indexes – part 114 (“Machine Learning Services”)

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

This blogpost is focusing on the unsung (and at the moment undocumented) improvement that is connected to the Columnstore Indexes, the communication between SQL Server relational engine and the Machine Learning Services in SQL Server… Read more

0 comments, 618 reads

Posted in Niko's blog on 29 October 2017

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, 367 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,657 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

3 comments, 301 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, 598 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, 256 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, 441 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, 511 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

3 comments, 1,509 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

2 comments, 749 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, 587 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, 638 reads

Posted in Niko's blog on 24 June 2017

Older posts