SQLSaturday Portugal Porto 2014 Recap
Incredibly as it sounds, it took us 2 years of work to get the 18th of October. It took a...
2014-11-04
199 reads
Niko's blog
Porto.Data
I am extremely excited to share that the first event of Porto.Data is all set for the 20th of November...
2014-10-29
142 reads
Clustered Columnstore Indexes – part 42 (“Materialisation”)
Continuation from the previous 41 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Important Disclaimer – I have started writing this blog post over 1 months...
2014-10-23
351 reads
SSIS ReportGenerator Task
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some...
2014-09-22
409 reads
Clustered Columnstore Indexes – part 41 (“Statistics”)
Continuation from the previous 40 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Note: This article is in’s 2nd version, after correcting comments done by...
2014-09-13
241 reads
Clustered Columnstore Indexes – part 40 (“Compression Algorithms”)
Continuation from the previous 39 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It’s time to take a look into the algorithms that Microsoft is...
2014-09-09
312 reads
Speaking at SQLSaturday Barcelona, Spain 2014
A couple of days ago, when I was in Germany – I have received some extremely exciting news that I was...
2014-09-05
139 reads
24 Horas de PASS em Português – Edição 2014
Este ano (2014) a 3ª edição do “24 Horas de PASS” em Português será realizada nos dias 7 e 8...
2014-09-05
105 reads
SSIS GoogleAnalyticsSource 1.7
A couple of days ago, Tillmann has released a new version of his amazing SSIS data source for Google Analytics...
2014-08-27
1,257 reads
Clustered Columnstore Indexes – part 39 (“Memory in Action”)
Continuation from the previous 38 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In this post I shall try to discover more interesting information about...
2014-08-26
608 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers