Toggle navigation
FAQ
Venue & Travel
Sponsors
Sessions
Training Days
Wednesday
Thursday
Friday
Saturday
Login
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Tags
performance
(331)
Content Type
Slide Deck
139
OtherSample
55
Video
257
Search
Conference
SQLBits I
5
SQLBits II
6
SQLBits III
6
SQLBits IV
7
SQLBits V
11
SQLBits VI
19
SQLBits VII
17
SQLBits VIII
20
SQLBits IX
21
SQLBits X
32
SQLBits XI
25
SQLBits XII
31
SQLBits XIV
45
SQLBits XV
26
SQLBits XVI
32
SQLBits XVII
28
"But It Worked in Development!" 3 Hard Performance Problems
You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
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.
Azure and SQL Server: Getting the best out of the cloud
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.
Azure SQL Data Warehouse Optimizing and Maintaining
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Azure SQL Database vs. Cosmos Db. How do you choose?
Focusing on the micro-service / OLTP domain, this talk approaches the challenge of choosing between Azure SQL Database and Cosmos Db (Document Db) by using solution use cases to test each storage's offering for appropriateness.
Best pratices for Power BI on implementation and monitoring
Learn about the component of Power BI and best practices for implementations
DAX Optimization Examples
In this session we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.
DirectQuery in Power BI and Analysis Services
DirectQuery best practices in Analysis Services and Power BI
Evaluating Models: Get Ready to ROC
Introducing the ROC curve and its use in Azure ML.
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers
Introduction to partitioning
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
Investigate TempDB like Sherlock Holmes
Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
Kick Start! SQL Server 2016/2017 Performance Tips and Tricks
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Man vs Machine: Adaptive query processing and auto tuning
Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL 2017. Adaptive query processing, auto tuning and few other features added into the product.
Maximise compute performance with Azure SQL Data Warehouse
Learn about the new compute optimized performance tier in SQL Data Warehouse and how to maximize your performance through improved table design and columnstore optimization.
Maximizing the Query Performance with Columnstore Indexes
Common performance issues with clustered columnstore index experienced by customers and strategies to address them.
Performance Monitoring Using Extended Events, DMVs & Query S
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Performance Tuning for the BI Professional
Come learn how to make your BI projects perform at their max!!
Query Execution: Expectation-Reality
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Query Store without SQL 2016 = Open Query Store
Query Store was the cool new feature in SQL 2016, but what about those of us stuck on older versions of SQL Server? Introducing: Open Query Store! This session will explain what OQS is and how it can help you take control of your query plans.
SQL Intelligence excels your tuning and security expertise
Azure SQL Database built-in intelligence features will help you improve performance and security of your database and dramatically reduce the overhead of managing thousands of databases.
SQL Server Administration on Linux
Come learn how to set up a production-grade SQL Server on Linux environment!
Tame Your Unruly Data...With Constraints!
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
The Microsoft Engineer's performance tuning toolbox
In this demo-only session, you will learn how Premier Field Engineers at Microsoft troubleshoot performance problems and what tool and scripts they use. We will take a look at tools and scripts like SQLDiag, SQLNexus, PAL, and BPCheck.
T-SQL Window Function Deep Dive
Solve complex problems with T-SQL window functions.
Uncovering Duplicate, Redundant, & Missing Indexes
Ensure your indexes are achieving their fullest potential!
Using Analysis Services MD as a Data Source for Power BI
Learn how to get the most of your SSAS MD cubes when using Power BI as a front-end
Why is SQL Server waiting for what?
You are wondering why SQL Server is waiting endless for a request and you don't know what is going on inside? A look behind the curtain with comon scenarios will help you to understand and solve long waits in SQL Server.
Adaptive QP Enhancements in SQL Server and SQL Azure
The SQL team has been working on next-gen query processing improvements to improve the performance of your queries and to enable new scenarios. This talk will explain these enhancements and how they fit into the overall product roadmap for SQL.
All about Indexes
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at the design considerations for clustered indexes and for nonclustered indexes.
Benchmarking & Testing In-Memory Performance
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.
Benchmarking like a PRO
In this demo-intensive session you will discover how to capture a meaningful workload in production and how to replay it against your test system.
Building a Performance Monitoring System Using XEvents
In this session you will learn how to use Extended Events and Dynamic Management Views (DMVs) to build a performance-monitoring system for your database environment.
Columnstore Indexes Worst Practices & Limitations
Have you ever considered a situation where Columnstore Index can be quite the opposite of what one expect from it? A slow, wasteful source of painfully slow queries, lagging the performance, consuming irresponsible amount of resources ...
Columnstore killed the OLAP Star-Did it really?
With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
Database Design Throwdown
Data architects and DBAs have debated database design best practices for decades. Join us for some great debates and laughs.
Designing for Concurrency
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.
Enhancements that will make your SQL Server roar-SP1 Ed.
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions.
Gems to help you troubleshoot query performance
In this session we will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot query performance.
Inside statistics-a guessing game
A query was running fast yesterday and today it suffers from performance problems. What will you do? - restart the server (did work) - drop the procedure cache (read in a blog article) - get a coffee and pass in review this session about statistics
Introducing the Query Store
The Query Store will change how you tune queries and gather metrics about them in both SQL Server 2016 and Azure SQL Database.
Lifting the lid on SQL Server on Linux
Martin Wild of Quest Software will lift the lid on SQL Server on Linux. He will explore the mechanics to deploy SQL Server on Linux, what is and is not in the current Linux build and share some of quirks, and observations on setup and config.
Master Data Services 2016
In this session you will get a brief introduction to the basic principles of Master Data Services, together with an overview of all the new features brought to you with Master Data Services 2016.
Optimizer Secrets: Debugging using 860x Trace Flags
Learn about the powerful 8600 series of trace flags which additional details about how the query optimizer behaves as it processes a query.
Optimizing multi-billion row tables in Tabular
In this session we will show you how Tabular performs when you are querying a model with many billions rows, conduct a complete analysis of the model searching for optimization ideas and implement them on the fly, so to look at the effect of using th
Performance Pitfalls of Code Reuse
Learn how object-oriented T-SQL hurts performance.
Performance tips for faster SQL queries
Ask with T-SQL the "what" and delegate to the engine the "how". With few slides and a lot of real-case scenarios, you can see the advantages of writing the query for high performance, even when they are written by that "someone else" called ORM
Query Plans Deep Dive
An in depth look at query plans and the query optimiser
Query Store – What is it all about?
The Query Store functionality in SQL Server 2016 will change the way we look at performance going forward. Come see why.
Real world learnings from SQL Server 2016 Migrations
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?
Review ColumnStore Index in SQL 2016 and Azure SQL DB
This session describes columnstore index internals with deep insight into data compression methodology for achieving high query performance including improvements in column store investments for SQL Server 2016 and Microsoft Azure SQL Database
Solving Hard To Crack Problems With Windows Performance Tool
You are hitting performance and scalability issues with the database engine, conventional wisdom and tools and getting you nowhere, where do you go ?, windows performance toolkit has the answers.
SQL Server 2016 It Just Runs Faster
Come take a deep dive and behind the scenes look at why SQL Server 2016 "Just Runs Faster" with little or no application changes.
SQL Server Internals and Configuration for R
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.
Statistics, Row Counts, Execution Plans, and Query Tuning
Row counts are the primary factor for choices made by the query optimizer. This session explores how row counts affects query performance.
Troubleshooting common DBA scenarios with SQL on Linux
This session will cover common DBA troubleshooting scenarios on SQL Server on Linux. In this demo rich session, we will cover various every-day from troubleshooting startup and configuration to performance and bottleneck analysis.
T-SQL : Bad Habits and Best Practices
In this session, you will learn about several bad habits, how they develop, and how you can avoid them.
Understanding the Transaction Log
In this session you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Whats new in Azure SQL DB and SQL engine
Attend this session to get an overview of the wide array of significant changes and investments with Azure SQL Database, including parity with SQL Server 2016 and Intelligent database capabilities.
Why Your Datatype Choices Matter
Learn how poor data type choices can cripple SQL Server.
Azure DocumentDB: Advanced Features for Large-Scale Apps
Let's talk about how you can get the most out of Azure DocumentDB. In this session we will dive deep in to the mechanics of DocumentDB and explain the various levers available to tune performance.
Cardinality Estimates in Microsoft SQL Server
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
Data Warehouse load performance with SSIS and SQL Server
The typical performance bottleneck in your data warehouse is using SSIS to insert massive amount of data into SQL Server. In this session, you will learn how to improve the load performance with SSIS into SQL Server.
Dynamic Search Conditions
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
Effective Indexing with Partitioning and Compression
We all know that correct indexing is king when it comes to achieving high levels of performance in SQL Server. When indexing combines with the enterprise features partitioning and compression, you can find substantial performance gains.
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 Bully Your Query Execution Plans
Sometimes bad execution plans happen to good queries. In this session you'll learn the pros and cons of using hints, plan guides, and the new Query Store feature in SQL Server 2016 to manipulate your execution plans.
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.
Introducing the SQL Server 2016 Query Store
In this session we will take a deep dive into one of the, in my opinion, most exciting new feature in SQL Server 2016, the Query Store. Learn all about the inner workings of the query store and how it can help you analyse query performance!
Introducing U-SQL: Big Data Processing made easy
This presentation will give you an overview on U-SQL, why we decided to build a new language, what its core philosophical underpinnings are as well as show the language in its natural habitat, development tooling and language capabilities
Leveraging Memory With The Database Engine
An advanced look into how memory works in modern servers, on modern processors and how to leverage it with SQL Server.
Lock, Block and Two Smoking Barrels
Enter the world of SQL Server concurrency to experience the age old problem of Locking, Blocking and Deadlocking. Let's investigate pessimistic isolation and whether optimistic concurrency could be the answer to all our problems or the last resort.
Locking and Blocking
Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look at the three main aspects of locking, including when locks cause blocking and also examine ways to minimize blocking.
Modeling Data in a Document-Oriented NoSQL Database
In this talk, you will get an overview on what to think about when storing data in a document database.
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.
Plan optimization from DBA to Developer
Maximise resolution time with some joined up thinking between developers and DBAs. We'll show how to identify poorly performing SQL, how to navigate and analyse its plan and how to increase performance, and cover some free tools to help connect you resolve issues faster.
Recovery Models Made SIMPLE
This session looks inside the transaction log to see exactly what is logged for minimally logged operations in each of the recovery models. We also look at other factors in our SQL Server operations that affect what is actually written to the log.
SQL Server 2016 Business Intelligence New Features
Do you get involved in the creation of Business Intelligence solutions within your organisation? This session will show you the new features of SQL Server 2016 Business Intelligence components.
SQL Server 2016 Performance and Scalability Improvements
In this session we will cover the core database engine improvements that make SQL Server 2016 run faster than previous releases. We will also cover some new performance related features and how Windows Server 2016 will improve SQL Server performance.
SQL Server Statistics – What Are The Chances?
This session will explain how the Query Optimizer uses column statistics to determine which operators to use and the operator costs. We'll also look at the changes to the Cardinality Estimator in SQL Server 2014.
The Key to Keys
Learn about keys and how to get them right.
The Query Store and Query Tuning in SQL Server vNext
SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.
T-SQL : Bad Habits & Best Practices
In this session, you will learn about various anti-patterns and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits.
T-SQL User-Defined Functions, or: Bad Perf. Made Easy
T-SQL user-defined functions may appear to be a good tool for code encapsulation and reuse, but they can have a dramatic impact on performance. In this session, you'll see why they slow down your queries, and how you can avoid this performance hit.
Using CISL for getting the insights on Columnstore Indexes
Learn in just a bit over an hour how to use CISL (open source Columnstore Indexes Library) for getting deep insights on the Columnstore Indexes and how to use its maintenance solution for keeping Columnstore Indexes performing at their maximum speed.
All about Indexes
Indexes are essential to good database performance, but it can be hard to decide what indexes to create. In this session we'll look at guidelines for index creation
All About Indexing
Indexes are the best instrument for query optimization. But what kind of indexes and on what columns? The key to answering those questions is understanding how indexes are stored and used by SQL Server. And that is exactly what this session is about.
An Introduction To Column Store Indexes and Batch Mode
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.
BI DBA Performance Tuning
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
Building A Reporting Solution Using Power Query
See how to use Power Query to build a detail-level reporting solution
Building an Operational Data Store using SQL Server in Azure
This presentation will focus on techniques and practices for using memory optimized tables in SQL Server to build “warm” data stores from a variety of application data sources (logs,traces, performance statistics)
Building scalable analytical solutions on Azure
Come to this session to see how to build a scalable analytical solution on Microsoft Azure with Elastic Search and Kibana.
Challenge Me! Capturing SQL Server Data with PowerShell
Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees are encouraged to send challenges to the presenter via email for demonstration purposes.
Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit
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
Common TSQL Mistakes
A review of many TSQL mistakes I see over and over at clients! This is a 100%-demo session, with the bad AND good code presented. I GUARANTEE that you will find things here that help you be MUCH better at interacting with SQL Server!!
Daily problems with indexing and its-possible-solution
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
Database Design: Size DOES Matter
Great database performance starts with great database design.
Deep dive into Delayed Durability
In this session you will see what is delayed durability, how it is achieved and how to make the best use case out of it. You will understand how to use it and a demo which explains the effects of using delayed durability with SSDs.
Deep into Isolation Levels
Isolation levels are one of the most complex subjects inside SQL Server and at the same time - one of the most important one. In this session we will take a look at all of them and see how they work behind the scenes.
<<
1
2
3
4
>>