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 » SQL Server   (RSS)

• Andy's Crazy Questions
• BIML
• Books
• Business Intelligence
• Community
• Components
• Data Warehouse
• Data Warehousing
• database design
• Database Developer
• database developers
• Database Edition
• Database Testing
• DBA
• Denali
• Deployment
• Design Pattern
• Developer Community
• Elegant Design
• ETL
• ETL Instrumentation
• Expression Language
• I-Am-Such-A-Geek
• Incremental
• measurement
• Mentoring
• Microsoft
• MVP
• No Pony
• PASS
• PASS Summit 2008
• PASS Summit 2010
• PASS Summit 2011
• Presentations
• quality
• Reporting Services
• RichmondSQL
• scalable
• Service Packs
• Software Business
• software developers
• SQL Azure
• SQL Saturday
• SQL Server 2008
• SQL Server 2012
• SQL Server Community
• SQL Server Data Service
• SSDS
• SSIS
• SSMS
• Support
• Team Edition for Database Professionals
• T-SQL Snack
• User Groups
• utilities
• Visual Studio
• Visual Studio 2008
• Windows 7
• Writing
• x64

• RichmondSQL Meeting Tonight! (12 Dec 2013) - Az Arunachalam on Extended Events

  When: Thursday, December 12th, 2013, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM! SQL Server Extended Events Microsoft is deprecating Trace and Profiler, a staple for monitoring SQL server since forever, in favor of Extended Events, introduced in Read More... Posted Thursday, December 12, 2013 7:30 AM by andyleonard | 0 Comments Filed under: Database Developer, Developer Community, SQL Server, SQL Server Community, RichmondSQL

• SQL in the City Event Dates Announced!

  Red Gate rocks. If you didn’t know that already, you know it now. The latest evidence to support this claim is the publication of the schedule for US SQL in the City events. They are: 9 Oct – Pasadena 11 Oct – Atlanta 14 Oct – Charlotte Registration for Read More... Posted Saturday, May 18, 2013 3:00 AM by andyleonard | 0 Comments Filed under: Software Business, Developer Community, SQL Server, SQL Server Community, Community

• 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 Read More... Posted Monday, August 06, 2012 1:37 PM by andyleonard | 4 Comments Filed under: Design Pattern, Incremental, Database Developer, Developer Community, SQL Server, ETL, SQL Server 2008, Components, Business Intelligence, ETL Instrumentation, Writing, Books, Expression Language, Elegant Design, Deployment, Data Warehouse, Data Warehousing, SQL Azure, SQL Server 2012, BIML

• “Do Philanthropy Where You Are”

  That call to action from Microsoft Leadership struck a chord with many in the SQL Server MVP Community. The response? SQL Server MVP Deep Dives , released at the PASS Summit 2009. Proceeds from the sale of that book continue to go to War Child International Read More... Posted Wednesday, October 12, 2011 8:00 AM by andyleonard | 2 Comments Filed under: SQL Server, Books, MVP, SQL Server Community, PASS Summit 2011

• 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 Read More... Posted Tuesday, August 30, 2011 11:52 AM by andyleonard | 4 Comments Filed under: SQL Server, Elegant Design

• Quick Database Connectivity Testing

  Introduction Ever find yourself needing to test connectivity, but you’re on a machine with no client tools? It happens to me occasionally. Here’s one trick to help: UDL files Right-click on the Windows Desktop, hover over New, and click Text Document: Read More... Posted Friday, August 26, 2011 1:00 PM by andyleonard | 5 Comments Filed under: SQL Server, Database Testing

• I Am Here To Help™

  Introduction This isn’t a trick. It’s not a gimmick. It’s not bait-and-switch. It is selfish; please allow me to explain: I Am Here To Help™ This has been my motto for the past few years. How can I serve you today? Are you thinking about starting a User Read More... Posted Friday, August 19, 2011 10:30 AM by andyleonard | 4 Comments Filed under: SSIS, Developer Community, SQL Server, ETL, Support, Mentoring

• Presenting at Hampton Roads SQL Server and SharePoint Users Group Tomorrow!

  I am honored to present Designing an SSIS Framework to Hampton Roads SQL Server and SharePoint Users Group tomorrow, 20 Jul 2011! You can register here . Details: Infotec 100 Constitution Dr Virginia Beach, VA 23462 Wednesday, July 20, 2011 at 6:30 PM Read More... Posted Tuesday, July 19, 2011 1:58 PM by andyleonard | 0 Comments Filed under: Design Pattern, SSIS, Developer Community, SQL Server, ETL, User Groups, Presentations

• SQL Solstice

  Introduction My friends in North Carolina have decided to create a new event called SQL Solstice . Details: 18 - 20 Aug 2011 Holiday Inn Brownstone & Conference Center 1707 Hillsborough Street - Raleigh, NC 27605 Toll Free 800-331-7919 18 Aug - A Read More... Posted Wednesday, June 29, 2011 8:00 AM by andyleonard | 1 Comments Filed under: Developer Community, SQL Server, SQL Server Community

• SQLUniversity Professional Development Week: Learning To Fly

  Introduction Clem and Jim Bob were out hunting the other day in the woods south of Farmville. As they crossed a ridge, they came upon a big ol' Momma Bear and her cub. The larger bear immediately started towards them. Jim Bob took off running as fast Read More... Posted Friday, February 25, 2011 8:00 AM by andyleonard | 1 Comments Filed under: SQL Server, SQL Server 2008, Denali, SQL Server Community

• PASS Goals and the SQL Server Community

  Introduction I was honored to sit at the blogger's table during the keynote sessions at the PASS Summit 2010! Our official job was to promote the Summit keynotes via social media and our blogs. Our unofficial job was to pick on each other. Rob's response? Read More... Posted Monday, November 22, 2010 8:00 AM by andyleonard | 0 Comments Filed under: Developer Community, SQL Server, PASS, PASS Summit 2010

• 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 Part 4 of Building a Scalable, Enterprise-Class Data Warehouse for SQL Server 20 Oct 2010

  I am honored to present Part 4 of 4 of Building a Scalable, Enterprise-Class Data Warehouse for SQL Server Wednesday, 20 Oct 2010! This presentation features a demo of expressor 3.0 studio by Steve Frechette, expressor's Vice President of Engineering. Read More... Posted Friday, October 15, 2010 8:00 AM by andyleonard | 2 Comments Filed under: SQL Server, ETL, Data Warehouse

• SQL Saturday #48 Recap

  Introduction I got to attend SQL Saturday #48 2 Oct 2010 and was honored to present. "I'm Andy, and I'm a session-hopper." There. I said it. When I'm not presenting, I often wander between sessions. I want to learn a little something from everyone. Here Read More... Posted Monday, October 04, 2010 8:00 AM by andyleonard | 3 Comments Filed under: Database Developer, Developer Community, SQL Server, ETL, SQL Saturday

• T-SQL Snack: Why Does SSMS Generate Create Scripts With EXEC dbo.sp_executesql?

  Introduction I've been meaning to blog about this for a while and a question from a team member prompted this post (thanks Allan!) SSMS Scripting Options In SSMS you can script a stored procedure - right-click a stored procedure, hover over Script Stored Read More... Posted Monday, July 19, 2010 8:00 AM by andyleonard | 9 Comments Filed under: SQL Server, SSMS, T-SQL Snack, No Pony