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
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.
See how to use Power Query to build a detail-level reporting solution
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!!
Great database performance starts with great database design.
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
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.
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.
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)
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.
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.