What’s New in SQL Server “Denali” CTP1

Denali. No, not that one...

How many of you have heard that the Community Technology Preview (CTP1) for the next version...

XQuery for the Non-Expert – Terminology

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
It’s time...

A Plug for SQLSaturday #45 in Louisville

My friend Mala is heading up the 2nd annual SQLSaturday in Louisville, KY, being held next year on January 22,...

Announcing the SQLDoctor

Today I’m very proud to announce a FREE SQL Server consulting service from me called
the “SQLDoctor”.

The concept of the SQLDoctor...

Cleaner Code Demos – Speaker Hints

Recently I had the privilege of watching Paul Randal and Kimberly Tripp present (separately) at SQL Server Connections. If you...

Handling Type II Dimension with the MERGE Statement

Microsoft attempted to make our lives easier with the Slowly Changing Dimension task in SSIS.  However, as we all know...

PASS Summit Report 3: Women in Technology Rock!

Last year I was honored to be a member of the Women in Technology (WIT) Panel at the PASS Summit....

Powershell: Calculating Seven Day Retention for Security Event Logs

I needed to figure out how much space was required to maintain 7 days of event log entries for the...

SQLSaturday#59 NYC 2010 - 3 Days Away! - Sponsor Profile

SQLSaturday#59 is only a mere 3-days away!  Today, I am bringing you a sponsor profile for our participating vendors, who...

Template for Tracking Professional Development

One of the ideas I mentioned in my presentation on Comprehensive Professional Development was to set up some type of...