sqlpasshistory

ID: 1012

Back to Main list

20 Years of PASS - Past Learnings and Future Visions

Session Date/Time (dd-MM-YYYY 24h) Speaker Category Track Title
03-04-2019 18:00 Devin Knight 24 Hours of PASS (60 minutes) Business Intelligence and Data Warehousing Power BI Streaming Datasets with Microsoft Flow
03-04-2019 19:00 Pam Lahoud, Pedro Lopes 24 Hours of PASS (60 minutes) Database Administration and Development Modernizing SQL Server the Right Way
03-04-2019 20:00 Taiob Ali 24 Hours of PASS (60 minutes) Database Administration and Development Performance Optimization with Azure SQL Database
03-04-2019 21:00 Alessandro Goncalves, Eman Yarlagadda 24 Hours of PASS (60 minutes) Database Administration and Development Deep Dive into Optane Storage and Memory Technology
03-04-2019 22:00 Erin Ostrowsky 24 Hours of PASS (60 minutes) Business Intelligence and Data Warehousing Intro to Data Storytelling with Power BI
03-04-2019 23:00 Rick Heiges 24 Hours of PASS (60 minutes) Database Administration and Development Constant Change and Community
04-04-2019 00:00 Paresh Motiwala 24 Hours of PASS (60 minutes) Professional Development How to Get and Nail Your Interviews
04-04-2019 01:00 Allen White 24 Hours of PASS (60 minutes) Professional Development Prepare for Change, Because It's Coming
04-04-2019 02:00 Melody Zacharias 24 Hours of PASS (60 minutes) Advanced Analytics Not Your Grand Mother's AI
04-04-2019 03:00 Rob Farley 24 Hours of PASS (60 minutes) Database Administration and Development Indexes - Are Things That Different to Twenty Years Ago?
04-04-2019 04:00 Hasham Niaz 24 Hours of PASS (60 minutes) Advanced Analytics Dashboard Designing – From 0 to Hero
04-04-2019 05:00 Anupama Natarajan 24 Hours of PASS (60 minutes) Advanced Analytics Introduction to Cognitive Search
04-04-2019 06:00 Reza Rad 24 Hours of PASS (60 minutes) Business Intelligence and Data Warehousing Power BI for Enterprises; Robust, Reliable, and Scalable Solution
04-04-2019 07:00 Jose Manuel Jurado Diaz 24 Hours of PASS (60 minutes) Application Development Azure SQL Database - Lessons learned from the trenches
04-04-2019 08:00 Markus Ehrenmueller-Jensen 24 Hours of PASS (60 minutes) Advanced Analytics From Power BI to Power AI – Enrich your Business Intelligence
04-04-2019 09:00 Sriharsh Adari 24 Hours of PASS (60 minutes) Business Intelligence and Data Warehousing Modernize Data Platform - A Detailed Case Study
04-04-2019 10:00 Carlos Robles 24 Hours of PASS (60 minutes) Database Administration and Development Exploring SQL Server containers on Docker & Kubernetes
04-04-2019 11:00 Raj Pochiraju, Pedro Lopes 24 Hours of PASS (60 minutes) Cloud Solutions Transforming your Data Estate - Beating the End of Support for SQL Server 2008/R2
04-04-2019 12:00 Andy Leonard 24 Hours of PASS (60 minutes) Business Intelligence and Data Warehousing Faster SSIS
04-04-2019 13:00 Cathrine Wilhelmsen 24 Hours of PASS (60 minutes) Business Intelligence and Data Warehousing Pipelines and Packages: Introduction to Azure Data Factory
04-04-2019 14:00 Allan Hirt 24 Hours of PASS (60 minutes) Database Administration and Development A Look Into the Past and the Future of Availability and Infrastructure for SQL Server Deployments
04-04-2019 15:00 Lord Richard Douglas, Kevin Kline 24 Hours of PASS (60 minutes) Database Administration and Development Baselining and Alerting for Microsoft SQL Server
04-04-2019 16:00 Gail Shaw 24 Hours of PASS (60 minutes) Database Administration and Development The Real Self-Tuning Database
04-04-2019 17:00 Paresh Motiwala 24 Hours of PASS (60 minutes) Cloud Solutions My Company is Going to Azure, What Can I do?

SessionID: 91091

Power BI Streaming Datasets with Microsoft Flow

Back to calendar

Event Date: 03-04-2019 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Devin Knight

Title: Power BI Streaming Datasets with Microsoft Flow

Description:

Come explore the joy of creating streaming datasets in Power BI using Microsoft Flow to orchestrate the movement of data from varies sources into Power BI directly. We will also explore other ways to enhance the capabilities of Power BI like using Azure Cognitive Services to determine sentiment analysis of incoming data.

SessionID: 91363

Modernizing SQL Server the Right Way

Back to calendar

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

Speaker(s): Pam Lahoud, Pedro Lopes

Title: Modernizing SQL Server the Right Way

Description:

Migrations should be approached with the same rigor and processes as a full software or hardware project –a solid methodology is required for success. Microsoft provides you with all the tools you need to achieve a seamless, reliable upgrade experience. In this session we will review some of the free tools that Microsoft provides in order to ensure your SQL Server upgrade is a success.

We will also discuss the merits and caveats of following a database compatibility-based upgrade along with the tools Microsoft is building to ensure customers have a smoother upgrade and migration experience.

After this session, you will be able to: • Position Database Compatibility as a real alternative to support complex modernization projects as critical moments like 2008 End-of-Life. • Leverage Microsoft SQL Server features and tools to support a DB Compat based upgrade or migration.

SessionID: 90897

Performance Optimization with Azure SQL Database

Back to calendar

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

Speaker(s): Taiob Ali

Title: Performance Optimization with Azure SQL Database

Description:

The cloud is just using someone else's compute. You still need to care about and optimize for performance.  Just as a dropped call frustrates cellular customers, an app with data issues, high latency, connection timeouts will create the same frustration for users.  Do you want to catch the performance issues before your customers?  Do you want to automatically identify database issues and quickly drill down into details? Azure provides built in tools just to do that.

In this session I will show you 4 of those tools.  You will learn how these tools can provide Performance overview of a database and recommendations that can improve workload performance.  Find top resource consuming queries, deeper insight into your databases resource (DTU) consumption and learn when to let Azure  automatically optimize your database.   At the end of this session you will walk out knowing how to identify and tune Azure SQL database performance  issues with built in tools in Azure Portal.

SessionID: 91451

Deep Dive into Optane Storage and Memory Technology

Back to calendar

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

Speaker(s): Alessandro Goncalves, Eman Yarlagadda

Title: Deep Dive into Optane Storage and Memory Technology

Description:

With hardware technology advancements the number of design choices also increase. On-premises deployments are still relevant in today’s cloud dominated news cycle. With different Storage and Memory technologies available it is key to understand their usage. Intel Optane technology introduces a revolutionary approach to data storage. Optane unique properties enables different form factors and usages. Can all Optane modes be of benefit for database design? What’s Persistent Memory and how can I use it? This presentation will walk you through the Optane technology and build a server reference design with INTEL Optane technology.

SessionID: 91432

Intro to Data Storytelling with Power BI

Back to calendar

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

Speaker(s): Erin Ostrowsky

Title: Intro to Data Storytelling with Power BI

Description:

Learn some fun and effective ways to turn your Power BI report into a more compelling digital narrative by leveraging Power BI’s storytelling capabilities. Features like bookmarks, tooltip report pages, and interactive popups are just a few examples of how you can turn dull reports into a more dynamic experience. This session introduces some of those Fundamental design patterns.

SessionID: 91452

Constant Change and Community

Back to calendar

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

Speaker(s): Rick Heiges

Title: Constant Change and Community

Description:

20 years ago, the community had a different focus on what topics were hot. 20 years ago, most of us had monitors that required 2 people to lift off of our desks. 20 years ago, we were focused on the Y2K bug. And 20 years ago, the PASS community was in its infancy. Today, our challenges, technology, and hot topics may be different, but the idea that community can be a real asset to your career is still as strong. In this session, we will hit recall some of the big challenges that we faced from a technical point of view and how the community has also adapted to the changes. We will also gaze into the crystal ball and see where technology may be heading and ways that the community can help you thrive in your career.

SessionID: 91644

How to Get and Nail Your Interviews

Back to calendar

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

Speaker(s): Paresh Motiwala

Title: How to Get and Nail Your Interviews

Description:

Have you been stuck in your existing job for years? Do you feel you need to get out, try either a new company, a new role or even a new boss? Then this very entertaining, informative and highly interactive session is perfect for you. I assure you that you'll walk out of it totally reassured and enlightened.

In this session I'll share personal and some real-life stories. You’ll learn techniques for finding new opportunities in a competitive job market. I’ll also share how to exploit the social media to your advantage (they are not bad if used judiciously).

What can you do once you get that rare and elusive interview? There are several things we need to take care of like, overall appearance, food habits, arrival, sitting posture, small talk or ice-breakers and humor. The most important parts of the limited interviewing opportunities are closing and follow up. I’ll share my own experience and notes from the field. You will also learn the importance of interview logs.

Never stop looking!

SessionID: 91426

Prepare for Change, Because It's Coming

Back to calendar

Event Date: 04-04-2019 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Professional Development

Speaker(s): Allen White

Title: Prepare for Change, Because It's Coming

Description:

Technology is changing. That is the one constant in this world, yet it catches so many people off guard. You, not your employer, are responsible for making sure that you have the skills to not only stay relevant, but to help manage the change. In my 45 years in Information Technology I've had to retrain myself on new technology on average every five years. That pace is quickening. This session will provide a retrospective of those 45 years, and help you find ways to drive your career forward, and stay on top of the change.

SessionID: 91453

Not Your Grand Mother's AI

Back to calendar

Event Date: 04-04-2019 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics

Speaker(s): Melody Zacharias

Title: Not Your Grand Mother's AI

Description:

What was AI in the past, what is it now and where will the future take us? Data Science, Azure Machine Learning, and Analytics are all becoming core pieces of a many successful businesses. What are people doing with it and how can it be used in all aspects of business. As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients. Using an easy to follow example, I will show the flow from problem to solution. A demonstration of AI used in the real world.

SessionID: 91454

Indexes - Are Things That Different to Twenty Years Ago?

Back to calendar

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

Speaker(s): Rob Farley

Title: Indexes - Are Things That Different to Twenty Years Ago?

Description:

Indexes have been a major backbone of performance tuning since before computers existed. But that doesn’t mean that your approach to indexing won’t have changed in the past twenty years. In this session, Rob Farley will explore some of his favorite indexing features, and which things he considers to have been the most significant game-changers.

SessionID: 91266

Dashboard Designing – From 0 to Hero

Back to calendar

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

Speaker(s): Hasham Niaz

Title: Dashboard Designing – From 0 to Hero

Description:

We will be using Power BI to design a Dashboard over financial data, this Dashboard will help management analyze Sales pattern with the help of different visuals.. You will learn how you can turn raw data into actionable insights using Power BI.

SessionID: 91191

Introduction to Cognitive Search

Back to calendar

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

Speaker(s): Anupama Natarajan

Description:

Real World data is messy and gaining knowledge from those data is not easy. Cognitive Search is an AI feature in Azure Search, used to extract text from images, blobs, and other unstructured data sources. It enriches the content to make it more searchable. Extraction and enrichment are implemented through cognitive skills like Natural Language Processing, Image Processing etc. The typical solution pattern for Cognitive Search is a data ingestion, enrichment and exploration model. Come and learn how to use Cognitive Search in real world scenarios.

SessionID: 91455

Power BI for Enterprises; Robust, Reliable, and Scalable Solution

Back to calendar

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

Speaker(s): Reza Rad

Title: Power BI for Enterprises; Robust, Reliable, and Scalable Solution

Description:

Power BI is not just a self-service tool for business analysts; It is a tool for enterprises to surface the data through powerful visualizations and analytics features in this product. In this session, you will learn deep dive techniques about features that are essentials elements of a robust, reliable, and scalable solution in Power BI. You will learn how Aggregations, Incremental Load, Composite Model, XMLA endpoint, Dataflows, and some external tools can help in building an enterprise Power BI solution. The session is full of demos of working with these features.

SessionID: 91018

Azure SQL Database - Lessons learned from the trenches

Back to calendar

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

Speaker(s): Jose Manuel Jurado Diaz

Title: Azure SQL Database - Lessons learned from the trenches

Description:

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.

SessionID: 90639

From Power BI to Power AI – Enrich your Business Intelligence

Back to calendar

Event Date: 04-04-2019 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Advanced Analytics

Speaker(s): Markus Ehrenmueller-Jensen

Title: From Power BI to Power AI – Enrich your Business Intelligence

Description:

AI is everywhere – and now even included in Power BI. Sometimes AI might be very apparent when you enrich your data with predictions by explicitly calling an Azure Machine Learning web service in Power Query. Sometimes it might by hidden in a nice little context menu when Power BI is auto-magically explaining the reason of a difference or a change over time in your data to you.

No matter if you are a business user, analyst or data scientist – Power BI has AI capabilities tailored to you. In this session we will cover how you can integrate and leverage the use of language R, how to integrate an Azure Machine Learning Service when loading data, what kind of insights Power BI is capable of delivering automatically, how you can create a complex new column without typing a single formula/function, how you can explore your data by asking questions in plain English, ... and more!

Sounds like a lot of content? I omitted most of the slides in favor to spend the time in live demos instead.

SessionID: 91143

Modernize Data Platform - A Detailed Case Study

Back to calendar

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

Speaker(s): Sriharsh Adari

Title: Modernize Data Platform - A Detailed Case Study

Description:

SessionID: 90638

Exploring SQL Server containers on Docker & Kubernetes

Back to calendar

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

Speaker(s): Carlos Robles

Title: Exploring SQL Server containers on Docker & Kubernetes

Description:

In this session we will explore the options we have when working with SQL Server running on Docker containers or Kubernetes. Also, will take a look at some real world scenarios of backing up \ restoring databases in containers, high availability, version upgrades and the most important portability. Join me to discuss further about this interesting topic that is called by some experts as "The Future of Database Infrastructure".

SessionID: 91327

Transforming your Data Estate - Beating the End of Support for SQL Server 2008/R2

Back to calendar

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

Speaker(s): Raj Pochiraju, Pedro Lopes

Title: Transforming your Data Estate - Beating the End of Support for SQL Server 2008/R2

Description:

SessionID: 91101

Faster SSIS

Back to calendar

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

Speaker(s): Andy Leonard

Title: Faster SSIS

Description:

Ever wonder why SSIS runs so slowly? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data, and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.

SessionID: 91456

Pipelines and Packages: Introduction to Azure Data Factory

Back to calendar

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

Speaker(s): Cathrine Wilhelmsen

Title: Pipelines and Packages: Introduction to Azure Data Factory

Description:

As Data Engineers and ETL Developers, our main responsibility is to move, transform, and integrate data for end users as efficiently as possible. With the ever-increasing volume and variety of data, this can feel like a daunting task. Azure Data Factory (ADF) is a hybrid data integration service that lets you build complex and scalable data pipelines - without writing any code.

But wait! You have already invested years and millions in a comprehensive SSIS solution? No problem! You can lift and shift existing packages into Azure Data Factory to modernize your solution while retaining investments already made.

In this session, we will go through the fundamentals of Azure Data Factory and see how easy it is to build new data pipelines or migrate existing SSIS packages. Then, we will explore some major improvements in Azure Data Factory v2, including the new Mapping Data Flows. Finally, we will look at best practices for development to speed up productivity and keeping costs down.

SessionID: 91362

A Look Into the Past and the Future of Availability and Infrastructure for SQL Server Deployments

Back to calendar

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

Speaker(s): Allan Hirt

Title: A Look Into the Past and the Future of Availability and Infrastructure for SQL Server Deployments

Description:

A lot has changed in 20 years when it comes to both how to make SQL Server available as well as the underlying infrastructure used for deployments … or has it? What can clues about our past predict about the future? Are FCIs obsolete? How have advancements in storage altered the rules of engagement? What does the public cloud mean for SQL Server? These and other topics will pass through mission critical expert Allan Hirt’s history machine and crystal ball to discuss where we were, where we are, and where we might be headed.

SessionID: 91361

Baselining and Alerting for Microsoft SQL Server

Back to calendar

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

Speaker(s): Lord Richard Douglas, Kevin Kline

Title: Baselining and Alerting for Microsoft SQL Server

Description:

Ensuring peak performance on an instance of Microsoft SQL Server is not easy and requires a lot of work on the part of the DBA. Experienced DBAs know that to maintain the best possible performance, you need to make sure you are monitoring the right performance metrics on a regular basis. Using those metrics, you can determine what normal performance looks like under most workloads. After all, when troubleshooting, how can you tell what is abnormal performance if you don’t know what is normal? But how do you know what performance information to track and how to interpret it? Baseline comparisons can help.

This session describes techniques and procedures to monitor important performance metrics you can use to define as a baseline for “normal” performance. From there, we will show you how to use these baseline metrics to identify and alert on abnormal circumstances. In addition to the main objectives, this session will help you:

• Learn about the major metrics that quantitatively define the performance baseline for an instance of SQL Server • Learn how to collect baselines and, on a live SQL Server, compare and alert when performance metrics are outside of normal • How to best utilize your newly freed time once you start to utilize baselines as a regular part of your workday

Baselining is a skill that separates junior DBAs from senior DBAs. Take the leap to learn this important skill today!

SessionID: 91457

The Real Self-Tuning Database

Back to calendar

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

Speaker(s): Gail Shaw

Title: The Real Self-Tuning Database

Description:

Back 20-odd years ago, Microsoft’s marketing team advertised SQL Server as a ‘self-tuning database’. It wasn’t. Fast forward a few years, and we now have database engines that are, in some circumstances, are self-tuning.

In this presentation, we’re going to look at the self-tuning aspects of SQL Server 2019, specifically the adaptive query processing features and Query Store’s automatic plan regression fixes.

SessionID: 91193

My Company is Going to Azure, What Can I do?

Back to calendar

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

Speaker(s): Paresh Motiwala

Title: My Company is Going to Azure, What Can I do?

Description:

Lets take a close look at the world of Azure.

You possibly know of the "Plane Effect". It means that your CIO or CTO possibly picked up the phrase "Cloud" in a tech magazine on one of his/her expensive trips to wherever. Now the whole company is running around it.

In this session we'll cover what points should you consider before going to Azure. Here's a short list:

  1. Learn about your current footprint
  2. Learn what to move
  3. Learn how to move
  4. Gather knowledge on Azure topics
  5. Research a backup cloud provider!

Should you even really care or just look for another job?

We will learn how simple to use is the Azure portal. We will make a couple of VMs, Databases along the way.