| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 25-05-2016 12:00 | Peter Myers | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | What's New in SQL Server 2016 Analysis Services |
| 25-05-2016 13:00 | Stacia Varga | 24 Hours of PASS (60 minutes) | BI Information Delivery | A Gentle Introduction to Data Analytics in SQL Server 2016 |
| 25-05-2016 14:00 | J May | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | SQL Server 2016 AlwaysOn Availability Groups Enhancements |
| 25-05-2016 15:00 | Bill Jacobs | 24 Hours of PASS (60 minutes) | BI Information Delivery | Advanced R Analytics in SS2016 using R Tools for Visual Studio |
| 25-05-2016 16:00 | Julie Koesmarno, Tomaž Kaštrun | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | 5 Techniques to Beautiful Data Insights with R and SSRS |
| 25-05-2016 17:00 | Sunil Agarwal, Kevin Farlee, Joe Yong, Luis Vargas, Umachandar Jayachandran, Jos de Bruijn, Sahaj Saini, Casey Karst, Jack Richins, Tommy Mullaney | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Microsoft SQL Server 2016 Program Manager Panel |
| 25-05-2016 18:00 | Warner Chaves | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Swimming in the Data Lake |
| 25-05-2016 19:00 | Robert Dorr | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | SQL Server 2016 Just Works Faster – Performance Improvements in Database Core Engine |
| 25-05-2016 20:00 | Niko Neugebauer | 24 Hours of PASS (60 minutes) | Application & Database Development | Columnstore Technology Improvements in SQL Server 2016 |
| 25-05-2016 21:00 | Jeremiah Wilton | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Four Reasons to Migrate Your SQL Server Databases to the Cloud: Security, Agility, Availability, and Reliability |
| 25-05-2016 22:00 | Riccardo Muti, Chris Finlan | 24 Hours of PASS (60 minutes) | BI Information Delivery | SQL Server 2016 Reporting Services & Mobile BI |
| 25-05-2016 23:00 | Rick Heiges | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Winning with Column Store in SQL Server 2016 - A Customer Story |
| 26-05-2016 00:00 | Reza Rad | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Temporal Tables and Their Role in ETL and Data Warehouse |
| 26-05-2016 01:00 | Saptak Sen | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Got Data? Go Modern and Monetize. Learn How to Run Hortonworks Data Platform (HDP) as a Service Through Microsoft HDInsight |
| 26-05-2016 02:00 | Steve Hughes | 24 Hours of PASS (60 minutes) | Application & Database Development | Using JSON with SQL Server 2016 |
| 26-05-2016 03:00 | James Serra | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Relational Databases vs Non-Relational Databases vs Hadoop |
| 26-05-2016 04:00 | Marko Hotti | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | SQL Server 2016 Hero Features in Action: Full Lifecycle of Financial Data & SQL Server 2016 In-Memory Performance |
| 26-05-2016 05:00 | Silvia Doomra | 24 Hours of PASS (60 minutes) | Cloud Application Development & Deployment | Elastic Database Client Library and Elastic Database Transactions |
| 26-05-2016 06:00 | Martin Catherall | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | A Lap Around Columnstore and 2016 Operational Analytics. |
| 26-05-2016 07:00 | n/a n/a | 24 Hours of PASS (60 minutes) | Cloud Application Development & Deployment | Session Details not available |
| 26-05-2016 08:00 | Leila Etaati | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Treasure Map: Choosing the Right Algorithm in Azure ML |
| 26-05-2016 09:00 | Mark Broadbent | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Schizophrenic High Availability with SQL and Windows 2016 |
| 26-05-2016 10:00 | Robert Davis | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | New Paradigm for Performance Tuning in SQL Server 2016 |
| 26-05-2016 11:00 | Grant Fritchey | 24 Hours of PASS (60 minutes) | Cloud Application Development & Deployment | Perfect Fits for Azure SQL Database Migrations |
Event Date: 25-05-2016 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Topics will include: Upgrading tabular projects to SQL Server 2016, implementing new calculation capabilities including DAX improvements and calculated tables, implementing new table relationship capabilities, configuring display folders, and also managing model translations. In addition, topics will explore working with new DirectQuery mode capabilities, the new Tabular Model Scripting Language (TMSL) and PowerShell.
Event Date: 25-05-2016 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
In this session, we explore the goals of data analytics solutions and review scenarios for using data analytics. You also learn which tools in the Microsoft stack that you can use to support your data analytics requirements and to explore and visualize data as part of a data analytics solution. By the end of the session, you'll have some new ideas and inspiration to get started with your own project!
Event Date: 25-05-2016 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 25-05-2016 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
Event Date: 25-05-2016 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
This session covers techniques in integrating R’s strength in statistics, predictive modelling, data mining, graphical solutions in SQL Server’s mature reporting services capabilities. The demo focuses on the building blocks, including code samples in R and SSRS to get you started on your journey to beautiful data insights and actionable decisions.
Event Date: 25-05-2016 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 25-05-2016 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 25-05-2016 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 25-05-2016 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 25-05-2016 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Attend this webinar for an in-depth look at how AWS customers like Unilever, Hearst, Rovio and Prezi are using RDS SQL Server in concert with Amazon Virtual Private Cloud to improve security, and with the Multi-Availability-Zone feature to provide high availability. Learn how RDS customers easily scale up the power of their databases without downtime, and achieve fast, consistent, and predictable performance through AWS Provisioned IOPS.
In this session, you will also learn about:
Implementing database security within AWS through storage-level encryption, network layer controls, Instance and data access controls, and encrypted connections using SSL
Sizing RDS SQL Server instances to meet workload demands
Monitoring database performance using Amazon CloudWatch, and adding alarms & notifications
Migrating and replicating data into AWS and also between database engine types with minimal downtime using the AWS Database Migration Service
Event Date: 25-05-2016 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
Event Date: 25-05-2016 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-05-2016 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
In this session you will learn how Temporal Tables works, and you will also learn through live demos how to use it in your Data Warehouse for Slowly Changing Dimension. You also learn some tips and tricks when you work with Temporal Tables for SCD implementation.
Event Date: 26-05-2016 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
• Analyze, explore, query and deliver insights with Hadoop. Leverage linear scale storage and compute across multiple access methods from batch to interactive, to real time, search and streaming.
• Integrate with your existing applications and systems so that you can take advantage of Hadoop with minimal change to existing data architectures and skillsets.
• Experience best practice capabilities aligned to functional areas: Data Management, Data Access, Data Governance and Integration, Security, and Operations
Event Date: 26-05-2016 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 26-05-2016 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
In this presentation I will first clarify what exactly these database solutions are, how they compare to Hadoop, and discuss the best use cases for each. I’ll discuss topics involving OLTP, scaling, data warehousing, polyglot persistence, and the CAP theorem. We will even touch on a new type of database solution called NewSQL. If you are building a new solution it is important to understand all your options so you take the right path to success.
Event Date: 26-05-2016 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-05-2016 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment
Objectives
Build Scaled-out applications using Elastic Database Client Library
Execute transactions spanning across multiple databases in Azure SQL
Event Date: 26-05-2016 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
We will work through enhancements that have incrementally been made to columnstore and conclude with a look at how operation analytics can provide customers with the up-to-date insights into their data that may well give them a business advantage.
Attendees will leave this session with the following knowledge: •An understanding of the columnstore features in each SQL Server version. •An understanding of both the Technical and Marketing language behind columnstore. •The advantages of the query processing mode that columnstore brings. •Why columnstore provides both storage and performance improvements. •A knowledge of some of the internals and storage structures of Columnstore. •A reasonable grounding in 2016 Operation Analytics and how it can be leveraged.
Event Date: 26-05-2016 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment
Event Date: 26-05-2016 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 26-05-2016 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 26-05-2016 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
You’ll discover how to:
Quickly analyze and troubleshoot problem queries
Diagnose the root-cause of query slow-downs
Force execution plans and prevent future plan regressions
Event Date: 26-05-2016 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Application Development & Deployment