Toggle navigation
FAQ
Sponsors
Sessions
Training Days
Tuesday
Wednesday
Thursday
Friday
Saturday
Login
Home
Sessions & Content
Sessions & Content
Tags
memory
(16)
Content Type
Slide Deck
16
Search
Conference
SQLBits I
0
SQLBits II
1
SQLBits III
0
SQLBits IV
0
SQLBits V
1
SQLBits VI
2
SQLBits VII
0
SQLBits VIII
0
SQLBits IX
1
SQLBits X
1
SQLBits XI
1
SQLBits XII
1
SQLBits XIV
0
SQLBits XV
5
SQLBits XVI
0
SQLBits XVII
1
SQLBits XVIII
2
SQLBits XX
0
From adaptive to intelligent: query procesing in SQL 2019
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
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.
An introduction to SQL Server for data scientists
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
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.
Enhancements that will make your SQL engine roar #2
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.
How to start with In-Memory OLTP?
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.
Optomizing SQL Server Performance in a Virtual Enviroment
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.
SQL Server 2016 Hero Features in a Customer Scenario
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.
Latches, Spinlocks, and Lock Free Data Structures
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
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
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
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
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
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)
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...
I/O! I/O! It’s off to disk we go...
<<
1
>>