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
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers