For the past 1 1/2 years now we’ve been hosting two presentations each meeting. The first presentation is typically a 30 minute intro level topic and the second a 60 minute more advanced topic. This month we are giving something else a go. We are hosting two 60 minute presentations. The first topic is “Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class” being presented by Brooke Philpott of SQL Sentry. The second presentation is “Efficient Operational Data Replication (ODR) with the Attunity CDC Suite for SSIS” by Doug Wheaton of Attunity. Attunity is also the featured sponsor for this month.
Here is more detail:
The first presentation, "Turbocharge SQL Server Insert Performance with the Hidden SqlCommandSet Class" will be given by Brooke Philpott of SQL Sentry.
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 is a Senior Technical Lead at 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. Brook 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/
The second presentation, "Efficient Operational Data Replication (ODR) With the Attunity CDC Suite for SSIS" will be given by Doug Wheaton of Attunity.
During this presentation you will learn how to leverage your SQL Server skills and software to reduce cost and accelerate operational data replication (ODR), synchronization, and real-time integration of heterogeneous data sources including SQL Server, Oracle, and DB2. Doug will explain CDC (change data capture) and ODR concepts and benefits as well as how you can use them to enable operational reporting and business intelligence or to maintain data consistency across systems.
Doug Wheaton is a Senior Software Engineer at Attunity and has over 20 years of experience in the content, workflow management and data integration space. He has written numerous related articles and has presented at many Microsoft conferences throughout the US on the topic of data integration using Microsoft SSIS.
Location:
AmeriTeach
7800 East Dorado Place, Suite 150
Greenwood Village, CO 80111
720-346-1710
Meeting Agenda:
5:30 - 6:00 - Food / Socializing
6:00 - 6:10 - User Group Business
6:10 - 6:15 - Open Panel/Questions & Answers
6:15 - 7:15 - Presentation 1
7:15 - 8:15 - Presentation 2
8:15 - 8:20 - Give Away / Wrap-Up
And of course: SQL Saturday #52 – Colorado is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free with the exception of a $10 lunch fee; all other costs are covered by donations and sponsorships. Please also let friends and colleagues know about the event.
Registration for the 9/25 event is now open at: http://www.sqlsaturday.com/52/register.aspx
