Table Hierarchy updated

Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database.  As I pulled out the script from the...

Table Hierarchy updated

Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...

Win a Free Conference Pass to SQL Server Live in Las Vegas

Taking responsibility for your professional development and making it a priority is essential to being a successful Data Professional. It’s...

Power BI for Office 365 pricing announced

Pricing for Power BI for Office 365 has been announced (see pricing).

 
It’s all very confusing to me but Melissa Coates does a...

Three Hundred!

Just announced on Friday, SQLSaturday #300 will be held in Kansas City, MO, on September 13, 2014 . Everything about that...

Using Outlook.com

I looked at Outlook.com when it launched and recently revisited. I connected a couple of my personal email accounts to...

Thaw, Rinse, Repeat – #SQLPlunge

Three years ago in March of 2011, on a whim, I jumped into a hole in a frozen lake into...

Moving WordPress to Windows Azure

For the past year or so I’ve hosted this blog at Godaddy using their web hosting service. It took a...

Why no discussion of MarkLogic / NoSQL security in light of Obamacare security fiasco?

We are awaiting Polar Vortex 2 in New England and are set to have more snow dumped on us starting...

Myths and Misconceptions about Transaction Isolation Levels

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...