4th - 7th May 2016

Liverpool

Conference
Content Type
Search
Clear
Tags

Sessions & Content

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
  1 to 25 of 266 first 1 2 3 4 5 6 7 8 9 10  next last  Show 10 25 50 100 sessions per page