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
194 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
134 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
343 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
396 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
236 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
310 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
135 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
99 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,252 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
602 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers