sqlpasshistory

ID: 1064

Back to Main list

24 Hours of PASS: Summit Preview 2019

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

SessionID: 98282

Dr. DMV's Troubleshooting Toolkit

Back to calendar

Event Date: 10-09-2019 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Glenn Berry

Title: Dr. DMV's Troubleshooting Toolkit

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98279

Dipping Your Toes In: Azure Data Lake for DBAs

Back to calendar

Event Date: 10-09-2019 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Big Data and IoT

Speaker(s): Bob Pusateri

Title: Dipping Your Toes In: Azure Data Lake for DBAs

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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!

SessionID: 98285

Do You Know What's In Your Server Inventory?

Back to calendar

Event Date: 10-09-2019 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Allen White

Title: Do You Know What's In Your Server Inventory?

Description:

Before you encounter an emergency situation, you need to know what exactly exists in the servers you manage. Without that, you can't properly recover when something amiss happens. One of the biggest problems after a ransomware attack is reconstructing what existed before it hit.

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.

SessionID: 98287

Scripting for Success on Linux- Top Tips and Tricks

Back to calendar

Event Date: 10-09-2019 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Kellyn Pot'Vin-Gorman

Title: Scripting for Success on Linux- Top Tips and Tricks

Description:

For most Microsoft professionals, extensive time has been invested in PowerShell and although a viable option on Linux, learning Linux shell scripting, (also referred to as BASH scripting or the CLI in the Azure Portal) can extend automation capabilities in Linux and in the cloud, along with longevity in your career.

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.

SessionID: 98292

Why You Need Query Store

Back to calendar

Event Date: 10-09-2019 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Erin Stellato

Title: Why You Need Query Store

Description:

Whether you run SQL Server in house, in the cloud on a VM, or use Azure SQL Database, Query Store is a tool you can leverage for troubleshooting and monitoring, as well as stabilizing query performance. This session will show you why Query Store is essential, whether you have prior experience with query tuning or not. We'll step through a series of demos based on problems encountered in production environments over the last three years to provide an understanding of what this feature has to offer, and why you'll want to start using it.

Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.

SessionID: 98294

Introduction to Azure Machine Learning and Azure AutoML

Back to calendar

Event Date: 10-09-2019 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics

Speaker(s): Kathi Kellenberger

Title: Introduction to Azure Machine Learning and Azure AutoML

Description:

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.

SessionID: 98295

Extending DevOps To SQL Server

Back to calendar

Event Date: 10-09-2019 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Grant Fritchey

Title: Extending DevOps To SQL Server

Description:

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. In this session Grant explores how you can stay ahead of the competition and discusses what's needed to effectively balance the demand for delivering software faster, while protecting and preserving business critical data.

SessionID: 98297

Bigger Hardware or Better Code and Design?

Back to calendar

Event Date: 10-09-2019 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Jonathan Kehayias

Title: Bigger Hardware or Better Code and Design?

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98298

Everyone Has a Story to Tell: Developing Your First Presentation

Back to calendar

Event Date: 10-09-2019 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development

Speaker(s): Andy Yun

Title: Everyone Has a Story to Tell: Developing Your First Presentation

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98302

Unlocking New Visualizations and Features in Power BI

Back to calendar

Event Date: 10-09-2019 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics

Speaker(s): Reid Havens

Title: Unlocking New Visualizations and Features in Power BI

Description:

Power BI is a great sandbox environment for report design. However, knowing how to leverage visuals and features in a way that adds additional value can be challenging. New visualizations and features can be created a number of ways including: layering visuals, customizing visual formatting, and/or utilizing DAX measures. The session will include a series of visualization and reporting techniques that you'll be able to leverage in your company's reports to take them to the next level.

Attend this session to get a preview of the creative Power BI features Reid will be presenting at PASS Summit 2019.

SessionID: 98300

Precursor to Cool Data Warehouses – Where to Start

Back to calendar

Event Date: 10-09-2019 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Jeff Renz, Leslie Weed

Title: Precursor to Cool Data Warehouses – Where to Start

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98355

Query Optimization Statistics: Driving Force Behind Performance

Back to calendar

Event Date: 10-09-2019 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Vern Rabe

Title: Query Optimization Statistics: Driving Force Behind Performance

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98283

Architecting a Big Data Analytics Solution with SQL Server 2019

Back to calendar

Event Date: 11-09-2019 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Big Data and IoT

Speaker(s): Kevin Feasel

Title: Architecting a Big Data Analytics Solution with SQL Server 2019

Description:

Over the past decade, the dual themes of Big Data and Data Science have stretched out the data platform space in two separate directions: one toward the accumulation of larger, more varied sources of data; and the other toward more and better predictions of future behavior. These two, separate themes are now coming together as the need for better predictions depends on the collection of more and better data.

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.

SessionID: 98310

Azure Databricks is Easier than you Think

Back to calendar

Event Date: 11-09-2019 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Ike Ellis

Title: Azure Databricks is Easier than you Think

Description:

In this 1-hour webinar, we’ll show you how easy it is to create ETL pipelines in Python and pySpark. We’ll spin up a Spark cluster, create a pipeline in a notebook, and talk about why this process is far better than creating pipelines in other frameworks. Migrating to Databricks from SSIS is far easier than you think. We’ll also cover common pitfalls of new Databricks developers.

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.

SessionID: 98286

Evaluating Cloud Products for Data Warehousing

Back to calendar

Event Date: 11-09-2019 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Ginger Grant

Title: Evaluating Cloud Products for Data Warehousing

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98288

What Every DBA Needs to Know About AI

Back to calendar

Event Date: 11-09-2019 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics

Speaker(s): Melody Zacharias

Title: What Every DBA Needs to Know About AI

Description:

Starting with a general overview about the AI ecosystem to help improve communication between the DBA and data scientists. We move on to the understanding of the 5 questions data science answers for us. By exploring the nuances between AI vs. ML, Cognitive Services vs. Data Science, and how they are used, we get a better understanding of how to support your AI team. From server implementations to deployments, we will look at the skills you need to support AI in your organization. This expanding ecosystem is already in our workplace, let's understand how we can leverage it. We will focus on the architecture and key items to be aware of for operationalizing the models your data scientists deliver to you for production using Azure ML Server.

Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.

SessionID: 98289

Database Privacy and Security for Developers

Back to calendar

Event Date: 11-09-2019 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Ed Leighton-Dick

Title: Database Privacy and Security for Developers

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98301

Code Like a Snake Charmer - Introduction to Python!

Back to calendar

Event Date: 11-09-2019 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics

Speaker(s): Jamey Johnston

Title: Code Like a Snake Charmer - Introduction to Python!

Description:

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:

  1. Installing and Configuring a Python environment including using VS Code and the Anaconda Distribution of Python
  2. Installing and Managing Packages
  3. Tour of Python in the Microsoft stack

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.

SessionID: 98290

AI Builder for Automated Form Processing in Power Apps and Flow

Back to calendar

Event Date: 11-09-2019 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics

Speaker(s): Leila Etaati

Title: AI Builder for Automated Form Processing in Power Apps and Flow

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98303

The Open Source Opportunity: How You Can Impact Azure Data Studio

Back to calendar

Event Date: 11-09-2019 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Application Development

Speaker(s): Drew Skwiers-Koballa

Title: The Open Source Opportunity: How You Can Impact Azure Data Studio

Description:

Open source software presents a unique opportunity to shape the future of a product with modes of involvement for any skillset or interest. Azure Data Studio, a cross-platform product with monthly releases, has a steadily growing pool of contributors from across the data platform community. From reporting bugs to submitting source code pull requests, we’ll review the ways anyone can impact the development Azure Data Studio.

Attend this session to get a preview of the topic that will be presented at PASS Summit 2019.

SessionID: 98291

Practical Azure Databricks: Engineering & Warehousing at Scale

Back to calendar

Event Date: 11-09-2019 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Simon Whiteley

Title: Practical Azure Databricks: Engineering & Warehousing at Scale

Description:

Azure DataBricks has a whole lot of buzz around it - but given it's based on Apache Spark, is it just a tool for "Big Data" developers? This blazing fast data processor allows for interactive querying and hosting of ML models all in one place! Most of the buzz is around Data Science & AI - but what about the humble data engineer who wants to harness the in-memory processing power within their ETL pipelines? What can it offer us?

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.

SessionID: 98293

How to Deploy SQL Server Containers on Kubernetes in Azure

Back to calendar

Event Date: 11-09-2019 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Cloud Solutions

Speaker(s): Hamish Watson

Title: How to Deploy SQL Server Containers on Kubernetes in Azure

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.

SessionID: 98305

Hidden Gems of SQL Server 2019

Back to calendar

Event Date: 11-09-2019 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Denis Reznik

Title: Hidden Gems of SQL Server 2019

Description:

This session will be a preview of the topic of the session from PASS Summit 2019, but at the same time, it will extend the story and help to understand why such features are worth to learn. Sometimes they can save some CPU time, and sometimes they can save your project. Of course, I am talking not about well-known "Killer" features of SQL Server 2019, but about those which do not have a lot of visibility now but looks very interesting, and maybe they will become useful to you very soon.

SessionID: 98227

A Glimpse into Datacenter and/or Cloud - When to Use One, the Other, or Both

Back to calendar

Event Date: 11-09-2019 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development

Speaker(s): Thomas Grohser

Title: A Glimpse into Datacenter and/or Cloud - When to Use One, the Other, or Both

Description:

This session will be a preview of the topic of the session from PASS Summit 2019.

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.