Varchar(Max) and ADO

Another note from a friend. They decided to upgrade a large varchar column to varchar(max) and subsequently found strange behavior...

Becoming a DBA, Part II

This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...

Technical Debt/Steve McConnell is the man!

Steve is the guy who wrote Code Complete (get rev 2 if you buy) which I consider to be required...

Replicate Stored Procedure Execution Published on SSC

Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the...

Linking Access to SQL Server Reposted on SSC

This is an older article that was recycled for Fri, but still seems to get a decent number of views...

Two TechEds Better Than One?

Just saw the announcement that there will be two back to back TechEd's next year. Both will be held in...

Mini Review: Building Technical User Communites by Greg Low

I had the chance to see Greg do a presentation at the PASS Summit in Denver that was based on...

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