PASS 2014 Nomination Committee

I’m officially on the slate and running for the PASS 2014 Nomination Committee!

Why should you vote for Ryan?
I love the PASS...

What is the difference between Money and Decimal(19,4)

One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....

SQL Saturday 294 Philadelphia, Nostalgic!

Less than a week left and I’m extremely excited about SQL Saturday in Philly on June 7th, 2014 and the...

SQL Server Quickie #14 – The Tipping Point

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...

2014 NomCom Slate is Amazing

Serving on the Nomination Committee (NomCom) is such an honor. One that I was lucky enough to experience two years...

How to easily automate SQL Code Guard.

It may happenthatyou have a needto check thescripts thatyou have on yourdisk.  For example, it may be part of yourbuildprocess.So how...

A quicker way to know when DBCC CHECKDB last ran in your database.

Problem : Surely you have scheduled jobs to run DBCC CHECKDB across your SQL Servers to check database integrity. But sometimes...

Building The SQLSaturday Orlando Marketing Plan-Part 16

As you can see my third attempt on Fiverr didn’t work out great. I asked for something bold/high contrast and...

Deferred-drop tipping point

I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...

MDX #41–Remove employees with less than $100,000 sales

Table of contents
Need to remove employees who have zero sales amountCreate a calculated measure with the IIF() function The NON...