THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Elegant Design   (RSS)
Showing page 1 of 2 (12 total posts)
  • SSIS Design Patterns Training in London 8-11 Sep!

    A few seats remain for my course SQL Server Integration Services 2012 Design Patterns to be delivered in London 8-11 Sep 2014. Register today to learn more about: New features in SSIS 2012 and 2014 Advanced patterns for loading data warehouses Error handling The (new) Project Deployment Model Scripting in SSIS The (new) SSIS ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 16, 2014
  • I Touched a Screen (and I Liked it)

    This is a picture of my son, Stevie Ray, learning SQL on my Surface Pro 2. I bought the Surface Pro 2 the day it was released. I didn’t pre-order it because I wanted to read what others had to say about it first. I’m an early-adopter, but not the earliest of adopters. I did not like it at first. “Why not, Andy?” I’m glad you asked. The form ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 15, 2013
  • It’s About Delivering Value, Stupid

    James Carville coined the phrase, “It’s the economy, stupid,” as part of Bill Clinton’s 1992 US Presidential campaign. I’m not fond of the “stupid” part. But I have also never successfully advised a governor to become President of the United States by unseating an incumbent President who enjoyed a 90% approval rating earlier in his presidency. I ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 11, 2013
  • Little Data Remains Important in Healthcare IT

    In his article Healthcare's Big Problem With Little Data, author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization that, I suppose, many thought would organically and naturally occur, stabilize, and be ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 30, 2013
  • SSIS Design Patterns, the Book

    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 ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 6, 2012
  • SSIS Snack: Name Those Connections!

    When creating Connection Managers in SSIS, take a moment to click the “All” page and set a value in the Application Name property. In SSIS 2008+, a default value is applied to this property. It’s useful but it contains a GUID. Yuck. I prefer to enter a more concise identifier like the one shown here:   “Why should I enter this ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 9, 2012
  • SQLTreeO–Folders in SSMS

    Introduction I got a note from Jakub Dvorak via LinkedIn inviting me to try SQLTreeO. I checked out the site, liked what I read, navigated to the download, and installed it. I think it’s pretty cool. Here’s how I used it: Create a New Folder in SSMS To create a folder, right-click the desired parent folder and click New Folder:   When ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 30, 2011
  • (YED) Young Engineers Disease

    Introduction When I was a young man (yes that's been a while now) I suffered from Y.E.D. (Young Engineer's Disease). Here are some of the symptoms. Sunny-Day Design The design assumes the user thinks like a software engineer. For example, the user is expected to: Click buttons in a prescribed order. Know, or be able to deduce, things ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 8, 2010
  • 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement