SQL PASS Summit 2011 Roundup

Last week was the annual SQL PASS Summit and I’ll say it was completely awesome.  I signed up for two all day pre-cons: 
Monday –
“A Day of SSIS in the Enterprise” by Andy Leonard (Blog | Twitter), Matt Masson (Blog | Twitter) and Tim Mitchell (Blog | Twitter)
Tuesday – “No More Guessing!  An Enlightened Approach to Performance Troubleshooting” by Adam Machanic (
blog | twitter)

Both pre-cons were worth every penny, all the presenters are just excellent speakers and very knowledgeable.

The next three days were the main conference.  Since so many people have already wrote daily posts I’ll just list them all here for your reading pleasure:

Wednesday

SQL PASS Keynote Notes by Denny Cherry
Summit Sessions Day 1 #sqlpass by Tim Radney
PASS Summit 2011 Day #1 Post #1 by Grant Fritchey
PASS Summit 2011, Day 1 by Kevin Kline
Liveblog for #SQLPASS 2011 Day 1 Keynote by Brent Ozar
PASS Summit 2011:  Wednesday Keynote by Andy Leonard
Microsoft Loves Your Big Data by Mike Walsh
Day 4 Summit Keynotes Live, DENALI HAS A NAME! SQL Server 2012! by Bradley Ball
PASS Summit Day 1 – Keynote Live Blog by Jen McCown
PASS Community Summit Day One Re-Cap by Tim Ford
PASS Summit Keynote Day 1 Hightlights by Jorge Segarra

Thursday

PASS Summit 2011 Day 2 – Keynote Live Blog by Jen McCown
PASS Summit 2011 Day 2 Keynote Liveblog #sqlpass by Brent Ozar
PASS Summit Day 2- Key Notes by Grant Fritchey
PASS Summit Day Two – Electric Boogaloo by Tim Ford
Blogging from the PASS Summit Keynote:  Day 2 by Aaron Bertrand
PASS Summit 2011 Day 2 – Women In Technology & SQLKilt Day by Allen White
Data, Information and Knowledge by Rob Farley
PASS Summit 2011 – Day 2 Keynote by Chris Webb
Day four of Summit – Keynote 2 #sqlpass by Tim Radney
PASS Summit Day 2 – Women in Technology Live Blog by Jen McCown
SQL PASS 2011 Keynote Day 2 by Denny Cherry
PASS Summit Keynote Day 2 by Wes Brown

Friday

PASS Summit 2011 Day 3 – Keynote Live Blog with Dr. DeWitt by Jen McCown
Day 6: Friday PASS Summit 2011 Keynote Live by Bradley Ball
PASS Summit 2011 – Keynote Day #3 by Jason Strate
PASS Keynote Day #3: Dr. Dewitt by Grant Fritchey
PASS Summit 2011, Day 3 – A Tribute to Wayne Snyder by Kevin Kline
Final Summit Keynote – NoSQL = Not Only SQL by Tim Radney
PASS Summit 2011 – Day 3 Keynote by Chris Webb
Blogging from the PASS Summit Keynote: Day 3 by Aaron Bertrand
PASS Summit 2011 – The Final Day by Allen White
PASS Community Summit 2011 Day 3 Keynote by Todd McDermid

I am sure there are more of these posts, I will continue to add to this post.

My Story as a Mom: Promoting WIT in Real Life

Much has been written about the need to encourage young women to seriously consider IT as a possible career choice.  Blog posts such as Women in Technology – Answering the Call by Stacia Misner and Sometimes Saying Yes is all About Not Saying No by Audrey Hammonds speak to the desire of the current crop of lady geeks to ensure that young women know that IT can be a great career choice.

Well, this issue is near and dear to my heart.  And this is the reason why:

Deanna and I

Deanna and I

My daughter, Deanna, just turned 18 this month.  And next week she starts her Senior year in high school.  So, the question “What I am I going to do with my life?” is very much on her mind.  And on mine.

But as much as I would like to push promote the idea of IT to my daughter, I temper my words for two very good reasons:

  1. My daughter is the least geeky member of the family.  I am geeky, my husband is geeky, our son is…well he is so geeky I am convinced that he took all of the geekiness out of the family gene pool and didn’t leave any for his sister!  Seriously, when Deanna was 14 she took a computer fundamentals class and just hated it.  So, at that point, I did not dare suggest she should consider IT as a career choice.  That’s because a long time ago I learned that trying to push people into something they did not want to do was a waste of time…and I learned that from the next reason…
  2. During my teen years, my mother was a nurse.  She loved her job caring for premature babies and worked with several women who loved it as well.  My mother knew the last thing I wanted was to work in a hospital with sick people (Yuck!).  But well-intentioned co-workers, friends and relatives kept asking me, “You are going to be a nurse when you grow up, just like your Mom, right?”  I cringed every time I heard this line and promised to myself that I would never treat any child like this.

So, I never pushed my daughter toward IT at all.   I encouraged her to take challenging classes in high school and do her best in them.  And I kept telling her that she could take on the hardest classes and do well in them.  And she did do well in all of her classes.

But this summer I got the shock of my life:

“Mom, I am going to take AP Computer Science next year”

Amazing!  Here is my daughter, who four years ago didn’t even want to take a computer class to learn about word processing, now willing to study programming!  Wow!

Now, she still doesn’t know what she wants to do after college.  But I am so glad that she is willing to try different subjects, including those she’s rejected in the past.

So, the moral of the story is this:  You may be having a large influence on someone and not even know it.  And it may not reveal itself until many years later.

SSIS Data Sources vs. Package Connections

When I first starting working with SSIS, I had a bit of confusion as to what the difference was between these two objects.  Well, this quick SSIS tidbit will explain.

A data source is a connection string that is created at the project level.  Once a data source is created all of the packages in that project can use it when creating a package connection through the Connection Manager.  Data sources are optional, you can still create the package connection without it. Data sources are helpful in that they provide a way to change the connection string information in one place and then that change will cascade down to all the packages in a project that reference that Data source.  Unfortunately, data sources come with some drawbacks, listed here in this article by Matthew Roche: Reusing Connections with Data Sources and Configurations.

Package Connections are connection strings saved at the package level.  They can reference a project Data Source or they can hold connection string information independent of the data sources for that project.

So, now that you know the difference between the two, how can you tell them apart?  Easy, just take a look at this screen shot.  The package connection based on the data source has the same icon as the data source shown in the Solution Explorer:

image

Meme Monday: A Short Story

Oh no, Yanni Robel tagged me for Tom La Rock’s Meme Monday.  Here it is:

The Internet has all the T-SQL you’ll ever need. Google it!

Now, let me count that again…make sure it is 11 words!

Fun and Joy with Optional Search Parameters

The past few weeks I’ve been writing stored procedures that use optional search parameters. Since this subject has been written about at length by many other SQL folks, with articles that have been very helpful to me, I decided to list the resources here on my blog.

Dynamic Search Conditions in T-SQL – Version for SQL 2005 and Earlier by Erland Sommarskog

Dynamic Search Conditions in T-SQL Version for SQL 2008 (SP1 CU5 and later) by Erland Sommarskog

Sometimes the Simplest Solution Isn’t the Best Solution by Bart Duncan