Introduction This post is the seventh part of a ramble-rant about the software business. The current posts in this series can be found on the series landing page. This post is about great teams. A Workplace Hierarchy I borrow heavily from a Maslow-vian (is this a word?) approach. Maslow’s Hierarchy of Human Needs has been applied …
Continue reading Definition of a Great Team
Author:Andy Leonard
On Writing
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. Additional Links Kevin Kline (Blog – @kekline):The Book Writing Business, Part 1The Book Writing Business, …
Continue reading On Writing
SSIS Snack: Passing Parent StartTime to the Child Package
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 I’d share it. Build a Project with a Couple Packages I created …
Continue reading SSIS Snack: Passing Parent StartTime to the Child Package
An Abbreviated History of Andy, Part 1
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? 1. Christy I recently read an article about how some …
Continue reading An Abbreviated History of Andy, Part 1
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 ADD (Andy-Driven Design… what’d you think I meant?). I’m expecting a wikipedia article on this …
Continue reading The Database Design Process
Balance, Part 2
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 this blog you already know I share a lot from my life. I think …
Continue reading Balance, Part 2
SSIS Snack: SSIS, Excel, and a 64-bit OS
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. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with …
Continue reading SSIS Snack: SSIS, Excel, and a 64-bit OS
Balance, Part 1
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 life is over, your tombstone will not read “…was just like Andy Leonard.” …
Continue reading Balance, Part 1
Follow Me
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 of the Way There are a lot of interesting books out there on leadership. I still use …
Continue reading Follow Me
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 me this week! :{> Andy
