Full Day of Training Offered by the DataChix! (On Pi Day, no less)

Do you want to learn about Data Warehouses? Do you want to learn about Extract, Transform, Load with SSIS?

Do you like Pi?

piday











Do you like Pie?

Learn DataWarehousing with the DataChix!

SQL Server MVPs and popular blogging team Audrey Hammonds and Julie Smith of DataChix.com offer this one day of training to benefit The Cloverleaf School of Atlanta in cooperation with The American Legion Post 251, Duluth, GA. Audrey will take you on a guided tour of converting a transactional model into Dimension and Fact tables. After the model has been created, Julie will guide you through loading those tables using SQL Server Integration Services.

To top it all off, it’s happening on March 14th folks.

That’s right. 3/14 Pi Day. Could there be a better way to celebrate the irrational number which represents the ratio of a circle’s circumference to its diameter than by using SSIS? NOPE! But maybe we’ll get some delicious Pie to celebrate as well!

Audrey and Julie bring over 25 years of warehousing experience to this fantastic day of training, but don’t say that to their faces!

audreyjulieaction2

Part I Dimensional Modeling with Audrey

Why Transactional databases are the way they are—Codd’s rules to live by

Why Codd’s rules don’t work for Reporting– Kimball’s rules to live by

Fun at the whiteboard converting a transactional model to a dimensional model.

Part II Extract Transform and Load using SSIS with Julie

A tour of SSIS

audreyjulieaction3












Control Flow Basics

Data Flow Basics

How to load Dimensions with SSIS

How to load Facts with SSIS

Why SSIS has got such a bad rap sometimes.

Frameworks

What happened and when

When things go wrong, how to know the details

Top quirks of SSIS—what, why, and how to get around them.

Data Quality! We’ll throw in a little Data Quality Services with our ETL!

Lunch and Continental Breakfast provided. Please contact the organizer at the above email for any special dietary considerations! Thanks and see you on Pi Day!

FOR TICKETS—–http://datawarehousingdatachix.eventbrite.com/#

Can’t make it to this great day of SSIS training to benefit the school, but you’d still like to support our mission? http://t.co/VX6yGftC

Our Busy Busy, Datachix-sy Schedule Revised as of 8/23/2011


Audrey and I had to have an emergency board meeting tonight to discuss the state of the DatachiXiness.  We are completely stoked (and a little verklempt) about the upcoming months:

September 8th

Audrey previews her Summit Spotlight Session at 24 Hours of PASS,  T-SQL Awesomeness – 3 Ways to Write Cool SQL   (also our writing partner Aaron Nelson (Blog | Twitter)  is appearing in this event as well, see here for his session Why PowerShell on September 7th).

September 17th– SQL Saturday 89 Atlanta

Audrey and I are helping to organize a truly fantastic SQL Saturday event in our hometown of Atlanta.  We are also putting on a couple of Pre-Cons.  This event is going to be amazing, with national as well as local talent appearing.  See here for details.

And now for the Big Show:  PASS Summit 2011 October 11-14

Audrey will be delivering two sessions,  Summit Highlight T-SQL Awesomeness – 3 Ways to Write Cool SQL and a lightning talk entitled How to Make Your Data Model Suck Less.

And thanks to you good SQL Community Voting People, I will also be speaking!  My session with Aaron Nelson ETL Smackdown:  PowerShell vs SSIS was one of the 5 selected community sessions!  I was truly speechless to have been included on the ballot with some of the most respected folks in our community.  It was an exceptional honor–thank you SO much!

An Ode to a Pre-Con– John Welch is Completely Awesome.

I am honored to be part of the team which is bringing SQL Saturday 89 — Atlanta, GA  to the community on September 17th. As an extra special treat, we are also bringing two Pre-Cons on the Friday before the Pre-Con for only $99.

Troubleshooting and Performance Tuning with Kevin Kline

AND…..

Data Warehousing with SSIS Deep Dive by MS SQL MVP —-John Welch

Today I want to tell you why you should attend John Welch’s Pre-Con.

At $99 –This is a bargain. Some phrases become trite with overuse. Phrases like: “A Fraction of the Cost”, “Gubernatorial”, “Buy now and get this personal pizza oven”.  But Google “SSIS training” and look at the prices.  Also look at the fact that this is only one day off of work, and if you are local, no travel. Also, you get John Welch live and in person. You can ask him questions!

John Welch (Blog | Twitter) is completely awesome.  He’s a skilled practitioner and a great speaker. He’s a Microsoft SQL Server MVP and was a contributing author to MVP Deep Dives. I learn something from John every time I see him–see this blog  post for how John helped me with Error Handling in SSIS. He’s been doing this ETL stuff for a long time and he’s got more tricks for doing it quickly and properly than Jason Bacani (another team member– Blog , Twitter) has shoes (next time you see Jason, ask him how many shoes he owns and report back, it’s astounding!). There have been many times when I have been completely stumped with a problem and found the answer on John’s blog  (he’s really good at working with XML in SSIS!).

Do you use BIDS Helper?  John Welch worked on that project. That’s right. John Welch helped write the code that turns your connection managers blue and pink and resets your GUIDs when they are trying to ruin your life ! Wouldn’t you like to learn from the man who helped tame SSIS with BIDS Helper and other similar projects ? Shouldn’t you thank him?!!!

Survival. If the subject matter in this session is not part of your job today, it will be soon. You will always need to know how to move data from Source A to Destination B. No matter the size your organization or your relationship with said organization’s data, there is almost always a moment when you are faced with importing or exporting data. It comes with being a DBA. While there are as many ways to accomplish this as there are DBA’s out there to do it; SSIS is actually built exclusively for this purpose. It may have bulky bells and whistles, but SSIS at its core is THE tool given to us by Microsoft to move data. Shouldn’t you learn how to bend it to your will? Could there be a better opportunity? So come on people: click the button!

http://www.eventbrite.com/event/1804919563

Thanks Daytona Beach SQL Server User Group!

The brand new PASS SQL Server User Group in Daytona Beach let me present at their very first meeting July 13th.  Thanks to Brook Ranne and Jim McAleer for inviting me.  I debuted a presentation on the changes forthcoming in SSIS with Denali.  The slides are available here.   If you are in the Daytona Beach area please check this group out!

I also just wanted to share some exciting news for me.  I submitted three sessions for this year’s PASS Summit.  When the schedule came out, none of them made the final selection.  However, this week I found out there still might be hope.  PASS has put together a Community Choice Ballot of 20 sessions for you the community to vote on, and one of mine (SQL Smackdown with Aaron Nelson) made the ballot!  There are five available slots we are competing for.  As I always say, I would love your vote, but regardless of whom you vote for, you should let your choice be known, as there are amazing sessions on the ballot!  Voting ends July 20th, so hurry! And thank you readers for your support this year, without you I’m sure I wouldn’t be on the ballot at all.

Check out the Community Choice Ballot here.

#SQLSat 70 — It was great! Read this if you attended my SSIS session.

Ugh! I screwed up. I’m going to tell you guys about it and beg your forgiveness.

What I did: I gave out some bad info in my session on SSIS in Columbia, SC this past weekend.

What I said: I said that when an SSIS package is executed using a SQL Server Agent job, that the Service Account under which SSIS is running under requires all of the necessary permissions (file, etc). I said that the Service Account for the agent also needs these permissions.

What’s wrong with that: The account under which SSIS runs under is not a player in jobs executed by the Agent. Only the Service Account that the Agent uses matters. If giving that account the necessary permissions is just not an option, then you need to execute the Agent job under a proxy account. Here is an excellent post covering this topic.

How I got screwed up: I got confused with this a few years ago. I had a file permissions error with an Agent job executing an SSIS package and could have sworn that I resolved it by giving the SSIS service account the necessary permissions.

What must have happened: Looking back, the agent must have been running under the same service account that SSIS was running under.

So there it is, my mea culpa. If you saw my session and are reading this, I apologize. Please tell anyone who was with you about my error, so that we can nip this bad info train in the bud. And to the gentleman in the front who doubted me, thank you. Without your help, I would still be operating with false info in my brain. I wish I had gotten your contact info–email me if you read this 🙂

Other than that, it was a fantastic, wonderful event. This was the world premier of my presentation Up and Running with SSIS; what really made me happy was that several of the attendees approached me afterwards and said that they had really gotten some necessary info out of it.