Building HTML Emails With SQL Server and XML

Building HTML Emails With SQL Server and XML
I’ve written a lot of custom reports in my days that output data...

Daily SQL Server 2008 New Features – Day 23

Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...

DBA Hell

On the first day of DBA hell, the server gave to me

A database with damaged system tables and no good...

Hawaii is Not Prometric Microsoft Certification Test Friendly

While I was at TechEd last week, I got a 50% off Microsoft Certification test voucher that expires on June...

Insert Unknown Row to Dimension Table

When building a warehouse there is a common practice of adding an Unknown row to the Dimension tables.  For me,...

Networking – A Year Later

I was excited to attend the networking session last year at the PASS Summit. Andy Warren and I had talked...

oPASS Meeting Tonight June 15, 2010 – Featuring Kendal Van Dyke

We’re meeting from 6-8 pm as usual, with Kendal Van Dyke presenting Paging Dr Availability, You’re Wanted In the Recovery...

Report Render Duration

Every once in a while I come across a scenario where I really want to know how long it took...

Sarasota SQL Server Users Group

Tonight I’m presenting for the Sarasota SQL Server Users Group. If you’re interested in attending, you can join in using...

SQL Server XML Schemas

Ever been curious about the schema of , say an SSRS rdl file ?  How about the execution plan ?
Not only should...