AndyLeonard.blog()

Introduction Tony Davis (Blog) wrote an interesting post (SA no more! – ha!) about users, developers, and especially third-party applications requiring sysadmin or sa login access. Tony makes an excellent point: “Ultimately, the business needs the application to work. The quickest solution to get the application into production is often to grant sysadmin privileges to …
Continue reading Database Security Testing

… you still have time to vote for your favorite SQLRally pre-conference seminars! Whether you plan to attend or not, you can still vote – it’s open to all. There are some really good sessions out there – plus mine! Voting ends at 8:00 AM PT 2 Nov 2010. :{>

Introduction I could run through the abstract for my submission to the SQLRally pre-con – and I will include much of it in this post. But Wait There’s More! It’s difficult to convey in writing my passion for SQL Server Integration Services. I like the platform – a lot. I love sharing SSIS with others for …
Continue reading A Day of SSIS in May

Today, SQLServerCentral republished the first article in my Test-Driven Database Development series: An Example of Test-Driven Database Development. (Thanks SSC!)

Introduction The PASS Summit 2010 is fast approaching, and I’m honored to present two sessions and participate in several events. I look forward to meeting lots of SQL Server professionals – some of whom I already know via Twitter! Tuesday, 9 Nov 2010 12:00 PM Birds of a Feather – I’ll be hosting a table to …
Continue reading PASS Summit 2010 Fun

Introduction I had a great time in Boston earlier this month delivering the three-day version of From Zero To SSIS! – the only SSIS class written cover-to-cover by me. The feedback was very positive, which made me feel really good about spending a year designing a course to thoroughly instruct developers and DBAs in SSIS …
Continue reading #SSIS Training Live and In-Person

SQLRally The SQLRally team has been working overtime and you can now vote on the pre-conference session you’d most like to see. What a great idea. This is a much better way to select pre-cons. This way, the SQL Server Community wins. I submitted a pre-conference session called A Day of SSIS. You can cast your vote …
Continue reading SQLRally Pre-Conference Voting Is Open!

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. It’s going to be fun and I hope to see you there! :{>

Introduction This post is the twenty-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 Balance, Part 1 Balance, Part 2 Definition of a Great Team The 15-Minute Meeting Metaproblems: Drama The Right Question Software is …
Continue reading Bridge Architecture

I’m honored and excited to present SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns for SQLLunch today (11 Oct 2010)! In this talk, I cover building a custom logging solution in SSIS. I hope to see you there! :{>