Tag: PASSProfDev

July PASSMN Meeting

Dude! Itzik Ben-Gan… Dig it!

Start Date/Time:
Tuesday, July 20, 2010 5:00 PM

End Date/Time:
Tuesday, July 20, 2010 7:00 PM

Query Tuning Tips with Itzik Ben-Gan

Meeting sponsor: Digineer

Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437

Live Meeting

·         URL: https://www.livemeeting.com/cc/usergroups/join?id=7DGRT6&role=attend&pw=h*ZR%248%25%2Fd

·         Meeting ID: 7DGRT6

·         Entry Code: h*ZR$8%/d


5:00 –5:15 : Announcements
5:15 –5:25 : Sponsor
5:25 –6:45 : Query Tuning Tips (Itzik)
6:45 –7:00 : Survey Collection and Giveaways


Query Tuning Tips

Given a SQL Server querying problem there’s much that you can do to enable a good performing solution. Tuning involves arranging an optimal physical environment, e.g., by creating supporting indexes, as well as writing the query in a way that it would get an optimal execution plan. Many factors can affect the efficiency of the solution including the availability of indexes, data distribution and density, and others. In different scenarios, a different solution could be the most efficient for the same querying problem. Query tuning could be considered an art. This session will provide various tips to do efficient query tuning and demonstrate those through specific tuning examples.

Itzik Ben-Gan is a Mentor and Co-Founder of Solid Quality Mentors. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2008: T-SQL Fundamentals, Inside Microsoft SQL Server 2008: T-SQL Querying and Inside Microsoft SQL Server 2008: T-SQL Programming. He has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN. Itzik’s speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Mentors’ events to name a few. Itzik is the author of Solid Quality Mentors’ Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities..

PASSMN June Meeting: What’s New In SSRS 2008 R2

I have been lax in promoting my local SQL users group, so here goes. Oh, by the way, it’s Lara’s fault that I am a SQL Server consultant. Thanks Lara!

June PASSMN Meeting & Newsletter
Sponsored by Magenic

There will be books, shirts and other swag at the end of the meeting!

Location:    8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437
Date:     June 15th, 2010
Time:    3:00 – 5:30

Please click here for meeting details and to RSVP.

Registration has changed with the move from our previous hosting site and you will be required to log into http://www.sqlpass.org in order to register for our events. If you have any issues with this, please contact support@mnssug.org.

What’s New in SQL Server 2008 R2 Reporting Services

Lara Rubbelke (Twitter | Blog), Microsoft

Amp up your Reporting Services with the many great enhancements in SQL Server 2008 R2. Lara will take you on a tour of all that is new in R2 including collaboration features, new visualizations, rendering enhancements, and new data sources. After this session you will wonder why they call R2 an "interim" release!

Questions for presenters?
If you have any questions you would like our presenter to answer in the meeting, feel free to submit them ahead of time to support@mnssug.org or to any of the board members before the meeting. All question askers will be kept anonymous.

Other News
•       Live Meeting
   o    Beginning in 2010 meeting, you will now be able to join monthly meetings virtually through Live Meeting. This is a great opportunity to stay connected that has been provided to us by PASS.
•       SQL Azure Presentation
   o   Presented by Mike Benkovich at Twin Cities Cloud Computing User Group (TCCCUG)
   o   July 8th, 2010
   o   Click Here for more information
•       PASS Summit 2010
   o    Registration for PASS Summit 2010 is now open. Register for only $1,395 until June 30. Tap into your 2009 or 2010 training budgets to take advantage of the low rate for PASS Summit.

Professional Development Plans: Turning Your Job Into a Career

This past Thursday, I watched a Live Meeting webcast by Andy Warren (Twitter | Blog) on Building a Comprehensive Professional Development Plan. Thanks to Jorge Segarra (Twitter | Blog) for organizing it. The recording can be found here.

Andy provides a lot of great food for thought and I highly recommend taking time to watch it. I won’t simply regurgitate it all here. But here are a few of the key points I wanted to focus on:

  • No one is going to build your career for you. You have to take ownership of that yourself.
  • Building your career requires resources like time and sometimes money. The key is to find a balance that prevents burnout and makes the best use of the funds you have available.
  • Writing is important. The ability to convey your ideas and share your knowledge well can go a long way toward building your brand.
  • Networking can be a very important part of increasing awareness of your brand. You may even find yourself a good mentor in the process.

At Digineer, the consulting firm I work for, we have formal Professional Development Plans. That is one of the  many aspects I love about Digineer: they want their employees to continue to grow and develop and they provide support in doing just that.

I want to stress that the idea of a PDP is not just for technical folks. In my opinion, one can apply a PDP in pretty much any industry or area of focus.

Before I get into my own PDP, I think it makes sense to explain a bit about what my overall goals are as a person. You will see later that my PDP goals tie in well with my personal goals.

The following poem on Success is actually a very accurate depiction of my general goals for myself in life. I think people who know me well will be able to see my behavior and attitude represented in these lines. This poem is often attributed to Ralph Waldo Emerson; although there is some controversy about that.

To laugh often and much;
to win the respect of intelligent people 
   and the affection of children;
to earn the appreciation of honest critics 
   and endure the betrayal of false friends;
to appreciate beauty; to find the best in others;
to leave the world a bit better,
   whether by a healthy child,
   a garden patch
   or a redeemed social condition;
to know even one life has breathed easier
   because you have lived.
This is to have succeeded.

My PDP has both short-term and long-term goals. I find it helps if I have some goals that are more immediate so that I can prioritize and keep myself going. I have also taken long term goals and broken them up into component parts as short term goals. That way, my short term goals can essentially provide the roadmap to my long term goals, allowing me to make progress in strides and effectively track that progress.

My most immediate short term goal is to pass the MCTS SQL Server 2008  Business Intelligence Development and Maintenance (70-448) exam by June 30th 2010. I want to point out that the true goal is not merely passing the exam and getting a cert, but rather to learn the material. Taking the exam is merely the measurement of how I have learned that material. And, when all is said and done, certifications certainly don’t hurt. Note: One of the reasons I have June 30th as a deadline is that June 30th also happens to be the deadline for the free retake as part of the Second Shot promotion. I take my first shot on June 1st.

The long term goal I wish to share is a lofty one. The following quote comes from here:

“The MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their deep, real-world knowledge about Microsoft technologies with others.”

Like with my certification goal above, the credential itself is not the real goal. Rather, it is the measurement of accomplishing my true goals. The MVP jacket is cool, as is the MVP logo you can put on your blog and in your email auto signature; but it’s not about any of that. If I can earn the right to be an MVP, then that means that I have, on a professional level, accomplished many of the the goals I have in life within the SQL community:

  • Win the respect of intelligent people
  • Earn the appreciation of honest critics 
  • Know even one life has breathed easier because I have helped them through my blog, a presentation, twitter, client engagements, etc

My plan for achieving this goal involves several steps, which map to the points gleaned from Andy’s PDP presentation.

I am taking charge of my own career by spending resources improving my knowledge and skills within SQL Server. In addition to reading blogs and attending meetings at my local chapter of PASS (PASSMN), I also attended SQL Saturday Chicago (which was a great means of networking as well a source of quality information). While the registration for the event itself was free, i did incur travel and lodging costs for my time in Chicago. And I have to say my experience was worth every penny and then some.

In terms of writing, I have established the blog you are currently reading. While I don’t post as often as I would like, I am working on that.

In terms of networking, don’t underestimate the power of “social media.” The SQL community on Twitter is remarkable. While many people do use twitter for just inane banter and letting all of their followers know every time they sit down, stand up, go to the bathroom, breathe, etc, the SQL community is a shining example of using Twitter for broadcasting relevant, quality information. I evangelize Twitter within my own area whenever I can. It is through my blog and presenting that I am building my own brand. It is through Twitter that I am building awareness of that brand.

By monitoring the #sqlhelp hash tag on Twitter, I have also had opportunities to help others in the community. That is not only a fantastic way to reach out for help, but also a way to make an impact by helping out someone else.

I am also currently preparing my abstract for a presentation submission for the PASS Summit in November. I have presented at PASSMN a few times and also within Digineer, as well. Presentations can help you to build your brand and are an awesome excuse to dig deeper into a topic that interests you.

All of these steps are the means by which I am attempting to become a technical community leader who shares deep, real-world knowledge about SQL Server with others. Hm…sound familiar?

I agree with Andy that establishing and maintaining a Professional Development Plan is a great way drive your own future. This goes for non-technical folks as well. I believe that a PDP, and the investment of time (and sometimes money) toward achieving the goals within, is a fantastic step toward turning you job into a career.