Azure SQL Database – TDE

I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...

Columnstore Indexes – part 87 (“Indexed Views”)

Continuation from the previous 86 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
A very long time desired feature from...

Implementing Fuzzy Sets in SQL Server, Part 4: From Fuzzy Unions to Fuzzy Logic

By Steve Bolton
…………Fuzzy set relations carry an added layer of complexity not seen in ordinary “crisp” sets, due to the...

Mastering Index – Nonclustered Index

This article is the part of series Mastering Index, in this particular article we will be exploring Nonclustered Index. Take...

Migrating Database Collation - The Red Gate Way

I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...

Migrating Database Collation - The Red Gate Way

I had some cross database comparisons that I wanted to simplify, but ensuring the collation matched. The amount of objects...

Monday Night Networking at Summit 2016

It’s PASS Summit time and that means Andy Warren and I are doing another Monday Night Networking Dinner.

For those of...

Pinned Tabs

It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b)...

SSC Editorial: A Visit to Microsoft

A Visit to Microsoft was posted back in August and I just re-read it. Here’s a quote that might interest you:
As...

SSC Editorial: Does Log Data Belong in a Table or a File?

I think the topic of whether log data belongs in a table or a file would be a great one for...