SQL – List All Tables, Space Usage Info & Other Details

One of the OP requested in the forum to find all table details of any database. The details which includes Number...

Logistics For All Day Meetings

Quick thoughts about the work required to make all day meetings run smoothly:
Suitable space with enough seating (and reasonable chairs!)Turn...

Summer SQL Server & Database Events In and Around NY

Summer SQL Server & Database Events In and Around NY-

Happy May everyone! 
Hope those April showers will bring us May flowers! ...

Stupid T-SQL Tricks – Part 1: Logarithms

Not just for math geeks, logarithms and their inverse functions (the exponentials) can have useful and often unexpected capabilities in...

DAX #2 – Installing AdventureWorks DW Tabular Model SQL Server 2012

OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we...

Speaking at Connections

I just got my acceptance to the DevConnections, SQLConnections in September for two sessions:
Continuous Integration for DatabasesMaintaining High Performance When...

SQL #53 – Keyboard shortcut Alt + F1 works now in SSMS 2012

Keyboard shortcut Alt + F1 works now
SSMS has a rich set of keyboard shortcuts that works by default. But in SSMS...

And I wonder, where that column is?

I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs...

The Cardinality Estimator in SQL Server 2014 – Going Forward and Backward

I saw a talk from Joe Sack (b | t) on the cardinality estimator (CE) in SQL Server 2014 and found...

Decks & Demos Live

Hello Dear Reader!  Just a quick update.  I've been traveling a lot and I'm behind in posting some Decks & Demos....