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!

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 design, Database Developer, 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 design, Database Developer, 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: Data Warehouse, database design, Database Developer

• 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: Data Warehouse, database design, Database Developer

• 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 design, Database Developer, 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: Business Intelligence, database design, Database Developer, Design Pattern, Developer Community, PASS, 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 design, Database Developer, 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: Agile, database design, Database Developer, 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: database design, Database Testing, DBA, quality, scalable, 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, LINQ, software developers

• 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: database design, database developers, measurement, quality, scalable, software developers, SQL Server

• 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, MDM, measurement