This month we are pleased to host two insightful presentations from fellow CSSUG members.

Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class by Brooke Philpott

SQL Server provides multiple ways to insert data using ADO.NET. We’ll explore individual writes as well as batched writes in non-RPC and RPC form, with a focus on using the internal SqlCommandSet class to get as close as possible to bulk-copy performance, without the restrictions. Along the way we’ll look at the impact of the various methods on the SQL Server plan cache, and address ways to prevent plan cache bloat when using high-volume inserts, ultimately arriving at a method that is very fast and has minimal impact on the plan cache.

Brooke Philpott, Senior Technical Lead, SQL Sentry, Inc. Brooke is the lead developer of SQL Sentry’s award-winning software products. He was also part of the DBA team managing the largest SQL Server hosting shop in the Southeastern United States. Brooke has BS in Mathematics from Davidson College. His hobbies include cooking, photography, music, and video games. You can read his blog here: http://brooke.blogs.sqlsentry.net/

Execution Plans Made Easier with SQL Sentry Plan Explorer by Scott Fallen

Performance tuning execution plans has never been an easy task. Now you can learn how Plan Explorer will help you explore, understand and tune the most difficult query plans. Hosted by the team that made this fantastic free tool. This session will cover the key differences between Plan Explorer and Management Studio’s capabilities.  We will also look at the new ways Plan Explorer provides to examine plan information, making query tuning easier, faster, and less painful. 

Scott Fallen, Technical Specialist, SQL Sentry, Inc.  Scott is a member of SQL Sentry’s pre-sales engineering and support teams.  He conducts product demos, new customer training, and represents SQL Sentry at community events including several recent SQLSaturdays.  His hobbies include motorcycles, gaming, cooking, and home theater.

Agenda:

5:30 PM Networking and Pizza

6:00 PM Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class

7:15 PM Execution Plans Made Easier with SQL Sentry Plan Explorer

7:50 PM Meeting End

7:55 PM Post-Meeting Social Hour - Join Us for Drinks at a venue TBA

Location:

The meeting is being held in the MPR room at the Microsoft Offices. Click for directions. The entrance and the room is marked on the linked map above. Thanks to Bing maps!

Sponsors:

TEKsystems® has been a loyal sponsor of the Charlotte SQL Server Users Group. TEKsystems® provides technology staffing and services, helping businesses deploy high-caliber IT and communications expertise. With roots as the nation’s largest IT staffing firm, they’ve become a billion-dollar services company by blending superior client service with an unrivaled ability to source and manage talent to precise specifications, resulting in successful technology executions. Visit www.teksystems.com for more info.

SQL Sentry, Inc., is a Charlotte based company and a long time sponsor of the Charlotte SQL Server Users Group. SQL Sentry creates software products to optimize the performance of Microsoft® SQL Server® environments.  SQL Sentry software provides unprecedented visibility and control that enables database administrators to monitor their database environment with confidence, and quickly diagnose and solve complex performance problems as they arise. Visit www.sqlsentry.net  for more info.

About Our Group:

Charlotte, NC has a dynamic, growing business environment filled with opportunities for SQL Server professionals. The goal of the Charlotte SQL Server User Group is to encourage and support the growth of that environment by providing a venue for user education and peer collaboration. Our group is a certified Chapter of PASS and we recommend all members join that organization.