Free

Push your app to Enterprise Scale with advanced SQL Server features

Event Information

Share this event

Date and Time

Location

Location

Microsoft Canada

110 - 9 Ave SW

Seventh Floor

Calgary, AB T2P 1M9

Canada

View Map

Event description

Description

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

Level: 300

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 base 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.

Agenda

4:30 pm - 4:45 pm MST - Food, drinks and networking
4:45 pm - 5:00 pm MST - Sponsor presentation
5:00 pm - 6:30 pm MST - Feature session with Kevin Kline

Speaker:

Kevin Kline is a noted database expert and software industry veteran. A long-time Microsoft Data Platform MVP and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server, as well as the author of popular IT books like SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide and has a monthly column at Database Trends magazine. He tweets at @kekline and blogs regularly. Kevin is a Principal Program Manager at SentryOne, a leading vendor of database tools.

Sponsor:

Robert Half Technology


Share with friends

Date and Time

Location

Microsoft Canada

110 - 9 Ave SW

Seventh Floor

Calgary, AB T2P 1M9

Canada

View Map

Save This Event

Event Saved