sqlpasshistory

ID: 36

Back to Main list

24 Hours of PASS: SQL Server 2014 Launch

Session Date/Time (dd-MM-YYYY 24h) Speaker Category Track Title
25-06-2014 12:00 Ross LoForte, Rick Heiges 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment Field Testing Buffer Pool Extension and In-Memory OLTP Features in SS2014
25-06-2014 13:00 Jamie Reding 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment SQL Server 2014: In-Memory OLTP Overview
25-06-2014 14:00 Sunil Agarwal 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment SQL Server 2014: In-Memory OLTP for Database Administrators
25-06-2014 15:00 George Li 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment SQL Server 2014: In-Memory OLTP End-to-End: Preparing for Migration
25-06-2014 16:00 Jos de Bruijn 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment SQL Server 2014: In-Memory OLTP for Database Developers
25-06-2014 17:00 Sunil Agarwal, Jos de Bruijn 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment AMA: Open Questions and Answers on SQL Server 2014 In-Memory OLTP
25-06-2014 18:00 Dan Kogan 24 Hours of PASS (60 minutes) BI Platform Architecture, Development & Administration The Modern Data Warehouse
25-06-2014 19:00 Darmadi Komo 24 Hours of PASS (60 minutes) Cloud Application Development & Deployment SQL Server 2014: Private and Hybrid Cloud Features
25-06-2014 20:00 Luis Vargas 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment AlwaysOn in Microsoft SQL Server 2014
25-06-2014 21:00 Sunil Agarwal 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment Columnstore Technical Deep Dive
25-06-2014 22:00 J May 24 Hours of PASS (60 minutes) BI Platform Architecture, Development & Administration Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit
25-06-2014 23:00 Selcin Turkarslan 24 Hours of PASS (60 minutes) Cloud Application Development & Deployment Migration and Deployment for SQL Server in Azure Virtual Machines
26-06-2014 00:00 Darmadi Komo, Evgeny Ternovsky, Bill Kan 24 Hours of PASS (60 minutes) Cloud Application Development & Deployment AMA: Open Questions and Answers on SQL Server 2014 HA-DR in the Cloud
26-06-2014 01:00 Bill Gibson 24 Hours of PASS (60 minutes) Application & Database Development Designing Modern Apps Using New Capabilities in Azure SQL Database
26-06-2014 02:00 Matt Usher 24 Hours of PASS (60 minutes) BI Platform Architecture, Development & Administration Introduction to Microsoft Analytics Platform System (APS)
26-06-2014 03:00 Evgeny Ternovsky, Bill Kan 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment SQL Server 2014 Upgrade: A Case Study Featuring In-Memory OLTP and Hybrid-Cloud Scenarios
26-06-2014 04:00 Scott Klein 24 Hours of PASS (60 minutes) Cloud Application Development & Deployment Patterns and Practices for Scaling Microsoft Azure SQL Database
26-06-2014 05:00 Scott Klein, Bill Gibson, Joanne Marone 24 Hours of PASS (60 minutes) Cloud Application Development & Deployment AMA: Open Questions and Answers on Azure SQL Database
26-06-2014 06:00 Jos de Bruijn 24 Hours of PASS (60 minutes) Application & Database Development SQL Server 2014: In-Memory OLTP Performance Troubleshooting
26-06-2014 07:00 Jamie Reding 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment SQL Server 2014 In-Memory OLTP: Memory/Storage Monitoring and Troubleshooting
26-06-2014 08:00 Pedro Lopes 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment SQL Server 2014: Changes to Query Plans
26-06-2014 09:00 Alexei Khalyako 24 Hours of PASS (60 minutes) Enterprise Database Administration & Deployment AMA: Open Questions on SQL Server 2014, Microsoft Azure, and Big Data
26-06-2014 10:00 Silvano Coriani 24 Hours of PASS (60 minutes) Application & Database Development AMA: Open Questions and Answers on SQL Server in Azure VMs
26-06-2014 11:00 Brian Mitchell 24 Hours of PASS (60 minutes) BI Platform Architecture, Development & Administration The Role of Polybase in the Modern Data Warehouse

SessionID: 7149

Field Testing Buffer Pool Extension and In-Memory OLTP Features in SS2014

Back to calendar

Event Date: 25-06-2014 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Ross LoForte, Rick Heiges

Title: Field Testing Buffer Pool Extension and In-Memory OLTP Features in SS2014

Description:

SQL Server 2014 ships with powerful new features that can really take your performance to the next level: In-Memory OLTP (Codename "Hekaton") and the Buffer Pool Extension (BPE). In-Memory OLTP unleashes today’s powerful processors and removes the roadblocks to new heights in performance. BPE takes advantage of lightning-fast storage (in the form of Solid State Storage) to effectively and economically expand the amount of usable memory for the system. These two new features were field benchmarked at the MTC Chicago in order to gain an understanding on the behavior, scalability, and use cases where these apply. This session reviews the results of the benchmark testing along with customer examples using each feature.

SessionID: 7150

SQL Server 2014: In-Memory OLTP Overview

Back to calendar

Event Date: 25-06-2014 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Jamie Reding

Title: SQL Server 2014: In-Memory OLTP Overview

Description:

SessionID: 7151

SQL Server 2014: In-Memory OLTP for Database Administrators

Back to calendar

Event Date: 25-06-2014 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Sunil Agarwal

Title: SQL Server 2014: In-Memory OLTP for Database Administrators

Description:

SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this DBA-focused session, we take a deep dive into how in-memory tables and indexes are managed in memory and in storage. You will also learn how to provision and control memory usage, how durability and high availability is achieved, and how these constructs and operations are integrated together with disk-based tables to provide you a seamless experience.

SessionID: 7152

SQL Server 2014: In-Memory OLTP End-to-End: Preparing for Migration

Back to calendar

Event Date: 25-06-2014 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): George Li

Title: SQL Server 2014: In-Memory OLTP End-to-End: Preparing for Migration

Description:

SQL Server In-Memory OLTP is a key new feature included in SQL Server 2014. It has been proven to dramatically increase OLTP performance without hardware changes. However, there are numerous nuances in In-Memory OLTP. These nuances mean that not all workloads can derive benefits from In-Memory OLTP. For the workloads that can benefit, care must be taken so that the migration process will enable the workload to take maximum advantage of In-Memory OLTP while keeping efforts down to a minimum. This session uses a sample workload to demonstrate how to plan to migrate to In-Memory OLTP.

SessionID: 7153

SQL Server 2014: In-Memory OLTP for Database Developers

Back to calendar

Event Date: 25-06-2014 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Jos de Bruijn

Title: SQL Server 2014: In-Memory OLTP for Database Developers

Description:

SQL Server 2014 introduces in-memory technology for optimizing OLTP workloads. In this session, we will focus on the new concepts for database developers. We will discuss the new memory-optimized tables and the new memory-optimized hash and non-clustered indexes. You will learn how to access memory-optimized tables using interpreted Transact-SQL, and how to optimize data access using the new natively compiled stored procedures. Finally, we will discuss how to work with the new lock-free transaction semantics for In-Memory OLTP.

SessionID: 7154

AMA: Open Questions and Answers on SQL Server 2014 In-Memory OLTP

Back to calendar

Event Date: 25-06-2014 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Sunil Agarwal, Jos de Bruijn

Title: AMA: Open Questions and Answers on SQL Server 2014 In-Memory OLTP

Description:

Got questions about SQL Server 2014 In-Memory OLTP? Submit your questions to 24hrs@sqlpass.org by June 13th and we’ll have SQL Server Product Managers answer them live!

SessionID: 7155

The Modern Data Warehouse

Back to calendar

Event Date: 25-06-2014 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Dan Kogan

Title: The Modern Data Warehouse

Description:

With data volumes exploding by 10x every five years and 85% of this growth coming from new data types, the data warehousing market has reached its most significant tipping point since its inception. In this session, you’ll learn about Microsoft’s unique approach to evolving your existing data warehouse infrastructure to support this hyper growth in variety, volume, and velocity of data.

SessionID: 7156

SQL Server 2014: Private and Hybrid Cloud Features

Back to calendar

Event Date: 25-06-2014 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Darmadi Komo

Title: SQL Server 2014: Private and Hybrid Cloud Features

Description:

Join this session to learn about new features in SQL Server 2014 geared towards private and hybrid cloud. This session is demo-heavy and you will walk away with great understanding of how the product team bakes cloud features directly into SQL Server 2014.

SessionID: 7157

AlwaysOn in Microsoft SQL Server 2014

Back to calendar

Event Date: 25-06-2014 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Luis Vargas

Title: AlwaysOn in Microsoft SQL Server 2014

Description:

In this session, we will share our experience upgrading mission critical databases supporting large workloads to SQL Server 2014 with minimal downtime. We will then discuss the practical process of enabling some of the new features introduced in the 2014 release including in-Memory OLTP, Managed Backup, and Data Files in Microsoft Azure Storage.

SessionID: 7158

Columnstore Technical Deep Dive

Back to calendar

Event Date: 25-06-2014 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Sunil Agarwal

Title: Columnstore Technical Deep Dive

Description:

The addition of updateable columnstore in Microsoft SQL Server 2014 offers order of magnitude and more query performance. In this session, we will discuss the impact of this to you and your customers. We’ll also talk about internals, how columnstore works, the differences from row store, and about the metadata that surfaces this new information.

SessionID: 7159

Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit

Back to calendar

Event Date: 25-06-2014 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): J May

Title: Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit

Description:

Columnstore indexes were introduced in SQL Server 2012 and have been wholly re-architected and optimized in SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads and are a hybrid technology leveraging the best of off-disk and In-Memory capabilities. This presentation includes an overview of SQL Server 2012 and a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, and big wins at customer sites and inside MSIT. The presentation is rich in demos, including leveraging IaaS. Learn whether columnstore can change your users' world and why it may be a compelling reason to upgrade. Also learn how columnstore indexes flip the DW faster bit and why it manifests my motto, “Change the world or go home!”

SessionID: 7160

Migration and Deployment for SQL Server in Azure Virtual Machines

Back to calendar

Event Date: 25-06-2014 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Selcin Turkarslan

Title: Migration and Deployment for SQL Server in Azure Virtual Machines

Description:

SessionID: 7161

AMA: Open Questions and Answers on SQL Server 2014 HA-DR in the Cloud

Back to calendar

Event Date: 26-06-2014 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Darmadi Komo, Evgeny Ternovsky, Bill Kan

Title: AMA: Open Questions and Answers on SQL Server 2014 HA-DR in the Cloud

Description:

Got questions about SQL Server 2014 cloud solutions for High Availability and Disaster Recovery? Submit your questions to 24hrs@sqlpass.org by June 13th and we’ll have SQL Server Product Managers answer them live!

SessionID: 7162

Designing Modern Apps Using New Capabilities in Azure SQL Database

Back to calendar

Event Date: 26-06-2014 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Bill Gibson

Title: Designing Modern Apps Using New Capabilities in Azure SQL Database

Description:

Join this session to learn about the latest investments in Azure’s relational database service, SQL Database. We will demonstrate key architectural patterns gathered during close customer engagements to showcase how customers are achieving mission criticality in the cloud. The focus will be on how and when to apply the new capabilities across business continuity and performance into the design of modern mission-critical applications. Expect us to cover both business as well as architectural considerations including technical demos.

SessionID: 7163

Introduction to Microsoft Analytics Platform System (APS)

Back to calendar

Event Date: 26-06-2014 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Matt Usher

Title: Introduction to Microsoft Analytics Platform System (APS)

Description:

The Analytics Platform System brings Microsoft’s massively parallel processing (MPP) data warehouse technology — the SQL Server Parallel Data Warehouse (PDW) — together with HDInsight, Microsoft’s 100% Apache Hadoop distribution, and delivers it as a turnkey appliance. To integrate data from SQL Server PDW with data from Hadoop, APS offers the PolyBase data querying technology.

SessionID: 7164

SQL Server 2014 Upgrade: A Case Study Featuring In-Memory OLTP and Hybrid-Cloud Scenarios

Back to calendar

Event Date: 26-06-2014 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Evgeny Ternovsky, Bill Kan

Title: SQL Server 2014 Upgrade: A Case Study Featuring In-Memory OLTP and Hybrid-Cloud Scenarios

Description:

In this session, we will share our experiences with upgrading mission critical databases supporting large workloads to SQL Server 2014 with minimal downtime. We will then discuss the practical process of enabling some of the new features introduced in the 2014 release, including In-Memory OLTP, Managed Backup, and Data Files in Windows Azure Storage.

SessionID: 7165

Patterns and Practices for Scaling Microsoft Azure SQL Database

Back to calendar

Event Date: 26-06-2014 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Scott Klein

Title: Patterns and Practices for Scaling Microsoft Azure SQL Database

Description:

Cloud computing is distributed computing which requires thoughtful planning and delivery, regardless of platform choice. Because of the inherent complexity of running services at scale, it is important to understand the behavior and performance of the cloud platform in which a database is hosted to match business performance and scale expectations and requirements. This session will look at different scenarios, patterns, and best practices for building scalable databases in Microsoft Azure SQL Database. We’ll also look at scale-up vs. scale-out models, horizontal partitioning, and some tips for dealing with some of the complexities of cloud database scalability, including identity generation, working with relationships, and fan-out queries.

SessionID: 7166

AMA: Open Questions and Answers on Azure SQL Database

Back to calendar

Event Date: 26-06-2014 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment

Speaker(s): Scott Klein, Bill Gibson, Joanne Marone

Title: AMA: Open Questions and Answers on Azure SQL Database

Description:

Got questions about Azure SQL Database? Submit your questions to 24hrs@sqlpass.org by June 13th and we’ll have SQL Server Product Managers answer them live!

SessionID: 7167

SQL Server 2014: In-Memory OLTP Performance Troubleshooting

Back to calendar

Event Date: 26-06-2014 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Jos de Bruijn

Title: SQL Server 2014: In-Memory OLTP Performance Troubleshooting

Description:

You've migrated parts of your application to In-Memory OLTP, but now you're not seeing a serious performance improvement, or maybe you’re even seeing a performance degradation! What's going on? In this session, we walk you through several performance problems we have seen with customers, and demonstrate how to diagnose and resolve the issues to ultimately obtain the performance improvement you're looking for from In-Memory OLTP. We will address a variety of issues, including log IO bottlenecks, index tuning, and query plan problems.

SessionID: 7168

SQL Server 2014 In-Memory OLTP: Memory/Storage Monitoring and Troubleshooting

Back to calendar

Event Date: 26-06-2014 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Jamie Reding

Title: SQL Server 2014 In-Memory OLTP: Memory/Storage Monitoring and Troubleshooting

Description:

Now that you have your application migrated to the In-Memory OLTP Engine and you're getting good performance with your workload, your main focus is to keep it operational. This session walks through various scenarios, such as running out of memory, garbage collection of both memory and storage, and corrupt backups. We will also discuss how to manage it using familiar tools such as PerfMon, Profiler, DMVs, XEvents, and Management Pack to monitor your workload.

SessionID: 7172

SQL Server 2014: Changes to Query Plans

Back to calendar

Event Date: 26-06-2014 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Pedro Lopes

Title: SQL Server 2014: Changes to Query Plans

Description:

There are two big changes in SQL Server 2014 that will impact your query plans, particularly for data warehousing applications. In this session, you will learn how to manage statistics on large tables with the new capability in SQL Server 2014 to define and update stats by partition. We will also discuss the cardinality estimator drives on how plans are costed and were re-architected in SQL Server 2014. We will then dive into details on the reason for these changes and how they might affect you.

SessionID: 7196

AMA: Open Questions on SQL Server 2014, Microsoft Azure, and Big Data

Back to calendar

Event Date: 26-06-2014 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment

Speaker(s): Alexei Khalyako

Title: AMA: Open Questions on SQL Server 2014, Microsoft Azure, and Big Data

Description:

Got questions about SQL Server 2014, Microsoft Azure, or Big Data? Submit your questions to 24hrs@sqlpass.org by June 13th and we’ll have SQL Server Product Managers answer them live!

SessionID: 7197

AMA: Open Questions and Answers on SQL Server in Azure VMs

Back to calendar

Event Date: 26-06-2014 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development

Speaker(s): Silvano Coriani

Title: AMA: Open Questions and Answers on SQL Server in Azure VMs

Description:

Got questions about SQL Server 2014 in Azure VMs? Submit your questions to 24hrs@sqlpass.org by June 13th and we’ll have SQL Server Product Managers answer them live!

SessionID: 7171

The Role of Polybase in the Modern Data Warehouse

Back to calendar

Event Date: 26-06-2014 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration

Speaker(s): Brian Mitchell

Title: The Role of Polybase in the Modern Data Warehouse

Description:

We have all heard about the PolyBase feature of the Microsoft SQL Server 2012 Parallel Data Warehouse, but what are the use cases for this technology? In this session, we explore and demonstrate specific use cases for implementing PolyBase into your Modern Data Warehouse solution. Specifically, we examine how PolyBase can help you: streamline your ETL process by using Hadoop as the staging area of the backroom; export to your Hadoop environment your Enterprise Data Warehouse conformed dimensions; use Hadoop as a low cost, online data archive; and enrich your relational data with ambient data resident in Hadoop.