KDiff3

As I write more code, especially database code, and I collaborate with others (or myself), I find that I have...

Easy SQL mistakes: Accidental Correlated Subquery

Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup...

How to Trim Characters in C#

The removing of leading and trailing characters in c# is made possible by the System namespace.
My demo is uses a windows...

My First PASS Board Meeting

Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as...

My First PASS Board Meeting

Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as...

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