PASS in Five Years: It's about the Members

Andy Warren (blog | twitter) recently blogged about wanting input on What Should PASS Be? and I think it's a reasonable...

Why knowledge of internals is required for DBA? here is a valid reason

I got a report from development team that section of BizTalk communicating with SQL Server to update status
is frequently...

Writing Better Queries Presentation Materials

I delivered a webcast for the PASS DBA Virtual Chapter yesterday. It was called Tips & Tricks for Writing Better Queries. I really appreciated everyone who made the time...

Writing Better Queries Presentation Materials

I delivered a webcast for the PASS DBA Virtual Chapter yesterday. It was called Tips & Tricks for Writing Better Queries....

“Apparently, you signed a software services agreement without fully understanding it.”

I am not a lawyer. Let me say that again, I am not a lawyer.

Todays Dilbert has prompted me...

Visualize Tech Skills

Is your area of responsibility starved for resources? Is it difficult to get a raise? If so, don't despair. You're...

Configuring Antivirus for SQL Servers

I've been on both sides of the debate with respect to whether or not to install antivirus software on a...

SQLskills Immersion Event on Internals and Performance – Day 3

Overview
Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a...

How Can I Help You Go To SQLRally?

I bet by now you've heard of SQLRally, be it from the blogosphere, Twitter, the PASS Connector bi-weekly emails, word...

Emailing tempdb Query Results to Paul Randal with PowerShell

I was referred to someone on twitter today who wants to email query results without setting up database mail.  I explained this in Post 6 of PowerShell Week at...