thoughts

TSQL Tuesday #93: 2 Job Interviews

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…

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…

Presentations & Blogging of 2016 in Review

For the 4th year in a row, I am keeping data on my professional engagements to help the others – public presentations, blogging efforts & organisations of the events. In 2016, I have made my best efforts to reduce travelling…

The Future of the User Groups (SQLPort)

With SQLPort approaching it’s 6th birthday (21st of April), I have to admit that the works on the user group have already started around 2 months before that date. The moment when the SQLPort was announced at the last TechDays…

Presentations & Blogging of 2015 in Review

Another year is coming to an end and I am doing a review of which goals I have managed to achieve. Most of my goals are not public and I am intending to keep them that way, but in the…

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 of the major improvements in SQL Server 2016, related to the Batch Execution Mode. By all means this list…

MVP Showcase Portugal 2015

É com uma enorme felicidade e orgulho que gostava de partilhar a notícia sobre a criação de um evento Português sobre o programa MVP – MVP ShowCase Portugal 2015. o MVP ShowCase Portugal 2015 será realizado no dia 22 de…

SQLPort – 5 Years

On 21st of April 2015, SQLPort is preparing a very special event. The reason for this is that on 21st of April 2010, during the last TechDays in Portugal, the creation of the SQLPort – Portuguese SQL Server Community was…

Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)

Continuation from the previous 33 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Segment Elimination for Deleted Row Groups After some very interesting and inspiring conversations during SQLBits, I came to an idea of testing a Segment Elimination while working with a fully deleted…

Hekaton 2014 – The Saviour vs The Lost Cause

With the release of the SQL Server 2014, Microsoft has finally unleashed their long-time in work In-Memory solution (codenamed XTP for Extreme Transaction Processing, old codename Hekaton). Note: I will be keep on using the name Hekaton since Dr Devitt…
Go to Top