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

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

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

Adding Extended Properties to a Table

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

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

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

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

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