Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and 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 2008   (RSS)

• BIML
• Books
• Business Intelligence
• Change Data Capture
• Code Camp
• Components
• Data Profiing Task
• Data Warehouse
• Data Warehousing
• Database Developer
• database developers
• Database Testing
• DBA
• Denali
• Deployment
• Design Pattern
• Developer Community
• Elegant Design
• ETL
• ETL Instrumentation
• Expression Language
• I-Am-Such-A-Geek
• Incremental
• Installation
• PASS
• PASS Summit 2008
• quality
• Reporting Services
• Social Intelligence
• SQL Azure
• SQL Server
• SQL Server 2012
• SQL Server Community
• SSIS
• SSMS
• User Groups
• utilities
• Visual Studio 2008
• Writing

• 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: BIML, Books, Business Intelligence, Components, Data Warehouse, Data Warehousing, Database Developer, Deployment, Design Pattern, Developer Community, Elegant Design, ETL, ETL Instrumentation, Expression Language, Incremental, SQL Azure, SQL Server, SQL Server 2008, SQL Server 2012, Writing

• 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: Denali, SQL Server, SQL Server 2008, SQL Server Community

• Presenting at the PASS Application Development Virtual Chapter 8 Sep!

  Business Intelligence at REST September 8th at 1:00 PM Eastern Presenter: Andy Leonard I am honored to present Business Intelligence at REST to the PASS Application Development Virtual Chapter on 8 Sep 2009! This is going to be a fun presentation for Read More... Posted Thursday, September 03, 2009 8:00 AM by andyleonard | 0 Comments Filed under: Business Intelligence, Developer Community, I-Am-Such-A-Geek, PASS, Social Intelligence, SQL Server 2008, SSIS, Visual Studio 2008

• Presenting Incremental Loads, CDC, and SSIS 2008 to Columbus SQL Server UG Tomorrow!

  I'm honored to present Incremental Loads, Change Data Capture, and SSIS 2008 to the Columbus SQL Server Users Group tomorrow evening! This is the first remote presentation I've attempted in a while. I won't be in physical attendance, only virtually. I'll Read More... Posted Wednesday, July 08, 2009 12:30 PM by andyleonard | 1 Comments Filed under: Business Intelligence, Developer Community, ETL, Incremental, SQL Server 2008, SSIS

• xp_delete_file

  Introduction I built a SQL Server 2008 Maintenance Plan and included a Maintenance Cleanup Task. For those who don't work with this stuff every day, Maintenance Plans are actually SSIS packages. The short version of a long story is: I couldn't execute Read More... Posted Wednesday, March 11, 2009 7:00 PM by andyleonard | 28 Comments Filed under: database developers, SQL Server, SQL Server 2008, utilities

• Presenting at New England SQL Server User Group!

  I am getting psyched about presenting to the New England SQL Server User Group in a couple weeks! On 12 Feb I'll be talking about Incremental Loads, Change Data Capture, and SSIS 2008. The bonus is I get to hang out with my friend Adam Machanic ! If you Read More... Posted Wednesday, January 28, 2009 11:35 PM by andyleonard | 1 Comments Filed under: Developer Community, ETL, Incremental, SQL Server 2008, SSIS, User Groups

• SQLPass 2008: Thursday Keynote

  Introduction So, it's a few minutes before the PASS Summit 2008 Thursday keynote, and I'm settled into the Press Table behind the sound board. Tony Davis is here. Steve Jones is here. And I'm seated beside Brent Ozar. Rushabh Mehta To complement Wayne Read More... Posted Thursday, November 20, 2008 12:39 PM by andyleonard | 1 Comments Filed under: PASS, PASS Summit 2008, SQL Server 2008

• Speaking at Raleigh Code Camp tomorrow!

  Code Camp RDU Fall 2008 is tomorrow (15 Nov 2008)! If you're going to be in the Raleigh area tomorrow and are interested in anything related to Microsoft technology, register and check out the sessions . I always have a blast in Raleigh! I will be presenting Read More... Posted Friday, November 14, 2008 7:00 AM by andyleonard | 0 Comments Filed under: Code Camp, Developer Community, SQL Server 2008, SSIS

• Speaking at Midlands PASS Chapter in Columbia SC!

  I finally get to meet Brian Kelley in person! I'll be presenting Incremental Loads, Change Data Capture, and SSIS 2008 to the Midlands PASS Chapter in Columbia, SC on Thursday 2 Oct 2008! If you're in the area and read this blog, stop by and say "Hi". Read More... Posted Friday, September 26, 2008 5:48 PM by andyleonard | 0 Comments Filed under: Change Data Capture, Developer Community, Incremental, PASS, SQL Server 2008, SSIS

• SQL Server 2008 Management Studio - Function Keys

  F7! The F7 key displays details in SSMS 2008. I'm almost positive SSMS 2005 RTM'd with the same funtionality and it was later removed. F8? I love the F7 key. And I love that it displays details when I highlight something in Object Explorer - which, by Read More... Posted Friday, August 08, 2008 1:17 PM by andyleonard | 17 Comments Filed under: SQL Server 2008

• SQL Server 2008 ReleaseWatch!

  With the imminent release of SQL Server 2008, I think we should set up a SQL Server 2008 ReleaseWatch. Who's in? :{> Andy Read More... Posted Tuesday, July 22, 2008 2:54 PM by andyleonard | 4 Comments Filed under: SQL Server 2008

• Installing SQL Server 2008 RC0

  Introduction SQL Server 2008 RC0 has been out for a while. You can download it here . This post is not a detailed examination of the setup options. There are much better articles and posts out there if you want more information. This post represents one Read More... Posted Tuesday, July 15, 2008 12:01 AM by andyleonard | 17 Comments Filed under: Installation, SQL Server 2008

• SQL Server 2008 RC0 Download

  The SQL Server 2008 RC0 download is available to the general public here . For goodness' sake, don't load this on a real machine. Go get Virtual PC or Virtual Server - they're both free. You can get the Trial Editions of Windows 2008 Server here: Windows Read More... Posted Tuesday, June 10, 2008 3:48 PM by andyleonard | 12 Comments Filed under: SQL Server 2008

• Speaking at Philly Code Camp 2008.2 Saturday

  I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008! The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that! Read More... Posted Thursday, May 15, 2008 12:31 AM by andyleonard | 0 Comments Filed under: Business Intelligence, Code Camp, ETL, Incremental, SQL Server 2008, SSIS

• Thanks PassMN!

  I had a fantastic time presenting Change Data Capture, Incremental Loads, and SSIS 2008 to the Minnesota SQL Server User Group tonight! They're a fun bunch. It was cool to meet Lara and Mark in person - and thanks Lara for bailing me out on a couple relational Read More... Posted Tuesday, April 29, 2008 10:43 PM by andyleonard | 2 Comments Filed under: Developer Community, SQL Server 2008, SSIS