| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 07-09-2016 12:00 | David Klee | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | The Complete Primer to SQL Server Virtualization |
| 07-09-2016 13:00 | Brian Larson | 24 Hours of PASS (60 minutes) | BI Information Delivery | Effective Data Visualization with SQL 2016 - Data Near and Far |
| 07-09-2016 14:00 | Glenn Berry | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Dr. DMV: How to Use DMVs to Diagnose Performance Problems |
| 07-09-2016 15:00 | Tara Shankar Jana | 24 Hours of PASS (60 minutes) | Application & Database Development | “Sneak Peak” Cloud App Development Immersion- Hands on approach to build data-driven Intelligent applications |
| 07-09-2016 16:00 | Guy Glantser | 24 Hours of PASS (60 minutes) | Application & Database Development | From XML to JSON |
| 07-09-2016 17:00 | Allan Hirt | 24 Hours of PASS (60 minutes) | Application & Database Development | A Closer Look at Distributed Availability Groups |
| 07-09-2016 18:00 | Dmitri Korotkevitch | 24 Hours of PASS (60 minutes) | Application & Database Development | The Ambiguous Case of Off-Row Storage in In-Memory OLTP |
| 07-09-2016 19:00 | Vicky Harp | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Understanding and Monitoring Tempdb |
| 07-09-2016 20:00 | Patricio Cofre | 24 Hours of PASS (60 minutes) | Application & Database Development | Using Azure Machine Learning to Predict Consumer Price Index |
| 07-09-2016 21:00 | Marco Russo | 24 Hours of PASS (60 minutes) | BI Information Delivery | Create a Power BI Solution in One Day |
| 07-09-2016 22:00 | Kalen Delaney | 24 Hours of PASS (60 minutes) | Application & Database Development | Locking, Blocking, Versions: Concurrency for Maximum Performance |
| 07-09-2016 23:00 | Jen Underwood, Kevin Petrie, Reza Khan | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Enabling Real-time Analytics with CDC and Data Warehouse Automation |
| 08-09-2016 00:00 | Kathi Kellenberger | 24 Hours of PASS (60 minutes) | Application & Database Development | Indexing for Beginners |
| 08-09-2016 01:00 | Brent Ozar | 24 Hours of PASS (60 minutes) | Professional Development | 500-Level Guide to Career Internals |
| 08-09-2016 02:00 | Joachim Hammer | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | Securing your Data is Easier Than Ever: Security Investments in SQL Server 2016, Azure SQL Database, and SQL Data Warehouse |
| 08-09-2016 03:00 | Andy Yun | 24 Hours of PASS (60 minutes) | Application & Database Development | Performance Pitfalls from Code Reuse |
| 08-09-2016 04:00 | Eduardo Castro | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | R Language for the SQL Server DBA |
| 08-09-2016 05:00 | Rob Farley | 24 Hours of PASS (60 minutes) | Enterprise Database Administration & Deployment | The Synergy of In-Memory Operational Analytics |
| 08-09-2016 06:00 | Matan Yungman | 24 Hours of PASS (60 minutes) | Application & Database Development | MongoDB for the SQL Server Professional |
| 08-09-2016 07:00 | Markus Ehrenmueller-Jensen | 24 Hours of PASS (60 minutes) | BI Information Delivery | My Favorite Pie (Chart): Simple Rules for Clear Visualizations |
| 08-09-2016 08:00 | Mladen Prajdić | 24 Hours of PASS (60 minutes) | Application & Database Development | Optimizing Database Access And Diving Into .Net SqlClient |
| 08-09-2016 09:00 | Hamish Watson | 24 Hours of PASS (60 minutes) | Application & Database Development | Overcoming a Culture of FearOps by Adopting DevOps |
| 08-09-2016 10:00 | Peter Myers | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | Developing a SQL Server 2016 Master Data Services Solution |
| 08-09-2016 11:00 | Tim Mitchell | 24 Hours of PASS (60 minutes) | BI Platform Architecture, Development & Administration | A Crash-Course in Biml |
Event Date: 07-09-2016 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Preview this all-day interactive and hypervisor-agnostic session that is designed to help data professionals learn more about virtualization and infrastructure, and discover how this new layer can be used to improve the management, availability, and performance of their databases. You will be exposed to all layers of virtualization underneath the SQL Server, from the storage to the hypervisor, and will discover many useful tips and tricks to tuning the database layer to boost performance and availability. The following topics will be addressed during the session: • virtualization and infrastructure fundamentals • the SQL Server Virtual Machine • networking, support, and licensing • High Availability and Disaster Recovery • performance investigation and tuning of the entire stack.
Event Date: 07-09-2016 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
The session will include tips and tricks for creating simple, easily maintainable visualizations of complex datasets. Along the way, we will look at innovative ways to utilize features such as scope, dynamic report properties, images, and SQL Server spatial data types to push our visualizations to the limits.
As we examine each data visualization tool, we will discuss its strengths, weaknesses, and ways in which it can best be utilized. The session will also cover methods for secure, efficient delivery of visualizations both inside and outside of the organization. We may even play a SQL Server visualization-based game or two!
Participants will leave with a knowledge of the range of tools available in SQL Server 2016 and a solid understanding of the ways to leverage each tool for effective data visualization.
Event Date: 07-09-2016 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
If you have ever been responsible for a mission critical database, you have probably been faced with a high stress, emergency situation where a database issue is causing unacceptable application performance, resulting in angry users and hovering managers and executives. If this hasn't happened to you yet, thank your lucky stars, but start getting prepared for your time in the hot seat. This session will show you how to use DMV queries to quickly detect and diagnose the problem, starting at the server and instance level, and then progressing down to the database and object level.
This session will show you how to properly analyze and interpret the results of every single query in the set, along with lots of information on how to properly configure your instance and databases.
Event Date: 07-09-2016 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Get hands-on and learn how to build secure, performant, scalable and predictive application modernization practice centered around data-driven intelligent apps, and re-architect on-premises ISV/SaaS apps to Azure for scale, reach.
The goals of this session are to: • Get familiar with Immersion experiences • Learn about the scenarios you would get hands on experience during Pre-Con for PASS Summit • Learn about what are intelligent applications in a data driven world
Event Date: 07-09-2016 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
In this preview session we will learn how to work efficiently with these two markup languages in SQL Server. We will discuss use cases for using either XML or JSON. We will compare a few methods and talk about the performance impact of each. If you’re a developer and you need to manipulate XML or JSON files in SQL Server, then this session is for you.
Event Date: 07-09-2016 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 07-09-2016 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
This session will explain how In-Memory OLTP works with LOB data and columnstore indexes in-memory, and it will provide you with the set of guidelines on how to reduce performance overhead they could introduce.
Event Date: 07-09-2016 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 07-09-2016 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Through leveraging Azure+PowerBI resources for data scraping, analytics, and visualization, it is possible to obtain:
Event Date: 07-09-2016 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
At the end of the day, you will be ready to start using the entire Power BI stack in your company, choosing the right feature for each requirement and applying the best practices in each step. The additional benefit is to understand how to include cloud services as a part of your data warehouse infrastructure.
Event Date: 07-09-2016 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 07-09-2016 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Attendees will learn about:
• Hybrid data warehousing architecture • Data warehouse development automation • Just-in-time and real-time BI/analytics enablement technologies • Real-world user success stories • Data integration tips and best practices to save time, $ and sanity
You’ll also see a live demo of the highlighted technologies.
Event Date: 08-09-2016 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 08-09-2016 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
Brent will show you simple techniques to build a blog, a brand, and a business without that pesky personal networking stuff. He will explain why you have to give everything away for free, and why you cannot rely on the old methods to make money anymore.
It will not be easy - and that is why this session is level 500. This session is about radical methods that achieve radical results.
Event Date: 08-09-2016 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 08-09-2016 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to explore how it generates your Execution Plan. You will be introduced to a T-SQL tool that will aid you in unraveling nested code and together we will explore solutions to help you mitigate these performance pitfalls.
Event Date: 08-09-2016 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
We will start by using R Studio and Scripts samples and will migrate these scripts to Microsoft R Server and Microsoft SQL Server 2016. Next, we will show how to integrate these scripts inside the data warehouse cycle and within PowerBI in the architecture.
Event Date: 08-09-2016 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Enterprise Database Administration & Deployment
Event Date: 08-09-2016 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
MongoDB is the leading NoSQL database today. It provides a rich set of features and supports many programming languages. Many organizations move from SQL Server to MongoDB, and many DBAs and database developers are required to know it in addition to SQL Server.
In this preview session, we will talk about:
MongoDB is here. It's time to know how, when, and why to work with it.
Event Date: 08-09-2016 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Information Delivery
Join this session to preview five easy-to-implement rules, which will guide you through the process of creating clear and attractive visualizations. Every rule will be applied through live demos in Excel, Reporting Services, and Power BI Desktop, where you will learn how to avoid pitfalls from the defaults in those tools.
Event Date: 08-09-2016 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
Event Date: 08-09-2016 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application & Database Development
During this preview session we will demonstrate how DevOps allows you to respond faster to competitive pressures by replacing error-prone (human) processes with automation for improved traceability, reliable, and repeatable deployments.
DevOps methodologies allow you to develop and use automation techniques for fast, efficient, and reliable software delivery. DevOps is about a cultural shift as much as a process and technological one. This session will illustrate how when you overcome the technical challenges of implementing DevOps you expose the cultural benefits.
With improved traceability, reliable, and repeatable deployments, this session will help you remove FearOps from your organisation.
Event Date: 08-09-2016 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
Event Date: 08-09-2016 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: BI Platform Architecture, Development & Administration
In the preview for this Summit half-day session, we will fully explore how Biml can help you with your SSIS development. We will review what Biml is, walking through the language basics and showing how it fits into your existing SSIS development environment. Once we've covered those basics, we will work through several increasingly complex examples to show how Biml can be used to generate, in a matter of minutes, packages that would have otherwise taken days if not weeks.
There are two types of SSIS developers: Those using Biml, and those who will soon be. This session will help you to get started with Biml, and put you ahead of your peers in this revolutionary technology.