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 1 of 2 (11 total posts)
  • 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
  • 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement