Sessions & Content

Search
Content Type
Conference
Tags
Debugging common DAX and Model performance issues Kasper de Jonge
In this session, we will explore real world DAX and Model performance scenario's. These scenarios range from memory pressure to high CPU load. Watch as we will dive into the model and improve performance by going through concrete examples.
From adaptive to intelligent: query procesing in SQL 2019 Hugo Kornelis
SQL Server 2019 includes new query processing features such as batch mode on rowstore, memory grant feedback, approximate query processing, and more. How do these work? Are they as good as Microsoft wants us to believe?
Identify opportunities for In-Memory OLTP Margarita Naumova
The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.
Probelm Solving Using The In-Memory Engine Chris Adkin
The in-memory OLTP engine has been around since version 2014 of the database engine, do you need to be a SaaS provider processing billions of transactions a day to use this ?, the short answer is absolutely not and this session will show you why.
What Else Can Indexes Do? Erik Darling
No pictures of phone books, here. We're gonna look at the way indexes change query behavior for better... and worse.
An introduction to SQL Server for data scientists Gavin Payne
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
Back to the future with Temporal Tables Randolph West
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean.
Persistence is Futile-Implementing Delayed Durability Mark Broadbent
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput.
Understanding the Power BI data model Kasper de Jonge
In this session we will look at all the important topics that are needed to get your Power BI modelling skills to the next level. We will cover the in memory engine, relationships, DAX filter context, DAX vs M and DirectQuery.
Benchmarking & Testing In-Memory Performance Amit Bansal
Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. This session gives you the details you need.
Designing for Concurrency John Q. Martin
SQL Server normally relies on concurrency models in order to maintain the Isolation in ACID. As systems scale, this method can go from being a benefit to a hindrance, limiting the concurrency for our applications and hurting performance.
Real world learnings from SQL Server 2016 Migrations Mike Boswell
SQL Server 2016 is a class leading Tier One product but how do you get customers to upgrade and migrate? How can you address the "so what" SQL does everything I need to do now?
SQL Server Internals and Configuration for R Ginger Grant
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.
Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit Jimmy May
This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites
In-Memory OLTP, how to use it John Q Martin
We have all heard about In-memory OLTP and how fast it can go, but just how do you use it? In this session we will look at how to migrate a system to use this new capability.
Life saver-Resource Governor for applications & reporting Dr. Subramani Paramasivam
There are still environments which serve one single SQL Server database for both critical applications & reporting. Budgeting issues and infrastructure bottlenecks kill the application to be better managed and maintained. What could be the solution?
My top 5 new features in SQL Server 2014 Sandip Pani
SQL server 2014 is one of their measure releases. Where Microsoft has done a superb job. There are so many enhancement we have in SQL Server 2014. In my session I will show you my top 5 features.
Scaling the DVD Store from 100 to a million TPM Bob Duffy
Come along to see us attempt to optimise and redesign the “Dell DVD Store” sample dot.net/SQL application from a modest 100 transactions per minute to a million transactions per minute.
SQL Server 2014 In-Memory OLTP Deep Dive Klaus Aschenbrenner
Hekaton is the Greek word for 100 - the goal of In-Memory OLTP in SQL Server 2014 is to improve query performance up to 100 times. In this session we will look under the cover of Hekaton and the Multi Version Concurrency Control (MVCC) principles.
SSAS Tabular from the Trenches Marco Russo
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
<<123>>