Development (DEV) Sessions

Title:

Using Your Brain to Beat SQL Server

Speaker:

Adam Machanic and Thomas Kejser

Abstract:

Thought you did everything right? Indexes are finely tuned. Statistics are fully scanned and updated. Your nice, big server seems to have plenty of power. But you are still not getting the performance you expect from SQL Server. Why is the optimizer failing you? SQL Server's query optimizer, often very good at coming up with decently performing plans, also regularly goes down the wrong path. The problem domain is simply too large and complex for it to adequately cover all cases.

When the going gets tough, your mind is a better machine for the job. So don't trust optimization to a mere piece of code! In this session, you will learn how to recognize various real-world cases where the optimizer fails. You will see why these queries aren't performing as well as they should, and how to work around the optimizer's lack of insight. You will learn to turn your brain into a better query optimizer and make your queries faster than you thought possible.

Level: 500


Title:

How the SQL Server Engine Thinks

Speaker:

Brent Ozar

Abstract:

When you pass in a query, how does SQL Server build the results? Let’s role play: Brent Ozar will be an end user sending in queries, and you will be the SQL Server engine. Using simple spreadsheets as your tables, you will learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.

Level: 100


Title:

Powerful T-SQL Improvements that Reduce Query Complexity

Speaker:

Hugo Kornelis

Abstract:

We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012. New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, running totals, moving aggregates, YTD, and much more are at your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about. Get a thorough description and explanation of the syntax – plus loads of demos to show you how to use all the new features. Attend this session to boldly take SQL Server where it has never gone before!

Level: 300


Title:

Does Optimistic Concurrency Resolve Your Blocking Problems?

Speaker:

Margarita Naumova

Abstract:

Blocking is a common problem in SQL Server databases. There are some well-known recommendations for resolving blocking issues, and one of them is switching to the Optimistic Concurrency model. In this session, we’ll explore whether this is really a solution, when to consider it, how to implement it, and what to be aware of. The session will explain everything you need to know about Optimistic Concurrency so that you can make an informed and optimal decision for your environment.

Level: 300


Title:

Compliance and the Data Professional

Speaker:

John Martin

Abstract:

Compliance is becoming more and more prevalent in all areas of the IT industry, especially where data professionals are concerned. In this session, we’ll cover what you need to consider regarding the most common compliance regulations, including PCI-DSS, Sarbanes-Oxley, and the Data Protection Act. What are these regulations, and how do they apply to you? The answer in many cases is, "It depends," so bring your questions so we can discuss them. We’ll also discuss how compliance can help build better systems and drive improvements in processes for all areas of data systems and data roles, from the DBA and developer all the way through the BI spectrum to Big Data.

Level: 200


Title:

Azure Premium DB, Virtual Machines & Other Azure Storage Options

Speaker:

Ewan Fairweather

Abstract:

A number of relational and non-relational storage options are available on Azure, including Azure SQL Database, the new Premium Database offering, SQL in a Virtual Machine, and table storage. In this session, we will do a deep dive into the new Premium offering that Azure SQL Database has in preview. We will describe how it’s implemented and show you how to determine in a systematic way when to use this technology and estimate your capacity needs. You’ll gain an understanding of the performance and scale you can achieve when leveraging Azure SQL Database Premium and how this compares to storage technology and scale-out approaches on Azure. You will also learn how to select the most appropriate technology for a certain scenario and understand what it can provide. We will demonstrate the lessons and best practices gathered during real customer engagements over the past 12 months with the Premium database.

Level: 400


Title:

Cloud-Optimizing Your Database App

Speaker:

Tobias Ternstrom

Abstract:

SQL and database access techniques have been around and evolving for decades. What changes to your database development tool belt should you consider when building next-generation cloud applications? Come learn about how you can continue to leverage the power of T-SQL and relational databases in the cloud world and avoid common issues.

Level: 300


Title:

INSERT, UPDATE & DELETE: Internals

Speaker:

Uwe Ricken

Abstract:

Dive into the log internals when an insert, update, or delete happens to your data. See the tremendous differences between the data manipulation language (DML) of a HEAP and a CLUSTERED INDEX. What happens to NCI if you run any DML? We’ll take the lid off what happens when you run your DML.

Level: 300


Title:

Data Tools: Important Part of Modern Software Design

Speaker:

Vesa Tikkanen

Abstract:

Data Tools is an add-on to Visual Studio, allowing database development to be a cohesive part of your software development process. Database development can be versioned, and all the product lifecycle management benefits are part of your database development. In this demo-based session, you'll see how to make your production database part of your future development. We'll modify the database for new business requirements and publish the changes as part of our new version. Within the demos, we'll address the most common issues faced when using Data Tools and share the knowledge gained.

Level: 300


Title:

Hekaton for the Developer

Speaker:

Victor Isakov

Abstract:

SQL Server’s new In-Memory table technology (codenamed “Hekaton”) promises to be one of the most exciting new features to be released when SQL Server 2014 ships. For database developers, it completely changes the way we can build high-performance OLTP applications: All the data is in memory, and there is no locking! In this session, we will discuss Hekaton from a developer perspective, covering Hekaton’s architecture and internals, T-SQL surface area, interoperability considerations, and what performance gains to expect. We will also explore some use cases and examples of where to use Hekaton.

Level: 300

 
 

 


MAIN  SPONSOR


ENTERPRISE  SPONSORS
 

   
 

STANDARD

 

Become a sponsor