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

I went to SQL Saturday in Tampa!

 My husband and I got married May 3 (I’m not telling the year).  As we were rushing to the airport en route to our honeymoon, we realized that in the chaos of the wedding, we had almost forgotten a present for our mothers on the upcoming Mother’s Day.  I somehow found the perfect card given the circumstances, and we mailed them just as we were leaving.  Here is a rendition of the card we each sent our mothers that year:

 

The reason I’m thinking of that anecdote is that here it is on Tuesday, and it’s my turn for a blog post, and I’m in sort of a rush again.  Not on my way to Europe this time, but anyway; I’m busy.

I wanted to do a write up of SQL Saturday #62 in Tampa which occurred two weeks ago, but I feel like the content is going to be as dense and informative as the above referenced greeting card. 

Suffice it to say that I had a fantastic time.  Organizers Pam Shaw and Jose Chinchilla are to be commended for the hospitality, the food, the speed pass idea.  It was a great weekend. 

It was warm in Florida.  This cannot be overemphasized.  I really enjoyed the Sun (Blog | Twitter) and the way its shininess let me cavort around mittenless.  I hope to return to Tampa every time there is a SQLSaturday in the winter.

My presentation was well attended and well received.  Lots of folks came, including many people who work with SSIS and are pretty famous for it.  Fortunately for me their presences neither made me faint nor throw up, always a bonus. 

I left with more friends and professional connections, and perhaps most importantly, the most awesome SQL Saturday presenter’s shirt EVAH:

If only I had something yellow to wear. Not a polo.

———————————————————-

Finally, I’d like to “roll credits” so to speak and give a shout out to all the great folks I got to spend time with that weekend.  (Loving the networking tab on the SQL Saturday Page!).  Can’t wait to see you all again.

Name/Twitterhandle:

Aaron Nelson @sqlvariant   
Adam Jorgensen   @adam_jorgensen
Andy Warren    @sqlandy
Bobby Dimmick    @kr4ster
Brad Schacht   @bradleyschacht
Brian Knight @BrianKnight
Brian McDonald    @briankmcdonald
David Taylor    @dyfhid
Denny Cherry    @mrdenny
Jorge Segarra    @sqlchicken
Jose Chinchilla    @sqljoe
John Welch    @john_welch
Jason E Bacani    @jebacanisqldude
Jack Corbett    @unclebiguns
Geoff Hiten   @sqlcraftsman
Gareth Swanepoel    @garethswan
Ed Wilson   @scriptingguys
Erika Bakse    @baksedoesbi
Eric Wisdahl    @old_man_fish     @EricWisdahl
Kevin Boles    @thesqlguru

Mike Wells @SarasotaSQL
Pam Shaw    @pamshaw
Troy Gallant    @gratefuldba
Tim Radney    @tradney
Stacia Misner    @staciamisner 

——————————

And lastly, SQLRally voting for the BI Track will be next week.  Don’t forget to vote! (for me! ) 

Julie to Present “Cool Tricks to Pull from your SSIS Hat” at SQL Saturday #62 in Tampa FL

I am honored to be presenting at SQL Saturday #62 which will be held in (hopefully) warm Tampa, Florida on January 15, 2011. The title of my presentation is Cool Tricks to Pull from your SSIS Hat, and it covers the basics of SSIS variables and the Expression language. I will also be participating in the Women in Technology panel discussion.

This event, the first of 2011, will be bustling with fantastic speakers. I’m especially looking forward to the Powershell/SSIS Smackdown with Aaron Nelson (Blog|Twitter) and Mike Davis (Blog|Twitter).

I am also going to the PreCon which will be the Friday before the main event. This is a huge bargain and I didn’t want to miss the opportunity for an entire day of training on (SAN) storage and virtualization for DBA’s and BI for $99. I imagine I’ll be switching from room to room throughout the day. Sign up before tomorrow to join me at this price!

From Pam Shaw and Jose Chinchilla on the PreCon–>

We will also be hosting a Day of Data on 1/14/2011, the day before SQL Saturday #62 in Tampa at the Italian Club in the historic Ybor City district. We are offering 2 all day sessions from which to choose. For the DBAs we have Denny Cherry presenting Storage and Virtualization for the DBA. For the BI focus We have Stacia Misner presenting Business Intelligence End-to-End. The cost is only $99 per person thru 1/5/2011, after that the price goes to $109. This price includes coffee, juice and donuts, lunch, and course materials. Click here to register for Day of Data.

And from @Datachix1 ‘s Mom…. #SqlSat48

Like I mentioned in my post, my mom (Karen Smith, not on the Twitter yet)  came with me to Columbia and decided to come to the day’s events.  She attended sessions all day, sometimes with me, sometimes on her own.  She branched out on her own for two sessions–David Taylor’s “To Click or Not to Click” and Jose Chinchilla’s “Get Cert! Get Cred!”  here are some of mom’s thoughts:

What I most appreciated about David Taylor’s ( @DYFHID ) presentation was his infectious enthusiam for all things SQL.  In addition he offered very practical advice for anyone like him who becomes an accidental DBA. Very good advice for beginners like me.
 
Jose Chinchilla has a plan to get certified: ( @sqljoe ) the why, where and how.  Lots of money saving tips and advice. I came away with something to aspire to! 
 
 
As for SQL Saturdays and PASS, I can’t say enough about them. I’ve worked at conferences and attended a few. I have to say this gang really know how to put on a seminar:  great sessions, great topics, great speakers, really nice venue and food! The organizers really know how to pull it off. This is a great community!

#sqlsat48 Datachix1’s Wrapup. Columbia SC/October 2, 2010

I had a great time at this past Saturday’s event in Columbia, SC where I  was lucky enough to be presenting.  I forgot to mention during my presentation –“Cool Tricks to Pull from your SSIS Hat” –that Carolina is my alma mater, and the Columbia area was home to me and my parents for 8 years. 

This was my first time back in 15, and besides the great professional event, I got to see several dear dear, friends from my previous life which was in Theatre.  I stayed at the lovely Hampton Inn in downtown Columbia (in the newish Vista area).  My mom came with me and we caught Rent at Trustus Theatre, which was only a few blocks from the hotel.  What an amazing show!  Shout out to the folks at Trustus for 26 years of theatrical awesomesauce. 

My mother happens to be a smart lady who is also interested in the SQL Server lifestyle, so she also came with me to the speaker’s dinner and the event itself.  It was really nice to share a little of my career with her.  I’m pretty sure she loved it.

This event was swarming with MVP’s and VIP’s and I got a chance to meet quite a few great folks and cavort with people I already knew. 

Where should I start?  Maybe with my some of my homies from Atlanta…..

Mark Tabladillo.  He’s a super smart guy with whom I shared a great conversation at the Speaker’s Dinner about Data Mining and ways to test the trustworthiness of your results and predictions.  My conversation with Mark illustrated to me the beauty of SQL Saturdays and events like them—you can not only learn cool and useful things, but enjoy great conversations and build relationships from which you can continue learning. 

Bob Langley.  Bob sat next to me at the speaker’s dinner and I was pretty sad to learn that we were scheduled to speak in the same time slot, because his presentation on Column Level Encryption really interested me.  This is a request I have received before, and I want to see what the possibilities are.  This was Bob’s first speaking engagement—kudos for speaking.

Stuart Ainsworth.  Stu did 3, yes 3 presentations.  I was not able to make any of them because of the restraining order, (just kidding), but I did hear that he did a great job.  He reported that his lunchtime demo was slightly hindered by a runaway process which ate his laptop, but I don’t think anyone noticed because

— the LUNCH was AWESOME!

                And FREE!  Thanks Sponsors

Special thanks also to Brian Kelley and Bobby Dimmick (and all the volunteers, especially Paul Waters who was my AV helper and the lovely man who watched our stuff all day in the speaker’s room).  The day really did go beautifully. 

Now the Outliers:

David Taylor from Alabama by way of Boston.   David was doing a new presentation on DBA tasks which my mother loved.  David is a recent convert to SQL Server whose enthusiasm for our community is palpable.  I always enjoy seeing David.

Jose Chinchilla.  Jose is a super nice guy that  I got to sit with at the Speakers Dinner as well.  He is running a SQL Saturday event in Tampa in January of 2011, which I hope to make.  Mom sat in on his certifications session, and she is really excited about getting some certifications now. 

Andy Leonard. (Blog | Linkedin | Twitter)  The Man . The Myth. The Moustache  :{>.  Andy is one of those Rock Star names in BI that I was super excited to get a chance to meet and hear present and he didn’t disappoint.  He loves his work and he loves his family and he loves sharing the tools of our trade with people.  I watched both of his presentations and got to learn how bigger shops can standardize large deployments and solutions, with clever safeguards in place.  He took time to talk with me about my presentation, sharing with me some additional xml tools I could use and giving me praise which made me all giggly.

Andy Warren. (Blog | Linkedin | Twitter) Co-founder of SQL Saturday, SQLServerCentral and a Director at Large of PASS.  Andy’s presentation on developing yourself professionally was well received and given that bio, I think he knows of what he speaks.  He encouraged us to think of ourselves as a product or business, and to develop a business plan accordingly.  I concur. 

Jessica Moss.  (Blog | Linkedin | Twitter) So glad I got to meet Jessica and see her presentation on Reporting Services.  Jessica is a great speaker—people were engaged and learning and she has a great time up there, which I love to see.

My presentation went very well.  I had 20 folks and I felt like most of my group was really enjoying it.  Several folks said they learned at least one or two very useful things.  I realized when it was over that I didn’t get very many questions, but people were definitely engaged, so I hope I wasn’t bulldozing them.  Got an average score of 4.6 (out of 5)—the large majority of people liked the presentation a lot. 

My advice to first time speakers:  (Robert Cain also gave me this advice):  practice with 1024×768 resolution.  You would be amazed how much the low resolution will throw you off, and how frequently you encounter it.  Also, practice your presentation with people in an audience—I inflict it on my coworkers.  I did practice runs on Tuesday and Thursday.  Tuesday really kind of sucked (thanks dear coworkers for suffering through it), on Thursday I felt much better and by Saturday I was pretty happy.