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...

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...

Run SQL Server In A Container Today July 2015

Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official...

FOR JSON Clause With INCLUDE_NULL_VALUES Option In SQL Server 2016

Hi folks, Today we learn how to format query using FOR JSON clause with INCLUDE_NULL_VALUES option in SQL Server 2016....

010 – Ayman El-Ghazali - WaterOx Consulting

Reading Time: 2 minutesThe community makes it all happen! In WOxPod!, episode # 009 –...
The post 010 – Ayman El-Ghazali appeared first...

Speaker of the Month: June 2015

With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I...

Speaking engagements for August and September

August and September are going to be some busy weeks!

In those two months I will be speaking on three SQLSaturday...

How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...

Making Changes to Many Forms In Access

Although generally I prefer to create custom interfaces for my databases using fully developed programming languages like Python or C#....

I’m Speaking! Omaha SQL Server/BI User Group

Well, it has finally happened. In the 7+ years that I helped to run the Omaha SQL/BI User Group, I...