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...

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...

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...

SQL Prompt

I downloaded and installed SQL Prompt from Red Gate this morning. If
you aren't aware, PromptSQL was bought by Red Gate...

Disaster Recovery and SQL Server, Part I

The last few weeks I've been working on disaster recovery procedures
for my organization. We review them at least yearly to...

Backing up virtual machines on VMware ESX Server

I know VMware and Virtual Server
technology is becoming more and more prevalent in organizations as both
packages can greatly reduce hardware...