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:
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.
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!
I was fortunate to be able to speak at the Microsoft Integration Architects monthly meeting tonight. Thanks to all who came out tonight to see the presentation! This is a great group which tackles Integration from a multi -product standpoint. I am going to be attending these meetings!
Here is a link to download the slides as pdf and a zip with the code:
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
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!