DataZulu

SQL Saturday - Portland

ewc+blogcomments@datazulu.com — Sat, 06 Jun 2009 07:00:00 GMT

The presentation given yesterday at SQL Saturday Portland is up in the Downloads area. Or directly at this link.

SQL Server 2008 Table-valued parameters and NULL

ewc+blogcomments@datazulu.com — Mon, 04 May 2009 08:00:00 GMT

So it turns out table-valued parameters can be optional with no problem. But it’s non-standard syntax...

Cleaning off 600 MB from my poor laptop with one command

ewc+blogcomments@datazulu.com — Mon, 04 May 2009 08:00:00 GMT

How much old installation garbage is left on your machine? For mine, it was 600MB. Here's how I fixed it.

SQL Saturday Presentation on XML and Relational Databases

ewc+blogcomments@datazulu.com — Tue, 07 Oct 2008 07:00:00 GMT

(See this post for the Presentation and Sample Code.)

Testing for "failure" in VS DB Pro database unit tests

ewc+blogcomments@datazulu.com — Wed, 28 May 2008 08:00:00 GMT

Although I enjoy the unit-testing features of Visual Studio "Database Professional" edition, it is a ghastly oversight that you can't obviously test for certain error conditions. Here's the work-around I'm using...

Cast 'true' as BIT - one step closer to Booleans in SQL Server

ewc+blogcomments@datazulu.com — Wed, 07 May 2008 08:00:00 GMT

Starting with SQL Server 2005 we can use the string literals 'true' and 'false' in place of the 1 or 0 value for BIT types. Here's a quick example.

Reading Recommendations from "Relational Principles" Training

ewc+blogcomments@datazulu.com — Wed, 06 Feb 2008 07:00:00 GMT

I had a fun opportunity to teach some of my relational database thoughts on fundamentals and design issues to a vibrant team at Bally Technologies last week. From those discussions, here are some strong reading recommendations.

Intro to Source-Control for SQL Server development

ewc+blogcomments@datazulu.com — Fri, 09 Mar 2007 08:00:00 GMT

Source control for SQL Server development just isn't that hard. This entry gives some introductory pointers.

Eric's Axioms of Data Management - #1

ewc+blogcomments@datazulu.com — Tue, 07 Nov 2006 07:00:00 GMT

If supporting foreseeable business changes requires adding tables or columns to your database, the design is deficient.

Microsoft Word is a Legal Document

ewc+blogcomments@datazulu.com — Sat, 26 Feb 2005 07:00:00 GMT

To say "Access is a relational database" is as incorrect as saying, "Word is a legal document." We need to be more clear than this as data professionals.