I am extremely happy to be selected as a speaker for the very first Business Intelligence Edition of SQLSaturday in Europe, in Edinburgh (Scotland), which will happen on 14th of June 2014. Organised by European PASS Director Jen Stirrup, this…
Analysing SQL Server Agent Job Results through Power Query by reading Exchange Mails
This is my all time first post on the matter of PowerQuery, even though I have been playing and presenting it since it was publicly available almost a year ago (March 2013). First of all I have to recognise Andreas…
Clustered Columnstore Indexes – part 26 (“Backup & Restore”)
Continuation from the previous 25 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This time I decided to take a look at how having Columnstore Indexes in a database is affecting database backup & restore procedures. I decided to take a simple backup from…
Statistics: Incremental (2014) – Part 3: Updates Performance
This post is a direct continuation from the previous post on the new Incremental Statistics feature in SQL Server 2014. This time we shall dive into the performance of the Statistics Update statement. To reset the game, I will update…
TUGA – portuguese non-profit society for knowledge sharing
Today, almost 4 years after starting Portuguese SQL Server User Group I am happy to share that an official Entity is born and its name is TUGA, a non-profit society for knowledge sharing. You might wonder about the chosen name,…