|
|
|
|
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!
January 2010 - Posts
-
We're postponing SQL Saturday #30 until 10 April 2010 due to the weather forecast for Friday and Saturday in Richmond VA. :{< Andy Read More...
|
-
Introduction Back in the day (when years began with "1"), I was an electronics instructor at ECPI for a while. I absolutely loved this job! You can learn a lot of logic when you study electronics. And one of the fascinating facts about logic is: There Read More...
|
-
Introduction This post is the seventh part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Balance, Part 2 Read More...
|
-
Introduction Brent Ozar ( Blog - @BrentO ) published a series of posts on experinces authoring his first book. If you're interested in writing, Brent is fresh from the battlefield and eloquently conveys a sense of the trials and triumphs of the experience. Read More...
|
-
Introduction Jack Corbett ( Blog - @unclebiguns ) tweeted recently about recording the start time of a parent package from the child package it called. I responded and ended up writing a small demo project in SSIS 2005 that you can download here . I thought Read More...
|
-
Introduction After Paul Randal ( Blog – @PaulRandal ) tagged him in a post about the three events that brought him here , Brent Ozar ( Blog - @BrentO ) tagged me in his cleverly titled You may ask yourself, How did I get here? So. How did I get here? Read More...
|
-
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...
|
-
Introduction This post is the sixth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Balance, Part 1 Out There If you read Read More...
|
-
Let's say you want to load data from an Excel 2003 (.xls) file into a database using SSIS: If you're running on a 64-bit machine, you'll get this: Plus this error: [PASS Regional Mentor Spreadsheet [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Read More...
|
-
Introduction This post is the fifth part of a ramble-rant about the software business. The current posts in this series are: Goodwill, Negative and Positive Visions, Quests, Missions Right, Wrong, and Style Follow Me Be The Best You You Can Be When your Read More...
|
-
Introduction This post is the fourth part of a ramble-rant about the software business. The first post is entitled Goodwill, Negative and Positive ; the second, Visions, Quests, Missions ; the third, Right, Wrong, and Style . Lead, Follow, or Get Out Read More...
|
-
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...
|
-
Henk van der Valk has started blogging ! You may not recognize Henk's name, but I can almost guarantee you've heard of his work. Henk is a manager for Unisys - he manages the Unisys European Performance (test) Center in Schiphol-Rijk, The Netherlands. Read More...
|
-
I'm thrilled to be presenting Incremental Loads with SSIS to the Orlando PASS Chapter (OPASS) Tuesday evening (12 Jan 2010)! Please email webmaster@opass.org to RSVP. :{> Andy Read More...
|
-
Introduction I love PASS Virtual Chapters ! I appreciate the work PASS has put into the VCs and all things virtual. PASS has done a fantastic job utilizing LiveMeeting. 24 Hours of PASS and Virtual Chapters are but two examples. Virtual Chapters There Read More...
|
-
I'm honored to present Database Design for Developers to the Southern Maryland .Net Users Group ! I'll be there Monday evening, 11 Jan 2010, and the meeting starts at 6:30. If you read this blog and attend, be sure to introduce yourself! :{> Andy Read More...
|
-
Introduction I admire the way Grant Fritchey ( Blog - @GFritchey ) blogged about his PASS Summit Evaluations for several reasons. Chief among them: I love the transparency. It's inspiring! Here's mine: BIA-532-S: Applied SSIS Design Patterns, 119 evaluations Read More...
|
-
Here's a couple cool SSIS Expressions for creating Package Version strings: Format: 1.0.0 (DT_STR,4,1252) @[System::VersionMajor] + "." + (DT_STR,4,1252) @[System::VersionMinor] + "." + (DT_STR,4,1252) @[System::VersionBuild] Format: 1.0.0.20100106 (DT_STR,4,1252) Read More...
|
-
Introduction This post is the third part of a ramble-rant about the software business. The first post is entitled Goodwill, Negative and Positive ; the second, Visions, Quests, Missions . Right and Wrong I've beat on the right-and-wrong drum a bunch in Read More...
|
-
Introduction Lately I've been thinking a lot about business stuff. Scary, I know. This post is the second part of a ramble-rant about the software business. The first post is entitled Goodwill, Negative and Positive . People Come First... In his excellent Read More...
|
-
Introduction I recently blogged about LinkedIn and mentioned I imported my Gmail contacts to grow my network. "Did It Work?" Yes. And how. But I wasn't very smart about how I did it and I'd like to share my mistake and what I learned from it. I like the Read More...
|
-
Introduction Tim Ford ( Blog / Twitter ) tagged me in a post about 2010 Resolutions and Themeword . Resolutions I've not had good luck with resolutions in the past and I think I figured out why: My life doesn't revolve around a calendar year. This sounds Read More...
|
|
|
|
|
|