On August 28, 2018 at 2PM EDT, I’ll be joining Melissa Connors (blog|twitter), Kevin Kline (blog|twitter), and Rob Sewell (blog|twitter) for a webinar on advanced SQL Server features. The webinar centers around a real-life case study of technology SentryOne is using in it’s own database. I’ll be giving an overview of each of the features, and Melissa will cover how those features helped SentryOne boost performance. Kevin & Rob will be moderating
To sign up, register here.
You can access the recording of the session here.
Abstract
You have an OLTP database application that sustains a heavy mixed workload with lots of read and write transactions; at the same time, a client application reports on the data. 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 partitioned clustered columnstore indexes (CCI). 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.