SQL Server 2016 features to look for -2

In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion...

Behavior of ORDER BY + UNION Can Be Confusing

This is an interesting example and it exposes a quirk with the concept of a UNION, which is, that the...

Animated Graphics Depict The Fallen of World War II

In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war.  Starting...

Animated Graphics Depict The Fallen of World War II

In an amazing application of visualization techniques, this production is a depiction of the casualties and affects of war.  Starting...

See You Next Weekend at SQL Saturday Houston!

Looking forward to speaking next weekend at SQL Saturday Houston 2015 on June 13!

If you haven't already registered for this...

New Course: Building Better SSIS Packages–Denver and Boston

Earlier this week, I confirmed two full-day seminars I’ll be delivering in conjunction with SQL Saturday events this fall. I’ve...

006 – Personal Trainer - WaterOx Consulting

Reading Time: 5 minutesDo You Have a Personal Trainer? In WOxPod!, episode # 006 –...
The post 006 – Personal Trainer appeared first...

SSC Editorial: Should Salary Information Be Confidential?

I’m expecting Should Salary Information Be Confidential? to draw a wide range of comments. I’m curious to see if many will be...

SQL Server – Capture Execution Plan of a Currently Running Query/Process SPID

DBAs most often face scenarios where they need to capture graphical execution plan of a query currently running on a live production instance because...

SQL Server – How to Calculate Length and Size of any field in a SQL Table

Recently I came across a situation where queries are loading extremely slow from a table. After careful analysis we found...