Personal Links Minimize

Search Blogs Minimize

Blog Archives Maximize

 OldBlog      
Author: Eric Wilson Created: 2/3/2007
Database and Software Engineering
SQL Saturday - Portland
By Eric Wilson on 6/5/2009
The presentation given yesterday at SQL Saturday Portland is up in the Downloads area. Or directly at this link.
More...
SQL Server 2008 Table-valued parameters and NULL
By Eric Wilson on 5/4/2009
So it turns out table-valued parameters can be optional with no problem. But it’s non-standard syntax...
More...
Cleaning off 600 MB from my poor laptop with one command
By Eric Wilson on 5/4/2009
How much old installation garbage is left on your machine? For mine, it was 600MB. Here's how I fixed it.
More...
SQL Saturday Presentation on XML and Relational Databases
By Eric Wilson on 10/6/2008
(See this post for the Presentation and Sample Code.)
More...
Testing for "failure" in VS DB Pro database unit tests
By Eric Wilson on 5/28/2008
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...
More...
Cast 'true' as BIT - one step closer to Booleans in SQL Server
By Eric Wilson on 5/7/2008
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.
More...
Reading Recommendations from "Relational Principles" Training
By Eric Wilson on 2/5/2008
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.
More...
Intro to Source-Control for SQL Server development
By Eric Wilson on 3/9/2007
Source control for SQL Server development just isn't that hard. This entry gives some introductory pointers.
More...
Eric's Axioms of Data Management - #1
By Eric Wilson on 11/6/2006
If supporting foreseeable business changes requires adding tables or columns to your database, the design is deficient.
More...
Microsoft Word is a Legal Document
By Eric Wilson on 2/25/2005
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.
More...
Blog OldBlog Downloads
Copyright 2005-2009 Eric M. Wilson and Reimage LLC Terms Of Use Privacy Statement