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

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

Statistics Are Vital For Query Performance

This is post #10 supporting  Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...

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

Special Discount for PASS Summit Precon

I’m very honored to be speaking at the PASS Global Summitagain this year in Seattle during the week of October...

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

Power BI Custom Visuals Class (Module 20 – Word Cloud)

In this module you will learn how to use the Word Cloud Power BI Custom Visual.  The Word Cloud is...

Making the case for CamelCase naming

Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...

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

Mastering Index – Nonclustered Index

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