Sessions & Content

Tags
Search
Conference
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.
Blend SQL Azure with SQL Server to drive Performance Insight
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.
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.
Optimizing & Analyzing DAX Query Plans
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
Optimizing database access and diving into .Net SqlClient
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()
Patterns & Practices for Scaling Windows Azure SQL Database
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.
Performance Tuning SQL Server Integration Services (SSIS)
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
Query Optimizer Internals : Traceflag fun
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.
SAN eye for the SQL girl/guy
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.
SQL 14 In-memory OLTP : Architecture to Implementation
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
SQL Server In-Memory OLTP and Flash
Learn how flash storage accelerates In-Memory OLTP performance. We will also cover limitations with SQL Server In-Memory OLTP.
The dangerous beauty of Bookmark Lookups
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
The Day After Tomorrow; Why You Need to Baseline
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.
Things You Can Find in the Plan Cache
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.
T-SQL : Bad Habits & Best Practices
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
T-SQL Tips and Tricks
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.
Understanding Parameter Sniffing
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.
Watch Brent Tune Queries
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.
<<1>>