How do I rename a column?

Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to...

Can’t RDP to Azure VM?

I ran into an interesting problem early this month. I was spinning up an Azure VM with SQL Server 2016...

Columnstore Indexes – part 82 (“Extended Events in SQL Server 2016”)

Continuation from the previous 81 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Previously, I have blogged about about the...

SQL Saturday #492 Follow Up – A Window into Your Data

Thanks for attending my session on window functions in TSQL. I hope you learned something you can take back and...

What's New in SQL Server 2016 Release Candidate 3

Microsoft announced SQL Server 2016 Release Candidate 3 Evaluations

Benefits of SQL Server 2016 Release candidate 3:
Enhanced in-memory performance provide up...

Community work

I have been really busy lately with articles, podcasts and so forth. Lately I have been working on 2 public...

Sarpedon Quality Lab presenting SQL Server 2016 In-Memory and Security Features in Arabia at SQL Gulf 3

?????

(“MARR-hah-bah”, Arabic: Hello)
This year takes me to yet another part of the world:
I have been invited to speak at THE...

Test

SQL 2016 Temporal Tables By Example

Brief Description
Temporal tables allow automated change tracking of a table directly in to a history table which can be queried...

Goodness-of-Fit Testing with SQL Server Part 7.2: The Lilliefors Test

By Steve Bolton
…………Since I’m teaching myself as I go in this series of self-tutorials, I often have only a vague...