SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...

[Shameless Plug] Can We Have Your Vote?

[Shameless Plug] Can We Have Your Vote?
SQL PASS SQLRally
Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL...

Breaking Down TempDB Contention (part 2)

Breaking Down TempDB Contention (part 2)
Tempdb Contention via Idera Diagnostic Manager
I wrote a somewhat popular script and blog post a...

The Kind of DBA I Want to Be

The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)

I was a big fan of the original Iron...

Including Missing Values in Data Ranges Without a Lookup Table

Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Data

One of the ways that I learn new things...

Webcast: Putting a Better SQL Server in Production

Webcast: Putting a Better SQL Server in Production
Production Line

Webcast:Putting a Better SQL Server in Production
Date: Wednesday, January 18, 2012 3:00...

Using Dynamic Values in XMLA

Using Dynamic Values in XMLA
XMLA

A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...

Undocumented Gotchas of Transactional Replication

Undocumented Gotchas of Transactional Replication
Gotcha - Norelco commercial (1977)
This discussion started on Twitter via the #sqlhelp hash tag. The question that...

PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses

PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
Subject:Row Versioned Data WarehousesStart Time:Thursday, December 15, 2011 6:00 PM US Pacific...

PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?

PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...