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

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

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

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

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

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

Structuring the Blog Better

For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....