Designing and Tuning high speed data loading
In almost all data warehouses there is a requirement to quickly get data into SQL Server. In this talk, I will present the different options you have: SSIS vs. T-SQL. We will look at some common design patterns for scalability and take a deeper look at how the Bulk API for SQL Server works.
- Downloads
- SpeakerBIO
Thomas has been working with SQL Server since version 6.5 and performance tuned cubes since OLAP Server 7.0. He has worked on some of the largest cubes in the world. Performing fast loading of warehousing and removing every bottleneck is one of Thomas specialties. He holds a master degree in computer science and has 10+ years of experience with developer coaching and scalable architectures on both OLTP and OLAP systems.
- Video
- Session Files Explorer
Designing_and_Tuning_high_speed_data_loading
Designing and Tuning high speed data loading - Thomas Kejser.pptx
| |
0