VTSQL UG: Enterprise Scaling with Advanced SQL Server Features (ONLINE)

Title: Real-World Case Study: Push Your App to Enterprise Scale with Advanced SQL Server Features

Level: 300

Abstract: You have an OLTP database application which sustains a heavy mixed workload with lots of read and write transactions at the same time that it reports data to a client application. Performance was fine for a long time, but it is not meeting your needs now that it must scale to much higher workloads. What should you do? In this real-world case study, you’ll learn about a series of technologies that provide unprecedented scalability, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes. We will walk you through a chronology of the application and database architecture, its changes over time, and the degree of performance improvement achieved with each new SQL Server feature applied. This session will teach you all about planning and implementing advanced SQL Server performance features and how each one impacts your system performance for applications with 100’s or 1000’s of concurrent users. Here’s what you’ll learn in this session:

• Goal 1: Learn how to plan, prepare for, and implement advanced features on SQL Servers, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes.
• Goal 2: See the performance impact of each of the major feature implementations as they relieve performance bottlenecks.
• Goal 3: Learn about the trade-offs in applying major new features, tips and tricks, and other advice for achieving enterprise scale in your SQL Server applications.

Prerequisites: Intermediate experience with Microsoft SQL Server administration, application architecture, and SSMS.

About the speaker: Kevin Kline is a noted database expert and software industry veteran currently serving as the Principal Program Manager at SentryOne, a leading vendor of database tools. A Microsoft Data Platform MVP since 2003, Kevin was a founding board member and former president of the Professional Association for SQL Server. He has authored more than ten books, including the best-selling SQL in a Nutshell. Kevin contributes a monthly column to Database Trends magazine. Kevin is a top-rated speaker on technology and professional development topics at conferences worldwide such as Microsoft Ignite/TechEd, the PASS Summit, DevTeach, Oracle OpenWorld, and IT/Dev Connections. He tweets at @kekline and blogs at http://KevinEKline.com.

------------
We will have a raffle for a $50 gift certificate to a local restaurant, courtesy of SentryOne.

Please join my meeting from your computer, tablet or smartphone.

https://global.gotomeeting.com/join/884822485

Join from a video-conferencing room or system.
Dial in or type: 67.217.95.2 or inroomlink.goto.com
Meeting ID: 884 822 485
Or dial directly: 884822485@67.217.95.2 or 67.217.95.2##884822485

New to GoToMeeting? Get the app now and be ready when your first meeting starts: https://global.gotomeeting.com/install/884822485