July PASSMN Meeting Announced

Posted by & filed under , , , , .

Lego DeadlockSometimes when we are putting together the user group meetings things change.  Opportunities arise and we get a chance to take a cool meeting and turn it into a great meeting.  That happened with this months meeting and it’s going to be great.

A couple things are different for this month… time and topic.  This month instead of meeting at 3:00 PM we are meeting at 5:00 PM.  And the reason for the change is that we have Itzik Ben-Gan (blog) stopping by for a presentation.

The Presentation

This month he’ll be teaching a course at Benchmark Learning.  His course is Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005 & 2008.  If you want more than what you suspect will be at the meeting, then this class is for you.

What can you suspect will be at the meeting this month?  Well, how about this?

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.

Pretty cool stuff, eh?

And the Rest of the Details…

This month’s meeting sponsor is Digineer.  They’ll be providing the food and beverages.  Digineer happens to be my employer and if you’re local and looking for a company with talent and skill this is a good place to look.

Date: July 20, 2010
Time: 5:00 PM – 7:00 PM
Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN  55437
Live Meeting

The all important RSVP link – please do RSVP so that we’ll have enough food for the event.