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.
Stored Procedures vs Ad-Hoc SQL: Performance Showdown! Argenis Fernandez
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail!
Superscaling SQL Server 2014 Parallel Insert Chris Adkin
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
Understanding & Solving Columnstore Problems Niko Neugebauer
Dive deep into Columnstore Indexes and discover their advantages and some of the limitations. Look into some of the Columnstore Indexes myths, understand more complex concepts of Batch Mode & Query Processing with another depth.
Latches, Spinlocks, and Lock Free Data Structures Klaus Aschenbrenner
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
SQL 14 In-memory OLTP : Architecture to Implementation Microsoft
What is In-Memory OLTP? How is it architected? Where can I use in-memory technology in my solutions? Learn this and more from the Microsoft team
SQL Server In-Memory OLTP and Flash Fusion-io
Learn how flash storage accelerates In-Memory OLTP performance. We will also cover limitations with SQL Server In-Memory OLTP.
Optimizing SQL Server Performance in a Virtual Environment Denny Cherry
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
Real World Data Movement with Attunity Replicate Attunity
In this lunchtime session, Attunity will highlight real customer implementations of Attunity Replicate and the Microsoft BI technology stack that enabled them to achieve competitive advantage.
SQL Server 2012 Memory Management Neil Hambly
SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one, discover all these important changes
Troubleshooting the most difficult SQL Server problems Klaus Aschenbrenner
Do you have enough from "normal" performance tuning sessions? You can't hear anything about Indexing and Execution Plans anymore? Then you are right in this session!
Analysis Services 2012 Tabular Mode Best Practices Itay Braun
In this session we'll understand the best practices of using this new technology. What exactly is it good for? When to use it and when NOT to? Migration, Security, Administration and other tips and tricks.
Memory Management for Analysis Services with SQL Sentry SentryOne
Learn how to monitor Analysis Services with SQL Sentry Performance Advisor. Get tips on best practices, monitoring counters and options plus improve your understanding of how Analysis Services uses memory and where it differs from SQL Server.
Query Tuning Mastery: Workspace Memory Internals Adam Machanic
Large, complex queries need memory in which to work--workspace memory--and understanding the how's, when's, and why's of this memory can help you create queries that run in seconds rather than minutes.
T-SQL Brush-up:The Best Things You Forgot You Knew About SQL Jennifer McCown
Sometimes some piece of T-SQL slips by, or falls out of memory.Come and revisit old favorites, and brush up on new T-SQL features and enhancements.This session is chock full of code examples, including before-and-after demos and how-to illustrations.
Through the virtual looking glass - monitoring virtualised SQL Gavin Payne
Virtualisation changes the way you need to monitor the performance of a virtualised instance of SQL Server. In this session I will demonstrate a balanced and well-rounded approach to performance monitoring in the virtual world along with best practices to avoid poor virtualised performance.
Fast Track Foundations: Get Serious about Sequential I/O James Rowland-Jones
Fast Track is a new reference data warehousing architecture provided by Microsoft. More than this it represents a new way of thinking about data warehousing. A Fast Track system is measured by its raw compute power - not by a DBAs ability to tune an index. Fast Track is an appliance-like solution that delivers phenomenal performance from a pre-defined, balanced configuration of CPU, memory and storage using nothing but commodity hardware. Of particular interest in a Fast Track system is the way in which the storage and SQL Server are configured. To achieve the fantastic throughput without using SSDs requires some careful configuration. This configuration is designed to make use of Sequential I/O to dramatically improve disk I/O performance. Interested? If you have a large data warehouse that's seen better days or perhaps you are about to embark on a new warehousing project then you should be! Fast Track is a great solution with a fantastic value proposition. In this one hour session we'll aim to get under the skin of Fast Track and get some answers as to how it delivers such great throughput on commodity hardware. In the process we'll aim to answer the following questions: * When might I need Fast Track? * What is Sequential I/O? * How does Sequential I/O improve performance? * What do I need to do to get Sequential I/O? * How can I monitor for Sequential I/O ? * What may I need to change in my ETL to get the benefit of sequential I/O? Still reading? I'll save you a front row seat....
Photograph: SQL Server Crash Dump Analysis Pablo Doval
This session will reveal the basics of analyzing crash-dumps in order to troubleshoot SQL Server crashes or abnormal situations. We will also review the postmortem analysis of common (but tricky) development problems, such as connection leaks, using WinDbg and Adplus.
SQL Server 2008 Reporting Services Scalability and Performance Rob Carrol
This session covers the new scalability features of SQL Server Reporting Services 2008 and demonstrates how to build a high performance reporting platform to deal with your enterprise reporting needs.
SQL Server optimization stuff you won’t find on Google (yet) Andre Kamman
Henk van der Valk from the Unisys performance lab will be my special guest for this session. He has a test system that we all would like to have at home. The ES7000 has 96 Cores and half a Terabyte of RAM yes RAM (!). We will look at various ways to push SQL Server workloads by methodically detecting and resolving bottlenecks.Together we will show you how you can apply this approach on mid-sized and even smaller systems. (We’ll even try some of them on a laptop, and of course we will remote connect into the big machine ) In this session you will: Learn how to measure what the next bottle-neck is,using perfmon and waitstats. Hear about optimization tips that will get the most out of your hardware to speed up your processsing.
Strapped for cache? - Troubleshooting memory problems in SQL Server 2008 Christian Bolton
Learn the terminology, architecture, features and best practices that can help you understand, troubleshoot and avoid memory problems in SQL Server 2008.
A walk down memory lane Christian Bolton
A walk down memory lane
<<1>>