THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Elegant Design   (RSS)
Showing page 2 of 2 (14 total posts)
  • How Many SSIS Packages Should I Create?

    Introduction   I received the following questions (paraphrased) from a friend:   I'm building an ETL process with SSIS in which I pull from about 40 tables in DB2. I put the data into staging tables in a SQL Server database. Is it better to have one package with 40 data flows, 40 packages with ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 28, 2009
  • More On Elegance in Database Design: Design Decisions

    Introduction I wrote recently on the importance of elegance in database design (Art vs. Science). In More on Elegance in Database Design: Complexity, I wrote about balancing the amount of complexity in design. In this installment, I want to talk about design decisions. Who's Buried in Grant's Tomb? How many states exist for two-state ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 20, 2009
  • More on Elegance in Database Design: Complexity

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 14, 2009
  • Art vs. Science

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 11, 2009
Privacy Statement