I Did It - PASS Nomination Application

I send my board of directors nomination application to PASS and asked for a confirmation. I always worry that something...

It’s the Journey

I saw this on the 37 Signals blog as “I’ve already got the prize" and found it to be both...

SQLRally

A new event is coming to the East Coast next year that will give people a chance to experience a SQL Server conference at a much lower cost.

Collective Intelligence

Trying to keep up with all the learning going on in the SQL Community can be frustrating. Or is it? Give us your answer in this week's Friday poll.

SubQuery Performance

Why would you do this?
select distinct(hostname),
(select count(*) as criticalCnt
from @temp where severity_guid='0168A833-1732-411E-8205-C2F6CD91737D'
and hostname=t.hostname
group by hostname),
(select count(*) as criticalCnt...

The Wiffle-Waffle, or Why I’m Running for the PASS Board of Directors

I’ll announce it here first, along with some reasons why I’m waffling from an earlier post:
I’m going to run...

SQL Audit

Scanning Without Wires - Epson Workforce 610

We are trying to buy another property here at the ranch. My wife had to leave town in the middle...

SQL Saturday Advice - Build a Foundation

I think this is a good idea, and I’ll give you some reasons, but every SQL Saturday ought to consider...

Core DBA Skill – Backing up the tail log

I’ve never had to do this in production, and I’ve only practiced it a few times, but I think this...