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

Draft SQLRally Pre-Conference Seminar Proposal

andyleonard — Thu, 02 Sep 2010 11:00:00 GMT

Introduction

Andy Waren (Blog | @sqlAndy), Jack Corbett (Blog | @unclebiguns), and Kendall Van Dyke (Blog | @SQLDBA) have been busy. They're working on SQLRally - a regional PASS event scheduled for May 2011 in Orlando. Andy does a good job explaining the thinking behind the event in his 31 Aug 2010 post: Positioning SQLRally in the PASS Event Universe.

Pre-Cons

Andy's 1 Sep 2010 post on the topic (SQLRally Pre-Con Selection Process – Draft for Comment) includes a draft document outlining a proposal for the pre-conference selection process. I see improvements over the current PASS Summit pre-/post-conference selection process (which I blogged about here). There's even community engagement in the mix.

The Big (Medium) Deal

I think Kendall summed it up well in this tweet:

Andy and the crew also did a good job with this table:

	Summit	SQLRally	SQLSaturday
Attendance	+3000	Max 600	Avg of 250
Price	$995 – $1995	$299	Free
Duration	3 Days	2 Days	1 Day
Sessions/Tracks	160+	40-48	12-50
Keynote	Yes	No	Sometimes
Exhibit Hall	Yes	No	No
Organizers	HQ	HQ/Local Chapter	Local leaders
Meals	Seated buffett	Boxed lunch	Pizza/Box Lunch

SQLRally is positioned as a regional event. I think regional SQL Server events is a market that's currently underserved and look forward to PASS's offering. Given the SQL Server Community talent behind this event, I'm sure it will be awesome!

:{> Andy

Sessions I Submitted to the PASS Summit 2010

andyleonard — Wed, 26 May 2010 11:00:00 GMT

Introduction

I'm borrowing an idea and blog post title from Brent Ozar (Blog - @BrentO). I am honored the PASS Summit 2010 (Seattle, 8 - 11 Nov 2010) would consider allowing me to present. It's a truly awesome event. If you have an opportunity to attend and read this blog, please find me and introduce yourself.

If you've built a cool solution to a business or technical problem; or written a script - or a bunch of scripts - to automate part of your daily / weekly / monthly routine; or have some advice on community or career development; I urge you to submit an abstract (or four) to present at the PASS Summit 2010. The Call for Speakers is open until 5 Jun 2010!

I submitted the following four sessions to the PASS Summit this year:

Applied SSIS Design Patterns, Part 2 (Level 400 Spotlight)

"Design Patterns" is more than a trendy buzz phrase; design patterns are a way of breaking down complex development projects into manageable tasks. They lend themselves to several development methodologies and apply to SSIS development. Chances are you're using your own design patterns now! At the PASS Summit 2009, Andy Leonard demonstrated ways to use some less-deocumented features of SSIS. At the PASS Summit 2010 Andy shares more SSIS Design Patterns.

This session includes patterns:
- to migrate SSIS packages through your enterprise without editing connection managers;
- to load data from variable-length row files;
- to extend the functionality of the parent-child pattern to create SSIS execution groups.

The session is designed for those with little or no exposure to design patterns or application development methodologies; but with good experience in SSIS. The goal is to introduce the science, terminology, and philosophy of design patterns to those wishing to learn more.

ETL With SSIS (Pre- / Post-Conference)

SQL Server MVP Andy Leonard spends a day walking you through creating an ETL Solution in SSIS to load a Relational Data Warehouse.

Topics include:
- A Brief SSIS Refresher: Business Intelligence Developer Studio
- Relational DW Design Concepts: Dimensions and Facts
- The Dimension
- The Date Dimension
- The Fact
- Externalized Metadata
- Logging
- Execution Strategy
- Monitoring and Maintenance

Database Design for Developers (Level 200)

This 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.

Build Your First SSIS Package (Level 100)

This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Conclusion

Not every submission is selected and that's ok. As I stated earlier, I'm honored to participate in the PASS Summit in any capacity. I hope to see you there!

:{> Andy

24 Hours of PASS

andyleonard — Wed, 12 May 2010 11:00:00 GMT

I am honored to participate in 24 Hours of PASS starting at 8:00 AM 19 May 2010!

My presentation is titled Database Development Patterns and is the second session - starting at 9:00 AM EDT 19 May 2010.

It's free, but you have to register to attend - register today!

:{> Andy

My 2008 PASS Summit Sessions

andyleonard — Sat, 13 Sep 2008 20:05:00 GMT

I am honored to be selected to present at the 2008 PASS Summit!

I'm presenting two sessions: Test-Driven Development For Database Professionals and SSIS Scripting. I've been working on the presentations recently and realize there will be a few minutes left in the SSIS Scripting talk unless I talk slow. (Some people say I talk slow enough already - and that I have a Southern accent. Can you believe it?)

Anyway, I open the floor to you good people - the readers of my blog: What cool (or useful, or challenging) SSIS Scripting demo would you like to see? We'll make it a contest. Leave a comment here (keep in mind I moderate comments so they will not appear automatically) and I'll pick one.

I'll have to come up with some cool gift to award the winner.

:{> Andy

PASS Presentation - SSIS Development And Testing

andyleonard — Tue, 28 Aug 2007 14:27:00 GMT

I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month!

One presentation is entitled Integrate Your SSIS Development. The focus is on SSIS development and testing. I touch on continuous integration and test-first development - using Team Foundation Server for the CI and Team Edition for Database Professionals to test ETL. I use the data collected by ETL Instrumentation in the testing, so this presentation highlights a lot of the pieces of my integrated SSIS development methodology (and previews some upcoming books!).

I hope to see you there!

:{> Andy