SQLSaturday Portugal 2015 – Above & Beyond
At the same day, 4 years ago me & my team were already in the process of organising the very first...
2014-12-17
439 reads
Niko's blog
Azure Columnstore, part 2 – Snapshot Isolation & Batch Mode DOP
Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1...
2014-12-16
655 reads
Azure Columnstore, part 1 – The initial preview offering
With today’s announcement on the availability and support of the Columnstore indexes in the Preview version of Azure SQLDatabase, I...
2014-12-12
650 reads
SQLKonferenz 2015
If you are looking for one of the most awesome and most import conferences in Europe, then surely you need...
2014-12-04
433 reads
Clustered Columnstore Indexes – part 45 (“Multi-Dimensional Clustering”)
Continuation from the previous 44 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
I have blogged a couple times (part 29 – “Data Loading for Better...
2014-12-02
362 reads
Clustered Columnstore Indexes – part 44 (“Monitoring with Extended Events”)
Continuation from the previous 43 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the monitoring aspects of the Columnstore Indexes,...
2014-11-23
402 reads
In-Memory Virtual Chapter Co-Lead
It is official – since a couple of weeks I have become a co-leader of one of the newest Virtual Chapters...
2014-11-20
276 reads
Clustered Columnstore Indexes – part 43 (“Transaction Log Basics”)
Continuation from the previous 42 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
This post is dedicated to the Transaction Log behaviour, which might explain...
2014-11-19
421 reads
Essentialism: The Disciplined Pursuit of Less by Greg McKeown
While on my trip to PASS Summit 2014, I have selected one more book to read on the long flights...
2014-11-17
447 reads
PASS Summit 2014 Recap
Every autumn one can observe the pilgrimage of almost all Microsoft Data Platform specialists (SQL Server, Excel, Azure Platform) for...
2014-11-16
306 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers