Thanks for attending tonight. Here is the link to the slidedeck.
{August 23, 2011}
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!
{August 17, 2011}
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!
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.
Thanks for coming to my presentation, here is the link to the slides and the code: LINK
–Julie
{February 22, 2011}
Our Busy Busy, Datachix-sy Schedule (as a Blog Post).
I don’t think our pages are coming out in syndication, so I wanted to make sure this gets out. Check out our schedule page!
