PASS SQLRally 2011 www.sqlpass.org Twitter Facebook

Database Administration (DBA)

The following sessions were chosen to be presented at PASS SQLRally Nordic 2012.
Scroll down to see them all:
 

Selected Sessions

 

Title:

SQLCAT - Data movement considerations for the hybrid solutions
between Cloud and on-Premise

Speaker:

Alexei Khalyako

Abstract:

There is a lot of excitement around moving parts of the business workload into the Cloud.  One of the most interesting approaches is to build combined solutions where the ‘traditional’   SQL and Cloud services could be combined together in so called ‘Hybrid’ configuration. The question we want to discuss is: we know how to get data into the SQL Server quick and efficiently. Will those techniques also work  when moving data into the Cloud? Please join the session to learn about our observations when we applied the data loading best practices to the Hybrid solutions and the best practices we identified for the Hybrid configurations.

Level 300

 

 

 

 

 

 

 

 


 

Title:

Deploying SQL Server 2012 Failover Clustering Instances

Speaker:

Allan Hirt

Abstract:

There are quite a few changes to failover clustering instances in SQL Server 2012, not the least of which is full multi-subnet support, the use of SMB shares, the ability to use a local tempdb, and more. Add to that mix the possibility of a new platform (Windows Server 2012), and there's a lot DBAs will need to know to update their skills to deploy clustered instances with the latest version of SQL Server. This session will cover the relevant tips, tricks, and gotchas including anything related to Windows Server 2012 if possible.

Level 100

 

 

 

 

 

 


Title:

SQLCAT - SQL 2012 OLTP 

Speaker:

Ewan Fairweather

Abstract: SQL Server 2012 provides enhancements to internal components and programmability features in the relational engine. In this session we’ll focus on common challenges our OLTP workloads face:
•  Describe how new features can benefit and how they relate to older functionality. 
•  We will look at what you should consider for use as you design a system, maintain it and troubleshoot it 
•  How Sequence objects can be leveraged to unblock latch contention scenarios
•  The internal enhancements we have made to the memory manager and what you need to know about it
•  Walk through practical examples of how to use the new XEvents UI and harness it’s debugging capabilities so that you can get a real insight into what is going on in your system.

Level 300

 

 

 

 

 

 

 

 

 

 


 

Title:

Automating DMV Performance Collection, Analysis and Archival

Speaker:

Joe Chang

Abstract: The SQL Server Dynamic Management Views and Functions are highly useful in providing quick access to available performance data without having to wait for a new trace. Collecting, analyzing and archiving DMV data through SQL scripts can be awkward and cumbersome. It is much more effective to do this in a proper programming language. Much of the tedious analysis work can be automated, but a quality assessment is still beyond the capability of hands-off tools. Performance data can be collected at regular intervals and archived without much effort. When there is a significant performance degradation, the before and after execution plans are readily available. Performance problems are not difficult to resolve. But management may want an explanation, and are prone to issue edicts. So it is important that the correct information be presented.

Level 400

 

 

 

 

 

 





 


Title:

SQL Server 2012 Troubleshooting with Extended Events

Speaker: Klaus Aschenbrenner 
Abstract: Extended Events is a new lightweight tracing infrastructure that Microsoft introduced first with SQL Server 2008. SQL Server 2012 provides you now also a very sophisticated UI for configuring event sessions based on Extended Events. In this session you will get a basic overview about Extended Events, what are they, how they are used inside SQL Server, and how you can use them to troubleshooting your SQL Server 2012 installation.

Level 300

 

 

 

 




 


 

Title:

Windows Server 2012 infrastructure for SQL Server

Speaker:

Michael Frandsen

Abstract: In this session I will go into the new storage features in Windows Server 2012. Through working with the Core Windows Server team in Redmond during the development of Windows 8 I did a lot of work with technologies which have been around for some time, but unavailable to Windows Server installations. We will talk about Infiniband, Multi-path I/O, RDMA, RoCE, NAND Flash storage, latency and much more.

Level 400

 

 

 

 

 


 


 

Title:

SQL Server 2012 Memory Management 

Speaker:

Neil Hambly

Abstract: SQL Server 2012 brings a wide range of changes, including a key change in how SQL Server memory is managed. Earlier releases of SQL Server have two memory managers, which have now been merged into one. And that’s just the beginning of the changes for SQL Server memory. This session will dive into SQL Server 2012's new memory architecture. We'll see how to diagnose memory performance issues and gain insight into memory pressure issues. We'll also cover the settings to adjust memory configuration levels and their impact.

Level 300

 

 

 

 

 

 

 


 

Title:

SQLCAT - Learn how Windows Azure SQL Database can support
very large scale customer deployments

Speaker:

Silvano Coriani

Abstract: In this session we’ll present some of the challenges the MS team (MCS, PFE, DPE, Windows Azure Incubation and SQL CAT) faced working with key customers to implement and launch successfully massive scaling web applications currently running on the Windows Azure as well as key lessons learned and best practices. These customer experiences cover Pottermore.com, Samsung Electronics and MYOB. Pottermore.com is built around the Harry Potter books where users can share and participate in the stories and showcase their own Potter-related creativity by uploading their thoughts and drawings to the site. Samsung Electronics system supports their Smart TV line across the globe with key services such as registration, firmware and apps upgrades, content delivery and remote management. MYOB is an ISV that provides accounting system for small companies across Australia and New Zealand planning to deploy and manage 100k+ SQL Databases.

Level 300

 

 

 

 

 

 

 

 







 

Title: 

Optimising Column Stores with Statistical Analysis

Speaker:

Thomas Kejser

Abstract:

You may already know that ordering the records in a table before you add a column store index may increase compression. And if you don't, I will show you just how it does to get us on the same page. But the real question is: WHICH order of the column is the right one? In this session, I will walk you through some basic statistical entropy analysis to discover the near optimal sorting of data. This will increase compression (And speed) of column stores. I will use anonymised datasets from real customer data to prove my points. As a side effect of the analysis we will do together, it is also possible to discover missing multi-column statistics on a table. Using this new knowledge, we will be able to add new statistics to the database table to increase the likelihood of getting good query plans.

Level 400


 

 

 

 

 







 


 

Title:

Upgrading Your High-Availability Solution to SQL Server 2012
AlwaysOn Availability Groups

Speaker:

Victor Isakov

Abstract: With SQL Server 2012 AlwaysOn Availability Groups Microsoft has substantially changed the way you can design your high-availability solutions. With read-only replicas that can be used for offloading your reports, backups and consistency checks this promises to be technology that can deliver a number of business benefits. In this session Victor Isakov (MCA, MCM, MCT, MVP) will cover the architecture of this new feature in SQL Server 2012 and the high-availability opportunities it presents. Victor will also cover how AlwaysOn Availability Groups can change how you maintain your database solutions so as to minimize the impact on production databases.

Level 300


PRIMARY  SPONSOR


ENTERPRISE  SPONSOR
 

   
 
 
 
 
 
 
 

STANDARD