| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 10-09-2019 12:00 | Glenn Berry | 24 Hours of PASS (60 minutes) | Database Administration and Development | Dr. DMV's Troubleshooting Toolkit |
| 10-09-2019 13:00 | Bob Pusateri | 24 Hours of PASS (60 minutes) | Big Data and IoT | Dipping Your Toes In: Azure Data Lake for DBAs |
| 10-09-2019 14:00 | Allen White | 24 Hours of PASS (60 minutes) | Database Administration and Development | Do You Know What's In Your Server Inventory? |
| 10-09-2019 15:00 | Kellyn Pot'Vin-Gorman | 24 Hours of PASS (60 minutes) | Database Administration and Development | Scripting for Success on Linux- Top Tips and Tricks |
| 10-09-2019 16:00 | Erin Stellato | 24 Hours of PASS (60 minutes) | Database Administration and Development | Why You Need Query Store |
| 10-09-2019 17:00 | Kathi Kellenberger | 24 Hours of PASS (60 minutes) | Advanced Analytics | Introduction to Azure Machine Learning and Azure AutoML |
| 10-09-2019 18:00 | Grant Fritchey | 24 Hours of PASS (60 minutes) | Database Administration and Development | Extending DevOps To SQL Server |
| 10-09-2019 19:00 | Jonathan Kehayias | 24 Hours of PASS (60 minutes) | Database Administration and Development | Bigger Hardware or Better Code and Design? |
| 10-09-2019 20:00 | Andy Yun | 24 Hours of PASS (60 minutes) | Professional Development | Everyone Has a Story to Tell: Developing Your First Presentation |
| 10-09-2019 21:00 | Reid Havens | 24 Hours of PASS (60 minutes) | Advanced Analytics | Unlocking New Visualizations and Features in Power BI |
| 10-09-2019 22:00 | Jeff Renz, Leslie Weed | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Precursor to Cool Data Warehouses – Where to Start |
| 10-09-2019 23:00 | Vern Rabe | 24 Hours of PASS (60 minutes) | Database Administration and Development | Query Optimization Statistics: Driving Force Behind Performance |
| 11-09-2019 00:00 | Kevin Feasel | 24 Hours of PASS (60 minutes) | Big Data and IoT | Architecting a Big Data Analytics Solution with SQL Server 2019 |
| 11-09-2019 01:00 | Ike Ellis | 24 Hours of PASS (60 minutes) | Database Administration and Development | Azure Databricks is Easier than you Think |
| 11-09-2019 02:00 | Ginger Grant | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Evaluating Cloud Products for Data Warehousing |
| 11-09-2019 03:00 | Melody Zacharias | 24 Hours of PASS (60 minutes) | Advanced Analytics | What Every DBA Needs to Know About AI |
| 11-09-2019 04:00 | Ed Leighton-Dick | 24 Hours of PASS (60 minutes) | Database Administration and Development | Database Privacy and Security for Developers |
| 11-09-2019 05:00 | Jamey Johnston | 24 Hours of PASS (60 minutes) | Advanced Analytics | Code Like a Snake Charmer - Introduction to Python! |
| 11-09-2019 06:00 | Leila Etaati | 24 Hours of PASS (60 minutes) | Advanced Analytics | AI Builder for Automated Form Processing in Power Apps and Flow |
| 11-09-2019 07:00 | Drew Skwiers-Koballa | 24 Hours of PASS (60 minutes) | Application Development | The Open Source Opportunity: How You Can Impact Azure Data Studio |
| 11-09-2019 08:00 | Simon Whiteley | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Practical Azure Databricks: Engineering & Warehousing at Scale |
| 11-09-2019 09:00 | Hamish Watson | 24 Hours of PASS (60 minutes) | Cloud Solutions | How to Deploy SQL Server Containers on Kubernetes in Azure |
| 11-09-2019 10:00 | Denis Reznik | 24 Hours of PASS (60 minutes) | Database Administration and Development | Hidden Gems of SQL Server 2019 |
| 11-09-2019 11:00 | Thomas Grohser | 24 Hours of PASS (60 minutes) | Database Administration and Development | A Glimpse into Datacenter and/or Cloud - When to Use One, the Other, or Both |
Event Date: 10-09-2019 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Dynamic Management views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates, and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.
This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.
Event Date: 10-09-2019 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Big Data and IoT
As a data professional, you know what data is, and hopefully know what a lake is too. But what's a Data Lake? This session covers the very basics of Azure Data Lake, and is geared towards those who are familiar with relational databases and also curious about other technologies. Topics covered will include Data Lake storage, security basics, and an introduction to U-SQL, Azure Data Lake's query language. We will finish up with architecture examples showing real-world use cases highlighting Azure Data Lake's strengths. Attend this session to see how Azure Data Lake can complement your existing relational database skills, and give you a great new tool in your data toolbox!
Event Date: 10-09-2019 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
In this session we'll go through in detail what you need to know, and one good way to build that list, so you can get back up and running much more quickly.
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 10-09-2019 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
This special 24 Hours of PASS session will be a preview of Kellyn’s Linux Scripting session and cover vital basics, important tips and tricks that will get you ahead, many of which won’t be covered in her content at the conference. If you are lucky enough to attend both, the more knowledgeable you’ll be as a Linux and Azure Cloud specialist.
Event Date: 10-09-2019 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 10-09-2019 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
If you want to learn more about Machine Learning and how to take advantage of the services found in Azure, this session is for you!
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 10-09-2019 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 10-09-2019 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Whether you are running SQL Server in the cloud or on-premise, more hardware often becomes the first answer to performance problems. The cost of scaling up in effort is relatively low, especially in the cloud where changing resource sizes is only a drop down option away, but financially this can quickly become a deal breaker. Even the fastest hardware won’t keep up with bad design and coding patterns.
This session will take a look at many of the new features of SQL Server and how they can best be leveraged for performance tuning your workload. From In-Memory OLTP to Columnstore Indexes, Query Store, and Extended Events, this session will guide you in finding the source of the problems, and solutions available to make your workload faster and consistently reliable. We’ll even take a look at different alternatives using older features of SQL Server that you may be leaving on the shelf that are a better fit to solving certain kinds of problems.
Event Date: 10-09-2019 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development
Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?
In this session I will show you how to get started. We will go over how to develop your idea, create session content, and I will share my favorite tips and tricks. You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Event Date: 10-09-2019 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
Attend this session to get a preview of the creative Power BI features Reid will be presenting at PASS Summit 2019.
Event Date: 10-09-2019 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can learn to build a data warehouse solution or hybrid solution that is agile in nature. Discover this highly auditable modeling technique used in international banking, manufacturing, insurance, and many more industries. In the first half of the session, we’ll talk about owning your model. Design changes happen and it can be addressed quickly avoiding pain and project delays, and ultimately keeping your business happy. In the second half of the session, we’ll learn how to leverage Master Data Management and Azure technologies to extend your model for performance, history, and to reference unstructured data. Let us bust the myth of data warehouses taking too long to build and being too hard to modify by adding value to your environment through decreased delivery time. We will look at some platform specific techniques and explore design options for Azure SQL Data Warehouse.
Event Date: 10-09-2019 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important information at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information.
In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and how to read and interpret them. Then, we’ll discuss some of the issues that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), skewed distribution, or downright bad summary information. There’ll be many examples, including using filtered statistics. By applying the techniques we’ll discuss, you WILL see improved query performance.
Event Date: 11-09-2019 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Big Data and IoT
This session is a preview of a full-day pre-con at PASS Summit 2019 where you will learn about the tactics and techniques surrounding Big Data Analytics, particularly on the Microsoft stack. In this session, we will cover the "what" and "why" behind Big Data Analytics, providing an overview of tools and techniques in this space as well as guiding principles for solving data science problems at scale.
Event Date: 11-09-2019 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
If you’re considering Databricks as part of your Azure data strategy, this will be an hour well spent.
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 11-09-2019 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
Data warehousing’s pending demise was exaggerated. In recent years, new products, including Snowflake and Databricks, have spawned providing more options for the modern cloud-based data warehouse. These new products solve different problems, which means the question is now determining which product can provide the best fit in your environment.
Event Date: 11-09-2019 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 11-09-2019 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Oh, look... another data breach. And another. And another. Hardly a day goes by without a mention of one in the media. Thousands were reported last year, and thousands more didn't make the news. Size, industry, location - none of these are a determining factor anymore. We're all at risk, from malicious actors, insiders, even accidents. And more and more, the weaknesses that are being exploited are found not in the operating system, or the browser, or the network, but in the applications we create and manage.
So, developers... what are you going to do about it?
In this one-day session, we're going to discuss a range of topics that developers need to know in order to improve their applications' data security and privacy. We'll cover SQL injection, one of the most common exploits over the last twenty years, in-depth, along with other common vulnerabilities. We'll talk about how to apply permissions and encryption properly in SQL Server to directly protect your data. We'll see how the new class of privacy regulations, including Europe's GDPR and California's CCPA, impact your business - no matter where your company is based. And we'll discuss what you're likely to encounter as your company moves toward a culture of data privacy.
Event Date: 11-09-2019 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
The session will be a brief introduction to the Python language focused on getting you ready for my extended PASS Summit Session in November 2019. This introductory session will cover:
The session will give you the basics to setup a good Python development environment and show how Python is used in the Microsoft stack.
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 11-09-2019 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics
Using Microsoft Flow for Automated Machine Learning Process enhance the usage of AI in application development. In this session, first, the process of how to use pre-built AI tools inside Microsoft Power Platform will be presented. The audience will learn how this automation can be used in the Microsoft Power Apps and Flow. Moreover, a demonstration on how to use Form Processing using AI builder and Microsoft flow to read handwritten forms will be presented. Finally, Audience will learn how to detect the objects and activities in an image using Microsoft Flow, Power Apps and Cognitive Services.
Event Date: 11-09-2019 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application Development
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 11-09-2019 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
This session focuses on Azure DataBricks as your data ingestion, transformation and curation tool of choice.
We will:
The session is aimed at Data Engineers seeking to put the Azure DataBricks technology in the right context and learn how to use the service.
Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.
Event Date: 11-09-2019 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Solutions
When Microsoft released SQL Server 2017, it allowed us to run SQL Server in docker containers. This radical change provides a wider and open platform that data professionals can choose how to deploy and run SQL Server.
This session will demonstrate how containers are a game changer for deploying and managing SQL Server. It will also showcase how the Azure Kubernetes Service (AKS) is a scalable and highly available platform for SQL Server running in containers.
Demonstrations will show how easy it is to create containers, deploy SQL Server in them, and how to automate and manage your SQL Server containers using Kubernetes on the Azure platform.
This session will show you the exciting future of SQL Server and you will walk away with knowledge of practical scenarios where SQL Server running in containers on Kubernetes may be the right deployment model for you.
Event Date: 11-09-2019 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 11-09-2019 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
As with all other items in your toolbox the datacenter (local or in the cloud) needs to be used correctly. This preview of the summit session will show the various types and sizes of workloads, show you how to categorize them, look at the requirements of your SLA (Service Level Agreement), and find the right location (cloud, datacenter, hybrid) for the data.