Sessions & Content

Search
Content Type
Conference
Tags
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?
Performance Tuning SQL Server on Crappy Hardware Monica Rathbun
This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. Learn tips and tricks on how to reduce IO,relieve memory pressure, and reduce blocking.
The video is not available to view online.
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.
Enhancements that will make your SQL engine roar #1 Pedro Lopes
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
The video is not available to view online.
Enhancements that will make your SQL engine roar #2 Pedro Lopes
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
The video is not available to view online.
How to start with In-Memory OLTP? Murilo Miranda
In this session, we will introduce a step-by-step approach to adopting the technology, aimed at beginners who are interested in how it can fit into their own environments.
The video is not available to view online.
Optomizing SQL Server Performance in a Virtual Enviroment 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.
The video is not available to view online.
SQL Server 2016 Hero Features in a Customer Scenario Marko Hotti
This sessions covers the SQL Server 2016 Hero Features and you will see a real customer scenario demo showcasing the Full Lifecycle of Financial Data.
The video is not available to view online.
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.
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.
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.
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.
I/O! I/O! It’s off to disk we go... James Rowland-Jones
I/O! I/O! It’s off to disk we go...
The video is not available to view online.
<<1>>