Database Administration (DBA) Sessions

 

Title:

SQL Server Internals and Architecture

Speaker:

Kevin Kline

Abstract:

Let’s face it, many SQL Server developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to understand SQL Server’s internal processes and architecture. This session will answer questions such as: “What’s different about 32- and 64-bit systems?” “What are the various areas of memory inside SQL Server?” “How are queries handled behind the scenes?” “What does SQL Server do with procedural code, like functions, procedures, and triggers?” and “What happens when transaction logs and databases grow or shrink?”

This fast-paced session will take you through many aspects of the internal operations of SQL Server, and for the topics we don’t cover, we will point you to resources where you can get more information.

Level: 200

 


Title:

Index Impact Workload Analysis

Speaker:

Klaus Aschenbrenner

Abstract:

Should you add an additional index or modify existing ones? Does it make sense to drop unused indexes to improve workload performance? You have indexing questions, but finding the correct answers is difficult. In this session, you will learn a proven approach for identifying whether an index change helped or hindered performance. We will take a real SQL Server OLTP workload, establish a baseline against it, and use that baseline along with some tools to determine whether index changes should be applied to our production databases or not. After attending this session, you will be able to easily apply the same techniques to your production environment.

Level: 300

 

 


Title:

The log, the whole log and nothing but the log

Speaker:

Mikael Wedham

Abstract:

This session focuses on the transaction log. It begins with a quick glance on what goes on in and around the log in the different recovery modes. You'll then get a deep dive into log sequence numbers, how to find them and what that info means. The context for theese demos is the backup database and backup log commands. And finally you'll see a demo in which we will recover a database from a total data-drive crash without losing one single transaction. It's all about the log...

Level: 300

 

 


 

Title:

SharePoint for the DBA

Speaker:

Régis Baccaro

Abstract:

SharePoint databases are considered a black box - touch them and you lose support. Furthermore, SharePoint leaves an unintelligible track of database names and GUIDs on your server. They are supposed to scale, but how and how much? Here are some techniques DBAs should be aware of to optimize SharePoint performance and scalability. This demo-packed session, based on real-life experiences, will show you how to tune your SQL Server for SharePoint and how to customize your SharePoint installation so that it fits your IT conventions, not the other way around.

Level: 300

 


Title:

The Day After Tomorrow: Why You Need to Baseline

Speaker: Richard Douglas
Abstract:

Ensuring peak SQL Server performance isn’t always easy and requires a lot of work on the part of the DBA. To maintain the best possible performance, you need to make sure you’re monitoring the right things. But how do you know if the performance numbers you’re seeing are good or bad? Baseline comparisons can help, and this session will show you how to get the most from them. You will learn what a baseline is, why and when you need to take one, and how to create one using native Windows and SQL Server tools.

Level: 200

 

 


 

Title:

Kung-Fu Migration to Windows Azure SQL Database

Speaker:

Scott Klein

Abstract:

As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the ability to efficiently migrate your database to the cloud is crucial. This demo-filled session will discuss the tips, tricks, methods, and strategies for migrating your on-premise SQL Server databases to Windows Azure SQL Database. Focusing primarily on SQL Server Data Tools, the DAC Framework, and the Import/Export service, this session will show you how these tools can make you a kung-fu migration master by simplifying the migration process, providing flexibility and more granular control of the migration, and ultimately easing many of the challenges of getting your on-premise database ready for migration to Windows Azure SQL Database.

Level: 300

 


 

Title:

Getting the Most from Your SAN: File and Filegroup Layout

Speaker:

Stephen Archbold

Abstract:

You’ve been given the task of optimizing the file and filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get more from your storage with a different design? Are your SAN guys saying your storage can process 2 GB/s, but you're only seeing 200 MB/s? This session will dive into how to optimize your file and filegroup layout strategy to get the most from your I/O subsystem. We will look at a case study where we took a customer’s table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout. Topics will include: layout for OLTP, data warehousing Fast Track style, data warehousing on a SAN, getting data into your SSAS cubes faster (ProcessData), hidden options and “go faster” buttons, and how to maximize performance in Enterprise Edition and master read ahead.

Level: 300

 


 

Title:

SQL Server High Availability in the Context of SLAs

Speaker:

Tobiasz Koprowski

Abstract:

If SQL Server is the heart of our environment, its health should be very important. And if SQL Server is important, its availability for our businesses is important, too. Customers – whether internal or external – don’t care where data is stored or how it’s stored. Especially for business managers, the data must be available on demand, on time, whenever they need it. High availability is our responsibility as DBAs. How can we implement the appropriate HA for our organizations? How is HA related to Service Level Agreements (SLAs)? And why are SLAs important? In this session, we will discuss HA options for SQL Server (2008, 2012, and 2014), for our different customers, and for meeting SLAs (formal or not).

Level: 300

 


 

Title: 

Architecting SQL Server HA and DR Solutions on Windows Azure

Speaker:

Turgay Sahtiyan and Umit Sunar

Abstract:

In real-life scenarios, SQL Server high availability (HA) and disaster recovery (DR) solutions are not simply cloud-based or on-premise solutions, or internally facing or external solutions. They are a mix of the best of a variety of solutions. Combine SQL Server AlwaysOn – which offers better availability, higher ROI, and simplicity – with Windows Azure technologies, and you can easily increase the efficiency and effectiveness of your solutions. SQL Server and Windows Azure can become the best HA and DR offering for you on multiple fronts. In this session, we will examine this solution’s capabilities, limitations, and trade-offs for various needs, such as complex HA and DR scenarios with minimum capital expenditure.

Level: 300

 


 

Title:

Hekaton for the DBA: A Whole New World

Speaker:

Kalen Delaney

Abstract:

SQL Server Hekaton, Microsoft’s new In-Memory table technology to be shipped as part of SQL Server 2014, will completely change the way you think about data management. As a DBA, you will need to analyze your memory and storage needs completely differently. All Hekaton data is always stored in memory, and the data stored on disk is basically just a REDO log used to regenerate the contents of your memory-optimized tables. This session will show you the in-memory architecture for your Hekaton data and indexes and discuss what gets written to disk during checkpoints, as well as what gets logged. You will also learn how the recovery process recreates your Hekaton tables.

Level: 400

 


MAIN  SPONSOR


ENTERPRISE  SPONSORS
 

   
 

STANDARD

 

Become a sponsor