25/02/2012 10:55:52 AM
Ever wondered how to process millions of rows as quickly as possible? Is partitioning the only solution?
With the explosion in data and 24x7 requirements it is important to understand how to process and load large volumes of data into your OLTP environment. (This is certainly a recipe to stress out your DBA!)
In this session Julie Koesmarno will present how SQL Server 2012 comes with new Transact-SQL functions and index enhancement to help solve high volume data processing requirements. Which should result in less impact on your production server(s) and less stressed DBAs!
Julie will demonstrate ultimate batching techniques to conquer high volume data processing in SQL Server 2012, and compare it with your options in SQL Server 2008 R2. This should help justify an investment in SQL Server 2012 from both a development and performance perspective.
• Understand batching techniques to adopt and their usefulness for managing high volumes of data
• Learn SQL Server 2012 enhancements for high volume data processing
• Learn how the Balanced Data Distributor task in SSIS can be used for types of high volume data processing
Julie Koesmarno is an MCITP Database Administrator 2008, MCITP Database Developer 2008 and MCITP Business Intelligence 2008, with a Bachelor degree in Information Technology specialising in Software Development. She has over 8 years commercial experience in SQL Server for large scale and multi-million OLTP and ETL projects as SQL Server Developer and System Analyst/Designer. She is currently working as a Microsoft BI Consultant.
Venue: Sydney Mechanics' School Arts |
Duration 12:00 - 14:00 |
On: Wednesday, 7 March 2012