Push Your App to Enterprise Scale with Advanced SQL Server Features

SentryOne Principal Program Manager, renowned database expert, founder and former president of PASS, and Microsoft SQL Server MVP, Kevin Kline, will share his deep SQL knowledge and best practices at a series of SQL Saturdays and SQL Server User Group meetings all around the world.
As a part New Zealand Down Under Tour, in association with SQLMasters Consulting, Kevin Kline is coming to Auckland on June 4th to deliver a session!

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

Agenda:
Arrival @11:45 to 12:00
Start and short intro @ 12:00 to 12:10
Kevin's Session @ 12:10 to 1:30
Questions & Answers @ 1:30 to 1:45

Food and drinks will be provided.

______________________________________________________________________________________

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

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.

Level: 300

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

_______________________________________________________________________________________

Biography
Kevin Kline is a noted database expert and software industry veteran. A long-time Microsoft SQL Server MVP and leader in the IT industry, Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a long-time veteran of the database tools market and serves as Principal Program Manager at SentryOne, makers of popular SQL Server tools like Plan Explorer. Kevin is a top-rated speaker at industry trade shows worldwide. He is on social media (LinkedIn, Twitter, and Facebook) at kekline and blogs at https://blogs.SentryOne.com/author/kevinkline