Online Resource: Safari Tech Books Online

I've used Safari (the O'Reilly version) for a number of years now and it is a resource I often recommend...

Studio B

Or maybe C. I think the outside shooting shouldn't really count since that's "on location."

Someone asked me about the podcasts...

Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs

As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...

SQLSaturday Finally Has a Logo

Sometimes its the little things that seem to take forever! We've had a text only logo up for a while,...

Nominations INETA North America Board of Directors

Picked this up from the local Net group here in Orlando. INETA is actually pretty helpful when it comes to...

Tool: KeePass Password Safe password manager/vault

Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open...

If Exists (Select 1...) vs If Exists (select * ...)

If exists is a well known way to improve performance because it returns as soon as it matches a single...

SQL Server: Listing all the database roles for a given database user

SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...

How Much Pizza and Soda for a User Group Meeting (Why You Should RSVP)?

After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...

Becoming a DBA, Part I

A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...