Search results matching tags 'Database Developer' and 'ETL'

SSIS Design Patterns, the Book

andyleonard — Mon, 06 Aug 2012 16:37:43 GMT

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 publication date is 27 Aug 2012 and I have high confidence in this date.

I take responsibility for publication delays and apologize to those who pre-ordered the book. The reasons for the delays are not important. I have built a career as a software developer and architect based on the following maxim:

Deliver quality late, no one remembers.
Deliver junk on time, no one forgets.

The shared goal of everyone working on this project has been to deliver quality. Proofing the manuscripts, I believe we have achieved that goal.

:{>

Presenting at Regina Technology Community 26 Apr 2011!

andyleonard — Tue, 19 Apr 2011 11:00:00 GMT

Introduction

I'm honored to deliver two presentations to the Regina Technology Community 26 Apr 2011!

Part I - Database Design for Developers
This interactive session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs. Bring your database deployment practices and be prepared to participate!

Part II - Introduction to Incremental Loads
This session is for SQL Server Integration Services (SSIS) developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS.

If you read this blog and are in the Regina area next Tuesday evening, stop by and introduce yourself! Register today!

:{>

SQL Saturday #48 Recap

andyleonard — Mon, 04 Oct 2010 11:00:00 GMT

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 are some sessions I wandered through and some notes from them:

Alejandro Mesa - Parameter Sniffing

I started in Alejandro Mesa's session on Parameter Sniffing. I actually got to speak with Alejandro before his session started. We spoke about family and the importance of feedback. Alejandro is cool. He's friendly and cares about delivering quality presentations. His passion for SQL Server and the community is evident - even if you only spend a few minutes with him.

I listened to the beginning of his session. In the portion I heard, he shared a good definition of parameter sniffing. He summarized the benefits and performance hit of parameter sniffing, and stated he would show how to detect and tune for various sniffing scenarios. I wanted to hear the remainder, but Andy Warren was presenting at the same time...

Andy Warren - DBA 101: The Basics

I skipped over to Andy Warren's (Blog | @sqlAndy) talk on DBA 101: The Basics. Andy is a great presenter who's passion for education and SQL Server are obvious to anyone with a pulse.

From what I heard Steve Jones (Blog | @way0utwest) wrote this presentation. There were 25 people in the room with 27 seats. The number of people in the room are a testament to the popularity of introductory material. It's a cool presentation to introduce people to SQL Server. Andy (and Steve) did a good job covering the objects of SQL Server: tables, views, stored procedures, and triggers. There were good questions from various attendees - evidence they were following and thinking about what they learned.

Introducing any topic in SQL Server in 60 minutes is tough. If you know someone brand new to SQL Server and databases in general, this is a good talk for them.

Julie Smith - Cool Tricks to Pull from your SSIS Hat

Meeting Julie Smith (Blog | @Datachix1) was a cool surprise for me. Julie is a great presenter with years of Business Inteliigence experience. Her presentation covered SSIS Expression Language and Variables. She did a good job with the "gotchas" of Variable scoping - accidentally creating a variable at a lesser scope than intended is a big-ee. She demonstrated the constraint options of the precedence constraint - which is a powerful and under-represented topic in many SSIS training sessions. I learned to use the Preview Pane in Windows Explorer!

I liked her presentation style and the material. Plus she provided some feedback on my SSIS Design Patterns talk that I will incorporate in future 60-minute versions of this talk.

Unfortunately, I needed to leave for the long trek back to Farmville before her session completed. I look forward to learning more cool SSIS tricks from Julie in the future!

Conclusion

SQL Saturday #48 was a huge success. The Columbia community responded to this awesome event by turning out in droves. I found the attendees of my sessions engaged - even right after lunch - and I received awesome questions throughout.

The organizers of the event are to be commended. They organizd an awesome event - from the Speaker Dinner through the After-Event party. About 90% of those in my sessions were attending their first SQL Saturday event.

:{> Andy

New SSIS 101 Article

andyleonard — Thu, 21 Aug 2008 14:20:00 GMT

My latest SSIS 101 article - SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers - is live at SQL Server Central today!

Enjoy!

:{> Andy

From my PASS presentations: Custom Test Condition Code: ETL Counts (Team Edition for Database Professionals)

andyleonard — Thu, 20 Sep 2007 20:47:00 GMT

I'd like to thank the people that attended my sessions at the 2007 PASS Summit in Denver this week! I had a blast and hope you all did as well.

The code will be available from the PASS website and on a DVD. For those in my sessions, I promised I would post the code here for my custom Counts test condition for Team Edition for Database Professionals. Free registration at VSTeamSystemCentral.com is required.

Extending Team Edition for Database Professionals with custom test conditions is fairly straightforward once you understand it. (Like everything else in life, Mr. Obvious...)

If you are completely new to coding and would like to build a custom test condition for database testing, fear not! The last part of Chapter 4 (entitled Testing the Database) of the Wrox book Professional Software Testing with Visual Studio 2005 Team System: Tools for Software Developers and Test Engineers is dedicated to a beginner's walk-through of building your first custom test condition.

Yes I am promoting my new book. There's a reason: it's a good book.

:{> Andy

Technorati Tags: Database testing Team Edition for Database Professionals Custom test condition PASS