Whitepaper: SQL Server 2005 Physical Database Storage Design

Microsoft has released a whitepaper on SQL Server 2005 Physical Database Storage Design
(Microsoft Word document). It's 35 pages in length...

Be on the lookout for the mistakes of others

I've come to learn that there are some really flaky systems out there.  Not just a few quirks here and...

Distributing Database Connection Strings Using Active Directory Group Policy

I ran into Brian Knight today on the Expo floor here at TechEd.
It was good to catch up a bit...

TechEd - DATTLC01 : Troubleshooting Performance Problems in SQL Server 2005

It's
been a few years since I wrote my eBook on SQL Server performance monitoring
but I still keep a strong interest...

In Boston for TechEd

This will be my first ever TechEd and I'm looking forward to it. I was able to go to the...

Training Center

We kind of opened the training center today. The pages are up, Google's charging us for their nice AdWords, and...

Two things I wish they'd change about endpoints in SQL Server 2005

I've
been playing around with endpoints in SQL Server 2005 looking at how they can
be used to enhance security for SQL...

When It Takes Time...

Saw this from Jason Haley's Interesting Finds post for the morning of May 25, 2006:

Project Managing Latency or: How to...

Disaster Recovery and SQL Server, Part II

In a previous post, Disaster Recovery and SQL Server, Part I,
I pointed to the Microsoft Knowledge Base (KB) article which...

The Business Trap

We finally approved the PO for our training center equipment yesterday and along with the order for the tables, we're...