Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

Browse by Tags

All Tags » database design   (RSS)

• Agile
• Business Intelligence
• Data Warehouse
• Database Developer
• database developers
• Database Testing
• DBA
• Design Pattern
• Developer Community
• LINQ
• MDM
• measurement
• PASS
• PASS Summit 2010
• Presentations
• quality
• scalable
• Software Business
• software developers
• SQL Saturday
• SQL Server
• Support
• User Groups

• Speaking at Roanoke Valley .Net UG 02 Dec 2010!

  I am honored to present Database Design for Developers to the Roanoke Valley .Net Users Group Thursday 2 Dec 2010 ! If you read this blog and will be in the Roanoke Virginia area Thursday, stop by and introduce yourself. :{> Read More... Posted Tuesday, November 30, 2010 8:00 AM by andyleonard | 0 Comments Filed under: database design, Developer Community, Presentations

• Article: An Example of Test-Driven Development, Part 2

  Today, SQLServerCentral republished another article in my Test-Driven Database Development series: An Example of Test-Driven Database Development , Part 2 . (Thanks SSC!) :{> Read More... Posted Friday, November 05, 2010 8:00 AM by andyleonard | 0 Comments Filed under: Database Developer, database design, Database Testing

• Article: An Example of Test-Driven Development

  Today, SQLServerCentral republished the first article in my Test-Driven Database Development series: An Example of Test-Driven Database Development . (Thanks SSC!) Read More... Posted Friday, October 29, 2010 10:00 AM by andyleonard | 0 Comments Filed under: Database Developer, database design, SQL Server

• Presenting Why Consider Semantic Integration? 29 Sep 2010!

  In the third part of our series on building a scalable, enterprise-class data warehouse for SQL Server, expressor 's ( blog | @expressor ) Mike Ruland ( @mruland ) and I present Why Consider Semantic Integration Thursday 29 Sep 2010 at 12:00 PM EDT. Semantic Read More... Posted Monday, September 27, 2010 8:00 AM by andyleonard | 0 Comments Filed under: Database Developer, database design, Data Warehouse

• Presenting the Importance of Good Metadata Management 8 Sep 2010!

  In the second part of our series on building a scalable, enterprise-class data warehouse for SQL Server, expressor 's ( blog | @expressor ) Mike Ruland ( @mruland ) and I present the importance of good metadata management tomorrow at 12:00 PM EDT. Metadata Read More... Posted Tuesday, September 07, 2010 1:00 PM by andyleonard | 0 Comments Filed under: Database Developer, database design, Data Warehouse

• Reminder: Presenting Database Design for Developers at SQL Saturday Nashville!

  A quick reminder: I am honored to present Database Design for Developers at SQL Saturday #51 in Nashville 21 Aug 2010! If you read this blog and will be in attendance, introduce yourself! :{> Andy Read More... Posted Friday, August 13, 2010 1:00 PM by andyleonard | 1 Comments Filed under: Database Developer, database design, SQL Saturday

• Sessions I Submitted to the PASS Summit 2010

  Introduction I'm borrowing an idea and blog post title from Brent Ozar ( Blog - @BrentO ). I am honored the PASS Summit 2010 (Seattle, 8 - 11 Nov 2010) would consider allowing me to present. It's a truly awesome event. If you have an opportunity to attend Read More... Posted Wednesday, May 26, 2010 8:00 AM by andyleonard | 5 Comments Filed under: Design Pattern, Database Developer, database design, Developer Community, PASS, Business Intelligence, PASS Summit 2010

• The Database Design Process

  Introduction Buck Woody ( Blog - @BuckWoody ) recently blogged about his Database Design Process and I see Grant Fritchey has a ( Blog - @GFritchey ) post on the same topic . I figured I'd throw my two cents into the mix. ADD I often joke that I practice Read More... Posted Thursday, January 21, 2010 8:00 AM by andyleonard | 4 Comments Filed under: Database Developer, database design, SQL Server

• Presenting Database Design for Developers @RichmondSQL Tonight!

  I am honored to present Database Design for Developers to the Richmond SQL Server Users Group ( @RichmondSQL ) this evening! If you're going to be in Richmond this evening and are interested, you can register here . This is the third presentation for Read More... Posted Thursday, January 14, 2010 8:00 AM by andyleonard | 0 Comments Filed under: database design, Developer Community

• Presenting at Southern Maryland .Net User Group 14 Dec 2009

  I'm honored to present Database Design for Developers to the Southern Maryland .Net Users Group ! I'll be there Monday evening, 14 Dec 2009, and the meeting starts at 6:30. If you read this blog and attend, be sure to introduce yourself! :{> Andy Read More... Posted Wednesday, December 09, 2009 8:00 AM by andyleonard | 0 Comments Filed under: database design, Developer Community, SQL Server, User Groups

• 9 Jun 2009: Speaking at the SQL Server Innovators Guild in Greenville, SC!

  I am honored and excited to present Database Development and Application Lifecycle Management - based on my article An Example of Test-Driven Development at SQLServerCentral.com ) to the SQL Server Innovators Guild (what a cool name for a SQL Server user Read More... Posted Saturday, June 06, 2009 1:04 AM by andyleonard | 1 Comments Filed under: Database Developer, Agile, database design, Developer Community

• Twitter Woes

  "My name is Andy Leonard. I tweet." "Hi Andy, we love you." It's true, I am a bona fide Twitter -holic. If you use the service you may have noticed disruptions lately. Frank La Vigne (recently married - congratulations Frank!) blogged about it. The Twitter Read More... Posted Friday, May 30, 2008 10:42 AM by andyleonard | 4 Comments Filed under: DBA, scalable, quality, database design, Database Testing, Support

• Kevin Hazzard on LINQ To SQL

  Kevin Hazzard did an outstanding job presenting to the Richmond SQL Server Users Group this evening on LINQ To SQL! I really like the ORM / code generation aspects of this new feature of the .Net Framework 3.5. Seeing it in action made me yearn (a little) Read More... Posted Friday, May 09, 2008 12:54 AM by andyleonard | 0 Comments Filed under: database design, Developer Community, software developers, LINQ

• Context and Grain

  Introduction: The World Series (1979) and Photography Willie "Pops" Stargell started my interest in photography (...a funny way to start a post on a SQL Server blog site, but bear with me). Pops Stargell led the 1979 Pittsburgh Pirates to win the World Read More... Posted Saturday, November 03, 2007 9:41 PM by andyleonard | 0 Comments Filed under: scalable, quality, database design, software developers, SQL Server, database developers, measurement

• Master Data Management 101: Standardize Units of Measure

  Introduction There's quite a bit of hoopla about MDM lately, mostly due to awareness. While "Lacks needed data" was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007) , "Insufficient Read More... Posted Sunday, October 21, 2007 12:24 AM by andyleonard | 2 Comments Filed under: database design, measurement, MDM