Columnstore Indexes – part 58 (“String Predicate Pushdown”)
Continuation from the previous 57 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have previously blogged on the predicate...
2015-07-05
838 reads
Niko's blog
Announcing Columnstore Indexes Script Library
Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the...
2015-07-05
460 reads
Columnstore Indexes – part 57 (“Segment Alignment Maintenance”)
Continuation from the previous 56 parts, the whole series can be found at http://www.nikoport.com/columnstore/
In this post I want to focus...
2015-06-28
1,068 reads
Speaking at PASS Summit 2015
I will reveal no big secret that on the night when email notifications of PASS Summit selection are sent, I...
2015-06-28
990 reads
Announcing Workshops – Columnstore Deep Dive
After 2 year of active blogging and almost 60 blog posts (56 + 3 on Azure) we have decided that it...
2015-06-16
449 reads
Columnstore Indexes – part 56 (“New DMV’s in SQL Server 2016”)
Continuation from the previous 55 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Before starting to dive into the specific...
2015-06-15
678 reads
Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)
Continuation from the previous 54 parts, the whole series can be found at http://www.nikoport.com/columnstore/
The architectural changes in the upcoming SQL...
2015-06-08
608 reads
Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)
Continuation from the previous 53 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a not very deep technical...
2015-05-27
950 reads
Azure Columnstore, part 3 – Modern Segment Elimination and Set Statistics IO
Welcome to the 3rd blog post in the Azure Columnstore series, this one is dedicated to one very important improvement...
2015-05-24
471 reads
Clustered Columnstore Indexes – part 53 (“What’s new for Columnstore in SQL Server 2014 SP1”)
Continuation from the previous 52 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This is a very small blog post...
2015-05-22
460 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
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...
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