Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
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.
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
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.
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.
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.
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.
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.
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!
An advanced look into how memory works in modern servers, on modern processors and how to leverage it with SQL Server.
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 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.
In this talk, you will get an overview on what to think about when storing data in a document database.
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.
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.
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.
Learn about keys and how to get them right.
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.
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 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.
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.
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
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.
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.
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
See how to use Power Query to build a detail-level reporting solution
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)
Come to this session to see how to build a scalable analytical solution on Microsoft Azure with Elastic Search and Kibana.
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.
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
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!!
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
Great database performance starts with great database design.
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.
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.
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
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
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.
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.
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.
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.
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.
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.
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
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
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. Topics include Hekaton, the new cardinality estimator and incremental statistics.
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!
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.
Your relational Data Warehouse is suffering from performance problems. In this session we will take a look at some of the most common performance problems that tend to occur in a relational data warehouse.
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
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.
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.
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
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.
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!
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.
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.
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.
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.
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.
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.
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
Indexing internals and how it impacts query performance.
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.
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.
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.
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.
Peter O'Connell will talk about how SpotlightEssentials.com uses SQL Azure to collect and mine over 40TB of SQL Server Performance data across thousands of instances to drive unique insights into SQL Server Performance.
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.
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!
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.
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
A deep dive into batch mode scalability with column store index and SQL 2014.
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.
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
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!
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.
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
Learn more about use cases and limitations for buffer pool extension. We will also cover the performance gains it can bring to your environment.
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
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.
Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues
Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader()
This session will discuss the recommended approaches and best practices for partitioning and scaling Windows Azure SQL Database, allowing you to fully leverage the managed relational database service and take advantage of massive scale-out scenarios.
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
The query optimizer is at the heart of SQL Server. Much of the its' internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags. This session will be a deep dive into the these internals.
More and more senior roles require familiarity with SAN technologies - tricky for us, 'just' the DBA. This '90% practical' session will explore Hue's 2× different SAN in a box'es. Come and gain this much-needed exposure to Enterprise technologies.
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
Learn how flash storage accelerates In-Memory OLTP performance. We will also cover limitations with SQL Server In-Memory OLTP.
In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems, and how the control flow and data flow engine work.
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
Ensuring top performance is never easy. To maintain performance you need to make sure you’re monitoring the right things. How do you know if the figures you’re seeing are good or bad? Baseline comparisons can help.
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system.
In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.
This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well.
Ever wonder how someone else does it? There’s no right way or wrong way, but in this session you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries and tries various techniques to make them faster.
Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
In this session we’ll look at a number of different data scenarios and explore ways of remodelling the data to optimise it for cubes and MDX. Sometimes a small ETL change can have a dramatic impact on the cube's functionality and simplicity.