Sessions & Content

Tags
Content Type
Search
Conference
"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.
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.
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.
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?
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.
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
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.
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
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.
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.
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
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
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.
Deploying SQL Server with Microsoft Azure Virtual Machine
Many customers are looking toward Cloud technologies to reduce operational and capital expenditures. A popular choices today for SQL Server customers is to deploy in the Microsoft Azure Virtual Machine environment. Come to this session and learn how
Designing a database to best support multidimensional OLAP
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
Designing Stored Procedure Solutions
In this session, you’ll learn about SQL Server stored procedures: what they are, when and why you'd use them, and how you would develop a solution with one. We’ll walk through examples to explore the process of solution building in SQL Server.
Easy Performance Tuning: an Intro to Wait Statistics
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
Estimation and Statistics : The Basis of query optimization
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
Five Ways to Write More Effective Triggers
Many triggers are inefficient and violate best practices, but it doesn't have to be this way. Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.
Get started with troubleshooting SQL Server
This session present key tools, methodology and approach for troubleshooting SQL Server. Performance and availability of the database engine has a direct impact on user experience of applications.
Indexing Internals
In this session we'll dig into the internal structures of indexes. We will explore the differences between clustered and non-clustered indexes, what's laid out within each page of the indexes.
Inside the Query Optimizer
In this session discuss the query optimizer, the individual phases of optimization, and how understanding these items can impact our queries in a positive way
Load Testing With SQL Server Tools
Understanding how SQL Server performs under various Load scenarios, requires controlled testing of a SQL Server instance whilst capturing key metrics using tools like Distributed Replay Controller can make this challenging task easier
Query Store: New Query Tuning Feature For SQL Server & Azure
Query Store is a new feature that is coming to SQL Azure and SQLServer. It aims to greatly simplify the process of getting insight intothe performance of your application. Come learn how the SQL team is going to make your life awhole lot easier!
Query Tuning Mastery: Clash of the Row Goals
Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries.
SQL Server 2014 In-Memory OLTP Deep Dive
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.
SQL2014 : The all new cardinality estimator
In SQL Server 2014, there have been many changes aimed at giving a more accurate number of rows, and therefore better plans. This session will be a look at these changes, comparing and contrasting with SQL2012/2008 to see how they help.
SSAS Tabular from the Trenches
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
SSIS & HDInsight
In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.
Stored Procedures vs Ad-Hoc SQL: Performance Showdown!
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
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.
Ten 10 Query Tuning Techniques Every SQL Programmer Should K
Learn how to assess query performance, ensure consistent and reliable query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.
The Data Loading Performance Presentation
Microsoft has a famous whitepaper called "The Data Loading Performance Guide". On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.
T-SQL : Bad Habits & Best Practices
Come learn how bad habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
Understanding & Solving Columnstore Problems
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.
Understanding SQL Database Elastic Scale for the DBA
This session will look at SQL Database Elastic Scale through the important lens of the DBA, focusing on the critical aspects of database performance, maintenance, and management without adding unnecessary complexity.
Visualizing performance tuning data
Over the years I've tried various ways to look at output from SQL Server for performance tuning reasons. We will look at virtual_file_stats, waitstats, the buffer cache etc. and we will visualize them in various ways
Visualizing Your Indexes-the Science behind the Art
Indexing internals and how it impacts query performance.
Wait watchers-Gain Performance Increases Fast!
In this session you'll learn all about SQL Server wait statistics. These are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions.
What Happened? Exploring the Plan Cache
In this session, we'll explore SQL Server's plan cache, including techniques for discovering what plans are in cache, how often they've been run, and whether they contain any sub-optimal operators. Knowing what's happened is the first step in tuning.
When good SQL design goes bad
In this humorous session I’ll be contesting many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.
Bad Plan! Sit!
In this session we'll look at the common causes of bad execution plans and examine options for resolving the problem, short term and long term.
Building a BI Performance Monitoring Solution
Learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. Learn how to set up a monitoring solution to capture data and diagnose slow queries.
Building Your Myth Busting Lab With Power BI
Information Workers and Data Analysts do “myth busting" on corporate performance and forecasts on regular basis. This session uncovers ways to take advantage of Power BI as Software as a Service (SaaS) for a "myth busting" lab you can try at home!
Building Your T-SQL Tool Kit: Window Function Fundamentals
Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
Cardinality Estimates in Microsoft SQL Server 2014
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
Column Store Index and Batch Mode Scalability Deep Dive
A deep dive into batch mode scalability with column store index and SQL 2014.
Dive into the Query Optimizer-Undocumented Insight
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
Effective Index Partitioning, Compression Strategy
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression
ETL Patterns with Clustered Columnstore Indexes
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
Inside Ola Hallengrens Maintenance Solution
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
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.
Learn about SQL Server Buffer Pool Extension, flash storage
Learn more about use cases and limitations for buffer pool extension. We will also cover the performance gains it can bring to your environment.
Monitoring Databases in a Virtual Environment
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
Monitoring Windows Azure SQL Server VMs and SQL Databases
Once you've decided to move to Azure with any of your databases, you're going to need to know how they're performing, this session shows you.
<<123>>