For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. I take ...

Introduction I wrote recently on the importance of elegance in database design (Art vs. Science). In that post I wrote ''Elegance is a solution crafted to meet the need(s).'' I'd like to elaborate on that point, as it is often the source of some confusion. Elegance vs. Complexity First, a couple statements: An elegant solution will ...

Introduction I read Phil Factor's Database Weekly editorial entitled Basically Available, Soft State, Eventually Consistent. I agree with Phil's conclusions about special-purpose databases that purport to be ''RDBMS killers.'' Please. How Much Paint? Some argue our profession is science. I can see that. Some argue it's a passion. I represent ...