align-toparrow-leftarrow-rightbackbellblockcalendarcamerachatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-crosscrosseditemptyheartfacebookfullheartglobegoogleimagesinstagramlocation-pinmagnifying-glassmailmoremuplabelShape 3 + Rectangle 1outlookpersonplusImported LayersImported LayersImported Layersshieldstartwitteryahoo

Triangle SQL Server User Group Meeting

Scalable, Large-Volume Data Synchronization in OLTP Systems

 

Synchronizing data from any external source (file, web form, web service, etc.) poses problems as the data volume and/or transaction count increases. While a data warehouse might have a regular window in which to ETL its data, an OLTP system--especially one that serves a 24 / 7 / 365 business--has to deal with issues such as concurrency, disk space, and even memory management on the app server. And the processing still needs to be done ASAP.  Solomon Rutzky will show various methods that he has used to synchronize tens of thousands and up to millions of rows quickly, with very little app-memory used, and all while performing validations and transformations.

SPEAKER

Solomon Rutzky has been working with computers for almost 30 years, across several different platforms, languages, and roles. He has been working with databases for 17 years now and has focused on Microsoft SQL Server for the past 11 years. He specializes in development, data modeling, and performance tuning and doesn't much care for the administrative side of things. Solomon has written articles for SQLServerCentral.com and Simple-Talk.com, and is also the author of SQL# -- the popular SQLCLR library of functions that greatly expands what can be done in T-SQL (http://www.SQLsharp.com/). In his spare time, he enjoys...wait, with three kids under the age of 4, he has no spare time :(.

AGENDA

6:30PM - 6:45PM - Meet, Greet and Eat - Thank you to our sponsor TEK Systems
6:45PM - 6:50PM - Meeting Announcements
6:50PM - 8:15PM - Presentation
8:15PM - 8:30PM - Q & A and Wrapup

 

Join or login to comment.

  • Christopher P.

    Can't wait. Thanks for the help keeping my SQL Skills from going stale!!

    May 20, 2013

Our Sponsors

  • TEK Systems

    TEK Systems provides space for our meetings as well as food and drink.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy