Founded in September 2002, the Cape Cod .NET User Group's purpose is to educate and support developers in the use of Microsoft .NET technologies. All levels, from beginner to early adopter, are welcome.

We are now 202 members

Sign Up

Please sign up for additional information by entering your name and e-mail address in the Sign Up box on this page.

Please note that your name and e-mail entered in the Sign Up box are used only to inform you about events and information concerning this user group. Under no circumstances will your information be shared with others.

Save the date for our first fall meeting Wednesday, September 23

Best Practices for Working With SQL Server Execution Plans

Speaker: Grant Fritchey

Location: Venture Think Together, 540 Main Street, Hyannis 02601
Directions

Wednesday, September 23, 6:00-8:30 PM

This presentation will focus on identifying and fixing common performance and execution problems within TSQL. The methods defined for using execution plans will follow a problem/solution paradigm in order to show practical ways that execution plans can help solve common problems. Access of execution plans is normally only defined as being from the Management Studio GUI.

This session will show methods of access that include direct queries into the procedure cache using dynamic management views and functions and plans captured through the use of trace events defined in Profiler. Access through XQuery against the XML will be demonstrated through several practical applications. The overall focus of the session will be towards practical methods that can be applied in the attendees systems immediately.

Speaker's Bio

Grant Fritchey, Microsoft SQL Server MVP, works for an industry-leading engineering and insurance company as a principal DBA. He's done development of large-scale applications in languages such as Visual Basic, C#, and Java, and has worked with SQL Server since version 6.0.

Grant spends a lot of time involved in the SQL Server community, speaking, blogging, volunteering with PASS, and he is an active participant in the SQLServerCentral.com forums.

He is the author of SQL Server Execution Plans (Simple Talk Publishing, 2008) and SQL Server 2008 Query Performance Tuning Distilled (Apress, 2009).

Thanks to Bill Fallon, Baystate Financial Services, for his June 25 presentation on How to think about your Future and your Career.
Thanks to Adam Machanic for his June 16 presentation on Learning to Harness the Under-Used OVER Clause. Click here for a copy of his presentation.
Thanks to Jim O'Neil, Microsoft Developer Evangelist for his May 12 presentation on .NET Debugging. Click here for a copy of his presentation deck.
Thanks to Bob Depin for his April 22 presentation on LINQ.
Thanks to Mike Cramer, Architect, Microsoft Developer and Platform Evangelism, for his April 3 presentation on Azure. Click here for a copy of his presentation (6.93 MB).