sqlpasshistory

ID: 952

Back to Main list

PASS Summit 2019

Session Date/Time (dd-MM-YYYY 24h) Speaker Category Track Title
04-11-2019 08:30 Rob Sewell Pre-Conference Session (Full Day) Database Administration SQL Server Administration Made Easy with dbatools  
04-11-2019 08:30 Bob Ward Pre-Conference Session (Full Day) Database Administration The SQL Server 2019 Workshop
04-11-2019 08:30 Ed Leighton-Dick Pre-Conference Session (Full Day) Security Database Privacy and Security for Developers
04-11-2019 08:30 Kendra Little, Steve Jones, Grant Fritchey, Ike Ellis, Hamish Watson Pre-Conference Session (Full Day) DevOps Redgate SQL in the City Summit Seattle
04-11-2019 08:30 Erin Stellato Pre-Conference Session (Full Day) Database Administration Performance Tuning With Query Store in SQL Server
04-11-2019 08:30 Natasha Balac Pre-Conference Session (Full Day) Advanced Analytics Data Science in a Day: Preparation, Patterns, and Predictions
04-11-2019 08:30 Itzik Ben-Gan Pre-Conference Session (Full Day) Database Administration Mastering T-SQL Querying Fundamentals
04-11-2019 08:30 David Klee Pre-Conference Session (Full Day) Database Administration Advanced Virtual SQL Server Performance 
04-11-2019 08:30 Kevin Feasel Pre-Conference Session (Full Day) Big Data Architecting a Big Data Analytics Solution with SQL Server 2019
04-11-2019 08:30 Leila Etaati Pre-Conference Session (Full Day) Advanced Analytics AI and Power BI: The Realm of the Impossible
04-11-2019 08:30 Edwin M Sarmiento Pre-Conference Session (Full Day) Database Administration The SQL Server DBA’s Guide to Docker Containers
05-11-2019 08:30 Bob Ward Pre-Conference Session (Full Day) Database Administration The SQL Server 2019 Workshop
05-11-2019 08:30 Terry McCann, Simon Whiteley Pre-Conference Session (Full Day) Business Intelligence and Data Warehousing Practical Azure Databricks: Engineering & Warehousing at Scale
05-11-2019 08:30 Jonathan Stewart Pre-Conference Session (Full Day) Advanced Analytics An Introduction to Data Driven Storytelling: Data Visualization for all!
05-11-2019 08:30 Jonathan Kehayias Pre-Conference Session (Full Day) Database Administration Bigger Hardware or Better Code and Design?
05-11-2019 08:30 Kendra Little, Steve Jones Pre-Conference Session (Full Day) Database Administration How to Architect Successful Database Changes: Source Control and Release Patterns for Performance and Availability
05-11-2019 08:30 Ike Ellis Pre-Conference Session (Full Day) Development Move a Successful Legacy On-Premise OLTP SQL Server Database to Azure
05-11-2019 08:30 Tim Corey Pre-Conference Session (Full Day) Development How to Build 5 Azure-Powered Apps to Automate Your Job
05-11-2019 08:30 Monica Rathbun Pre-Conference Session (Full Day) Database Administration SQL Server Performance Tuning and Optimization
05-11-2019 08:30 Alberto Ferrari Pre-Conference Session (Full Day) Business Intelligence and Data Warehousing From 0 to DAX
05-11-2019 08:30 Davide Mauri, Andreas Wolter, Sanjay Mishra, Rohit Nayak, Denzil Ribeiro, Rie Irish, Jovan Popovic, Mladen Andzic, Shreya Verma, Dimitri Furman Pre-Conference Session (Full Day) Data Platform Strategy Modernizing your Database with Azure SQL
06-11-2019 00:00 LaShana Lewis Luncheon (105 minutes) Professional Development (Other) WOMEN IN TECHNOLOGY LUNCHEON: LaShana Lewis - Data-Driven Diversity: Using Your Skills to Make a Difference
06-11-2019 00:00 Kevin Kline Marketing Community Session (45 minutes) Professional Development (Other) Introduction to PASS Summit 2019
06-11-2019 00:00 To be Announced PASS Event (90 minutes) Professional Development (Other) Exhibitor Reception
06-11-2019 00:00 David Pless, Dandy Weyn Vendor Professional Development (Other) Microsoft Certification Preparation Session - Thursday
06-11-2019 00:00 Rohan Kumar Keynote (90 minutes) Database Administration KEYNOTE: Rohan Kumar, Microsoft (Microsoft Azure Keynote Room)
06-11-2019 00:00 To be Announced PASS Event (90 minutes) Professional Development (Other) Welcome Reception
06-11-2019 00:00 Tarah Wheeler Keynote (90 minutes) Security KEYNOTE: Tarah Wheeler - Cybersecurity is Everyone’s Problem (Microsoft Azure Keynote Room)
06-11-2019 00:00 David Pless, Dandy Weyn Vendor Professional Development (Other) Microsoft Certification Preparation Session - Wednesday
06-11-2019 00:00 David Pless, Dandy Weyn Vendor Professional Development (Other) Microsoft Certification Preparation Session - Friday
06-11-2019 00:00 To be Announced General Session (75 minutes) Professional Development (Other) First-Timer Event
06-11-2019 10:15 Jes Schultz General Session (75 minutes) Professional Development (Other) Roles and Responsibilities of the Azure Data Engineer
06-11-2019 10:15 Eric Peterson General Session (75 minutes) Big Data SQL and MongoDB: When Two Worlds Collide
06-11-2019 10:15 David Maxwell General Session (75 minutes) Database Administration Performance Tuning Azure SQL Databases
06-11-2019 10:15 Allen White General Session (75 minutes) Database Administration Emergency! Are You Ready for Disaster to Strike?
06-11-2019 10:15 Heidi Hasting General Session (75 minutes) Data Governance/Privacy MDS from the Ground Up - Let your Users Maintain their Data?
06-11-2019 10:15 Denise McInerney, Kellyn Pot'Vin-Gorman General Session (75 minutes) Professional Development (Other) Becoming a Technical Leader
06-11-2019 10:15 Kendra Little Partner Session (75 minutes) DevOps Why the Database is at the Heart of DevOps Success
06-11-2019 10:15 Vicky Harp, Udeesha Gautam Microsoft Session (75 minutes) Database Administration What’s new in SQL Server Tools
06-11-2019 10:15 Kenneth Fisher General Session (75 minutes) Security SQL Server Security from the Ground Up
06-11-2019 10:15 Ginger Grant General Session (75 minutes) Advanced Analytics Hidden Differences Between Azure ML Products Revealed
06-11-2019 10:15 John Morehouse General Session (75 minutes) Cloud Solutions Journey to the Cloud: Planning the First Steps
06-11-2019 10:15 Rob Collie General Session (75 minutes) Database Administration SQL Isn’t for Analysis: Why Everyone Needs OLAP Data Models
06-11-2019 10:45 Kevin McGinley Partner Session (75 minutes) Business Intelligence and Data Warehousing How to Analyze JSON with SQL
06-11-2019 10:45 Bob Ward, Anna Hoffman Microsoft Session (75 minutes) Database Administration SQL Server and Azure Data: What to Use When
06-11-2019 10:45 Andy Leonard, Elizabeth Baron, Sreeja Pullagura General Session (75 minutes) DevOps SSIS DevOps and Azure Containers
06-11-2019 10:45 Andrea Martorana Tusa General Session (75 minutes) Advanced Analytics Failure Prediction for Manufacturing Industry with SQL Server & R
06-11-2019 10:45 Andy Yun General Session (75 minutes) Professional Development (Other) Everyone Has a Story to Tell: Developing Your First Presentation
06-11-2019 10:45 Janis Griffin Partner Session (75 minutes) Development Do You Feel The Need … The Need for Speed? Top Five SQL Server Query Tuning Tips
06-11-2019 10:45 Anthony Nocentino General Session (75 minutes) Cloud Solutions Inside Kubernetes - An Architectural Deep Dive
06-11-2019 12:30 Kevin Kline Marketing Community Session (45 minutes) Professional Development (Other) Introduction to PASS Summit 2019
06-11-2019 13:30 Ben Weissman General Session (75 minutes) Big Data Introducing SQL Server 2019 Big Data Clusters
06-11-2019 13:30 Prathy Kamasani General Session (75 minutes) Business Intelligence and Data Warehousing An Introduction to Data Visualizations and Design Best Practices
06-11-2019 13:30 Thomas Norman General Session (75 minutes) Data Governance/Privacy Encrypting Data Within SQL Server
06-11-2019 13:30 Grant Fritchey General Session (75 minutes) Development SQL Injection: What Is It, Prevent It, Monitor For It!
06-11-2019 13:30 Aaron Nelson General Session (75 minutes) Development SQL PowerShell 2019: The Lingua Franca for the Data Platform
06-11-2019 13:30 Kevin Kline General Session (75 minutes) Professional Development (Other) Successfully Communicating with Peers and Colleagues
06-11-2019 13:30 Danny Ravid General Session (75 minutes) Security TDE, Encryption, and Compliance With Azure Key Vault Zero To Hero
06-11-2019 13:30 Melody Zacharias General Session (75 minutes) Artificial Intelligence An Introduction to AI for Everyone
06-11-2019 13:30 Patrick LeBlanc, Amir Netz, Will Thompson Microsoft Session (75 minutes) Business Intelligence and Data Warehousing Microsoft Power BI: Business Intelligence Strategy, Vision, and Roadmap Update
06-11-2019 13:30 John Maxwell, Chuck Priddy Partner Session (75 minutes) Database Administration SQL Server Performance Analysis Powered by Machine Learning
06-11-2019 13:30 Erland Sommarskog General Session (75 minutes) Security Packaging Permissions in Stored Procedures
06-11-2019 13:30 Rob Collie General Session (75 minutes) Big Data Modern Excel: The Supercomputer Hiding on Everyone’s Desktop
06-11-2019 13:30 Pam Lahoud Microsoft Session (75 minutes) Database Administration Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations
06-11-2019 13:30 JP Chen Partner Session (75 minutes) Database Administration SQL on Linux
06-11-2019 13:30 Jim Dorame General Session (75 minutes) Development Cosmos DB Develop Locally Deploy Globally
06-11-2019 13:30 Chris Woodruff General Session (75 minutes) Database Administration Removing the SELECT *: Helping your App Developers and Yourself
06-11-2019 13:30 Brian Kelley General Session (75 minutes) Security How I Would Attack SQL Server
06-11-2019 13:30 Kathi Kellenberger General Session (75 minutes) Professional Development (Other) Build Your Brand with Technical Writing
06-11-2019 13:30 Bob Ward Microsoft Session (75 minutes) Database Administration SQL Server 2019: Your Next Modern Data Platform
06-11-2019 15:15 Gabi Münster, Thomas Martens General Session (75 minutes) Business Intelligence and Data Warehousing Aggregations in Power BI
06-11-2019 15:15 Adam Jorgensen Half-Day Session (2.5 hours) Professional Development (Other) Creating Success as a Data Entrepreneur
06-11-2019 15:15 Tim Mitchell General Session (75 minutes) Business Intelligence and Data Warehousing Head to Head: SSIS Versus Azure Data Factory
06-11-2019 15:15 Dustin Vannoy General Session (75 minutes) Business Intelligence and Data Warehousing Azure Storage Options for Analytics
06-11-2019 15:15 Glenn Berry Half-Day Session (2.5 hours) Database Administration Dr. DMV's Troubleshooting Toolkit
06-11-2019 15:15 Erin Stellato General Session (75 minutes) Development Understanding Execution Plans
06-11-2019 15:15 Martin Wild, Peter O'Connell, Denis O’Sullivan Partner Session (75 minutes) Database Administration Azure SQL Database Managed Instances: A Beginner’s Guide – the Pros, the Cons, and the Gotchas
06-11-2019 15:15 Bob Ward, Sridharan Sakthivelu Partner Session (75 minutes) Database Administration A Deep Dive into Persistent Memory Features in SQL Server 2019
06-11-2019 15:15 Leo Li Microsoft Session (75 minutes) Cloud Solutions Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory and Azure SQL Database Managed Instance
06-11-2019 15:15 Jeff Renz, Leslie Weed Half-Day Session (2.5 hours) Business Intelligence and Data Warehousing Innovative Data Modeling for Cool Data Warehouses
06-11-2019 15:15 Ben Miller General Session (75 minutes) Development Everything You Wanted to Know About Implementing Temporal Tables
06-11-2019 15:15 Carlos Robles General Session (75 minutes) Cloud Solutions Working with SQL Server Containers to Build Database Solutions
06-11-2019 15:15 Andrea Martorana Tusa General Session (75 minutes) Advanced Analytics Spatial Analysis with SQL Server, R and Power BI
06-11-2019 15:15 Thomas Grohser General Session (75 minutes) Business Intelligence and Data Warehousing Scaling Clustered Column Store Indexes
06-11-2019 15:15 Anna Hoffman General Session (75 minutes) Artificial Intelligence A Behind the Scenes Look at ML, AI, and Deep Learning
06-11-2019 15:15 Eddie Wuerch General Session (75 minutes) Database Administration Never Lose Data: Digging Out From Corruption
06-11-2019 15:15 Rob Sewell General Session (75 minutes) Database Administration SQL Notebooks in Azure Data Studio for the DBA
06-11-2019 15:15 Johan Ludvig Brattås, Rune Ovlien Rakeie General Session (75 minutes) Cloud Solutions Choosing your Cloud: Step 2 in your Cloud Migration Journey
06-11-2019 15:15 Hamish Watson General Session (75 minutes) Database Administration Linux Fundamentals for SQL Server DBAs
06-11-2019 16:45 Bert Wagner General Session (75 minutes) Development I Want To Go Faster! An Introduction to Indexing
06-11-2019 16:45 Patrick LeBlanc, Ginger Grant, Warren Sifre, Jonathan Stewart, Reid Havens General Session (75 minutes) Advanced Analytics The Emerging Role of BI in your Organization
06-11-2019 16:45 Denny Cherry, Erin Stellato, Bob Ward, Mike Flasko, Asad Khan, Rie Irish, Slava Oks, Arun Ulagaratchagan Microsoft Session (75 minutes) Database Administration Microsoft Data Engineering Unplugged
06-11-2019 16:45 Markus Ehrenmueller-Jensen General Session (75 minutes) Development A Game of Hierarchies: Graph Processing with SQL Server 2019
06-11-2019 16:45 Kevin Feasel General Session (75 minutes) Advanced Analytics SQL Server Machine Learning Services in Production
06-11-2019 16:45 Joe Sack, Pedro Lopes Microsoft Session (75 minutes) Development SQL Server and Azure SQL Database Intelligent Query Performance
06-11-2019 16:45 MIKE DONNELLY General Session (75 minutes) Cloud Solutions Cosmic DBA - Cosmos DB for SQL Server Admins and Developers
06-11-2019 16:45 Natasha Balac General Session (75 minutes) Advanced Analytics From Data Munging to Wrangling - 7 Steps to Mastering Data Preparation for Data Science
06-11-2019 16:45 Shawn Meyers, Rob Girard Partner Session (75 minutes) DevOps A new Breed of Storage for SQL Server – Level up your DevOps!
06-11-2019 16:45 Denis Reznik General Session (75 minutes) Database Administration Hidden Gems of SQL Server 2019
06-11-2019 16:45 Brian Larson General Session (75 minutes) Business Intelligence and Data Warehousing Handling Role Playing Dimensions in Tabular Models
06-11-2019 16:45 John Martin General Session (75 minutes) Data Platform Strategy Managing your Data Platform Lifecycle
06-11-2019 16:45 Vern Rabe General Session (75 minutes) Database Administration Query Optimization Statistics: Driving Force Behind Performance
06-11-2019 16:45 Christopher Unwin General Session (75 minutes) Data Governance/Privacy Protect your Data by Design: Creating a Data Masking Strategy
06-11-2019 16:45 Jonathan Dahlberg General Session (75 minutes) Artificial Intelligence Data for Good: Using Machine Learning to Improve Water Access in Developing Nations
06-11-2019 16:45 Hamish Watson General Session (75 minutes) Professional Development (Other) SPEAKER IDOL - ROUND 1
07-11-2019 10:15 Tejas Shah Microsoft Session (75 minutes) Database Administration Choice with Compatibility: SQL Server 2019 on Linux and Containers
07-11-2019 10:15 Amit Banerjee Microsoft Session (75 minutes) Cloud Solutions Azure SQL Database Edge: Overview
07-11-2019 10:15 Alberto Ferrari General Session (75 minutes) Business Intelligence and Data Warehousing Improve Your Power BI Reports with DAX
07-11-2019 10:15 Grant Fritchey General Session (75 minutes) Data Governance/Privacy Data Classification: Taking Your First Step on the Road to Agile Data Governance
07-11-2019 10:15 Doug Bernhardt Partner Session (75 minutes) Big Data Deploying SQL Server 2019 Big Data Clusters on VMware
07-11-2019 10:15 Anupama Natarajan General Session (75 minutes) Artificial Intelligence AI for Developers
07-11-2019 10:15 Hiram Fleitas General Session (75 minutes) Development The Power Platform Game Changer
07-11-2019 10:15 Richard Waymire Partner Session (75 minutes) Cloud Solutions Migrating SQL Server Workloads to Amazon Web Services (AWS)
07-11-2019 10:15 James Rowland-Jones Microsoft Session (75 minutes) Database Administration Enabling End to End Scenarios with Data Virtualization in SQL Server 2019
07-11-2019 10:15 Sanil Mhatre General Session (75 minutes) Advanced Analytics Text Mining & Sentiment Analysis made easy
07-11-2019 10:15 Hamish Watson General Session (75 minutes) Cloud Solutions How to Deploy SQL Server Containers on Kubernetes in Azure
07-11-2019 10:15 Ray Maor Partner Session (75 minutes) Database Administration Create the Perfect Multi-Column Index for Your Query
07-11-2019 10:45 Jack Corbett General Session (75 minutes) Database Administration dbatools - A PowerShell Toolkit for the DBA
07-11-2019 10:45 Jonathan Kehayias General Session (75 minutes) Development Eliminating Anti-Patterns and RBAR for Faster Performance
07-11-2019 10:45 Adam Jorgensen, Chris Yates General Session (75 minutes) Professional Development (Other) Making the Leap to Management
07-11-2019 10:45 Niko Neugebauer General Session (75 minutes) Database Administration Columnstore Indexes in 2017-2019
07-11-2019 10:45 Monica Rathbun General Session (75 minutes) Database Administration I'm It - Survival Techniques for the Lone DBA
07-11-2019 10:45 Paul Andrew General Session (75 minutes) Big Data ETL in Azure Made Easy with Data Factory Mapping Data Flows
07-11-2019 13:30 Kalen Delaney General Session (75 minutes) Development Into the Future with In-memory OLTP
07-11-2019 13:30 Bob Pusateri General Session (75 minutes) Big Data Dipping Your Toes In: Azure Data Lake for DBAs
07-11-2019 13:30 Johan Ludvig Brattås, Rune Ovlien Rakeie General Session (75 minutes) Cloud Solutions Privacy and Security by Design in a Cloud Environment
07-11-2019 13:30 John Martin General Session (75 minutes) Security Database Security, Who Owns It?
07-11-2019 13:30 Bob Ward, Shreya Verma Microsoft Session (75 minutes) Hybrid Infrastructure SQL Server in Azure Virtual Machine Re-Imagined
07-11-2019 13:30 Jonathan Stewart General Session (75 minutes) Advanced Analytics Two Truths That's A Lie: Data Visualization Ethics
07-11-2019 13:30 Grant Fritchey Partner Session (75 minutes) Hybrid Infrastructure SQL Server in Containers: Your Next Dev/Test/Integration/Upgrade Server
07-11-2019 13:30 Adam Jorgensen General Session (75 minutes) Professional Development (Other) Taking Leadership to the Next Level: Mastering Your Own Growth
07-11-2019 13:30 Patrick LeBlanc, Chris Finlan Microsoft Session (75 minutes) Business Intelligence and Data Warehousing SSRS 2019 and Paginated Reports in Power BI
07-11-2019 13:30 Leila Etaati General Session (75 minutes) Advanced Analytics AI for the BI Professional
07-11-2019 13:30 Kevin Kline, Andy Yun Partner Session (75 minutes) Database Administration Fix Slow Queries. Fast. With SentryOne Plan Explorer
07-11-2019 13:30 Ike Ellis, Simon Whiteley, Dustin Vannoy General Session (75 minutes) Business Intelligence and Data Warehousing 10 Cool Things You Can Do With Azure Databricks
07-11-2019 13:30 Jamey Johnston General Session (75 minutes) Advanced Analytics Code Like a Snake Charmer - Introduction to Python!
07-11-2019 13:30 Denise McInerney General Session (75 minutes) Professional Development (Other) Successfully Communicating with Your Customers
07-11-2019 13:30 Itzik Ben-Gan General Session (75 minutes) Development Missing T-SQL Querying Features for Handling NULLs and for Data Analysis
07-11-2019 13:30 Alicia Moniz General Session (75 minutes) Artificial Intelligence AI Cognitive Services: Vision 101
07-11-2019 13:30 Chris Woodruff General Session (75 minutes) Development Entity Framework Debugging Using SQL Server: A Detective Story
07-11-2019 13:30 Kellyn Pot'Vin-Gorman General Session (75 minutes) Database Administration Empowering the SQL Server Professional with Linux Scripting
07-11-2019 13:30 Pam Lahoud Microsoft Session (75 minutes) Development Modernize Your SQL Server the Right Way
07-11-2019 15:15 Neil Hambly Half-Day Session (2.5 hours) Cloud Solutions CosmosDB - Designing and Troubleshooting Lessons
07-11-2019 15:15 Tobias Ternstrom General Session (75 minutes) Database Administration Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases
07-11-2019 15:15 Paul Turley General Session (75 minutes) Advanced Analytics No-Code Custom Visuals! Can You Say Charticulator? …I Knew You Could
07-11-2019 15:15 Chris Bell General Session (75 minutes) Development Building Your First SQL Server Container Lab in Docker
07-11-2019 15:15 Melody Zacharias General Session (75 minutes) Artificial Intelligence AI for the DBA
07-11-2019 15:15 Jens Vestergaard, Martin Catherall, Eugene Meidinger, Kimberly StJacques, Paul Andrew, Michael Grayson Lightning Talk (10 minutes) Advanced Analytics LIGHTNING TALKS
07-11-2019 15:15 Pablo Alvarez Partner Session (75 minutes) Data Platform Strategy Self Service with a Logical Architecture: How to Consolidate Access to Fragmented Data without Additional Replication
07-11-2019 15:15 James McGillivray General Session (75 minutes) Business Intelligence and Data Warehousing Design Strategies and Advanced Data Visualization: The Ingredients for a Delicious Data Story
07-11-2019 15:15 Simon Whiteley General Session (75 minutes) Business Intelligence and Data Warehousing An Azure Data Engineer's ETL Toolkit
07-11-2019 15:15 Deana Ritter, Simon Whitworth Partner Session (75 minutes) Business Intelligence and Data Warehousing Scaling with a Distributed Architecture and Real-time Data for an Evolving Business—A DBA’s Journey
07-11-2019 15:15 David Klee General Session (75 minutes) Data Platform Strategy Virtual SQL Server Performance Deep Dive
07-11-2019 15:15 Steve Wake General Session (75 minutes) Business Intelligence and Data Warehousing Power BI Premium: Is it for Your Company (and Worth It)?
07-11-2019 15:15 Tracy Boggiano General Session (75 minutes) Database Administration Using Open Source Software to Collect Performance Metrics
07-11-2019 15:15 John Morehouse General Session (75 minutes) Hybrid Infrastructure Designing Azure Data Disaster Recovery Strategies
07-11-2019 15:15 Chris Webb General Session (75 minutes) Business Intelligence and Data Warehousing Power BI Data Privacy Settings Deep Dive
07-11-2019 15:15 Des FitzGerald, Jayakesh Venu Microsoft Session (75 minutes) Cloud Solutions SQL Migration to Azure: Best Practices, Accelerators, and Production Case Studies
07-11-2019 15:15 Rob Volk General Session (75 minutes) Database Administration Revenge: The SQL!
07-11-2019 15:15 Saveen Reddy, Priyanka Gomatam Microsoft Session (75 minutes) Cloud Solutions Introducing Azure Synapse Analytics: The End-to-End Analytics Platform Built for Every Data Professional
07-11-2019 15:15 Jose Manuel Jurado Diaz, Roberto Cavalcanti General Session (75 minutes) Database Administration Azure SQL Database - Lessons Learned from the Trenches
07-11-2019 16:45 Sergiy Lunyakin General Session (75 minutes) Big Data Data Virtualization is easy with SQL Server Big Data Cluster
07-11-2019 16:45 Randolph West General Session (75 minutes) Database Administration Back Up and Restore a SQL Server Database If You're Not a DBA
07-11-2019 16:45 Joe Obbish General Session (75 minutes) Development Improving Columnstore Load Scalability on Large Servers
07-11-2019 16:45 Bryan Gartner Partner Session (75 minutes) Advanced Analytics SUSE Linux for Modern Data and Analytics
07-11-2019 16:45 Joe Sack, Denzil Ribeiro Microsoft Session (75 minutes) Database Administration Azure SQL Database: Maximizing Cloud Performance and Availability
07-11-2019 16:45 Mike Walsh General Session (75 minutes) Database Administration HA/DR - Too Many Choices!
07-11-2019 16:45 Hugo Kornelis General Session (75 minutes) Development From Adaptive to Intelligent: Query Processing in SQL 2019
07-11-2019 16:45 Thomas LeBlanc General Session (75 minutes) Business Intelligence and Data Warehousing On-Premises Power BI and Reporting: Reporting Services 2019
07-11-2019 16:45 Hamish Watson General Session (75 minutes) Professional Development (Other) SPEAKER IDOL - ROUND 2
07-11-2019 16:45 Patrick LeBlanc, Phillip Seamark General Session (75 minutes) Business Intelligence and Data Warehousing Using the Power Platform to Radically Change your Business
07-11-2019 16:45 Carlos Bossy General Session (75 minutes) Advanced Analytics Operationalize Data Science for Advanced Decision Support
07-11-2019 16:45 MIKE DONNELLY General Session (75 minutes) DevOps DataOps - Deploy SQL Server Databases Using Azure Pipelines
07-11-2019 16:45 Ed Leighton-Dick General Session (75 minutes) Security Six Ways to Improve SQL Server Application Security
07-11-2019 16:45 Marco Russo General Session (75 minutes) Business Intelligence and Data Warehousing Different Types of Many-to-Many Relationships in Power BI
07-11-2019 16:45 Denis Reznik General Session (75 minutes) Database Administration True SQL Server Detective
07-11-2019 16:45 Reeves Smith General Session (75 minutes) Business Intelligence and Data Warehousing Start off the Season with Azure Snowflake
07-11-2019 16:45 Pedro Lopes Microsoft Session (75 minutes) Database Administration SQL Server Migration: The Last Mile
08-11-2019 08:00 Aaron Nelson General Session (75 minutes) DevOps SQL Containers in 5 minutes and 5 lines of code
08-11-2019 08:00 Marsha Pierce General Session (75 minutes) Data Platform Strategy The Future Is Here for Containers!
08-11-2019 08:00 Niko Neugebauer General Session (75 minutes) Business Intelligence and Data Warehousing Batch Execution Mode on Rowstore Indexes
08-11-2019 08:00 Amit Banerjee, James Rowland-Jones Microsoft Session (75 minutes) Database Administration Azure Arc: Bring Azure Data Services to On-Premises, Multi-Cloud and Edge
08-11-2019 08:00 Ray Kim General Session (75 minutes) Professional Development (Other) Whacha Just Say? Talking Technology to Non Technical People
08-11-2019 08:00 Jeff Renz General Session (75 minutes) Business Intelligence and Data Warehousing Delivering a Data Warehouse in the Cloud
08-11-2019 08:00 Hamish Watson General Session (75 minutes) Professional Development (Other) SPEAKER IDOL - ROUND 3
08-11-2019 08:00 Tim Corey General Session (75 minutes) DevOps Complete CI/CD for C# and SQL
08-11-2019 08:00 Reza Rad General Session (75 minutes) Business Intelligence and Data Warehousing Architecture Blueprints for Power BI Implementation
08-11-2019 08:00 Leila Etaati General Session (75 minutes) Advanced Analytics AI for Analysts
08-11-2019 08:00 Asgeir Gunnarsson General Session (75 minutes) Business Intelligence and Data Warehousing What's Going On in My Power BI Environment?
08-11-2019 08:00 Hiram Fleitas General Session (75 minutes) Development Real-time Sentiment Prediction in SQL Server
08-11-2019 08:00 Bob Ward Microsoft Session (75 minutes) Database Administration Inside SQL Server on Kubernetes
08-11-2019 08:00 Martin Catherall General Session (75 minutes) Data Governance/Privacy Data Privacy, Security, Ethics and Compliance in a Data-Driven World
08-11-2019 08:00 Heidi Hasting General Session (75 minutes) Business Intelligence and Data Warehousing Bringing Source Control to BI world!
08-11-2019 08:00 Rob Sewell General Session (75 minutes) Development pwsh? Using PowerShell on Linux
08-11-2019 08:00 Ori Kashi Partner Session (75 minutes) Cloud Solutions Getting the Most Out of Your Microsoft Windows and SQL Server Migration to Google Cloud
08-11-2019 08:00 Rajnikant Tandel General Session (75 minutes) Database Administration Reduce Cost by Tuning Queries on Azure DBaaS
08-11-2019 09:30 Pam Lahoud Microsoft Session (75 minutes) Database Administration Turbocharge Your SQL Server with In-Memory Database
08-11-2019 09:30 Jovan Popovic, Mladen Andzic Microsoft Session (75 minutes) Database Administration SQL Managed Instance: a Fully Managed SQL Server in the Cloud
08-11-2019 09:30 Danny Ravid, Yitzchak Wahnon General Session (75 minutes) Hybrid Infrastructure Neither Here Nor There - Hybrid AO SQL Architecture On-Prem/Azure
08-11-2019 09:30 Martin Cairney General Session (75 minutes) Development Data Classification and Masking: the What and How of Data Protection
08-11-2019 09:30 Vanessa Kesten General Session (75 minutes) Business Intelligence and Data Warehousing Help Me SSIS Logging, You're My Only Hope!
08-11-2019 09:30 Ginger Grant General Session (75 minutes) Business Intelligence and Data Warehousing Data Warehousing: Which of the Many Cloud Products is the Right One for You?
08-11-2019 09:30 James Rowland-Jones Microsoft Session (75 minutes) Big Data Presenting Big Data Clusters for SQL Server 2019
08-11-2019 09:30 Vishal Pawar General Session (75 minutes) Data Platform Strategy Power BI Report Server Enterprise Architecture, Tools to Publish
08-11-2019 09:30 Ike Ellis General Session (75 minutes) Cloud Solutions Data Modeling Trends for 2019 and Beyond
08-11-2019 09:30 Donald Farmer Keynote (90 minutes) Advanced Analytics ANALYTICS SPOTLIGHT: The New Analyst
08-11-2019 09:30 Kendra Little General Session (75 minutes) DevOps Best Practices for Branching Database Code in Git
08-11-2019 09:30 Tom Staab Partner Session (75 minutes) Database Administration Modernize SQL Server Workloads in The AWS Cloud: Self-Managed, Managed, and Serverless
08-11-2019 09:30 Jim Wooley General Session (75 minutes) Development Successful ORM Design Strategies
08-11-2019 09:30 Warwick Rudd General Session (75 minutes) Database Administration Azure Data Studio - The New Frontier
08-11-2019 09:30 Glenn Berry General Session (75 minutes) Database Administration Hardware 301: Choosing Database Hardware for SQL Server 2019
08-11-2019 09:30 Tillmann Eitelberg, Frank Geisler General Session (75 minutes) Business Intelligence and Data Warehousing Reporting for Developers
08-11-2019 09:30 David Bermingham General Session (75 minutes) Cloud Solutions Surviving the Next Azure Outage Like a Boss
08-11-2019 09:30 Dmitri Korotkevitch General Session (75 minutes) Database Administration Deep Dive into Blocking and Deadlocks Troubleshooting
08-11-2019 09:30 Hugo Kornelis Half-Day Session (2.5 hours) Development Hash Match, the Operator
08-11-2019 11:00 Kathi Kellenberger General Session (75 minutes) Artificial Intelligence Azure Machine Learning 101
08-11-2019 11:00 Simon Cho General Session (75 minutes) DevOps Database CICD (Continuous Integration and Deployment)
08-11-2019 11:00 Prathy Kamasani, James McGillivray General Session (75 minutes) Business Intelligence and Data Warehousing "What's in a Name?", Data Stories that Would Make the Bard Proud
08-11-2019 11:00 Edwin M Sarmiento General Session (75 minutes) Professional Development (Other) Successfully Managing Upwards And Getting Your Boss On Your Side
08-11-2019 11:00 Elizabeth Noble General Session (75 minutes) Development Improving Database Code Quality with Unit Tests
08-11-2019 11:00 Hope Foley General Session (75 minutes) Artificial Intelligence AI to the Masses! But How? Pixie Dust?
08-11-2019 11:00 Ben Weissman General Session (75 minutes) Business Intelligence and Data Warehousing Let's Automagically Stage 100 Tables. For SSIS or ADF. With Biml. Live.
08-11-2019 11:00 Johan Ludvig Brattås, Rune Ovlien Rakeie General Session (75 minutes) Cloud Solutions Take Me to the (Multiple) Clouds Above Seattle
08-11-2019 11:00 Denzil Ribeiro Microsoft Session (75 minutes) Database Administration Best, Better, Hyperscale! The Last Database You will Ever Need in the Cloud
08-11-2019 11:00 Andy Leonard General Session (75 minutes) Business Intelligence and Data Warehousing Azure DevOps and the SSIS Development Lifecycle
08-11-2019 11:00 Reza Rad General Session (75 minutes) Business Intelligence and Data Warehousing Power Query, M and Dataflow; The Lightsaber for the Data Jedi
08-11-2019 11:15 Ed Leighton-Dick General Session (75 minutes) Security Capturing SQL Server activity with SQL Server Audit
08-11-2019 11:15 Charles Christian, Sreraman Narasimhan Microsoft Session (75 minutes) Cloud Solutions Deep Dive with Data Migration Tools and Azure Database Migration Service (DMS)
08-11-2019 11:15 Pinal Dave General Session (75 minutes) Database Administration Elementary! The Curious Case of Deceptive Query Optimizer
08-11-2019 11:15 Victor Isakov General Session (75 minutes) Database Administration Should I Move My Production SQL Server Workloads to Containers?
08-11-2019 11:15 Christine Assaf General Session (75 minutes) Professional Development (Other) Giving Feedback: How to Effectively Communicate to your Employees
08-11-2019 11:15 Warren Sifre General Session (75 minutes) Database Administration Introduction To Data Governance
08-11-2019 11:15 Fabiano Amorim General Session (75 minutes) Database Administration Query Analysis Deep Dive: 13 Causes of a Slow Query
08-11-2019 13:00 Kevin Kline Marketing Community Session (45 minutes) Professional Development (Other) Staying Involved with PASS
08-11-2019 14:00 Jim Wooley General Session (75 minutes) Development Entity Framework Performance Monitoring and Tuning
08-11-2019 14:00 Ola Hallengren General Session (75 minutes) Database Administration Query Store In-Depth
08-11-2019 14:00 Russel Loski General Session (75 minutes) Business Intelligence and Data Warehousing Managing ETL Change Using BIMLScript
08-11-2019 14:00 Peter Shore General Session (75 minutes) Database Administration Infrastructure for the DBA: An Introduction
08-11-2019 14:00 Jim Dorame General Session (75 minutes) Development JSON for the Data Mortals
08-11-2019 14:00 Chris Bell General Session (75 minutes) Security MSAs, GMSAs, and Groups - Use SQL Without Traditional User Accounts
08-11-2019 14:00 Andreas Wolter, Rohit Nayak, Mirek Sztajno Microsoft Session (75 minutes) Security What's new in Security for Azure SQL/MI
08-11-2019 14:00 Hamish Watson General Session (75 minutes) Professional Development (Other) SPEAKER IDOL - FINALE
08-11-2019 14:00 Anand Subbaraj, Gaurav Malhotra Microsoft Session (75 minutes) Business Intelligence and Data Warehousing Ingesting and Managing Petabytes of Data with Azure Data Factory
08-11-2019 14:00 Chad Crawford General Session (75 minutes) Professional Development (Other) From Fear to Confidence – Learn the Art of Influence
08-11-2019 14:00 Reid Havens General Session (75 minutes) Business Intelligence and Data Warehousing How to Build an Impactful KPI Scorecard in Power BI
08-11-2019 14:00 Dejan Sarka General Session (75 minutes) Advanced Analytics Comparing Predictive Models from R, Python, SSAS, and Azure ML
08-11-2019 14:00 Drew Skwiers-Koballa General Session (75 minutes) Development Azure Data Studio Extension Development
08-11-2019 14:00 Edward Pollack General Session (75 minutes) Development Dynamic SQL: Writing Efficient Queries on the Fly
08-11-2019 14:00 Jeremy Frye General Session (75 minutes) Artificial Intelligence PowerApps and AI: A Flow of Location Events
08-11-2019 14:00 Randolph West General Session (75 minutes) Database Administration Managing and Monitoring SQL Server on Linux from the Command Line
08-11-2019 14:00 Richard Tkachuk, Miki Ben-Ze'ev, Assaf Shemesh Microsoft Session (75 minutes) Business Intelligence and Data Warehousing Enterprise-Grade BI with Power BI: Enterprise Information Management (EIM), Scale and Performance
08-11-2019 14:00 Thomas Grohser General Session (75 minutes) Data Platform Strategy Datacenter and/or Cloud - When to Use One, the Other, or Both
08-11-2019 15:30 Steve Wake General Session (75 minutes) Business Intelligence and Data Warehousing Data Modeling and Prototyping in Power BI Desktop
08-11-2019 15:30 Jamey Johnston General Session (75 minutes) Advanced Analytics Code Like a Snake Charmer – Advanced Data Modeling in Python!
08-11-2019 15:30 Jan Mulkens General Session (75 minutes) DevOps 6 Months to 5 minutes, DB & BI Deployments at the Speed of Light
08-11-2019 15:30 Ted Stathakis General Session (75 minutes) Business Intelligence and Data Warehousing Reporting Services: A Smart Migration Strategy
08-11-2019 15:30 Sriharsh Adari General Session (75 minutes) Data Platform Strategy How Do I Ensure my Azure Modern Data Warehouse is Secure?
08-11-2019 15:30 Morgan Oslake Microsoft Session (75 minutes) Database Administration Azure SQL Database Serverless: Compute Autoscaling Solution to Optimize Database Price-Performance
08-11-2019 15:30 Oliver Engels, Tillmann Eitelberg General Session (75 minutes) Data Governance/Privacy Data Quality Round-trip in the MS Dataplatform 2019
08-11-2019 15:30 Jens Vestergaard General Session (75 minutes) DevOps ABCs of the Power BI REST API
08-11-2019 15:30 Mike Diehl General Session (75 minutes) Business Intelligence and Data Warehousing Azure DevOps Pipelines for BI
08-11-2019 15:30 Elizabeth Oldag, Shane Risk Microsoft Session (75 minutes) Business Intelligence and Data Warehousing Large-Scale Migration of On-Premise Big Data Workloads to Azure
08-11-2019 15:30 Gabi Münster, Benjamin Kettner General Session (75 minutes) DevOps Continuous Intelligence... What's This All About?
08-11-2019 15:30 Bert Wagner General Session (75 minutes) Development Identifying Anti-Patterns in Analytical Queries
08-11-2019 15:30 Mike Walsh General Session (75 minutes) Database Administration Upgrading SQL Server - Prepare for Success!
08-11-2019 15:30 MIKE DONNELLY, Jennifer McCown, Paul Wehland, Jorge Besada, Dennes Torres, Edward Pollack Lightning Talk (10 minutes) Database Administration LIGHTNING TALKS
08-11-2019 15:30 Dan de Sousa General Session (75 minutes) Database Administration Azure Data Studio: The Challenger
08-11-2019 15:30 Dan Mallott General Session (75 minutes) Security Secure SQL Server Database Design: Tactics and Technology
08-11-2019 15:30 Ike Ellis General Session (75 minutes) Cloud Solutions Relational Data Modeling Trends for Transactional Applications
08-11-2019 15:30 Kevin Kline General Session (75 minutes) Advanced Analytics Effective Requirements Gathering for Successful Project Outcomes

SessionID: 92853

SQL Server Administration Made Easy with dbatools  

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Rob Sewell

Title: SQL Server Administration Made Easy with dbatools  

Description:

Automation - When you are responsible for a number of SQL Instances automating tasks is vital.

Consistency - When a script run it will do the same thing every time. It won't forget to copy the WHERE clause into the query! Expertise - Gaining more knowledge, developing skills and being able to improve your productivity will have a positive bearing on your career.

dbatools is an open-source cross-platform PowerShell toolkit for SQL Server DBAs. With over 150 contributors from the SQL and PowerShell communities, dbatools is designed and written by the people who use it in their everyday work. If you want to learn how to use it you come and spend a day with Rob Sewell, one of the dbatools contributors and co-author of dbatools in a Month of Lunches.

You will learn many practical examples of how dbatools can help you to save time in your DBA administration duties including:

Even better, you will be able to ask questions, meet other people and learn together and make connections that will be of benefit in the future as you take this knowledge and use it in your day to day work.

Learning to use dbatools will also teach you how to use PowerShell and PowerShell interacts with many technologies so you will also be gaining knowledge that you will be able to make use of when you are faced with interacting with other technologies.

This day-long session will be of benefit to any level of DBA looking after estates with one or more instances who have a little knowledge of PowerShell.

SessionID: 93732

The SQL Server 2019 Workshop

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Bob Ward

Title: The SQL Server 2019 Workshop

Description:

THIS SESSION IS SOLD OUT

You may have heard or seen something about SQL Server 2019, but the best way to learn is to try it yourself.  Bob Ward, Principal Architect for the SQL Server Engineering Team, will lead you through a day long workshop on how to maximize the new capabilities of SQL Server 2019. You will walk away from this workshop knowing “what Bob knows” so that you can modernize your skills with SQL Server and teach others in your community or company why SQL Server 2019 is truly a modern data platform.

In this workshop, Bob will teach and lead you through SQL Server 2019 scenarios including but not limited to: • How to reduce the time required for complex query performance tuning and maximize database performance • How to make your SQL Server is online and highly available • How to modernize your skills by extending T-SQL and deploying SQL Server on Linux, Containers, and Kubernetes • How to reduce the need for costly ETL programs with data virtualization

This day will be extremely interactive and Bob always provide details on “how it works”.  Attendees will have the option of using their laptop to “try it yourself” for many of the scenarios or “watch and learn”. At the end of the day you will walk away with all the materials, code, slides, and demos for future use. Due the interactive nature of this workshop, space will be very limited*.

SessionID: 92851

Database Privacy and Security for Developers

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Security

Speaker(s): Ed Leighton-Dick

Title: Database Privacy and Security for Developers

Description:

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: 92888

Redgate SQL in the City Summit Seattle

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: DevOps

Speaker(s): Kendra Little, Steve Jones, Grant Fritchey, Ike Ellis, Hamish Watson

Title: Redgate SQL in the City Summit Seattle

Description:

Redgate SQL in the City Summit Seattle brings together database, IT, operations, and development leaders together to discuss Compliant Database DevOps. Stay ahead of the competition and discuss what's needed for IT to effectively balance the demand for delivering software faster, while protecting and preserving business critical data.

The schedule includes thought provoking sessions presented by world class speakers, engaging panel discussions with industry peers, plus time for networking. A fantastic line-up of Microsoft Data Platform MVPs and Data experts will share their knowledge and experience of how businesses can benefit from a DevOps approach to database development, while staying compliant and minimizing risk.

Discover why DevOps has been adopted by many successful organizations across various industries, learn about the benefits of Database DevOps, and understand how best to implement this positive shift in your IT team.

Who should attend: If you lead an IT team or manage databases on Microsoft's Data Platform and you're looking to stay ahead of the competition, increase the speed of deployments, help your team work leaner and quicker, add more value, and manage risk, all at the same time, join this event to understand how Redgate is helping leaders like you to deliver value quicker and keep their data safe.

Agenda: 8:00AM – 8:30AM Registration, networking

8:30AM – 9:30AM Opening Keynote: 2019 State of Database DevOps and Predictions for 2020 Kendra Little, Microsoft Data Platform MVP

9:30AM – 10:00AM Choosing the right source control approach for your team
Kendra Little, Microsoft Data Platform MVP and Hamish Watson, Microsoft Data Platform MVP and DevOps Alchemist at Morph iT

10:00AM – 10:30AM
Morning break

10:30AM – 11:15AM Implementing Compliant Database DevOps in your organization Arneh Eskandari, Sales Engineering Manager, Redgate

11:15AM – 12:00PM 10 Steps Towards Global Data Compliance Grant Fritchey, Microsoft Data Platform MVP and Evangelist at Redgate

12:00PM – 1:00PM Catered lunch

1:00PM – 1:45PM Panel: What you need to know before launching a DevOps Initiative
Moderator: Steve Jones
Ike Ellis, Microsoft Data Platform MVP and Partner at Crafting Bytes, Hamish Watson, Microsoft Data Platform MVP and DevOps Alchemist at Morph iT, and Kendra Little, Microsoft Data Platform MVP and DevOps Advocate at Redgate

1:45PM – 2:30PM Case study session: How I turned a dysfunctional company around to being a DevOps leader using the SQL Toolbelt. Hamish Watson, DevOps Alchemist at Morph iT

2:30PM – 3:00PM Afternoon break

3:00PM – 4:00PM The Business Case – Set yourself up for success within three months Ike Ellis, Microsoft Data Platform MVP and Partner at Crafting Bytes

4:00PM – 4:30PM Final takeaways + Q&A with the speakers All speakers

To view a more detailed agenda click here: The Redgate Event Agenda Site .

SessionID: 92854

Performance Tuning With Query Store in SQL Server

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Erin Stellato

Title: Performance Tuning With Query Store in SQL Server

Description:

Have you upgraded to SQL Server 2016 or higher, but still have databases using the old Cardinality Estimator?

Do you know that you have queries with inconsistent performance, but you're just not sure how to find them, or fix them, quickly?

Are you tired of flailing around in SQL Server, querying DMV after DMV to figure out the real problem with performance?

Query Store can help.

We’ll cover Query Store end-to-end in this full day workshop built using real-world examples based on customer issues resolved over the last 2+ years. You'll understand how to configure it, what data it captures, and how to use it to analyze performance, find regressions, and force plans. The demos will teach you how to find common patterns in query performance using T-SQL, and how to understand your workload.

This class is applicable for those running SQL Server 2016 or higher (or planning to upgrade), or Azure SQL Database, and will provide practical and applicable information you can use whether you're a new or veteran DBA, a developer that has to troubleshoot query performance, or an application administrator just trying to keep the system afloat. You'll learn how to find and leverage important information in Query Store to make solving common performance problems easier the moment you walk back into the office. 

SessionID: 93271

Data Science in a Day: Preparation, Patterns, and Predictions

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics

Speaker(s): Natasha Balac

Title: Data Science in a Day: Preparation, Patterns, and Predictions

Description:

This one-day session is designed for attendees seeking to enhance their data analysis skills through Machine Learning and Artificial Intelligence.

In this training, attendees will:

Attendees will learn the core Data Science techniques and tools that enable discovery of accurate and actionable insights. This practical course emphasizes key learning techniques: classification, regression, association rules, and clustering. During the sessions participants will acquire new skills across data preparation, the application of Data Science algorithms to real data, and finally the interpretation of results.

The tool of choice for this training is the open source KNIME Analytics Platform, which also offers great integrations with R, Python, SQL, and Spark.

SessionID: 92844

Mastering T-SQL Querying Fundamentals

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Itzik Ben-Gan

Title: Mastering T-SQL Querying Fundamentals

Description:

Does your work involve interacting with Microsoft SQL Server or Azure SQL Database? If so, writing T-SQL code is probably an integral part of your work. As a developer, DBA, analyst, BI pro, data scientist, or power user, a strong mastery of T-SQL querying and its foundations makes you better at what you do. This full-day seminar provides you with such strong foundations. You will naturally learn about T-SQL querying tools like joins, subqueries, table expressions, recursive queries, APPLY, set operators and many others. You will learn about logical query processing, which defines the conceptual interpretation of queries, unveiling many surprising things about T-SQL. You will learn about new T-SQL features that were added in recent versions of SQL Server and Azure SQL Database. You will also learn about common bugs and pitfalls, and ways to avoid those. As time permits, the seminar will also cover some of the more advanced querying tools like pivoting and unpivoting, window functions and grouping sets. This seminar will help you write correct and robust T-SQL code, avoid bugs, follow best practices, think in set-based/relational terms, and get a better mastery of T-SQL querying.

SessionID: 92846

Advanced Virtual SQL Server Performance 

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): David Klee

Title: Advanced Virtual SQL Server Performance 

Description:

Virtualization is the new norm in datacenters. Even the ubiquitous “cloud” is nothing more than virtualized servers in someone else’s datacenter with advanced automation on top of it. However, just because it’s everywhere doesn’t mean it is implemented and managed correctly. Done incorrectly, your SQL Server performance can take a massive dive. Are your SQL Servers running at their best possible performance?

This full-day boot camp covers all aspects of performance engineering for virtualized SQL Servers. We will review critical topics such as virtualization layers, VM construction, NUMA, resource scheduling, query parallelization and physical server alignment, “right-sizing,” and storage performance-oriented presentation. Availability and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to help you work better with your infrastructure team to streamline your critical SQL Server performance. You will understand how to review your critical SQL Servers for both their performance and availability as they relate to the virtualization and physical compute layers underneath, and work with your infrastructure team to implement and streamline any of your findings.

SessionID: 92847

Architecting a Big Data Analytics Solution with SQL Server 2019

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Big Data

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. In this full-day training, you will learn about the tactics and techniques surrounding Big Data Analytics, particularly on the Microsoft stack. We will architect a solution for a real data science problem using the technologies central to SQL Server 2019, particularly around Big Data Clusters.  We will investigate the key components and uses of Big Data Clusters as well as PolyBase and SQL Server Machine Learning Services, seeing how these interrelate to solve data science problems at scale. In addition to core SQL Server technologies, we will learn about Apache Spark and Spark Streaming outside of Big Data Clusters, seeing how we can use these technologies to collect, curate, and enrich data for analytics.  Bringing the analysis home, we will use Azure Data Studio and its addition of Jupyter Notebooks, letting us write our code using R, Python, and even T-SQL.  By the end of the day, you will have an understanding of how to scope and design a Big Data Analytics project from beginning to end.

SessionID: 92848

AI and Power BI: The Realm of the Impossible

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics

Speaker(s): Leila Etaati

Title: AI and Power BI: The Realm of the Impossible

Description:

There are tons of ways to do machine learning in Power BI. From using Pre-built AI services such as Cognitive services and custom visuals, to Custom AI tools such as writing R, Python scripts, or using Azure ML Studio (a drag and drop service). In this one-day workshop, first, an overview of what is machine learning and different approaches to machine learning (Predictive, descriptive and prescriptive analytics) and AI will be presented. The audience will learn the main process of doing machine learning by writing simple R or Python scripts to do predictive analytics in Power Query. In the next step, they will see how they able to consume some of the exciting custom visual in Power BI for the aim of machine learning without writing any lines of codes (such as decision tree, key influencer and so forth) and how to use them to add more analytics perspective to their reports. Moreover, the process of creating advanced analytics visual with the help of writing R or Python code will be explained. Next, the audience will see how to create a simple Azure Machine Learning model web service and then apply it on collected data in Power BI desktop (Power Query) for predictive analytics in Power BI desktop and data flow (Power BI Service). Next, the audience will learn how to use pre-built AI such as cognitive service inside Power BI desktop (Power Query) and Power BI service (Data Flow).

SessionID: 92850

The SQL Server DBA’s Guide to Docker Containers

Back to calendar

Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Edwin M Sarmiento

Title: The SQL Server DBA’s Guide to Docker Containers

Description:

Your role as a SQL Server DBA is evolving and you are now responsible for automating deployment, scaling and management of containerized applications – not just SQL Server databases. You don’t have a clue where and how to start. You are confused about this whole DevOps buzzword being thrown around and you are wasting a lot of time figuring things out on your own. What’s worse, you end up being a stressed, overworked engineer who wished you could focus on the “cool stuff”, but are instead stuck in firefighting mode while juggling the additional workload.

This session is specifically for you. This whole-day workshop is specifically designed for senior SQL Server database administrators and systems engineers responsible for automating deployment, scaling and management of containerized applications.

Learning Objectives:

  1. Introduce SQL Server DBAs to the world of Docker Containers
  2. Leverage Docker Containers for deploying SQL Server
  3. Introduce SQL Server DBAs to Container Orchestration

SessionID: 92855

The SQL Server 2019 Workshop

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Bob Ward

Title: The SQL Server 2019 Workshop

Description:

THIS SESSION IS SOLD OUT

You may have heard or seen something about SQL Server 2019, but the best way to learn is to try it yourself.  Bob Ward, Principal Architect for the SQL Server Engineering Team, will lead you through a day long workshop on how to maximize the new capabilities of SQL Server 2019. You will walk away from this workshop knowing “what Bob knows” so that you can modernize your skills with SQL Server and teach others in your community or company why SQL Server 2019 is truly a modern data platform.

In this workshop, Bob will teach and lead you through SQL Server 2019 scenarios including but not limited to: • How to reduce the time required for complex query performance tuning and maximize database performance • How to make your SQL Server is online and highly available • How to modernize your skills by extending T-SQL and deploying SQL Server on Linux, Containers, and Kubernetes • How to reduce the need for costly ETL programs with data virtualization

This day will be extremely interactive and Bob always provide details on “how it works”.  Attendees will have the option of using their laptop to “try it yourself” for many of the scenarios or “watch and learn”. At the end of the day you will walk away with all the materials, code, slides, and demos for future use. Due the interactive nature of this workshop, space will be very limited*.

SessionID: 92849

Practical Azure Databricks: Engineering & Warehousing at Scale

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing

Speaker(s): Terry McCann, Simon Whiteley

Title: Practical Azure Databricks: Engineering & Warehousing at Scale

Description:

You've probably heard the buzz - there's a thing called Azure Databricks that is going to solve all your problems? Surprisingly, it just might. First and foremost, knowing how to use Apache Spark will earn you more money. It is that simple. Apache Spark has been the biggest thing in Big Data processing for many years now, but it has always felt inaccessible to the humble Microsoft data developer. Azure Databricks takes the Spark engine and makes it really, really easy. Data Engineers who know Apache Spark are in massive demand and we're going to introduce you to the skills required to succeed.

In the morning we will introduce Azure Databricks then discuss how to develop in-memory elastic scale data engineering pipelines. We will talk about shaping and cleaning data, the languages, notebooks, ways of working, design patterns and how to get the best performance. You will build an engineering pipeline with Python, then with Scala via Azure Data Factory, then we'll get it into context in a full solution. We will also talk about Data Lakes - how to structure and manage them over time in order to maintain an effective data platform.

We will then shift gears, taking the data we prepared earlier and enriching it with additional data sources before modelling it in a relational warehouse. We will take a look at various patterns of performing data engineering to cater for scenarios such as real-time streaming, de-centralised reporting, rapidly evolving data science labs and huge data warehouses in specialised storage such as Azure SQL Datawarehouse. By the end of the day, you will understand how Azure Databricks sits at the core of data engineering workloads and is a key component in Modern Azure Warehousing.

SessionID: 92889

An Introduction to Data Driven Storytelling: Data Visualization for all!

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics

Speaker(s): Jonathan Stewart

Title: An Introduction to Data Driven Storytelling: Data Visualization for all!

Description:

We hear the term data visualization nearly everyday in our daily life. It has become an integral part of not only our day to day business practice but our actual daily life. It is the language of data. However, it can be overwhelming to those that are new to the topic, are unfamiliar with new tools or are looking to keep up with new technology.

In this session, we will have fun discussing the ins and outs of data driven visualizations. We will discuss the theory that becomes the practical. We will learn not only the how, but the WHY!

Get hands on experience as we work through multiple scenarios and learn how to build impactful data driven visualizations!

Topics in this course:

SessionID: 92852

Bigger Hardware or Better Code and Design?

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Jonathan Kehayias

Title: Bigger Hardware or Better Code and Design?

Description:

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: 92841

How to Architect Successful Database Changes: Source Control and Release Patterns for Performance and Availability

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Kendra Little, Steve Jones

Title: How to Architect Successful Database Changes: Source Control and Release Patterns for Performance and Availability

Description:

You want to frequently release quality database changes while maintaining high performance and availability standards, but how do you do it? While the term ‘DevOps’ has just turned 10 years old, database architects and DBAs have been developing patterns and practices to standardize and automate delivery of database code quickly and reliably for far longer.

In this session, you will learn how to choose between state and migrations-based approaches to database code management in source control on a per-project basis, and what this choice means for your release practices. You’ll learn what release automation means for ‘rollbacks’ with database code and get to join the debate on the pros and cons of different approaches to handling post-release disasters in production. We’ll discuss release patterns and how to measure success, including the blue/green deployment model when applied to databases, the expand/contract pattern, feature flags, and special cases for releases including replication, Azure SQL Database, and Managed Instances. Finally, we’ll cover how to identify and architect changes which require extra review and special design, including size of data operations and data modifications which need extra care.

You’ll leave this day-long session with an understanding of the patterns that real-world professionals use to standardize and automate successful releases to production, and the tools and resources to design, test, and automate successful changes for even the most critical databases.

SessionID: 92842

Move a Successful Legacy On-Premise OLTP SQL Server Database to Azure

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Development

Speaker(s): Ike Ellis

Title: Move a Successful Legacy On-Premise OLTP SQL Server Database to Azure

Description:

You never thought you'd have to move this large, OLTP database to the cloud. After all, the database has been running your business just fine for 20 years. It has 20 years worth of dependencies: linked servers, finance runs Excel projections directly from it, other databases connect directly to it, reporting, ETL, vendor extracts, FTP file uploads, and about 20 different internal applications all use that database as their main data source. How could this possibly go to the cloud?

Then one day your boss comes in the room and says "Management has made the unilateral decision that everything goes to Azure. Everything. And we have 18 months. Make a plan to get that database into Azure."

After the initial shock wears off, you roll-up your sleeves and say "I'm ready for this challenge! I can do this! But where do I begin? There are so many choices. How do I know I'm making the right ones?"

You also know that the existing application has acquired significant technical debt over time. Is this a good time to pay off that technical debt? If it is, how do we accomplish that? If it isn't how do I create a plan to pay it off in the future?

I know the mountain seems high, but you can climb it! This session will tell you everything you need to know about moving that database to Azure.

Here's what we will cover:

Come to the demo and lab-filled session and get all the tools necessary to perform a successful cloud migration project. You can do this! Let's get you on your way!

SessionID: 92845

How to Build 5 Azure-Powered Apps to Automate Your Job

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Development

Speaker(s): Tim Corey

Title: How to Build 5 Azure-Powered Apps to Automate Your Job

Description:

Azure is an incredibly large, ever-changing landscape that can sometimes feel overwhelming. Even if you are using one or two services, you might still feel like you are just barely scratching the surface of what you could be doing. In this full day Pre-Con, we will be building five different applications as an excuse to explore the various services Azure has to offer in a practical manner. For each of the five scenarios, we will start by identifying a need for automation. We will then identify the services that meet that need. Finally, we will build and deploy a C# application to meet our need using the identified Azure services. Topics covered in this session include, but are not limited to, Azure Web Apps, Functions, Storage, SQL, ServiceBus, Search, KeyVault, and DevOps. All examples will be written in .NET Core in C# on Visual Studio Code. Time will be given to allow you to get hands-on experience building the applications for yourself with guidance. Expand your knowledge of Azure and how to use it, build up your C# skills, and walk away with the power to make your life easier through automation.

SessionID: 93261

SQL Server Performance Tuning and Optimization

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration

Speaker(s): Monica Rathbun

Title: SQL Server Performance Tuning and Optimization

Description:

Do your users complain about slow reports? Are your database servers overwhelmed during times of high usage? Every SQL Server environment can benefit from performance tuning whether your environment has one server or thousands. In this full-day session you will learn about how identify problems using a wide variety of tools and scripts and how to implement best practices across your environment. Additionally, you will learn how to begin reading execution plans and how to tune queries to improve your performance within SQL Server. You will walk away with a list of items to evaluate in your environments and ways to resolve common issues. This session will guide you through real-life performance problems which can be solved by best practices and practical skills. Taught on a level anyone can understand, this session will focus on Microsoft SQL Server 2016 and forward.

You will also learn about maintenance activities and how they affect your server’s overall performance, and how to identify when your infrastructure is affecting your performance. Lastly, we will cover the newest performance enhancements coming with the latest release, SQL Server 2019. You’ll leave this demo-filled session better prepared to tackle many issues that can plague SQL Server performance along with the knowledge of how to resolve them.

SessionID: 92843

From 0 to DAX

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing

Speaker(s): Alberto Ferrari

Title: From 0 to DAX

Description:

The DAX language is the foundation of self-service Business Intelligence using the Microsoft stack. It is the language used to query and program Power BI, PowerPivot for Excel, and SQL Server Analysis Services Tabular models. Learning the basics of DAX is very simple, but mastering it is a different story because it requires a mindset that needs some study, for both BI Professionals and Information Workers. During this one-day workshop, the authors of the best selling books The Definitive Guide to DAX, The Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model, and Building Data Models with Power Pivot, will guide you in the process of learning the DAX language, through many examples and scenarios that will help you understand the important concepts of DAX and how to leverage them in the everyday work. The workshop is useful to many profiles: Information Workers interested in exploiting the many interesting features of PowerPivot for Excel and BI developers who want to learn the DAX language.

SessionID: 96798

Modernizing your Database with Azure SQL

Back to calendar

Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Data Platform Strategy

Speaker(s): Davide Mauri, Andreas Wolter, Sanjay Mishra, Rohit Nayak, Denzil Ribeiro, Rie Irish, Jovan Popovic, Mladen Andzic, Shreya Verma, Dimitri Furman

Title: Modernizing your Database with Azure SQL

Description:

Azure SQL provides the most comprehensive set of capabilities on a cloud relational database. Whether you are building a new application or migrating an existing application, whether you are a SaaS provider or an Enterprise business, Azure SQL is the best choice. SQL in a virtual machine, Azure SQL Database, Managed Instance, Elastic Pools, Azure SQL Hyperscale, Azure SQL DB Serverless – Azure SQL family of services provide you a variety of choices to build and run your SQL environment in the most cost-effective, secured and performant manner.

The ensemble all star cast from the Azure SQL product team will take you through the journey of:

• Understanding the various choices and when to pick which service for best fit • Understanding the Security, Networking, Business Continuity, Disaster Recovery capabilities • Managing the database, instance, elastic pools for best cost effectiveness, performance and scale • Understanding and troubleshooting common problems and errors • Design and develop for resiliency and performance, and building applications for business critical and enterprise workloads • Application patterns and best practices to achieve the best out of Azure SQL environment

SessionID: 98368

WOMEN IN TECHNOLOGY LUNCHEON: LaShana Lewis - Data-Driven Diversity: Using Your Skills to Make a Difference

Back to calendar

Event Date: 06-11-2019 00:00 - Category: Luncheon (105 minutes) - Track: Professional Development (Other)

Speaker(s): LaShana Lewis

Title: WOMEN IN TECHNOLOGY LUNCHEON: LaShana Lewis - Data-Driven Diversity: Using Your Skills to Make a Difference

Description:

Data is all around us. From calculating projections to influencing meaningful decision-making, the impact data has on the way we live and work is increasing rapidly. But, what does this mean for data processes and the business world as a whole, when not everyone has a seat at the table? During this presentation, LaShana Lewis will outline the importance of diversity in business and how you can consider data through the lens of diversity and inclusion, using your skills as a data professional to raise awareness and make lasting change.

LaShana Lewis is a technologist working in the diversity space with over 20 years of experience. She is currently the CEO of L. M. Lewis Consulting, a company which aims to make employers more diverse through recruitment, hiring, and retention best practices. She recently joined Astral AR as Director of Aerospace IT, a company dedicated to giving police/search-and-rescue teams sensory capable drones. Lewis has also served as the CTO of MultiPass, which seeks to network coworking spaces together.

If you didn’t sign up for the luncheon during registration, a limited number of tickets may be available at no additional cost from the Registration Desk onsite. Contact taylor.vick@pass.org for more information (subject line: PASS Summit 2019: WIT Luncheon).

Women in Technology Luncheon is proudly sponsored by: SentryOne

SessionID: 99093

Introduction to PASS Summit 2019

Back to calendar

Event Date: 06-11-2019 00:00 - Category: Marketing Community Session (45 minutes) - Track: Professional Development (Other)

Speaker(s): Kevin Kline

Title: Introduction to PASS Summit 2019

Description:

SessionID: 98612

Exhibitor Reception

Back to calendar

Event Date: 06-11-2019 00:00 - Category: PASS Event (90 minutes) - Track: Professional Development (Other)

Speaker(s): To be Announced

Title: Exhibitor Reception

Description:

Network with representatives from our sponsors and exhibitors and collect stamps for your PASS to Prizes card for the chance to win a big prize!

SessionID: 99039

Microsoft Certification Preparation Session - Thursday

Back to calendar

Event Date: 06-11-2019 00:00 - Category: Vendor - Track: Professional Development (Other)

Speaker(s): David Pless, Dandy Weyn

Title: Microsoft Certification Preparation Session - Thursday

Description:

SessionID: 98357

KEYNOTE: Rohan Kumar, Microsoft (Microsoft Azure Keynote Room)

Back to calendar

Event Date: 06-11-2019 00:00 - Category: Keynote (90 minutes) - Track: Database Administration

Speaker(s): Rohan Kumar

Title: KEYNOTE: Rohan Kumar, Microsoft (Microsoft Azure Keynote Room)

Description:

Join Rohan Kumar, Corporate Vice President of Azure Data, to learn about the latest innovations on Microsoft's data platform. Learn why Azure is the unmatched cloud in price-performance and how we are redefining cloud analytics with new and unrivaled capabilities. See our latest Kubernetes-based hybrid innovations that enable customers to reimagine their hybrid cloud environments. You will also hear about the latest innovations in Azure SQL DB and SQL Server 2019. See killer demos on how customers are using SQL Server 2019 to bring Intelligence closer to All their data, structured and unstructured. Hear our customer stories as they share how they’ve used Azure Data to build cutting-edge solutions to transform their businesses.

SessionID: 98611

Welcome Reception

Back to calendar

Event Date: 06-11-2019 00:00 - Category: PASS Event (90 minutes) - Track: Professional Development (Other)

Speaker(s): To be Announced

Title: Welcome Reception

Description:

Don’t miss the kick-off celebration on Tuesday evening! Stay tuned for details.

SessionID: 98366

KEYNOTE: Tarah Wheeler - Cybersecurity is Everyone’s Problem (Microsoft Azure Keynote Room)

Back to calendar

Event Date: 06-11-2019 00:00 - Category: Keynote (90 minutes) - Track: Security

Speaker(s): Tarah Wheeler

Title: KEYNOTE: Tarah Wheeler - Cybersecurity is Everyone’s Problem (Microsoft Azure Keynote Room)

Description:

SessionID: 99038

Microsoft Certification Preparation Session - Wednesday

Back to calendar

Event Date: 06-11-2019 00:00 - Category: Vendor - Track: Professional Development (Other)

Speaker(s): David Pless, Dandy Weyn

Title: Microsoft Certification Preparation Session - Wednesday

Description:

SessionID: 99040

Microsoft Certification Preparation Session - Friday

Back to calendar

Event Date: 06-11-2019 00:00 - Category: Vendor - Track: Professional Development (Other)

Speaker(s): David Pless, Dandy Weyn

Title: Microsoft Certification Preparation Session - Friday

Description:

SessionID: 98610

First-Timer Event

Back to calendar

Event Date: 06-11-2019 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): To be Announced

Title: First-Timer Event

Description:

Get up to speed on what to expect at PASS Summit 2019 and meet other First-Timers and Alumni attendees in a casual, social environment. Stay tuned for more event details!

Sponsored by: Solarwinds

SessionID: 93591

Roles and Responsibilities of the Azure Data Engineer

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Jes Schultz

Title: Roles and Responsibilities of the Azure Data Engineer

Description:

The rise of data science has led to the rise of the data engineer. While there's a huge push for people to become data engineers, there's also a lot of confusion about what this role is and does. If you're interested in taking your career in a new direction, come and learn what the data engineer role entails, the skills you need to learn, and the Azure services that tie to those skills. This will all be in alignment to the new Microsoft Azure Data Engineer Associate certification.

This session will put you on a path to transforming your career and becoming an Azure Data Engineer.

This session is the first session in the Becoming an Azure Data Engineer Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92172

SQL and MongoDB: When Two Worlds Collide

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Big Data

Speaker(s): Eric Peterson

Title: SQL and MongoDB: When Two Worlds Collide

Description:

Are you aware of the SQL and NoSQL worlds, but don't know why you would use both in the same sentence, let alone implement a hybrid solution? And then if you did want to set up such a system, where would you start?

After a quick overview of the SQL and NoSQL differences, we'll look at some scenarios where it makes sense to set up a hybrid environment to take advantage of the strengths of each database. Then we'll look specifically at accessing MongoDB from SQL Server.

Microsoft offers native integration with MongoDB in SQL 2019. We'll look at the mechanics of how to leverage that integration to archive data, feed a web farm, and provide more data to BI reporting.

We'll dig into querying normalized SQL and denormalized document db data structures simultaneously, and what that means for both data consistency and performance. Of course, this discussion wouldn't be complete without also knowing how to write to the document world from the relational world, so we'll cover that as well.

SessionID: 92582

Performance Tuning Azure SQL Databases

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): David Maxwell

Title: Performance Tuning Azure SQL Databases

Description:

Performance tuning is a critical skill for both DBAs and Developers, and it becomes even more critical when there’s a monthly cost attached to the performance of the database. How do you get the best out of that database when both the hardware and operating system are in someone else’s hands? Fortunately, Azure SQL Database provides several features that can be leveraged for quick and easy performance gains.

In this session, we’ll cover three key performance tuning features; Automatic Tuning, Intelligent Insights, and Extended Events. Each of these will be reviewed specifically with a focus on how it applies to Azure SQL Databases. Attendees will learn how to take advantage of each of these features, allowing them to save both time and money, and ensuring that their Azure SQL Databases are performing at their best.

SessionID: 92344

Emergency! Are You Ready for Disaster to Strike?

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Allen White

Title: Emergency! Are You Ready for Disaster to Strike?

Description:

Just like pilots who are prepared for disaster recovery through regular practice, we as database administrators need to actually spend time practicing recovering with those backups. Ransomware has made it critical to prepare to rebuild your datacenter at any moment.

This session will focus on the kinds of situations that can dramatically affect a data center, and how to practice recovery processes to assure business continuity.

SessionID: 92385

MDS from the Ground Up - Let your Users Maintain their Data?

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Data Governance/Privacy

Speaker(s): Heidi Hasting

Title: MDS from the Ground Up - Let your Users Maintain their Data?

Description:

CCome learn about how Master Data Services (MDS) can help your data journey, from governance and data quality through to integration, into operational and analytical solutions (warehouse), and beyond.

Eliminate data sprawl, while using the same tools business users already love - Excel! Let's talk about how MDS puts data management in the hands of those who understand the data best. Areas covered will include:

SessionID: 94172

Becoming a Technical Leader

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Denise McInerney, Kellyn Pot'Vin-Gorman

Title: Becoming a Technical Leader

Description:

Being a leader means having the respect of your colleagues, your management, and your customers. It means influencing the direction of your organization, and making an impact. Being a technical leader means doing that through your deep understanding of technology and your ability to communicate how technology can be used effectively in your company.

Co-presenters Denise McInerney and Kellyn Pot’Vin-Gorman have enjoyed successful careers in technology, primarily in individual contributor roles. We are each viewed as technical leaders in our respective organizations.

In this session, we will draw on our extensive experience to explore the many dimensions of the technical leader role.

We will discuss how you can gain influence in your organization and affect decision making.

We will delve into how to effectively communicate your ideas, including how to lead through code and other artifacts.

We will explore how to balance “today” and “tomorrow”, delivering what your organization needs in a timely way, and taking advantage of modern tools and technologies.

We will share tips for guiding your team members in their professional education, helping them to utilize new skills while still maintaining focus.

We will offer techniques for keeping your own technical skills sharp and your knowledge current.

And we will examine the art of staying just close enough to the details without getting lost in the weeds.

Join us in a session that will give you the tools you need to continue your evolution as a technical leader.

This session is the first session in the Technical Leadership Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98639

Why the Database is at the Heart of DevOps Success

Back to calendar

Event Date: 06-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: DevOps

Speaker(s): Kendra Little

Title: Why the Database is at the Heart of DevOps Success

Description:

As an Architect or Senior Developer, you need to deliver value to your customers more quickly than ever. Your software delivery pipeline can’t be held up by database changes.

Instead, you need to bring database changes into your Agile development practices and optimize these practices to find bugs well before they head to production. This means you must find ways of working that bridge longstanding silos between development and operations - even while teams are increasingly distributed across time zones and company cultures.

In this session, Microsoft Certified Master Kendra Little will show you how Redgate tools enable you to speed up software delivery with reliable, repeatable processes that remove the database bottleneck. Learn how you can empower your developers to innovate without sacrificing compliance, and bring DBAs into the SDLC early at critical review points.

SessionID: 98847

What’s new in SQL Server Tools

Back to calendar

Event Date: 06-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Vicky Harp, Udeesha Gautam

Title: What’s new in SQL Server Tools

Description:

Get sneak peeks of upcoming functionality for Azure Data Studio and the rest of the SQL Server tools to support the new capabilities of SQL Server, while also learning about the improvements that have shipped in the past year. Be the first to see some of the top requested features in their first public showing. Discover the value and benefits of SQL Notebooks, a new and exciting feature in Azure Data Studio, along with best practices on how to incorporate this feature into your day-to-day. Find out what’s to come for the evolving SQL Server tools suite.

SessionID: 92470

SQL Server Security from the Ground Up

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Kenneth Fisher

Title: SQL Server Security from the Ground Up

Description:

In the modern age, data is a company's most valuable asset and, unfortunately, data crimes are not only common, but on the rise. Because of this, everyone who works with SQL Server should have a basic understanding of database security.

Attend this session to learn the what, how, and why of database security. Learn what permissions, securables, and principals are. Learn how to manage database security. Most importantly, learn what the best practices are and why they are important. Your company's data is your responsibility, and after attending this session you can step up and help keep it safe.

This session is the first session in the Data Security Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92494

Hidden Differences Between Azure ML Products Revealed

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Ginger Grant

Title: Hidden Differences Between Azure ML Products Revealed

Description:

When searching for Azure ML [AML], the browser returns a number of different products. Which product do you want to use, when? Which is the appropriate tool for integrating with SQL Server or data in Azure?

AML Studio, Workspace, Pipeline and Service are different products which you can use to create or deploy a solution and they all start with AML. Understanding the differences between these products provides the information needed to be able to architect the appropriate solution in your environment. These session demos show how to create an end-to-end AML workflow to prepare data, create ML models, deploy models, and use data contained within SQL Server by integrating a number of tools including Databricks, Python, and Jupyter notebooks. Learn why you want to use AML Workspace for ML development collaboration, scaling, and management. Understand how to monitor ML models in production with AML Pipeline to organize releases and generate execution metrics.

SessionID: 93997

Journey to the Cloud: Planning the First Steps

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): John Morehouse

Title: Journey to the Cloud: Planning the First Steps

Description:

Every journey begins with a single step. This is true with any type of information technology project and moving to the cloud is no exception. With a cloud migration journey, that first step should be determining how to get there with a solid migration plan.

In order to build this migration, there are a lot of questions that need to be answered. Questions like “Who needs to be involved?”, “What region do we use?”, “How long will it take?”, and “What will it cost?” are a good starting point. While all of these questions can be overwhelming, forming a solid migration plan isn’t as hard as you’d think.

In this 75-minute session, we will help you answer these questions as we travel through the process of starting to create a solid migration plan. As we reach wrap up and reach our destination, you can take the answers and continue your journey to the cloud by attending the follow up session, “Choosing Your Cloud: Step 2 In Your Cloud Migration Journey”.

This session is the first session in the Cloud Migration Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98353

SQL Isn’t for Analysis: Why Everyone Needs OLAP Data Models

Back to calendar

Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Rob Collie

Title: SQL Isn’t for Analysis: Why Everyone Needs OLAP Data Models

Description:

In the world of data, everyone understands two fundamental truths: you have to store data, and you have to visualize it. Yes, you may have to perform some calculations, but those tasks generally fall to the storage layer (typically SQL) – and the results are then fed to the visuals in an “as-is” state.

Attendees of this talk will explore why this “storage and charts” mentality, while certainly pervasive, misses something spectacularly valuable: the power of a middle-tier modeling and calculation layer. Rob Collie will share lessons learned over two decades in the world of data. In this talk he will share case studies and clear explanations of why the middle tier creates value that would be impossible with the traditional two-tier model.

SessionID: 98650

How to Analyze JSON with SQL

Back to calendar

Event Date: 06-11-2019 10:45 - Category: Partner Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Kevin McGinley

Title: How to Analyze JSON with SQL

Description:

To thrive in today’s world of data, you must know how to manage and derive value from semi-structured data such as JSON to deliver valuable insight to your organization. If you’re an experienced data architect, data engineer, or data analyst, you’ve probably been exposed to semi-structured data such as JSON. IoT devices, social media sites, and mobile devices all generate endless streams of JSON log files. You can’t avoid handling JSON data, but it doesn’t have to be as hard as you might think.

In this session we’ll explore:

SessionID: 94016

SQL Server and Azure Data: What to Use When

Back to calendar

Event Date: 06-11-2019 10:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Bob Ward, Anna Hoffman

Title: SQL Server and Azure Data: What to Use When

Description:

Many organizations are faced with an aging or under-engineered data platform strategy. You may be thinking, should I move to the cloud? Should I migrate to the latest SQL Server? What does hybrid actually mean?

You need a plan for how to decide if, when, and how you should upgrade your systems, when to extend them to the cloud, what to keep on premises, and what can work in a hybrid fashion.

SQL Server, the leading database platform in the industry, now runs in your data center with SQL Server 2019, in the cloud with Azure Virtual Machine and Azure SQL Database and Managed Instance, or on the IOT Edge with Azure SQL Database Edge. Which one is right for you? Is it possible to use a combination of these?

In this session, you will learn how SQL Server is both the same and different across these platforms. You will walk away with information, guiding principles, and scenarios that will help you make informed decisions on which technology to use and when.

This session is the first session in the Modernizing with SQL Server 2019 Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92612

SSIS DevOps and Azure Containers

Back to calendar

Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Andy Leonard, Elizabeth Baron, Sreeja Pullagura

Title: SSIS DevOps and Azure Containers

Description:

Do you want faster turnaround and higher code quality for your SSIS projects, without disturbing your live environment?

Join Elizabeth Baron, Sreeja Pullagura, and Andy Leonard in a live demo as they show you what Continuous Integration and Continuous Delivery can look like for SSIS. First, we’ll explore how DevOps practices support CI/CD. We will then explore the pros and cons of supporting tooling including, GitHub, Bitbucket, tSQLt, Docker, DockerFile, Azure Container Instances, Azure Blob Storage, Azure Container Registry, Jenkins, and Azure DevOps Pipelines. And finally, we will leave you with code in GitHub you can take home and use yourself, as you begin your own CI/CD journey.

SessionID: 91876

Failure Prediction for Manufacturing Industry with SQL Server & R

Back to calendar

Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Andrea Martorana Tusa

Title: Failure Prediction for Manufacturing Industry with SQL Server & R

Description:

Working in manufacturing industry means that you must deal with product failures. As a BI or Data Scientist developer, your task is not only monitor and report product’s health state during its lifecycle, but also predict the likelihood of a fail in the production or delivery phase.?

Machine Learning techniques can help to accomplish this task. Starting from past failure data, we can build up a predictive model to forecast the likelihood for a product to fail or giving an estimate on its duration. And now it is possible to develop an end-to-end solution in SQL Server, because of the introduction of advanced analytics tools like R since release 2016. In this session, we start from the real case of a manufacturing company to create some predictive models: a) regression model; binary classification model, random forest.
The solution is built using SQL Server 2016, R and R services. On top of that, some reports are created to deliver the outcome to stakeholders

SessionID: 92683

Everyone Has a Story to Tell: Developing Your First Presentation

Back to calendar

Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Andy Yun

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

Description:

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: 98647

Do You Feel The Need … The Need for Speed? Top Five SQL Server Query Tuning Tips

Back to calendar

Event Date: 06-11-2019 10:45 - Category: Partner Session (75 minutes) - Track: Development

Speaker(s): Janis Griffin

Title: Do You Feel The Need … The Need for Speed? Top Five SQL Server Query Tuning Tips

Description:

Query tuning is key to peak performance in SQL Server databases. However, lots of developers and DBAs constantly struggle to pinpoint the root cause of performance issues and spend way too much time in trying to fix them.

In this presentation, I will share my tried and true best practices for tuning SQL statements and other issues by utilizing Wait Time Analysis, reviewing execution plans and using SQL diagramming techniques. In addition, several case studies will be used to demonstrate these best practices.

Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct tuning path with no guessing, saving countless hours of tuning queries and optimizing performance of your SQL Server databases.

Learning objectives: • Learn how to effectively use wait types to quickly identify bottlenecks and get clues on the best tuning approach • Quickly identify inefficient operations through review of query execution plans • Learn how to use SQL diagramming techniques to find the best execution plan

SessionID: 91786

Inside Kubernetes - An Architectural Deep Dive

Back to calendar

Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Anthony Nocentino

Title: Inside Kubernetes - An Architectural Deep Dive

Description:

In this session we will introduce Kubernetes, we’ll deep dive into each component and its responsibility in a cluster. We will also look at and demonstrate higher-level abstractions such as Services, Controllers, and Deployments, and how they can be used to ensure the desired state of an application and data platform deployed in Kubernetes. Next, we’ll look at Kubernetes networking and intercluster communication patterns. With that foundation, we will then introduce various cluster scenarios and high availability designs. By the end of this session, you will understand what's needed to put your applications and data platform in production in a Kubernetes cluster.

SessionID: 99092

Introduction to PASS Summit 2019

Back to calendar

Event Date: 06-11-2019 12:30 - Category: Marketing Community Session (45 minutes) - Track: Professional Development (Other)

Speaker(s): Kevin Kline

Title: Introduction to PASS Summit 2019

Description:

Feeling overwhelmed by all that PASS Summit 2019 has to offer?

Kevin Kline welcomes both our first-timers and seasoned veterans alike in this introduction to PASS Summit 2019. The session provides attendees with a general overview of the conference and related events.

SessionID: 91462

Introducing SQL Server 2019 Big Data Clusters

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Big Data

Speaker(s): Ben Weissman

Title: Introducing SQL Server 2019 Big Data Clusters

Description:

In the realm of data storage and processing, there are two major technologies which we deal with every day. On one side, we have relational data that is stored inside SQL Server, and on the other side, non-relational or very large datasets that do not fit the relational model which are stored on big data clusters like Hadoop or Spark.

This introduces challenges when having to combine datasets across both these technologies. SQL Server was never built to process huge datasets in a distributed fashion or to handle non-relational data very well, meaning that in many cases you would have to resort to bringing your relational data into Hadoop or Spark clusters. SQL Server 2019 has the answer with Big Data Clusters: it combines SQL Server with HDFS and Spark!

In this session we are going to explore the capabilities of the exciting new feature called SQL Server Big Data Clusters. How does it work and how can we work with datasets that are non-relational?

SessionID: 93577

An Introduction to Data Visualizations and Design Best Practices

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Prathy Kamasani

Title: An Introduction to Data Visualizations and Design Best Practices

Description:

As the value of data is being recognized across the world, the ability to communicate data to your audience effectively is becoming a sought after skill for professionals. Thankfully, effective data visualization is not only a skill for artists and designers, anyone can improve their data presentation by choosing the right visuals and following best practices.

In this session, we will discuss how different types of visuals are perceived and which charts are best suited to each category. We’ll cover a basic introduction into colour theory, how to use colour effectively in reports, and how to create Power BI themes for your enterprise. Finally, you will learn an introduction to the design approach and how it helps us to tell a good data story.

This session is the first session in the Data Visualization and Storytelling Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92080

Encrypting Data Within SQL Server

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Data Governance/Privacy

Speaker(s): Thomas Norman

Title: Encrypting Data Within SQL Server

Description:

Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data?

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption, and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption. Also, let’s learn how to classify data which should be protected and how to audit sensitive data usage.

You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.

SessionID: 92181

SQL Injection: What Is It, Prevent It, Monitor For It!

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Grant Fritchey

Title: SQL Injection: What Is It, Prevent It, Monitor For It!

Description:

This session will explain and demonstrate exactly how a SQL Injection attack occurs. While the core vulnerability is easy to understand, exactly how hackers exploit that vulnerability is not. I'll show you how a hacker explores your database through SQL Injection to find vulnerabilities and sensitive data. Better still, I'll show you the errors that this exploration generates, providing a mechanism for monitoring your systems to identify SQL Injection attacks. Finally, I'll show you the steps you should be taking to properly secure your systems in order to completely avoid SQL Injection attacks. SQL Injection is considered the primary vulnerability for most systems today. Learn how to protect yourself and your organization.

SessionID: 92818

SQL PowerShell 2019: The Lingua Franca for the Data Platform

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Aaron Nelson

Title: SQL PowerShell 2019: The Lingua Franca for the Data Platform

Description:

Let’s say that you need to import an entire database from Excel, or migrate a schema to Azure SQL Database. It used to be that for each product, you needed a different tool to talk to it. Now you can talk to all of them with PowerShell.

In this presentation, we’ll see how we can move smoothly from Azure Data Studio, to SQL Server, to Azure SQL Database, to Excel. And we’ll do it all with a single tool, PowerShell. We’ll also see how we can take an object-based approach to working with data. In doing so, we’ll be speaking PowerShell’s native language, objects. We’ll also cover how you can make your document your PowerShell code, as well as make it reusable by your coworkers, with PowerShell Notebooks.

By the end of this session, you’ll see how easily PowerShell integrates with many of the Microsoft data products. You’ll understand how to integrate between different data products. You’ll also know how to use PowerShell Notebooks to save the PowerShell work you build, and share it with your coworkers.

SessionID: 93579

Successfully Communicating with Peers and Colleagues

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Kevin Kline

Title: Successfully Communicating with Peers and Colleagues

Description:

What sets apart the most credible, trusted, and influential members of an IT team from the rest? What habits and behaviors do they exhibit that result in being treated with respect, while other team members of equal technical skill on the same team are virtually ignored? While data professionals are often analytical and data-driven in our work, we are rarely systematic about interpersonal communication and soft skills. This session will teach you how to bridge those gaps.

One of the most fundamental practices among successful data professionals is self-awareness. We will help, through personality profiles like DISC, MTBI, and StrengthFinder, to reveal your own preferences, strengths, and weaknesses. With that foundation, we move to best practices in communication, such as listening and questioning skills. Finally, we cover a variety of difficult conversations and common conflicts and the communication techniques that help navigate those situations successfully.

These lessons, in turn, build your confidence and influence in interpersonal situations, while enabling you to personally achieve new heights of productivity and greater personal effectiveness.

This session is the first session in the Communication for Technical Professionals Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 91771

TDE, Encryption, and Compliance With Azure Key Vault Zero To Hero

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Danny Ravid

Title: TDE, Encryption, and Compliance With Azure Key Vault Zero To Hero

Description:

GDPR? FISMA? ePrivacy? PIPEDA? If these words are giving you a headache you are not alone.

In this session, we will learn from start to finish how to make your data secure and compliant with SQL Server TDE and Encryption using Azure Key Vault from the very basics to the more advanced stuff. We will demo an end to end solution, focusing on the complexities, pitfalls and best practices. We will also cover AlwaysON scenarios and Hybrid Cloud Scenarios.

SessionID: 93578

An Introduction to AI for Everyone

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Melody Zacharias

Title: An Introduction to AI for Everyone

Description:

This session will give you a solid foundation for learning more about AI. During this session, we will cover the 5 questions data science answers for us. We will explore the nuances between AI vs. ML, Cognitive Services vs. Data Science, how they are used, and what that means to your career. AI is intertwining its way into many things we do in technology. This expanding ecosystem is already in our workplace, let's understand how we can leverage it.

We will explore the business use cases that can be solved using Machine Learning and how that can prepare you to be ready to take the next step. We will consider some of the latest releases from Microsoft and how they impact the way we work with AI.

By exploring and explaining the ecosystem, we will gain a deep-rooted understanding to set you on your way to discovering all that AI has to offer.

This session is the first session in the AI for Everyone Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98834

Microsoft Power BI: Business Intelligence Strategy, Vision, and Roadmap Update

Back to calendar

Event Date: 06-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Patrick LeBlanc, Amir Netz, Will Thompson

Title: Microsoft Power BI: Business Intelligence Strategy, Vision, and Roadmap Update

Description:

Power BI enables organizations to do more with their data. Join Microsoft's Business Intelligence leadershipteam to get the latest information about Microsoft's strategy, vision, and roadmap for Power BI and o check demos of the latest and greatest features in our Enterprise BI platform.

SessionID: 99186

SQL Server Performance Analysis Powered by Machine Learning

Back to calendar

Event Date: 06-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Database Administration

Speaker(s): John Maxwell, Chuck Priddy

Title: SQL Server Performance Analysis Powered by Machine Learning

Description:

This session includes an overview and demo of database performance mitigation, focusing on wait times. We’ll also discuss query performance analysis not based on user set thresholds, but machine learning algorithms that learn about database instances over time to determine both positive and negative anomalies.

We’ll walk through performance issues in an Azure SQL Database to determine where the problem or problems exist and how to best resolve them.

SessionID: 91220

Packaging Permissions in Stored Procedures

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Erland Sommarskog

Title: Packaging Permissions in Stored Procedures

Description:

Have you ever been in the situation where you want a user to be able to perform a privileged action, but you do not want to grant the user the permission needed, because that would permit the user to do a lot more? Maybe you have tried putting the action in a stored procedure, and if it is just a matter of plain DML, that works. But, you find that there are many situations where it fails; for instance when server permissions are needed. Or, for that matter, when your procedure uses dynamic SQL.

In this session, you will learn how you can package database or server permissions in a stored procedure in a very fine-grained way, by using certificate signing or the EXECUTE AS clause. You will learn that one is better than the other, and that for server permissions, certificate signing is the only choice. As a side note, you will learn why making a database TRUSTWORTHY is a security risk. In the session materials you will get some scripts for automating certificate signing.

SessionID: 98354

Modern Excel: The Supercomputer Hiding on Everyone’s Desktop

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Big Data

Speaker(s): Rob Collie

Title: Modern Excel: The Supercomputer Hiding on Everyone’s Desktop

Description:

Did you know that Microsoft has quietly been turbocharging Excel by integrating industrial-strength Business Intelligence and Reporting engines into it? Did you know that these new capabilities are 100% built for YOU, and that you can be successful with them in your first day? This session will empower attendees with absolutely game-changing Excel-based tools that dramatically accelerate data-driven decisions.

In this session, attendees will experience an end-to-end walkthrough of these tools, including multi-data source import, rapid data shaping and cleansing, the creation of “portable” formulas that can be re-used across all subsequent analysis, and the construction of insightful reports and dashboards.

SessionID: 98848

Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations

Back to calendar

Event Date: 06-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Pam Lahoud

Title: Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations

Description:

Have you ever stared at your database wondering if that transaction will ever finish rolling back? Maybe you rebooted the server to see if it would help and then the database was in recovery for hours? Gave up on index rebuilds because you can’t possibly get them done in a single maintenance window?

If this sounds familiar, this session is for you! Learn about two innovations in SQL Server 2019 and Azure SQL Database – Accelerated Database Recovery and Resumable Operations – that will help you meet even the strictest SLAs by reducing startup and maintenance time and increasing up-time.

SessionID: 94005

SQL on Linux

Back to calendar

Event Date: 06-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Database Administration

Speaker(s): JP Chen

Title: SQL on Linux

Description:

You are interested in running SQL on Linux but you don’t know how to get started.

In this presentation, we will share with you the software and hardware you need. We will walk you through the steps on installing and configuring VirtualBox, Ubuntu Server, PUTTY, SQL Server 2019 on Ubuntu. We will review the basic administration steps such as start and stop the SQL Server services on Linux, backup and restore a database on Linux and check CPU usage, disk i/o, and disk space.

By the end of the presentation, you will have the required knowledge to set up your own lab and continue your journey on further learning of SQL on Linux.

SessionID: 90961

Cosmos DB Develop Locally Deploy Globally

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Jim Dorame

Title: Cosmos DB Develop Locally Deploy Globally

Description:

CosmosDB is Microsoft’s globally distributed, massively scalable, cloud based database that is hosted in AZURE. Who cares? You should if you need to support thousands of transactions a second, global distribution and redundancy, and different consistencies.

Do you need to support JSON, Graph, et al? Done. Join me and see how easy it is to get started. We will set up a local instance of CosmosDB, load JSON data, and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for. At the end of the session, you will then learn how, with a couple of commands, to switch your visualization to the cloud.

SessionID: 91014

Removing the SELECT *: Helping your App Developers and Yourself

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Chris Woodruff

Title: Removing the SELECT *: Helping your App Developers and Yourself

Description:

Finding slow queries against your database? Want to make the application developers better with their operations on the database? Want to make yourself more valuable by understanding the ways applications impact the databases you support?

All this and more will be discussed during the talk. Get to know ORM frameworks like Entity Framework along with C# LINQ statements, and how they perform operations to get, create, and update data. The knowledge taken away from this talk will help you become a better data developer!

SessionID: 92752

How I Would Attack SQL Server

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Brian Kelley

Title: How I Would Attack SQL Server

Description:

This isn’t a talk about best practices or how to configure your system. It’s designed to get into the mindset of a motivated, equipped adversary who wants to get in to a system or application, specifically SQL Server, and uses the full extent of his or her creativity to do so. We’ll look at both traditional and non-traditional weak points, how an attacker discovers them, exploits them, and then covers up his or her tracks. We’ll also discuss what we can do to compensate for a weakness we can’t fix, which revolves mostly around detection and response and how an attacker will respond to such countermeasures.

This session is the second session in the Data Security Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 91929

Build Your Brand with Technical Writing

Back to calendar

Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Kathi Kellenberger

Title: Build Your Brand with Technical Writing

Description:

Have you considered writing an article or even a book but didn’t know how to get started? Have you wondered if writing is worth the time and effort?

Being a technical writer can help you build you brand and get noticed. It might lead to that next job opportunity or help you get consulting clients. Not only that, people from around the world can learn from what you write – you will be making a difference! Attend this session to learn about the publishing process, and how writing can propel your career.

SessionID: 94051

SQL Server 2019: Your Next Modern Data Platform

Back to calendar

Event Date: 06-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Bob Ward

Title: SQL Server 2019: Your Next Modern Data Platform

Description:

In this session, we will cover the complete set of features and capabilities in SQL Server 2019. Want your queries to run faster with no application changes or watch your database recover in seconds? Need to connect to Oracle, CosmosDB, or Azure without moving data? Making a move to SQL Server 2019 could be the right choice for you.

SQL Server 2019 represents the next evolution of the leading database platform in the industry. "This is not your grandpa's SQL Server" says Travis Wright. Whether it is Big Data Clusters with Hadoop and Spark, Java, Linux, Containers, or Kubernetes. Pedro Lopes says it still is "Your grandpa's SQL Server" because of Intelligent Performance, Mission Critical Availability, and Security. Who is right? Come to this session and see for yourself.

This session is the second session in the Modernizing with SQL Server 2019 Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 95865

Aggregations in Power BI

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Gabi Münster, Thomas Martens

Title: Aggregations in Power BI

Description:

Microsoft released a major feature to enable the high-performance analysis of large amounts of data in a manageable way by implementing Aggregations in Power BI (Power BI Desktop Release October 2018).

This feature is well known and used as an important performance optimization feature of Analysis Services Multidimensional. Compared to this the Aggregations available in Power BI offer a much more user-friendly and intuitive way of approaching this goal. But is this feature as powerful as the "mighty brother"? And is the handling still as easy under some closer inspection?

During this session, we will compare Aggregations in different Analysis Services engines and will highlight similarities and differences. In addition, we will dive into architectural approaches for implementing Aggregations in Power BI. We will point out strengths and weaknesses of different services and components to achieve a holistic analytical solution.

SessionID: 96396

Creating Success as a Data Entrepreneur

Back to calendar

Event Date: 06-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Professional Development (Other)

Speaker(s): Adam Jorgensen

Title: Creating Success as a Data Entrepreneur

Description:

Discover what it takes to step out on your own. The fact is that the majority of new businesses fail. Being a technical expert is not enough to guarantee business success. You need a plan to avoid burnout, create opportunities, close deals, manage your business, and grow your brand.

This session will deliver the four key things you will need to get started:

• Identify your goals and priorities – Your new business needs to serve your goals. • Choose right type of business for you – Work alone, grow a team, create an empire? It’s up to you! • Create your launch plan! – Transition and accelerate to an independent career, let’s do it! • Accelerate your business and your brand – Learn to make these goals work together!

Join this half day session to understand everything it takes to step out on your own. We’ll cover:

• What makes a truly successful business – for you. • Common pitfalls to avoid. • How to build your customer pipeline. • How to build your brand while growing your business. • Creating and managing essential business functions/assets (i.e. standard service contracts). • How and when to grow your team. • How to do this all while keeping customers happy and not losing your mind.

You will leave this session with step by step guidance to becoming a successful entrepreneur in the data industry.

SessionID: 92723

Head to Head: SSIS Versus Azure Data Factory

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Tim Mitchell

Title: Head to Head: SSIS Versus Azure Data Factory

Description:

Anyone working in the SQL Server ecosystem has likely heard of both SQL Server Integration Services (SSIS) and Azure Data Factory (ADF). Both of these are used to move and transform data, and are both very capable and mature tools. But how do the two compare to each other? How does one determine which is better for a given task?

In this session, we will do a head-to-head comparison of SSIS and ADF. We'll compare the features of each of these tools, calling out the functionality common to both as well as the behaviors exclusive to one or the other. We will discuss the benefits and the challenges of working with SSIS and ADF, exploring topics including: performance, ease of administration, monitoring and troubleshooting, and cost. Finally, we will wrap up with demos showing practical examples of using SSIS and ADF in the real world.

SessionID: 94120

Azure Storage Options for Analytics

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Dustin Vannoy

Title: Azure Storage Options for Analytics

Description:

Storage options for Analytics are not one size fits all. To deliver the best solution, you need to understand the use case, performance requirements, and users of the system. This session will break down the options you have in Azure to build a data analytics ecosystem, and explain why everyone's talking about data lakes and where's best to build your data warehouse. We will cover the fundamentals of data lakes and modern practices in cloud data warehousing. Attendees will leave the session with a firm grasp of how each data storage option can be used and which is appropriate for different analytics scenarios.

Data Lakes in Azure: • Why Data Lakes? • Common Data Lake Structures and Best Practices • Storage options for Data Lakes: o Blob Storage o ADLS Gen o ADLS Gen 2

Databases in Azure: • Why we still need analytics databases • Storage options for Analytics: o Azure SQL DB o Cosmos DB o Azure SQLDW

Analytics Layers in Azure: • Azure Analysis Services • PowerBI

This session is the second session in the Becoming an Azure Data Engineer Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92675

Dr. DMV's Troubleshooting Toolkit

Back to calendar

Event Date: 06-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Database Administration

Speaker(s): Glenn Berry

Title: Dr. DMV's Troubleshooting Toolkit

Description:

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: 94074

Understanding Execution Plans

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Erin Stellato

Title: Understanding Execution Plans

Description:

If you have struggled to understand why a query takes too long to execute, or don’t know where to start when a query requires a lot of I/O or consumes significant CPU, then we should talk about execution plans. When you write a query for SQL Server, you are asking the engine to return a specific set of data, but the optimizer decides how to get that information; an execution plan provides details about what SQL Server decided to do, and it’s a great place to start to understand why a query may not perform as you hoped or expected.

This session will include numerous demos that show:

In the demos we will also highlight other valuable information in a plan and how to identify potential problems. You will leave the session with practical information about execution plans that you can put to use immediately when you’re back at your desk and looking at a query that just didn’t run the way you anticipated.

This session is the first session in the SQL Performance for Developers Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98664

Azure SQL Database Managed Instances: A Beginner’s Guide – the Pros, the Cons, and the Gotchas

Back to calendar

Event Date: 06-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Database Administration

Speaker(s): Martin Wild, Peter O'Connell, Denis O’Sullivan

Title: Azure SQL Database Managed Instances: A Beginner’s Guide – the Pros, the Cons, and the Gotchas

Description:

Migrating your instance from on-premise to PaaS can seem like a leap too far for many DBAs. Fear, uncertainty, and doubt can consume any business, financial or technical advantages that might be gained as you worry about what, and how many, changes would be required to ensure the databases and applications continue to perform and function as designed.

Azure SQL Database and Azure Managed Instance are marketed as a cloud offering that allows DBAs to lift-and-shift their on-premise SQL Server instances to the cloud with minimal changes required to the application and database while giving you all the benefits of PaaS. An Azure Managed Instance is essentially a cloud-based version of an on-premise SQL Server instance. Databases share resources allocated to the Managed Instance and the databases in the instance are managed collectively. This is appealing to DBAs as it is familiar and reduces the learning curve involved, as well as reducing the risk of incorrectly sizing your PaaS environment.

In this session, we will explore the advantages and disadvantages Azure Managed Instances have over the other PaaS offerings and on-premise, the different sizing and offerings, and the inevitable gotchas that we incur when tackling a significant migration such as this.

SessionID: 99155

A Deep Dive into Persistent Memory Features in SQL Server 2019

Back to calendar

Event Date: 06-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Database Administration

Speaker(s): Bob Ward, Sridharan Sakthivelu

Title: A Deep Dive into Persistent Memory Features in SQL Server 2019

Description:

Do you think Hybrid Buffer Pool is a new way to do eco-friendly swimming? Or if Enlightenment is a new diet fad? Let us help set the record straight.

Come to this session featuring Intel’s Sri Sakthivelu and Microsoft’s Bob Ward to learn about the new persistent memory aware features coming in Microsoft SQL Server 2019. We will cover the technical details of what these features are, what hardware and software you need to use them, what Intel® Optane™ DC persistent memory is, how to configure your OS and databases to use these features, and how these new features provide benefits to your applications.

SessionID: 98842

Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory and Azure SQL Database Managed Instance

Back to calendar

Event Date: 06-11-2019 15:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Leo Li

Title: Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory and Azure SQL Database Managed Instance

Description:

Accelerate the migration of legacy SQL Server to the cloud with SQL Server Integration Services (SSIS) using Azure Data Factory (ADF). Learn how to provision Azure-SSIS Integration Runtime (SSIS-IR) and extend it with custom and 3rd party components. Discover how to run SSIS packages stored in file systems as first-class activities in ADF pipelines and how to access Azure SQL Database Managed Instance with OLEDB connectors configured for Azure Active Directory (AAD) authentication and Virtual Network (VNet).

In addition, learn how to get started with the complete SSIS Migration Playbook to perform batch package assessments, and batch package and job migrations using Data Migration Assistant (DMA) and Data Migration Service (DMS).

SessionID: 92794

Innovative Data Modeling for Cool Data Warehouses

Back to calendar

Event Date: 06-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Business Intelligence and Data Warehousing

Speaker(s): Jeff Renz, Leslie Weed

Title: Innovative Data Modeling for Cool Data Warehouses

Description:

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: 92233

Everything You Wanted to Know About Implementing Temporal Tables

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Ben Miller

Title: Everything You Wanted to Know About Implementing Temporal Tables

Description:

Have you ever wanted to know what the data looked like yesterday before or after a change was made? Have you cringed at the thought of creating triggers to capture data changes for analysis in the future? Looking at a new feature in SQL 2016 called Temporal Tables gives you the ability to create a table that automatically keeps track of your data in time. Magic was never meant to be part of IT, but SQL Server has done a great job with this new feature. You will learn how to set it up on a new table or an existing table, how it works in practice, and querying the tables including the history table using new syntax. Coverage of version 2016 through what is coming in SQL 2019, including Retention Policies. Join me in a time travelling adventure to find out how you can leverage Temporal Tables in your world.

SessionID: 92481

Working with SQL Server Containers to Build Database Solutions

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Carlos Robles

Title: Working with SQL Server Containers to Build Database Solutions

Description:

Containers are no longer the future, they are the present and are here to change the way DBAs used to think about building SQL Server solutions. Spending long periods of time installing, configuring, and preparing databases and SQL Server instances is no longer the case with containers.

In this session, you will learn the basic and advanced methods to deploy a SQL Server solution using containers in minutes. We will explore the options and tools (open source) we have available when working with SQL Server running on Docker containers through real world scenarios, like backing up\restoring databases, high availability, version upgrades, and the most important portability between cross platforms.

SessionID: 91875

Spatial Analysis with SQL Server, R and Power BI

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Andrea Martorana Tusa

Title: Spatial Analysis with SQL Server, R and Power BI

Description:

In the session, we will show how the joint use of these three tools empowers us to analyze and query the spatial properties of data, by showcasing a real-world example. Come, have fun, and discover a world of information inside your data with spatial analytics!

SessionID: 92505

Scaling Clustered Column Store Indexes

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Thomas Grohser

Title: Scaling Clustered Column Store Indexes

Description:

Clustered Column Store Indexes are a great tool when used correctly. This session will explain on how to plan, configure, and operate Clustered Columstore indexes to handle trillions of rows. This is done with a real world example that is in production. Avoiding mistakes in the beginning will save you lots of data wrangling over time.

Come and learn how to partition, select the right datatypes, and insert the data into a Clustered Column Store Index.

SessionID: 94014

A Behind the Scenes Look at ML, AI, and Deep Learning

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Anna Hoffman

Title: A Behind the Scenes Look at ML, AI, and Deep Learning

Description:

There’s a lot of hype going on around ML, AI, and Deep Learning. But how does it work? How does the process overlap between the three? What is the magic happening behind the scenes that is allowing for all these new advanced models to be created?

In a continuation of the AI learning pathway, we’ll dive a bit deeper and explore the basic mechanics of how ML, AI, and Deep Learning work. At the end, you will be able to differentiate between the three, as well as understand the concepts of what’s happening under the hood.

After this session, you will have some fundamental information that will help you make decisions and support your organization. Depending on your role, you may be interested in the other sessions in this pathway, diving into specific scenarios for developers, DBAs, and analysts/BI professionals.

This session is the second session in the AI for Everyone Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92364

Never Lose Data: Digging Out From Corruption

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Eddie Wuerch

Title: Never Lose Data: Digging Out From Corruption

Description:

A "Disaster" doesn't need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA's toolbox, and will enable you to prepare for, detect, and repair a variety of corruption-based problems.

SessionID: 92719

SQL Notebooks in Azure Data Studio for the DBA

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Rob Sewell

Title: SQL Notebooks in Azure Data Studio for the DBA

Description:

An Azure Data Studio recent release introduced SQL Notebooks as a capability. While you might have read about notebooks being used for data science, this session is primarily for DBAs.

We will cover installing Azure Data Studio, what a SQL Notebooks is, and numerous use cases for you to use SQL Notebooks in your daily workload such as creating a Notebook for Glenn Berry's Diagnostic queries.

And some gifs ;-)

SessionID: 93998

Choosing your Cloud: Step 2 in your Cloud Migration Journey

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Johan Ludvig Brattås, Rune Ovlien Rakeie

Title: Choosing your Cloud: Step 2 in your Cloud Migration Journey

Description:

You have now completed the most important part of your cloud journey. You have defined your key goals for the cloud migration that will govern your journey moving forward and have in your hand a solid cloud migration plan.

You are now ready for the next step: choosing your cloud.

In this talk we will look at this step from two different angles; migration of your OLTP system and migration of your BI-stack.

From both angles we will: • Look at the vendors strengths • Which tools and services do they offer to help with your cloud migration • How to map your on-premises services with equivalent cloud services • Benefits and challenges with a single cloud vendor

We will cover all this and more, to help you to prepare you for the next step, implementation into your best suited cloud platform(s).

This session is the second session in the Cloud Migration Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 93999

Linux Fundamentals for SQL Server DBAs

Back to calendar

Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Hamish Watson

Title: Linux Fundamentals for SQL Server DBAs

Description:

When Microsoft released SQL Server 2017 it allowed data professionals to run SQL Server on Linux and in containers, providing a wider and more open platform to deploy and run SQL Server.

This session will reveal the parts of SQL Server on Linux that will be familiar for data professionals, and also highlight and discuss the differences. The top Linux commands that SQL Server DBAs should know will be discussed and demonstrated as well as a close look at the Linux file system.

This session will incorporate a demonstration that will showcase the fundamentals of Linux management and demonstrate how to install, configure, manage, and monitor SQL Server on it.

This session will help you understand the basics and will present the exciting future of SQL Server on Linux.

This session is the first session in the Linux for SQL Server Professionals Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92229

I Want To Go Faster! An Introduction to Indexing

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Bert Wagner

Title: I Want To Go Faster! An Introduction to Indexing

Description:

Have you ever added an index to improve performance, but instead experienced little (or no) improvement and were left wondering where you went wrong?

In this session, you will learn how to create performance improving indexes from the ground up. We will discuss how to identify when a performance problem is due to a missing or poorly defined index, the secrets that allow indexes to make your queries run faster, and examples of how to correctly build indexes for common querying scenarios.

Whether you are a developer looking to make your application queries run faster, or a new DBA wanting to speed up those index-lacking tables you inherited, this introduction to indexing will have you covered.

This session is the second session in the SQL Performance for Developers Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 99548

The Emerging Role of BI in your Organization

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Patrick LeBlanc, Ginger Grant, Warren Sifre, Jonathan Stewart, Reid Havens

Title: The Emerging Role of BI in your Organization

Description:

Configure your existing infrastructure for BI. A panel discussion on how to leverage the power platform to maximize BI features and value. More details to come...

SessionID: 98849

Microsoft Data Engineering Unplugged

Back to calendar

Event Date: 06-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Denny Cherry, Erin Stellato, Bob Ward, Mike Flasko, Asad Khan, Rie Irish, Slava Oks, Arun Ulagaratchagan

Title: Microsoft Data Engineering Unplugged

Description:

SessionID: 92793

A Game of Hierarchies: Graph Processing with SQL Server 2019

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Markus Ehrenmueller-Jensen

Title: A Game of Hierarchies: Graph Processing with SQL Server 2019

Description:

Hierarchies and graphs are the bread and butter of most business applications and you find them almost everywhere:

SessionID: 92219

SQL Server Machine Learning Services in Production

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Kevin Feasel

Title: SQL Server Machine Learning Services in Production

Description:

Writing code which uses SQL Server Machine Learning Services is easy enough, but that's just the beginning of the story. In this talk, we will cover the rest of the R development story for database administrators. We will look at the methods available to install and maintain R packages, learn good practices for deploying and maintaining custom SQL Server Machine Learning Services code, and learn where to find critical information when things break. These battle-tested tips will make it easier for you to integrate R and SQL Server Machine Learning Services in your existing deployment processes and get the most out of this feature.

SessionID: 98850

SQL Server and Azure SQL Database Intelligent Query Performance

Back to calendar

Event Date: 06-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Development

Speaker(s): Joe Sack, Pedro Lopes

Title: SQL Server and Azure SQL Database Intelligent Query Performance

Description:

As part of the Intelligent Query Processing family, SQL Server 2019 and Azure SQL Database introduce ground-breaking enhancements. These enhancements make up the latest in Microsoft’s mission to improve critical parallel workloads when running at scale while remaining adaptive to the ever-changing landscape of data. Join us in the intelligent database world that started with SQL Server 2017 and takes a leap forward with the upcoming SQL Server 2019 and Azure SQL Database.

SessionID: 92119

Cosmic DBA - Cosmos DB for SQL Server Admins and Developers

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): MIKE DONNELLY

Title: Cosmic DBA - Cosmos DB for SQL Server Admins and Developers

Description:

NoSQL is not just about having eventual consistency. Switching from a relational database to a NoSQL data store like Cosmos DB is a mind shift for SQL DBAs and developers used to thinking in terms of tables. Schema-free doesn’t mean you don’t have to think about the schema, but it does allow for faster changes and some interesting design patterns.

This session will include a quick outline of Cosmos DB. Then it will move on to describe how indexing works, what the consistency levels all mean, and how your JSON should be designed based on your query patterns. And, I will toss in a high-level overview of the JavaScript triggers, stored procedures, and user defined functions for free. All of this will be presented using examples that are informed by my experience converting a global application from SQL Server to Cosmos DB using the document model.

SessionID: 96395

From Data Munging to Wrangling - 7 Steps to Mastering Data Preparation for Data Science

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Natasha Balac

Title: From Data Munging to Wrangling - 7 Steps to Mastering Data Preparation for Data Science

Description:

Data is at the heart of all Artificial Intelligence (AI) systems. Data is crucial in training, testing, validating, and evaluating machine learning algorithms. As the popularity of AI/ML continues to rise due to the combination of plentiful cloud computing and the availability of big data to train machine learning models, so does the need for good quality data. The more quality data used to train the algorithms, the higher predictive power trained machine learning models can deliver. This is why there are numerous studies, surveys, and reports indicating that most data scientists spend the majority (as high as 80%) of their time on data preparation and cleaning data.

Data cleaning and preparation is a critical step in any machine learning project. Preparing data judiciously and accurately is crucial in order to enable successful machine learning projects. Before utilizing data to train a machine learning model, it’s important to ensure that it is clean, consistent, and accurate.

In this session, we will provide an overview of steps and techniques for sourcing, preparing, transforming, and cleaning data for data science projects, and best practices for building effective data preparation implementation.

SessionID: 98646

A new Breed of Storage for SQL Server – Level up your DevOps!

Back to calendar

Event Date: 06-11-2019 16:45 - Category: Partner Session (75 minutes) - Track: DevOps

Speaker(s): Shawn Meyers, Rob Girard

Title: A new Breed of Storage for SQL Server – Level up your DevOps!

Description:

The best test infrastructure perfectly mimics production. Lowering the time to refresh data and time to run tests while increasing concurrency of tests leads to faster and more accurate development. Isolation is key to safe testing, but often leads to a great divide between how closely test & staging environments resembles your production environment. And without that isolation, the risks of something as simple as a wrong path in a script can easily bite you when it hits the wrong environment…. you didn’t need that production data anyway, did you?

Refreshing your development databases doesn’t have to be a complex operation and should be an easy option for DBAs to perform on their own. This should be extremely fast and non-impactful to both Prod and Dev systems. Don’t let the size of your data sets dictate the time it takes to refresh; and don’t take shortcuts in testing that could jeopardize your live data set.

The right infrastructure & software are at the heart of an efficient DevOps strategy. Virtualization and automation technologies make possible what was a mere dream in not too distant past. This session will shed light on new technology to include in your DevOps toolkit; technologies that enable simple & efficient automation workflows. Learn about past, current and future storage technologies available and what next-gen storage infrastructure can enable within your organization.

Tips and tricks shared in this session can be used to augment and improve what you do today, allowing you to keep up with what’s around the corner tomorrow. Stop supporting your infrastructure and let your infrastructure support you!

WARNING: Attending this session may lead to higher expectations of how your infrastructure should be supporting you.

SessionID: 92431

Hidden Gems of SQL Server 2019

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Denis Reznik

Title: Hidden Gems of SQL Server 2019

Description:

SQL Server 2019 is full of new features and improvements. The main "Killer" features of SQL Server 2019 are Big Data Cluster, Truncation error message improvement, Java support, Intelligent Query Processing, etc. And in this session, we will not talk about them. We will not do that just because there are a lot of cool features in SQL Server 2019, which are more hidden from our site and are not getting enough attention.

In this session, we will learn a lot about these features and improvements. Which features? That's a secret :) Come to the session and discover them with me!

SessionID: 91064

Handling Role Playing Dimensions in Tabular Models

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Brian Larson

Title: Handling Role Playing Dimensions in Tabular Models

Description:

Most data models contain at least one situation requiring role playing dimensional behavior. For example, order date, ship date, and invoice date all linked to the date table. The tabular model, available in Power BI, Power Pivot, and SQL Server Analysis Services, provides multiple methods for handling role playing dimensions.

In this session, we will implement examples of each of these alternatives, including the DAX expressions required to fully exploit each one. We will explore the strengths and weaknesses of each approach as well as best practices when implementing each of these alternatives. Special emphasis will be given to model maintainability, as well as the experience created for users exploring and analyzing the model.

SessionID: 90993

Managing your Data Platform Lifecycle

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Data Platform Strategy

Speaker(s): John Martin

Title: Managing your Data Platform Lifecycle

Description:

The SQL Server 2005, 2008, and 2008 R2 end of life were painful events for many businesses around the world. Having to deal with large numbers of databases and servers that needed to be upgraded or migrated along with their applications. But, how do we avoid this happening for SQL Server 2012?

Proactively managing the lifecycle of your SQL Server and larger data platform is becoming vital in order to deliver solid data platform solutions. Ranging from planning through to implementation, we will look at how to define a lifecycle that helps you avoid large legacy or highly fragmented estates. By the end of this session, you will be in a position to go back to your business and start building your own data platform roadmap and lifecycle.

SessionID: 92462

Query Optimization Statistics: Driving Force Behind Performance

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Vern Rabe

Title: Query Optimization Statistics: Driving Force Behind Performance

Description:

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 some general guidelines for their maintenance. Then we’ll look at some of the issues (how to find them, and how to solve them) 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, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.

SessionID: 92331

Protect your Data by Design: Creating a Data Masking Strategy

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Data Governance/Privacy

Speaker(s): Christopher Unwin

Title: Protect your Data by Design: Creating a Data Masking Strategy

Description:

Data Breaches are seemingly neverending in today's world with new ones coming to light every single day. To try and mitigate the fallout of a data breach we can implement a data masking strategy throughout our environments, so why haven't we already? In this session, you'll learn the traditional blockers to, and issues with masking data, how to overcome these, and how you can build your own masking plan to ensure the security of your data in pre-production.

SessionID: 94119

Data for Good: Using Machine Learning to Improve Water Access in Developing Nations

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Jonathan Dahlberg

Title: Data for Good: Using Machine Learning to Improve Water Access in Developing Nations

Description:

Around the world, nearly 25% of communal water points are non-functional. This challenge has been difficult to address at a global, national, or even local level, primarily due to a severe scarcity of data. About three years ago, the Water Point Data Exchange started tracking this data through the development of a global repository, and with nearly 500,000 water point data records across 40 countries to date, this now represents the largest open and harmonized water point dataset available. However, usage of water point data to improve decisions and ultimately water services is still in the very early stages. Most countries are operating in resource-constrained environments, and lack extensive technical resources to utilize this data to its maximum potential.

The Global Water Challenge (GWC) and DataRobot teamed up to solve this. The two organizations are leveraging automated machine learning to provide governments with insight to manage water access in their respective countries. To do this, the team converted messy, public data into an easy-to-use web-based tool to help governments identify and prioritize water points for repair, identify high risk water points, and determine the availability of water point access by region. While the technology powering the web app is complex, the information is easy to digest, and organized by simple hierarchical filtering. This ensures water managers from various communities, even those without technical training, can act on predictions and make use of the data in the most beneficial ways possible.

This session will also highlight the initial results of the water access project, and its application to operations and policy in West Africa today.

SessionID: 98948

SPEAKER IDOL - ROUND 1

Back to calendar

Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Hamish Watson

Title: SPEAKER IDOL - ROUND 1

Description:

Speaker Idol gives 12 community members the opportunity to present a lightning talk with immediate feedback from a panel of judges and compete for a guaranteed speaking spot at PASS Summit 2020. This experience allows you to get in front of the community and make yourself known. In fact, several previous contestants have gone on to speak at PASS Summit, even without winning the competition.

Contestants will compete in groups of four, over three different rounds. One winner will be selected from each round to compete in the Final Round, along with one contestant selected as a wild card.

Speaker Idol was founded by Denny Cherry, who unfortunately cannot attend PASS Summit this year. In his desire to see this competition continue, he supports PASS in facilitating the competition, along with organizer and host, Hamish Watson.

Round 1 - Contestants:

Speaker Idol 2019 Judges:

SessionID: 98851

Choice with Compatibility: SQL Server 2019 on Linux and Containers

Back to calendar

Event Date: 07-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Tejas Shah

Title: Choice with Compatibility: SQL Server 2019 on Linux and Containers

Description:

Two years ago, SQL Server 2017 entered the Linux operating system database market and never looked back. The Microsoft SQL Server team captured the imagination of developers and DBAs looking for a true enterprise database solution and has been working diligently on new scenarios, solutions, and deployment capabilities, on SQL Server on Linux, such as Replication, DTC, Polybase, and more. Come and learn about new and exciting features coming for SQL Server on Linux and Containers in SQL Server 2019.

SessionID: 98837

Azure SQL Database Edge: Overview

Back to calendar

Event Date: 07-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Amit Banerjee

Title: Azure SQL Database Edge: Overview

Description:

SessionID: 91794

Improve Your Power BI Reports with DAX

Back to calendar

Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Alberto Ferrari

Title: Improve Your Power BI Reports with DAX

Description:

By using DAX, you can create calculations that greatly enhance the usability and layout of your reports. In this session, we show practical examples of DAX formulas that are useful in everyday reporting. Using practical demos and demo files you will be able to download, you will see how to create measures to control conditional formatting, how to compute totals of non-additive measures by summing the rows visible in a report, how to create an additional “others” row after the top 10 customers, and how to provide a human-readable description of slicer selection.

SessionID: 95766

Data Classification: Taking Your First Step on the Road to Agile Data Governance

Back to calendar

Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Data Governance/Privacy

Speaker(s): Grant Fritchey

Title: Data Classification: Taking Your First Step on the Road to Agile Data Governance

Description:

You’ve heard it before; “data is the life blood of your business”. In order to keep your network of data ‘veins’ healthy you need to keep pace with how your data estate is made up and how it’s evolving. Only then can you control the flow of data to ensure development teams get the data they need, while protecting your business in a world of data breaches and new privacy regulations.

What’s more, having a deep oversight of what’s sensitive and what’s not, enables you to do the right thing by your customers when handling their data, who in turn will reward you with their loyalty.
This session will use best practices, maybe a case study, and a little tooling to show you how you can build and maintain an evergreen catalog of your SQL Server estate, and get started on the road to agile data governance.

SessionID: 98648

Deploying SQL Server 2019 Big Data Clusters on VMware

Back to calendar

Event Date: 07-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: Big Data

Speaker(s): Doug Bernhardt

Title: Deploying SQL Server 2019 Big Data Clusters on VMware

Description:

SQL Server 2019 Big Data Clusters introduce Kubernetes as whole new deployment platform. For those coming from prior versions of SQL Server on Windows, this can be daunting.

This session will walk through how to do the deployment step-by-step so you can understand how it’s done, the components involved, and what you might need to learn more about as you take the journey to SQL Server 2019 and Big Data Clusters.

SessionID: 94015

AI for Developers

Back to calendar

Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Anupama Natarajan

Title: AI for Developers

Description:

AI is accelerating digital transformation in every industry. 71% of companies are planning to integrate AI into their existing applications. How can this be achieved?

Microsoft offers pre-built and custom AI models to enable developers to create intelligent applications. Come to this session as part of the AI learning pathway and learn what it takes to become an AI developer. You will gain knowledge about the tools, infrastructure, and services that are available on the Azure AI platform and the skills you require as an AI developer. You will also learn about how to integrate these capabilities with your existing applications.

This session is part of the AI for Everyone Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92321

The Power Platform Game Changer

Back to calendar

Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Hiram Fleitas

Title: The Power Platform Game Changer

Description:

This is a game changing session. I'll show you how to go from zero-to-hero by building the business app you need, literally in minutes, using PowerApps, Flow, SQL Server, Power BI, and Cortana. Then, in a single-shot, securely publish and share your app to iOS, Android, Web and Windows 10.

AGENDA: 0. Intro to PowerApps

  1. Azure Data Studio Notebook
  2. Create 3 PowerApps
  3. Create Multiple Flows (Input, SQL Server, Variables, Respond, Tests)
  4. Data Gateway
  5. Cortana
  6. Securely Publish & Share with Enterprise Governance controls.
  7. Forms - Ai builder
  8. Row-Level-Security (RLS)
  9. Approvals (On SQL Server)
  10. International Space Station (Web HTTP API)

I look forward to seeing you there!

SessionID: 94114

Migrating SQL Server Workloads to Amazon Web Services (AWS)

Back to calendar

Event Date: 07-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Richard Waymire

Title: Migrating SQL Server Workloads to Amazon Web Services (AWS)

Description:

Join the mass migration to purpose-built databases! Over 130,000 databases have been migrated to Amazon Web Services (AWS) using the AWS Database Migration Service (DMS). We'll show you how to lift and shift your Microsoft SQL Server workload with minimal downtime. Deploy SQL Server on Amazon Elastic Cloud Compute (EC2) or Amazon Relational Database Service (RDS), and benefit from fully-managed, scalable, reliable, and secure SQL Server databases in the cloud. We'll share best practices for system sizing and configuration, security, and automation for your SQL Server workloads. We'll also cover how you can lift and modernize your current SQL Server workloads by moving to purpose-built relational and non-relational databases, and data lakes from AWS.

This session is part of the Cloud migration Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98832

Enabling End to End Scenarios with Data Virtualization in SQL Server 2019

Back to calendar

Event Date: 07-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): James Rowland-Jones

Title: Enabling End to End Scenarios with Data Virtualization in SQL Server 2019

Description:

Data Virtualization is one of the most exciting features in SQL Server 2019. This technology enables you to query relational tables in Oracle, directly from a SQL Server instance; pushing filters, joins, and aggregates to a remote Oracle instance.

Learn how data virtualization also works in conjunction with other great SQL Server features such as data classification and server-based auditing to produce complete and compelling solutions.

SessionID: 90956

Text Mining & Sentiment Analysis made easy

Back to calendar

Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Sanil Mhatre

Title: Text Mining & Sentiment Analysis made easy

Description:

Does your enterprise data include social media posts, product reviews, and survey results with free form text? Feel like you need a data scientist, equipped with tools like R, text mining, and sentiment lexicon to unlock the value of that data?

Not anymore! Thanks to our friends at Microsoft, a developer or analyst can leverage Azure Cognitive Services and PowerBI to easily analyze text data and create effective visual dashboards.

This session will walk through how to use text analytics APIs in Azure Cognitive Services, to analyze free form text responses to survey questions. We will learn how to parse key phrases, derive sentiment scores, and how to effectively use Power BI visualizations like Word Cloud, Gauge, Histograms, etc. to create a dashboard for effectively analyzing this data. We will browse through emotional classification and word correlation in R.

SessionID: 92753

How to Deploy SQL Server Containers on Kubernetes in Azure

Back to calendar

Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Hamish Watson

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

Description:

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: 98640

Create the Perfect Multi-Column Index for Your Query

Back to calendar

Event Date: 07-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: Database Administration

Speaker(s): Ray Maor

Title: Create the Perfect Multi-Column Index for Your Query

Description:

To know the optimizer's execution plan decision making is to know the most efficient method for our data to be returned with minimal resources.

In this session, you will be taught the quickest and ideal method of creating multi-columned indexes according to a set of predefined rules that include the column type, predicate order, statistics, select statement breakdown and much more.

This algorithm has been developed and perfected over the last 6 years by the presenter.

SessionID: 92730

dbatools - A PowerShell Toolkit for the DBA

Back to calendar

Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Jack Corbett

Title: dbatools - A PowerShell Toolkit for the DBA

Description:

In this demo driven session you will learn how to: prepare your computer for installation of the dbatools module, install dbatools and pre-requisites, use dbatools commands to automate routine tasks such as migrating logins and jobs, setup log shipping, and add databases to availability groups.

At the end of the session, you will be able to return to your office with dbatools as a new tool in your toolkit to help you manage your SQL Server estate in a more efficient manner.

SessionID: 94003

Eliminating Anti-Patterns and RBAR for Faster Performance

Back to calendar

Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Jonathan Kehayias

Title: Eliminating Anti-Patterns and RBAR for Faster Performance

Description:

Are you looking for faster performance on your existing hardware? Do you have queries that run slowly and don’t seem to scale as the data set grows? Are you running SQL Server in the cloud where you don’t have control over the configuration of the environment?

This session will show you how to find the low hanging fruit in your environment, explain why the problem exists, and step through how you can make the necessary changes to boost your SQL Server’s performance with a minimal amount of effort. This session focuses on schema and code design problems, to help you get the most bang for your buck when performance tuning SQL Server. By focusing on real-world examples with reproducible workloads, you will easily be able to see the impact of common mistakes and learn how to fix them quickly for improved performance.

This session is the third session in the SQL Performance for Developers Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 94225

Making the Leap to Management

Back to calendar

Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Adam Jorgensen, Chris Yates

Title: Making the Leap to Management

Description:

Have you ever wanted to rescue a team from a bad manager? Now is your chance to learn what it means to make the leap from technical expert to growing, developing, and managing a team. Come learn from our experience working with different organizations, industries, and countries, and get the clarity you want on what it means to make the leap to a leadership role. We will help you build a personal action plan focused on figuring out what types of roles you would be great for, where to find them in your company and beyond, and how to prepare for a successful transition! How do you balance being technical vs growing as a manager and growing your team? How do you make sure you don't turn into those terrible managers we've all had? How do you shortcut the mistakes and missteps so many others make? We will help you through all of it!

This session is the second session in the Technical Leadership Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92589

Columnstore Indexes in 2017-2019

Back to calendar

Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Niko Neugebauer

Title: Columnstore Indexes in 2017-2019

Description:

Columnstore Indexes were launched in SQL Server 2012 and greatly enhanced in 2014 & 2016 - and if you thought that Microsoft was done with them - you are missing a lot of important improvements that were added in SQL Server 2017 and 2019 (and some of which are available in Azure SQL Database).

It looks like the main focus right now of the dev team right now is on fixing the missing and if you are running high performance scale Data Warehouses or BI solutions - you better be aware what the newest versions are bringing on the table.

SessionID: 93467

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Monica Rathbun

Title: I'm It - Survival Techniques for the Lone DBA

Description:

Are you the only database person at your company? Are you both the DBA and the developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering.

This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 91948

ETL in Azure Made Easy with Data Factory Mapping Data Flows

Back to calendar

Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Big Data

Speaker(s): Paul Andrew

Title: ETL in Azure Made Easy with Data Factory Mapping Data Flows

Description:

What happens when you combine a cloud orchestration service with a Spark cluster?! The answer is a feature rich, graphical, scalable data flow environment to rival any ETL tech we’ve previously had available in Azure. In this session we’ll look at Azure Data Factory and how it integrates with Azure Databricks to produce a powerful abstraction over the Apache Spark analytics ecosystem. Now we can transform data in Azure using Databricks, but without the need to write a single line of Scala or Python! If you haven’t used either service yet, don’t worry, you’ll get a quick introduction to both before we go deeper into the Data Factory Mapping Data Flow feature.

SessionID: 92754

Into the Future with In-memory OLTP

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Kalen Delaney

Title: Into the Future with In-memory OLTP

Description:

In-memory OLTP, also known as Hekaton, is a game changer for many OLTP applications, allowing fast access to data with no locking or blocking. The initial version, introduced in SQL Server 2014, had so many restrictions on what tables could be placed in memory, and what programming constructs could be used with the data in those tables, that many people wouldn’t even consider using it. Starting in SQL Server 2016, many of those restrictions are starting to be removed and In-memory OLTP is much more robust. SQL Server 2016 also gave us the ability to build columnstore indexes on memory-optimized tables so that we could use them for analytical queries as well as for OLTP. There are very few scenarios now in which your table structure or SQL constructs used would be a contraindication to using In-memory OLTP.

This session will explore the changes to Hekaton since its original implementation, including SQL Server’s ability to create memory-optimized system tables in SQL Server 2019.

SessionID: 92260

Dipping Your Toes In: Azure Data Lake for DBAs

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Big Data

Speaker(s): Bob Pusateri

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

Description:

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: 92799

Privacy and Security by Design in a Cloud Environment

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Johan Ludvig Brattås, Rune Ovlien Rakeie

Title: Privacy and Security by Design in a Cloud Environment

Description:

With the arrival of GDPR in 2018, and CCPA just around the corner – data privacy is something that has moved from being a topic most of us rarely had to consider, to something most of us need to think about.

And as solution architects, when designing data platforms – we need to focus on security by design, and as an integral part, privacy by design. By following security and privacy design principles from the start and continuously verifying against them throughout the design process, your end result will have security and privacy support smoothly integrated into your solution.

Topics covered are security and privacy by design principles and how they relate to cloud architecture, examples of how to implement said design principles in a solution, best practices when designing solutions for security, and privacy by design.

SessionID: 90995

Database Security, Who Owns It?

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security

Speaker(s): John Martin

Title: Database Security, Who Owns It?

Description:

Who owns security when it comes to database and data platform systems? Is it the DBA, Developer, or dedicated InfoSec?

In this session we will explore the different layers that go into securing data platform solutions. We will look at the full development and operations lifecycle and how we can realize secure-by-design best practices within a DevOps framework.

SessionID: 98852

SQL Server in Azure Virtual Machine Re-Imagined

Back to calendar

Event Date: 07-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Hybrid Infrastructure

Speaker(s): Bob Ward, Shreya Verma

Title: SQL Server in Azure Virtual Machine Re-Imagined

Description:

With SQL Server on Azure VM, get the combined performance, security, and analytics of SQL Server, backed by the flexibility, security, and hybrid connectivity of Azure VMs.

In this session, we will discuss new features recently announced for SQL Server on Azure VM with SQL VM resource Provider around enhanced manageability, improved performance, flexible licensing and integration of SQL VM with unified Azure SQL Service.

SessionID: 93581

Two Truths That's A Lie: Data Visualization Ethics

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Jonathan Stewart

Title: Two Truths That's A Lie: Data Visualization Ethics

Description:

Data visualization is an impactful and influential method of telling a story, so it’s important to be as open and truthful as possible when telling your story. The Society of Professional Journalists have a code of ethics that begins with a single mission, “Seek Truth and Report It”, but what is truth in data? Data can tell multiple stories. How do we protect our company and reputation?

In this session, we will discuss how everything from color to chart can be used to change the meaning of visualization. We will cover the things that influence and manipulate. Finally, we will put it all together, creating two opposing stories using the same data-set.

SessionID: 98059

SQL Server in Containers: Your Next Dev/Test/Integration/Upgrade Server

Back to calendar

Event Date: 07-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Hybrid Infrastructure

Speaker(s): Grant Fritchey

Title: SQL Server in Containers: Your Next Dev/Test/Integration/Upgrade Server

Description:

Finally, it's become easy for SQL Server developers and DBAs to use containers to speed up software development and testing. Containers have been around for more than 30 years, and at last they have become a great tool for Microsoft data professionals.

Join Grant Fritchey to learn how containers differ from virtual machines, and why containers make it incredibly fast to deploy new instances of SQL Server. Grant will use Docker containers to demo the process of spinning up a new SQL Server using the very latest version of the product -- without actually installing SQL Server! Finally, you'll learn how containers can be used in the software development lifecycle to speed up the process of developing, testing, and deploying changes.

SessionID: 94224

Taking Leadership to the Next Level: Mastering Your Own Growth

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Adam Jorgensen

Title: Taking Leadership to the Next Level: Mastering Your Own Growth

Description:

A leader's greatest challenge can be continuing to develop themselves while focusing on their team and their company. Depending on what you're trying to learn, this can mean swinging between business and technical topics, HR and soft skills, presentation and speaking skills, or productivity and efficiency. You can't learn everything, but you need a system that works for you to make sure you can be the leader you want to be. Do you want to lead your team? Build a new product? Start your own company? These all require skills that build on each other, along with the right attitude and plan to give you the confidence and capabilities to crush all your goals. Come learn how to do this without becoming overwhelmed, handling situations you can't be trained for, and get a personalized library of resources to use in your journey.

This session is the third session in the Technical Leadership Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98833

SSRS 2019 and Paginated Reports in Power BI

Back to calendar

Event Date: 07-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Patrick LeBlanc, Chris Finlan

Title: SSRS 2019 and Paginated Reports in Power BI

Description:

Discover what's new in 2019 for SSRS and in the cloud with Paginated Reports in Power BI. Explore the ability to view and interact with pixel-perfect paginated reports, right alongside existing Power BI interactive reports. This session will cover report authoring, subscriptions, management, and more.

SessionID: 94073

AI for the BI Professional

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Leila Etaati

Title: AI for the BI Professional

Description:

There is a huge demand to apply AI and Machine learning (ML) in different software solutions and reporting. By using AI and ML in Business Intelligence solutions, we are able to bring more holistic and greater insight about data and deliver it to business and end users.

This session is part of the AI pathway with a focus on how a business user of BI or a BI developer is able to use AI in their reports. The audience will see how to consume pre-built AI tools such as cognitive service. Moreover, they will get familiar with how to consume the model that has been created by a data scientist (in Azure ML Studio, Service, or by R or Python) and apply more analytics on data using these models. Finally, they will get familiar with some AI features and visualization of Power BI to make more intelligence reports.

This session is part of the AI for Everyone Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 96659

Fix Slow Queries. Fast. With SentryOne Plan Explorer

Back to calendar

Event Date: 07-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Database Administration

Speaker(s): Kevin Kline, Andy Yun

Title: Fix Slow Queries. Fast. With SentryOne Plan Explorer

Description:

The query optimizer is the single most important technology within the SQL Server relational engine. It decides exactly how any given SQL statement is executed, which is shown in a query execution plan. However, the execution plan is only one of several important sources of information about how a query performs, and they are full of jargon and obscurely defined operations. But there is a solution to this problem!

Using SentryOne Plan Explorer (PE), a 100% free product, DBAs and Devs makes reading execution plans easier, enabling you to write better performing SQL code in a fraction of the time otherwise possible. Plus, troubleshooting existing SQL code becomes a fast, easy, and visually vibrant experience. We will start with visualizing, reading, and understanding execution plans, then explore all the ways that PE reveals additional performance pitfalls and eases troubleshooting. We will show you lots of demos where PE immediately reveals a problem situation that is otherwise hard to detect, including difficult situations like parameter sniffing, deadlock troubleshooting, outdated stats detection, inaccurate memory grants, and heavy tempdb spools/spills. In addition, you’ll learn about other powerful features like index what-if tuning, query history and comments, integrated wait stats and statistics IO metrics, live query replay with resource consumption correlation, and much more. When done with this session, you will have solid knowledge for tuning and troubleshooting SQL queries, transactions, and stored procedures. Learn all the ways SentryOne Plan Explorer helps in this demo-packed session!

SessionID: 99099

10 Cool Things You Can Do With Azure Databricks

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Ike Ellis, Simon Whiteley, Dustin Vannoy

Title: 10 Cool Things You Can Do With Azure Databricks

Description:

All demos! No slides! Ike, Dustin, and Simon will show you 10 cool things you can do with Azure Databricks. Each demo will be 5 - 10 minutes and will give you plenty of ideas of how you can implement this exciting technology in your environment, and have fun doing it!

We'll show you demos on:

SessionID: 92579

Code Like a Snake Charmer - Introduction to Python!

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Jamey Johnston

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

Description:

This session will be an introduction to the Python language including:

  1. Installing and Configuring Python
  2. Accessing and Manipulating Data
  3. Installing and Managing Packages
  4. Creating and Using Objects/Variables
  5. Controlling Flows and Functions
  6. Controlling Flows and Functions 6) Python in MS Power BI, Azure ML, MSSQL, and Databricks.

Attend this session to learn how Python can take your data analytics to the next level. We will use Python, SQL Server, and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learn some basic data science fundamentals.

SessionID: 94000

Successfully Communicating with Your Customers

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Denise McInerney

Title: Successfully Communicating with Your Customers

Description:

No matter what role you are in, your job is to satisfy your customers. But often in tech we struggle to do this, which negatively affects our projects and our careers.

One reason for this is poor communication. This session will explore why communication gaps exist and how to address them.

We will start by answering the question: “Who are my customers?”. Communication gaps begin when we are not clear on who has a stake in the outcome of a project.

We will offer tips and techniques for communicating with non-technical stakeholders.

We will examine the art of requirements-gathering, exploring how to unearth what a customer actually wants, and how to manage when they change their minds.

Once we have those requirements, we need to ensure the technical team understands them. This session will also discuss how to ensure nothing is “lost in translation.”

We will talk about how to keep stakeholders informed so as to avoid surprises and disappointment.

Throughout the session, we will emphasize an approach that turns customers into allies invested in your success and avoids an “us vs. them” mindset.

Technologists who effectively communicate with their customers are more valuable than those who do not. Come to this session to learn how to be a better communicator and more successful in your career.

This session is the second session in the Communication for Technical Professionals Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 93460

Missing T-SQL Querying Features for Handling NULLs and for Data Analysis

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Itzik Ben-Gan

Title: Missing T-SQL Querying Features for Handling NULLs and for Data Analysis

Description:

SessionID: 92704

AI Cognitive Services: Vision 101

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Alicia Moniz

Title: AI Cognitive Services: Vision 101

Description:

Are you curious about Visual Recognition and Object Detection in Azure? Are you wondering what the difference is between the Computer Vision API and the Custom Vision API? Do you want a quick introduction to get you up to speed on both, so that you can quickly build and deploy a Cognitive Services model?

Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.

In this session, we will look at the basics of Cognitive Services Vision. Next, we will learn how to create our very own Custom Vision Cognitive Services model. Then you can see how to train and improve accuracy. Finally, we will step through python code in Azure Notebooks to interact with our custom model. After this session, you will have the tools to get up and running in Cognitive Services Vision in under an hour!

SessionID: 91012

Entity Framework Debugging Using SQL Server: A Detective Story

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Chris Woodruff

Title: Entity Framework Debugging Using SQL Server: A Detective Story

Description:

What happens when the code for your Entity Framework LINQ queries looks good, but your app is very slow? Are you looking in the right place? Don’t be afraid to start looking at your database. Knowing how to investigate and debug what your LINQ queries are doing in SQL Server is as important as the actual LINQ query in your .NET solutions. We will be looking at database server configurations, using MSSQL database profiling tools and understanding Query Execution Plans to get the most out of Entity Framework. In the end, learning to be an Entity Framework detective will make your project sound and snappy.

SessionID: 92622

Empowering the SQL Server Professional with Linux Scripting

Back to calendar

Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Kellyn Pot'Vin-Gorman

Title: Empowering the SQL Server Professional with Linux Scripting

Description:

A DBAs suite of scripts is worth its weight in gold. As Azure moves the SQL DBA to a more Linux focused environment, the opportunity to learn Linux scripting and to add these valuable skills to your pre-existing Powershell skills is a great goal.

This session will teach you how to build out proper shell scripts, tips and tricks, along with how to learn faster.

This session is the second session in the Linux for SQL Server Professionals Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 94019

Modernize Your SQL Server the Right Way

Back to calendar

Event Date: 07-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Development

Speaker(s): Pam Lahoud

Title: Modernize Your 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 (MAP Toolkit, DMA, and DEA).

In this session, we will demonstrate the free tools that Microsoft provides in order to ensure your SQL Server upgrade is a success.

Attend this session to be aware of the free tools Microsoft provides to make upgrading SQL Server on-premises easier, and how to approach SQL Server upgrading as a seamless, reliable process.

This session is the third session in the Modernizing with SQL Server 2019 Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92335

CosmosDB - Designing and Troubleshooting Lessons

Back to calendar

Event Date: 07-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Cloud Solutions

Speaker(s): Neil Hambly

Title: CosmosDB - Designing and Troubleshooting Lessons

Description:

Following an introduction to Cosmos DB and it's latest features, we will review the following to achieve High Performance Cosmos DB Solution; using labs to showcase the following:

SessionID: 98739

Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Tobias Ternstrom

Title: Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases

Description:

Amazon Aurora is a relational database service for online transaction processing (OLTP) workloads offered as part of Amazon Web Services. In this session, Tobias Ternstrom describes the architecture of Aurora and the design considerations leading to that architecture. Tobias also discusses how the central constraint in high throughput data processing has moved from compute and storage to the network.

Aurora brings a novel architecture to the relational database to address this constraint, most notably by pushing redo processing to a multi-tenant scale-out storage service, purpose-built for Aurora. Tobias describes how this not only reduces network traffic but also allows for fast crash recovery, failovers to replicas without loss of data, and fault-tolerant, self-healing storage. Traditional implementations that leverage distributed storage would use distributed consensus algorithms for commits, reads, replication, and membership changes, and amplify the cost of underlying storage. Tobias describes how Aurora avoids distributed consensus under most circumstances by establishing invariants and leveraging local transient state. These techniques improve performance, reduce variability, and lower costs.

SessionID: 99173

No-Code Custom Visuals! Can You Say Charticulator? …I Knew You Could

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Paul Turley

Title: No-Code Custom Visuals! Can You Say Charticulator? …I Knew You Could

Description:

Create amazing Power BI custom visuals with no code using Charticulator, an open-source development tool created by Microsoft Research.

SessionID: 92727

Building Your First SQL Server Container Lab in Docker

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Chris Bell

Title: Building Your First SQL Server Container Lab in Docker

Description:

A few years back, virtualization changed the way to work with SQL and infrastructure. Now, the next chapter is opening and it’s all about containers. Containers can make the DBA’s job of creating and deploying servers much easier freeing them up for other tasks such as performance tuning and security.

In this session, we will go over the concepts of containers, their general capabilities, and then build, connect, and configure a SQL Server in a container for use as a private lab.

SessionID: 94013

AI for the DBA

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Melody Zacharias

Title: AI for the DBA

Description:

This session takes the AI pathway to the DBA. We will cover the basics of what a DBA needs to know about the AI ecosystem.

We will explore what a DBA needs to know to support your AI team. From server implementations to deployments we will look at the skills you need to support AI in your organization. We will cover a general overview to help improve communication between the DBA and data scientists. Then, we will dive deeper where you need an in-depth understanding to thrive in the AI world.

By exploring and explaining the ecosystem we will gain a deep-rooted understanding to set you on your AI pathway.

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.

This session is part of the AI for Everyone Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92294

LIGHTNING TALKS

Back to calendar

Event Date: 07-11-2019 15:15 - Category: Lightning Talk (10 minutes) - Track: Advanced Analytics

Speaker(s): Jens Vestergaard, Martin Catherall, Eugene Meidinger, Kimberly StJacques, Paul Andrew, Michael Grayson

Title: LIGHTNING TALKS

Description:

Sessions and Speakers will include:

Michael Grayson - Support What?! SQL Server and MongoDB: A side by side "How To" More and more companies are starting to invest in multiple database platforms and DBAs are needing to develop a skillset to support a mixed-database environment. Database concepts are often the same between platforms, however, the “how” can be very different (and sometimes not that different at all!). Starting with the basics and gradually moving into the more advanced, this talk will show you how to perform the same task in SQL Server and MongoDB.

Kimberly StJacques - Introduction to SQL Server 2019 Enhanced PolyBase Do you have ETL processes pulling data from multiple data sources into a data warehouse so you can run reporting from a single source? SQL Server 2019 enhanced the PolyBase feature that was introduced in SQL Server 2016. Come learn how the new PolyBase features enable you to generate reports on data stored in all of your data sources without the need of a physical data warehouse! This is a great introduction for the PolyBase beginner.

Jens Vestergaard - PBIRESTAPI, no time for spaces... In this talk, we will be looking into managing our Power BI content using only the Power BI REST API. Examples will be provided in Powershell, which may require minute skills up front. What will be demoed: Can I take ownership of this Dataset? How do I refresh my Dataset? Is my Dataset refreshing on a schedule?

Paul Andrew - Using Azure DevOps for Azure Data Factory DevOps as a process is here to stay and is typically a must have requirement for any data platform solution. But how does the concept translate to the technology when implemented? Sadly, the answer isn’t always straight forward. In this short session I’ll introduce how we can continuously integrate and deliver our cloud orchestration resource Azure Data Factory (ADF). We’ll discuss three options for getting our service JSON deployed to production using the popular Azure DevOps environment, previously known as VSTS, and think about the suitability of the Microsoft provided ARM templates for our highly dynamic orchestrator. Does the ADF portal UI really support the DevOps methodology? Can we confidently publish our pipelines? How should we handle the branching of our source code for ADF developers? The answers to these questions and more in this lightning session.

Martin Catherall - Data Privacy and the Data Professional World What are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens, the entire concept of data storage become more complex. We will see what is exactly legislation like the General Data Protection Regulation and how will it affect around the world.

Eugene Meidinger - Coming soon

SessionID: 99397

Self Service with a Logical Architecture: How to Consolidate Access to Fragmented Data without Additional Replication

Back to calendar

Event Date: 07-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Data Platform Strategy

Speaker(s): Pablo Alvarez

Title: Self Service with a Logical Architecture: How to Consolidate Access to Fragmented Data without Additional Replication

Description:

At the same time, self service initiatives have tried to create a simpler perspective on the data where empowered users can build their own intelligence without the constant help of IT. But how to bind these two perspectives together? Physical consolidation in a single system doesn't work anymore: volumes are too big, and built-for-purpose systems offer unique abilities that would be lost.

A logical approach is more feasible: a logical layer that connects different systems and exposes them as one. The complexity of the back-end systems is hidden from the end user, while security, governance and auditing are again centralized. Self service can then become a reachable goal.

In this session we will see how a data virtualization platform like Denodo provides the required capabilities to build such a layer, and bridge the gap between the modern IT infrastructure and the needs of the end users.

SessionID: 94004

Design Strategies and Advanced Data Visualization: The Ingredients for a Delicious Data Story

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): James McGillivray

Title: Design Strategies and Advanced Data Visualization: The Ingredients for a Delicious Data Story

Description:

You’re comfortable with picking the right visualization for a specific data set, and making it look good. You know the basics of design and can craft a report that is pleasing on the eye. Now it’s time to take your data presentation skills to the next level.

In this session, we will learn how to design for accessibility, allowing more people to benefit from our work. We’ll learn the difference between designing for users to explore information, and for users to consume insights. This will lead us into the basics of constructing a data story. From choosing the relevant data points, to removing all unnecessary distractions and constructing a cohesive narrative.

Every data story is unique, but the techniques for effective data presentation are universal. Improve your reports, dashboards, and slide decks by learning the art and science of quality data visualization.

This session is the second session in the Data Visualization and Storytelling Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 94072

An Azure Data Engineer's ETL Toolkit

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Simon Whiteley

Title: An Azure Data Engineer's ETL Toolkit

Description:

Many organisations have adopted a "cloud first" strategy, designing sophisticated data architectures in Azure - but there's already a wealth of existing business logic, cleansing, and transformation in your existing on-premise SSIS packages. A direct lift and shift of SSIS into the cloud is a tempting solution, but is it the best answer?

This session serves as an introduction to the various data movement and transformation options available in Azure, for aspiring data engineers, data architects, and anyone working with data in the cloud. We’ll compare and contrast SSIS with other tools such as Data Factory, Databricks, and Logic Apps, and showcase real-world examples of where each tool fits in.

We will then take a focus on Data Factory, looking at some common ETL patterns that can take advantage of the cloud and demonstrating how to put them to best use, including the new Data Flow features that will take your cloud ETL to the next level.

By the end of this session, you will have a better understanding of the limitations of SSIS in Azure, a deeper knowledge of how Azure Data Factory can fit into your cloud migration plans, and a roadmap for moving towards truly scalable cloud ETL in an achievable way.

This session is the third session in the Becoming an Azure Data Engineer Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98649

Scaling with a Distributed Architecture and Real-time Data for an Evolving Business—A DBA’s Journey

Back to calendar

Event Date: 07-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Deana Ritter, Simon Whitworth

Title: Scaling with a Distributed Architecture and Real-time Data for an Evolving Business—A DBA’s Journey

Description:

In this case study, learn how Senior DBA, Deana Ritter, designed a solution for delivering fresh data to business end-users and achieved greater manageability of data flows at an Energy Management Services company.

Deana found that their replication solutions were no longer serving the growing needs of the company and needed to find a better way to deliver data.

She will share her journey in finding a replication solution that could handle growing data volumes, horizontal scaling, and provide the energy management company's growing number of customers fast, accurate data at their fingertips. Deana will discuss challenges uncovered along the way, and how she found a solution that could satisfy multiple requirements that not only pleased stakeholders, but is flexible and scalable for the company's long term needs.

SessionID: 91909

Virtual SQL Server Performance Deep Dive

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Data Platform Strategy

Speaker(s): David Klee

Title: Virtual SQL Server Performance Deep Dive

Description:

This session is packed with many live examples of tips and tricks gained from years of experience in getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed, and tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

SessionID: 90989

Power BI Premium: Is it for Your Company (and Worth It)?

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Steve Wake

Title: Power BI Premium: Is it for Your Company (and Worth It)?

Description:

Power BI Premium is the top level of Power BI that your company can pay to get dedicated capacity for your Power BI reports and models. But at a starting price of $5000/month is it something your company needs and is it worth that price?

In this session, we will go over all of the current features offered with Power BI Premium and the features that we know are coming in the future, so that you can help make that decision for your company. With multiple demos in this session, you can see these features for yourself to help determine the worth. Come to this session if your company has been thinking about Power BI Premium, but you have been unable to determine if it is right for your company. At the end of this session, you will be armed with all of the knowledge you will need to make the right decision.

SessionID: 91763

Using Open Source Software to Collect Performance Metrics

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Tracy Boggiano

Title: Using Open Source Software to Collect Performance Metrics

Description:

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will discuss sp_whoisactive and Query Store to track what queries are running. Then, we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive and easy to set up system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances, Azure Managed Instances, and Azure SQL Databases. Attendees will see how easy it is to get good performance data and visualize it interactively, and combine with other tools to troubleshoot issues. Finally, we will look at a problem I solved using this solution as an example.

SessionID: 92680

Designing Azure Data Disaster Recovery Strategies

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure

Speaker(s): John Morehouse

Title: Designing Azure Data Disaster Recovery Strategies

Description:

In an on-premises world many organizations did not have the option of multiple data centers or were limited in what that they could protect from disaster. Moving to the cloud evolves many technologies—disaster recovery being one of the most prominent ones. It can be quick and easy to protect your application in multiple regions worldwide. For any critical application, disaster recovery should be at the forefront of your planning. The cloud does not change this. In the event of a regional outage, you still need to meet your recovery objectives. If you aren't prepared for this failure, the downtime could be costly.

In this session, we will examine the ways to help protect your Azure Data footprint from outages. You will learn about strategies with Azure SQL Databases, virtual machines, and Managed Instances as well as how to protect your application tier. At the end of the session you'll have a better understanding of how to ensure your data in the cloud is protected from failure.

SessionID: 92628

Power BI Data Privacy Settings Deep Dive

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Chris Webb

Title: Power BI Data Privacy Settings Deep Dive

Description:

Power BI's data privacy settings can be extremely difficult to understand, but they are nonetheless important: they control whether sensitive data is sent from one data source to another. They also have a big impact on dataset refresh performance and even cause errors.

In this session, you'll learn how they work, how to configure them, and how to make sure your queries run as quickly as possible.

SessionID: 93628

SQL Migration to Azure: Best Practices, Accelerators, and Production Case Studies

Back to calendar

Event Date: 07-11-2019 15:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Des FitzGerald, Jayakesh Venu

Title: SQL Migration to Azure: Best Practices, Accelerators, and Production Case Studies

Description:

This session is part of the Cloud Migration Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 90952

Revenge: The SQL!

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Rob Volk

Title: Revenge: The SQL!

Description:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 98838

Introducing Azure Synapse Analytics: The End-to-End Analytics Platform Built for Every Data Professional

Back to calendar

Event Date: 07-11-2019 15:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Saveen Reddy, Priyanka Gomatam

Title: Introducing Azure Synapse Analytics: The End-to-End Analytics Platform Built for Every Data Professional

Description:

Join us to learn about Azure Synapse Analytics, the latest analytics platform that brings the power of both relational and big data systems into a single workspace. We'll dive into how Synapse enables you to ingest, prep, model, and serve data all from a single workspace. From ingestion to preparation and AI-to-BI, it's never been easier to build a modern data warehouse solution than with Azure Synapse Analytics!

SessionID: 90954

Azure SQL Database - Lessons Learned from the Trenches

Back to calendar

Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Jose Manuel Jurado Diaz, Roberto Cavalcanti

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 the fruit of Microsoft CSS support cases and customer field engagements. This session includes several demos.

SessionID: 92493

Data Virtualization is easy with SQL Server Big Data Cluster

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Big Data

Speaker(s): Sergiy Lunyakin

Title: Data Virtualization is easy with SQL Server Big Data Cluster

Description:

Visit this session to learn how it is easy to implement Data Virtualization using SQL Server 2019 Big Data Cluster. Data Virtualization is an umbrella on top of variety of data sources that enable you to access and analyze external data sources from a single place and easily implement data ingestion to Data Warehouse. Also, we will review some lesson learned during a real data virtualization project.

SessionID: 92308

Back Up and Restore a SQL Server Database If You're Not a DBA

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Randolph West

Title: Back Up and Restore a SQL Server Database If You're Not a DBA

Description:

The primary goal of a data professional is being able to restore a database when needed. But, what if you're not a data professional, and just inherited a database to look after?

In this session, you will learn about data files and transaction logs, Recovery Time Objective (RTO) and Recovery Point Objective (RPO), and how to choose the right recovery model for your environment.

You will go back to work with a better understanding of database backups, and how to automate any database restore task.

This session contains a lot of demos, tips and tricks, and job-loss prevention techniques to make sure you are prepared for a data disaster.

SessionID: 91912

Improving Columnstore Load Scalability on Large Servers

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Joe Obbish

Title: Improving Columnstore Load Scalability on Large Servers

Description:

Clustered columnstore indexes can be a great solution for data warehouse workloads, but loading lots of data as quickly as possible is still a cutting edge problem. Experience a tour de force of columnstore scalability with total load time starting at 260 minutes and dropping to just 6 minutes. The techniques to achieve such an improvement are derived from lessons learned from production workloads with billions of rows. Session material is applicable to SQL Server 2016, 2017, and 2019.

Get ahead of the pack and improve your columnstore load times, increase scalability on your large servers, or simply be challenged. Attendees must have a good understanding of columnstore, wait stat analysis, extended events, and latches to get full value out of this session.

SessionID: 99157

SUSE Linux for Modern Data and Analytics

Back to calendar

Event Date: 07-11-2019 16:45 - Category: Partner Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Bryan Gartner

Title: SUSE Linux for Modern Data and Analytics

Description:

Enterprises are leveraging SUSE Linux for mission-critical enterprise server platform. Customers are considering Linux as their new operating system platform for Microsoft SQL Server. When we think about the evolution of the data platform we see a continuum of capabilities which started with Relational Databases, then the emergence of data proliferation and consolidation into data warehouses which gave rise to Analytics providing data abstraction for business applications. We now have generated such a significant data set and have learned how to better consume, analyzed, and process that data through Big Data and Analytics platform. Enterprises must be open to adopting platforms that increase flexibility and provide a unified experience across multiple workloads and modalities. SUSE is committed to enabling customers to choose the best platform for their data and analytics. This includes providing SUSE Linux Enterprise Server as a multimodal OS. Customers can choose SUSE Linux Enterprise Server to deploy Big Data, Data Analytics and fit for use data solutions. SUSE creates the opportunity to consolidate the platform for a diverse portfolio of data solutions on SUSE Linux Enterprise Server.

SUSE Linux Enterprise Server with High Availability Extension provides mission-critical uptime, fast failover, improved manageability, and easy configuration for Always on Availability Groups (AG) for SQL Server High Availability setup on Azure. SQL Server containers, orchestrated through SUSE container platform, provide a consistent, isolated and reliable behavior along with providing the ease of usage, deployment, and management. The ability to deploy a SQL Server container with Availability Groups, provides an Enterprise-class HA and DR for data and analytics deployments.

SessionID: 98853

Azure SQL Database: Maximizing Cloud Performance and Availability

Back to calendar

Event Date: 07-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Joe Sack, Denzil Ribeiro

Title: Azure SQL Database: Maximizing Cloud Performance and Availability

Description:

When you move to Azure SQL Database, you select a pre-defined set of allocated resources across several dimensions such as CPU, memory, storage, and more. For a typical business application you need to find a balance between cost, performance demands and availability requirements. Yet for your mission critical application your focus moves toward the highest availability (i.e. 99.995% uptime) and performance.

In this session we’ll review best practices around how to select your Azure SQL database configuration that is optimized for a specific application pattern and how to maximize its performance and availability. We’ll review the natural advantages you can leverage from the Azure SQL Database ecosystem and detail factors to consider when optimizing for performance in the cloud, including application patterns and anti-patterns that you may encounter when migrating legacy applications from SQL Server to Azure SQL Database.

SessionID: 92499

HA/DR - Too Many Choices!

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Mike Walsh

Title: HA/DR - Too Many Choices!

Description:

Your company needs to achieve high availability and disaster recovery, but there are many choices nowadays (more than a few ways inside of SQL Server, third-party options, on-prem, cloud, VM based technologies, oh my!). How do you choose what's right for YOU and your company?

In this "DBA 101" session, you'll wade through all of the choices and understand the pros and cons of each. You'll also learn which questions you should be asking of the business. Find your needs, then the right solution. Not the other way around! You'll leave more informed about the choices, have some guides to help you pick, and you'll be on your way to the right choice!

This session is for SQL Server technologists who "get SQL," but are looking to weigh their HA/DR options out and want to level up their knowledge and go back to the office prepared to be a consultant to your company and tackle those HA/DR needs.

SessionID: 91416

From Adaptive to Intelligent: Query Processing in SQL 2019

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Hugo Kornelis

Title: From Adaptive to Intelligent: Query Processing in SQL 2019

Description:

As announced in September 2018, SQL Server 2019 expands the "adaptive query processing" features of SQL 2017 and relabels them as "intelligent query processing". This name now covers many features, such as batch mode on rowstore, memory grant feedback, interleaved execution, adaptive joins, deferred compilation, and approximate query processing.

In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.

SessionID: 92515

On-Premises Power BI and Reporting: Reporting Services 2019

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Thomas LeBlanc

Title: On-Premises Power BI and Reporting: Reporting Services 2019

Description:

On-premises reporting of Power BI is available for those not yet in Azure. The new Report Services (PBIRS) can be installed alongside a Reporting Services (SSRS) installation, or the SSRS installation reports can be combined with the new PBIRS. If that is confusing, come to this session for an explanation.

This session will flow from installation and configuration to include the separate Power BI desktop installation. Reviewing the release schedule (every 4-5 months) shows that this is different than the monthly update for Power BI service. Next, example reports will be developed pointing out tips and tricks for reports used with on-premises features. The conclusion of the session will demonstrate the viewing of reports with PBIRS, plus managing security and data refreshes through the portal.

SessionID: 98949

SPEAKER IDOL - ROUND 2

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Hamish Watson

Title: SPEAKER IDOL - ROUND 2

Description:

Speaker Idol gives 12 community members the opportunity to present a lightning talk with immediate feedback from a panel of judges and compete for a guaranteed speaking spot at PASS Summit 2020. This experience allows you to get in front of the community and make yourself known. In fact, several previous contestants have gone on to speak at PASS Summit, even without winning the competition.

Contestants will compete in groups of four, over three different rounds. One winner will be selected from each round to compete in the Final Round, along with one contestant selected as a wild card.

Speaker Idol was founded by Denny Cherry, who unfortunately cannot attend PASS Summit this year. In his desire to see this competition continue, he supports PASS in facilitating the competition, along with organizer and host, Hamish Watson.

Round 2 - Contestants:

Speaker Idol 2019 Judges:

SessionID: 92767

Using the Power Platform to Radically Change your Business

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Patrick LeBlanc, Phillip Seamark

Title: Using the Power Platform to Radically Change your Business

Description:

How do you change your business with technology? In this session, we will explore how the Power Platform can do just that. We will look at how Microsoft Flow, PowerApps, and Power BI can come together to take your business to the next level!

SessionID: 92785

Operationalize Data Science for Advanced Decision Support

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Carlos Bossy

Title: Operationalize Data Science for Advanced Decision Support

Description:

Modern-day computing power makes it possible to create sophisticated predictive models that classify data, perform anomaly detection, and predict behaviors and tendencies.

Using data engineering principles and the latest tools released by Microsoft in Azure Machine Learning service to create a data science framework, you’ll see how to develop predictive models through the entire life cycle and incorporate them into your applications in a way that impacts the decision-making ability of everyone in your organization.

Through a case study, you’ll learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target and how to use data appropriately and adapt it to the model for maximum results. Best practices will be presented for developing, monitoring, and maintaining predictive models. Integrating predictive models into your architecture will allow you to take a step toward making predictive analytics pervasive in your organization.

SessionID: 92124

DataOps - Deploy SQL Server Databases Using Azure Pipelines

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): MIKE DONNELLY

Title: DataOps - Deploy SQL Server Databases Using Azure Pipelines

Description:

The database is sometimes one of the last areas considered when planning DevOps for new and existing projects. If you are new to Azure Pipelines or Database Projects in Visual Studio this presentation will show you how to combine these technologies to create a consistent database deployment across all your development environments. If you are already using Azure Pipelines and Visual Studio for your applications, you will learn how to include your database. We will go over creating a database project and deploying a Dacpac manually to multiple environments. I will point out things to consider and how to add custom deployment scripts and build validation. Then we will setup an Azure DevOps account and step through creating a pipeline to automatically deploy a data project stored in a git repository. We'll also use Key Vault to store the deployment credentials to avoid sharing around that password everyone uses to deploy manually.

SessionID: 93996

Six Ways to Improve SQL Server Application Security

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Ed Leighton-Dick

Title: Six Ways to Improve SQL Server Application Security

Description:

You know that vulnerabilities exist in your code, in your database. And you want to do something about it. That's good - you're on the leading edge. But what? Where do you start?

In this session, we'll talk about six mindsets you should adopt as you move toward a more secure database development environment. While the strategies are broad, we'll delve into each with specific tactics and examples. By the end of the session, you'll have actionable ideas on how you can move security and privacy forward in your company.

This session is part of the Data Security Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 91864

Different Types of Many-to-Many Relationships in Power BI

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Marco Russo

Title: Different Types of Many-to-Many Relationships in Power BI

Description:

The new composite models in Power BI introduced a new type of relationship cardinality, called many-to-many. Nevertheless, despite their name, they are not many-to-many relationships, they are relationships between tables generated at a different granularity.

In this session, we clarify the purpose of the relationships with many-to-many cardinality, highlighting the significant difference with canonical many-to-many relationships. In the meantime, we show how and when to use the different kinds of many-to-many relationships with several practical examples.

SessionID: 92362

True SQL Server Detective

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Denis Reznik

Title: True SQL Server Detective

Description:

Yes, you've heard this correctly. This is precisely a detective story, even a few stories. Each of them has an intricate plot, several active (or inactive) persons, facts, clues, and evidence.

During the session, we will solve all these cases and complete a path from obtaining information (accurate or inaccurate) to a complete understanding and solution of the problem, which will allow you to feel confident in a similar situation and work more efficiently with SQL Server. I cannot disclose many details so far (you understand), but I can tell you that the topics of performance tuning, blocking, and server management will take part in this detective story, and the examples themselves are true.

SessionID: 92865

Start off the Season with Azure Snowflake

Back to calendar

Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Reeves Smith

Title: Start off the Season with Azure Snowflake

Description:

We’ve entered the age of the cloud data warehouse, but why is it still so hard to manage? Snowflake will change the way you think about data warehousing. Snowflake decreases the administration and complexity overhead needed for a scalable data warehouse. All this without breaking the bank.

Snowflake is a multi-cluster solution with complete separation of compute and storage. With the separation of resources, we can scale up and/or out compute at any time independent of storage. This also means that data loading tasks can run on separate compute from query tasks while accessing the same shared data resource and without contention.

Discover how easy it is to create a cloud data warehouse that delivers performance, simplicity, concurrency and affordability with very little administration.

SessionID: 94020

SQL Server Migration: The Last Mile

Back to calendar

Event Date: 07-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Pedro Lopes

Title: SQL Server Migration: The Last Mile

Description:

The post-migration/upgrade step is crucial for reconciling any data accuracy and completeness, as well as uncover query performance issues with the workload, as it runs on the newer version of the Database Engine. This is especially critical when you upgrade from older SQL Server versions such as 2008/2008R2 to modern versions like SQL Server 2017/2019, and you want to leverage the latest query optimization features. The expectation is that the workload performance improves, but it’s possible that part of the workload actually regresses, noticeably due to changes in the Query Optimizer over the years.

In this session, we will go over the recommended process to upgrade your database that minimizes risk, and what features we have available to automate this critical step (Query Store, Automatic Tuning, and QTA).

This session is the fourth session in the Modernizing with SQL Server 2019 Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92817

SQL Containers in 5 minutes and 5 lines of code

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Aaron Nelson

Title: SQL Containers in 5 minutes and 5 lines of code

Description:

You've heard that containers are the hot thing and the future of computing. Unfortunately, it’s not always clear how they apply to SQL Server, or even how to get started. Fortunately, with PowerShell and Docker, it’s easy to get going.

In this session, we will see how to get started with SQL-on-Linux containers in Docker. In 5 lines of code and enough time to get coffee, we’ll have SQL Servers that we can query. We’ll cover everything you need to get started as well as how containers support QA and Dev environments.

By the end of this session, you’ll understand the basics of containers and how to run SQL Server with them. You’ll also see how being able to rapidly spin up new containers supports development and testing.

SessionID: 92542

The Future Is Here for Containers!

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy

Speaker(s): Marsha Pierce

Title: The Future Is Here for Containers!

Description:

Demonstrate how to use docker swarm to quickly spin up many containers and persist the same data set to all of the containers. This is what every developer wants. Should your container be on premise or the cloud? Does it matter? Demonstrate how to move a container between on premise and the cloud with data.

SessionID: 92529

Batch Execution Mode on Rowstore Indexes

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Niko Neugebauer

Title: Batch Execution Mode on Rowstore Indexes

Description:

With the upcoming appearance of the SQL Server 2019, Microsoft is bringing the super-fast Batch Execution Mode to the processing of the big amount of data even for the traditional Rowstore Indexes on SQL Server 2019 and Azure SQL DB.

Learn with me how and when it will function, and which challenges we shall meet on the path of making our workloads work blazingly faster, while also learning which cases one should be very careful about their application and usage.

SessionID: 98854

Azure Arc: Bring Azure Data Services to On-Premises, Multi-Cloud and Edge

Back to calendar

Event Date: 08-11-2019 08:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Amit Banerjee, James Rowland-Jones

Title: Azure Arc: Bring Azure Data Services to On-Premises, Multi-Cloud and Edge

Description:

Azure data services are now enabled by Azure Arc to run on Kubernetes and infrastructure of your choice.

Join us in this session to learn how you can gain access to latest Azure innovation on data, get cloud benefits like automation at scale and elastic scale, plus a unified management experience with modern cloud billing models across hybrid environments.

SessionID: 91121

Whacha Just Say? Talking Technology to Non Technical People

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Ray Kim

Title: Whacha Just Say? Talking Technology to Non Technical People

Description:

Many tech professionals are faced with the challenge of explaining technical concepts to people who don’t understand technology. And only a few are able to do it well. This session provides some strategies and suggestions to go about bridging the technological knowledge gap. With time and practice, a technical person can serve as an effective interpreter of technical concepts. This is an interactive session; audience participation is expected and encouraged!

SessionID: 99531

Delivering a Data Warehouse in the Cloud

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Jeff Renz

Title: Delivering a Data Warehouse in the Cloud

Description:

Are you ready to make the move from an on-premise data warehouse to the cloud? Do you have concerns about the effort required to lift and shift your warehouse? Confused about pricing? What about security?

In this session you will learn how to evaluate the scalability and cost-effectiveness of an Azure SQL Data Warehouse. We will demonstrate how to provision an Azure SQL data warehouse, design and load data into tables using Azure Data Factory and PolyBase. Next, we will explain how to leverage distribution schemes, compressed in-memory indexes, and how to analyze workloads using DMVs to improve performance. Finally, we will show how to manage security following best practices.

SessionID: 98950

SPEAKER IDOL - ROUND 3

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Hamish Watson

Title: SPEAKER IDOL - ROUND 3

Description:

Speaker Idol gives 12 community members the opportunity to present a lightning talk with immediate feedback from a panel of judges and compete for a guaranteed speaking spot at PASS Summit 2020. This experience allows you to get in front of the community and make yourself known. In fact, several previous contestants have gone on to speak at PASS Summit, even without winning the competition.

Contestants will compete in groups of four, over three different rounds. One winner will be selected from each round to compete in the Final Round, along with one contestant selected as a wild card.

Speaker Idol was founded by Denny Cherry, who unfortunately cannot attend PASS Summit this year. In his desire to see this competition continue, he supports PASS in facilitating the competition, along with organizer and host, Hamish Watson.

Round 3 - Contestants:

Speaker Idol 2019 Judges:

SessionID: 93580

Complete CI/CD for C# and SQL

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Tim Corey

Title: Complete CI/CD for C# and SQL

Description:

Are your C# and SQL deployments pain-free and push-button easy? If not, this session will help you get closer to that magical place.

The session will be a demo-heavy, practical demonstration on how to move towards a more automated way of managing and deploying both your software and your databases.

The demo application will be a C# web application with two different associated databases (one generated by Entity Framework and one built by hand). The first step will be to move the entire project and all databases into source control. The next step will be to set up an automated build process. After that, a set of deployment options will be established, including different deployments for different environments.

See how easy it is to automate your CI/CD pipeline, even with SQL databases. Along the way, you will learn about the pitfalls to avoid, best practices to follow, and how to take this system to the next level.

All source code for the demonstration will be provided, as well as additional resources to aid in further learning.

SessionID: 92257

Architecture Blueprints for Power BI Implementation

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Reza Rad

Title: Architecture Blueprints for Power BI Implementation

Description:

Implementing a Power BI solution is not just about the report development, dashboard design, and DAX queries. Designing the right architecture is an essential part of a Power BI implementation.

There are many areas to consider when you are designing a Power BI architecture. From sharing reports and security, to the type of connection and usage of other components such as dataflow.

Come to this session to learn about important things you need to know about the architecture of a Power BI solution. You will learn some blueprints of what are key things to consider and how to design the architecture for your solution.

SessionID: 94173

AI for Analysts

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Leila Etaati

Title: AI for Analysts

Description:

Using AI in your role is the new norm for data professionals. The analyst is no exception. Properly leveraging AI and ML techniques will enable you to provide the right insights, leading to better decision making within your organization. As an analyst, you may not be responsible for the technical aspect (coding or developing AI), but you will consume AI, applying the models, charts, and tools against your data.

In this session, we will go through an overview of how AI impacts the analyst role and what you need to know to be a part of a successful AI strategy in your organization. We will cover approaches, techniques, and tools that will help you to achieve your goals. We will discuss how to optimize the collaboration between you and your data science team (who created models) and your managers (who need high-level reports and analysis from you to drive the business). Overall, we will give you the knowledge you need to begin to leverage AI in your work, enhancing both your value to your company, and your career.

This session is part of the AI for Everyone Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 91894

What's Going On in My Power BI Environment?

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Asgeir Gunnarsson

Title: What's Going On in My Power BI Environment?

Description:

As Power BI is a self-service tool, it can be hard for administrators to monitor it. Power BI is fast improving in this context but there still isn’t a consistent way of monitoring it. There are compliance, governance, performance, and implementation questions to consider. Who is creating content, how is it being distributed, what data is being used, how long does the refresh take and how is it changing, who has a trial license, and what report is the most used? These are just some of the questions you as an administrator of Power BI might want to get answers to.

In this session, we will look at how you can find those answers by monitoring Power BI. We will look at the Power BI Audit log for usage, license, and other audit information. We will look at what the Power BI API can show us about data sets, refresh history, Enterprise Gateway information, premium capacity, and artifact inventory. The audience leave the session ready to start their own monitoring of all or some of the topics.

SessionID: 90987

Real-time Sentiment Prediction in SQL Server

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Hiram Fleitas

Title: Real-time Sentiment Prediction in SQL Server

Description:

In this session, I'll show you from start to finish how to use Machine Learning to predict a sentiment in real-time with Python and SQL Server (On-Premise or Cloud).

AGENDA:

5 DEMOS

  1. Setup • Add ML Features • Grant Access & Configure • Install Pre-Trained Models
  2. Debugging • Requirements.txt • Common Vulnerabilities • Python Profiling
  3. Performance • In-Database ML • realtime_scoring_only = True • sp_rxPredict • Performance Metrics
  4. Cognitive API • (T-SQL) for json path • (Python) json_normalize • CognitiveAPI.ipynb • Trollhunters.ipynb • (PDF) TrumpUkraine.ipynb
  5. Spark Streaming • Paginated Report • Ethics and Terms • Streaming (Spark in BDC)

I look forward to seeing you there!

SessionID: 94018

Inside SQL Server on Kubernetes

Back to calendar

Event Date: 08-11-2019 08:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Bob Ward

Title: Inside SQL Server on Kubernetes

Description:

Containers are the new "virtual machines" and one of the hottest technologies in the industry. While containers compliment virtual machines and provide consistency, portability, performance, and availability, how do you deploy containers at scale? For many, Kubernetes, an open-source system for automating deployment, scaling, and management of containerized applications, is the answer.

In this session, we will dive deep into the Kubernetes platform and how SQL Server containers can be deployed, managed, and configured. You will see how SQL Server can take advantage of Kubernetes for "built-in" high availability, easy to deploy patching, and integration with Always On Availability groups. We will discuss deploying SQL Server in various popular Kubernetes distributions including but not limited to Azure Kubernetes Service, OpenShift, and kubeadm. This session assumes a fundamental knowledge of both SQL Server and containers. We will move fast, and go deep using demos as a method to learn SQL Server and k8s.

This session is the fifth session in the Modernizing with SQL Server 2019 Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92710

Data Privacy, Security, Ethics and Compliance in a Data-Driven World

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Data Governance/Privacy

Speaker(s): Martin Catherall

Title: Data Privacy, Security, Ethics and Compliance in a Data-Driven World

Description:

New advances in technology coupled with the rate of change in the data-driven world are placing the issue of Privacy and Ethics at the forefront of public consciousness – forcing a discussion around the ethical use of data within business and the role that each data professional must play in ensuring that the highest standards are reached, maintained, and constantly evaluated. Technologies such as machine learning, artificial Intelligence, and big data processing are providing new business opportunities that must also account for privacy and ethics issues while maintaining a balance with compliance, security, and integrity of data.

But what are the issues that individual data professionals should be aware of to avoid reputational damage to their companies and themselves? And what are the tools that can help them in their endeavors?

This session will take a close look at some of these challenges and the tools that are available to help mitigate these issues and risks.

SessionID: 92715

Bringing Source Control to BI world!

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Heidi Hasting

Title: Bringing Source Control to BI world!

Description:

Do you ever have trouble finding the latest version of a report?

Do you want to see the changes to a database/cube/report over time?

Do you need to identify where a field is used across your BI environment?

Do you have issues with parallel development?

Do you work in a Business Intelligence environment with no source control?

If you answered yes to any of these questions, then this session is for you! We will go through:

  1. Why source control is important
  2. The different Visual Studio project types (Databases, Analysis Services, Integration Services, and Reporting Services)
  3. How to bring an existing Business Intelligence environment into Source Control
  4. How to facilitate parallel development

Let's bring order to your chaos!!

SessionID: 96617

pwsh? Using PowerShell on Linux

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Rob Sewell

Title: pwsh? Using PowerShell on Linux

Description:

“pwsh” – you might think that’s a sound that you would have heard Linux admins use about Windows tooling in the past, but I will show you how powerful it can be for Linux users and how you can use it to interact with Azure and SQL Server.

In this introductory session, you will learn how to install and use PowerShell on Linux, how to help yourself to learn more, and some use cases for PowerShell on Linux.

(and the meaning of pwsh!)

SessionID: 94174

Getting the Most Out of Your Microsoft Windows and SQL Server Migration to Google Cloud

Back to calendar

Event Date: 08-11-2019 08:00 - Category: Partner Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Ori Kashi

Title: Getting the Most Out of Your Microsoft Windows and SQL Server Migration to Google Cloud

Description:

Google Cloud is committed to helping customers run their Microsoft Windows and SQL Server-based applications and workloads on Google Cloud Platform.

In this session, you will learn about use cases and best practices for migrating and running Microsoft technologies (e.g. Microsoft Windows and SQL Server, Active Directory, BYOL, etc.) on Google Cloud Platform. You will be exposed to reference architectures and demos, as well as new features and roadmaps for our migration tools, and managed services (e.g. Anthos, Managed Service for Microsoft AD, Cloud SQL for SQLServer, and Velostrata). Come and learn how you can take advantage of Google’s infrastructure and innovation.

This session is part of the Cloud Migration Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92283

Reduce Cost by Tuning Queries on Azure DBaaS

Back to calendar

Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Rajnikant Tandel

Title: Reduce Cost by Tuning Queries on Azure DBaaS

Description:

Poorly written queries on on-premise server slow down the server performance, but with Azure SQL Database, those queries not only degrade the performance, but also cost money. When you tune queries in Azure SQL Database, you might get an additional benefit of reducing resource demands, your application might be able to run at a lower compute size, and eventually you can reduce the cost. In any given SQL Server instance, there are likely 8 to 10 queries or stored procedures which are responsible for 80 to 90 percent of the server load. If you can identify these problem queries and tune them, you can make a significant impact on the overall performance of your database.

This presentation will explain some simple techniques of tuning the queries and will demonstrate before and after performance differences.

SessionID: 98855

Turbocharge Your SQL Server with In-Memory Database

Back to calendar

Event Date: 08-11-2019 09:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Pam Lahoud

Title: Turbocharge Your SQL Server with In-Memory Database

Description:

In order to get the most out of the latest hardware innovations, you need the latest software innovations as well. SQL Server 2019 introduces a suite of new and improved memory optimized technologies that take advantage of modern hardware to take performance and scalability to the next level. Come learn how to scale your database applications to new heights with SQL Server In-Memory Database.

SessionID: 98840

SQL Managed Instance: a Fully Managed SQL Server in the Cloud

Back to calendar

Event Date: 08-11-2019 09:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Jovan Popovic, Mladen Andzic

Title: SQL Managed Instance: a Fully Managed SQL Server in the Cloud

Description:

SQL Managed Instance offers the best combination of a fully managed cloud service and SQL Server compatibility. This makes it the recommended destination for migration of most SQL Server workloads to cloud. Over the last year, SQL Managed Instance has been much enhanced in terms of functionality, the networking and security setup has been simplified, and new purchasing options have brought lower entry points and economy-at-scale offers. The time to migrate is now, so start exploiting the increased productivity and cost savings that the managed cloud gives you. Come to the session to hear about the best practices of cloud migration, hear the latest enhancements of SQL Managed Instance and the future roadmap.

SessionID: 92189

Neither Here Nor There - Hybrid AO SQL Architecture On-Prem/Azure

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure

Speaker(s): Danny Ravid, Yitzchak Wahnon

Title: Neither Here Nor There - Hybrid AO SQL Architecture On-Prem/Azure

Description:

In todays' ever-changing environments, on-prem is still the default, but the cloud is fast becoming a requirement for organizations. We will take Always On from an on-prem only architecture to a hybrid on-prem/Azure Cloud Solution. Learn from eToro, the biggest social trading company. In this session, we will cover and demonstrate Always On challenges, terminology, configuration, troubleshooting, and pitfalls in global architecture. We will also cover backup best practices, compliance, and more....

SessionID: 92186

Data Classification and Masking: the What and How of Data Protection

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Martin Cairney

Title: Data Classification and Masking: the What and How of Data Protection

Description:

As organisations make greater use of their data assets across multiple systems and environments, there is an increased risk of exposing unmasked sensitive data. This is particularly a concern when regulations such as GDPR are also in play.

However, copies of data used in dev/test or in analytics need to be an accurate representation of the primary data so omitting, or doing a simple replacement of sensitive values, may skew any results.

This session will introduce tools and processes that can be used to help protect your data. It will firstly show how the Data Classification utility in SSMS and SQL Server can identify and categorize your sensitive data. We will then see how dynamic and static Data Masking can be used to either hide sensitive data from selected users or to completely replace specific classifications of data with new values that both protect the source and also ensure that the distribution of data values remains consistent for your test environments.

SessionID: 92631

Help Me SSIS Logging, You're My Only Hope!

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Vanessa Kesten

Title: Help Me SSIS Logging, You're My Only Hope!

Description:

When something goes wrong with your SSIS package and you need to tell your boss more than "I have a bad feeling about this…", let the force of SSIS logging save you from the dark side!

SSIS logging may be the last thing on your mind when starting a new project, but getting it right in the beginning is well worth your while. Logging can help troubleshoot errors, tackle inefficiencies, and even raise a red flag when there are issues in your data flow. Newer versions of SQL Server have brought new options for logging. Learn what information is available for each option along with how to implement custom logging when the built-in options aren't robust enough for your project's needs.

SessionID: 95650

Data Warehousing: Which of the Many Cloud Products is the Right One for You?

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Ginger Grant

Title: Data Warehousing: Which of the Many Cloud Products is the Right One for You?

Description:

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: 98839

Presenting Big Data Clusters for SQL Server 2019

Back to calendar

Event Date: 08-11-2019 09:30 - Category: Microsoft Session (75 minutes) - Track: Big Data

Speaker(s): James Rowland-Jones

Title: Presenting Big Data Clusters for SQL Server 2019

Description:

Big Data Clusters is a brand-new feature in SQL Server 2019 that delivers the best of open source with everyone’s favorite database engine!

Learn how Microsoft has leveraged containers and Kubernetes to blend Apache Spark, Apache Hadoop, and SQL Server into a single deployment package to help you create a focal point for analytics in your organization.

SessionID: 92685

Power BI Report Server Enterprise Architecture, Tools to Publish

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Data Platform Strategy

Speaker(s): Vishal Pawar

Title: Power BI Report Server Enterprise Architecture, Tools to Publish

Description:

To improve the performance, sustainability, security, and scalability of enterprise-grade Power BI implementations with constant velocity, we need to adhere best practices.

In this session, Vishal will go over Power BI ecosystem with example, PBI RS' evolution from its inception, architecture of enterprise Power BI Report Server and usage through various tools available to publish - SSDT, SSRS, Power BI Desktop (Optimized Version), Report Builder and Mobile Report Builder, and various best practices for PBI Report Server.

SessionID: 93590

Data Modeling Trends for 2019 and Beyond

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Ike Ellis

Description:

There is so much confusion on how to model decision-making data for analysis. The number of products and tools the average company uses to store data has exploded. The database vendors are competing and releasing features at an astounding rate. One vendor says one thing while another vendor says another thing. The cloud vendors have also accelerated the pace of change. Do we still need a star schema? Do we create aggregate tables? How do we handle temporal data? How should we create slowly changing dimensions? These things are creating a confusing atmosphere for the data modeler.

It is true that data modeling has changed, but there is no need to throw out great practices that have served us for years and can continue to do so. This session will cover what has changed for data modeling, why it changed, and how to take advantage of those changes. Combine new thinking with classic data architecture and you will create great analytic and transactional systems for your data.

This session is the fourth session in the Becoming an Azure Data Engineer Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98369

ANALYTICS SPOTLIGHT: The New Analyst

Back to calendar

Event Date: 08-11-2019 09:30 - Category: Keynote (90 minutes) - Track: Advanced Analytics

Speaker(s): Donald Farmer

Title: ANALYTICS SPOTLIGHT: The New Analyst

Description:

In this spotlight, Donald Farmer will explore some of the skills and technologies that are needed for the new analytics. We will look at how analysts can work with data science and data engineering to everyone’s advantage; the importance of data literacy in modern business; and how being comfortable with ambiguity will become an essential skill.

SessionID: 92199

Best Practices for Branching Database Code in Git

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Kendra Little

Title: Best Practices for Branching Database Code in Git

Description:

SessionID: 98793

Modernize SQL Server Workloads in The AWS Cloud: Self-Managed, Managed, and Serverless

Back to calendar

Event Date: 08-11-2019 09:30 - Category: Partner Session (75 minutes) - Track: Database Administration

Speaker(s): Tom Staab

Title: Modernize SQL Server Workloads in The AWS Cloud: Self-Managed, Managed, and Serverless

Description:

Organizations today are looking to free themselves from the constraints of on-premises databases and leverage the power of databases in the cloud.

AWS offers a range of options to run SQL Server workloads in the cloud – reflecting our customers’ needs. Organizations can choose to deploy SQL Server on EC2 Windows and Linux. They can move to Amazon RDS for SQL Server that makes it easy to set up, operate, and scale SQL server workloads in the cloud. They can also modernize their SQL Server workloads by moving to Amazon Aurora, a built for the cloud database that gives you performance and availability of commercial-grade databases at 1/10th the cost.

This session will cover why you should consider moving your on-premises SQL Server deployments to AWS Cloud and the tools to get started. We will cover the different choices to run SQL Server workloads in the AWS Cloud and explore which option is right for you. This session will help you: • Learn considerations for deploying Microsoft SQL Server workloads in the AWS Cloud. • Learn best practices for running SQL Server workloads on EC2 Windows & Linux and Amazon RDS for SQL Server. • Learn how you can modernize your SQL Server workloads by moving to Amazon Aurora, a built for the cloud database with features such as multi-master, multi-region, and serverless.

SessionID: 99530

Successful ORM Design Strategies

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Jim Wooley

Title: Successful ORM Design Strategies

Description:

Object Relational Mapper (ORM) tools allow developers to focus on adding business value rather than spending extra development cycles on building often problematic plumbing code. These tools make persistence and retrieval from relational data stores easy (in some cases too easy) leading to performance and maintenance challenges.

In this session, we’ll examine common design patterns and strategies that you should consider when using ORM tools for data access, schema management, and object structures. We’ll explore some successful strategies to ensure maintainable and flexible uses of ORMs.

SessionID: 92427

Azure Data Studio - The New Frontier

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Warwick Rudd

Title: Azure Data Studio - The New Frontier

Description:

Have you heard about Azure Data Studio? In this fast-paced arena of Data Professionals, this new, light weight, cross platform tool from Microsoft is released on a monthly cycle, providing ever increasing new features to assist you with managing and maintaining your Data Platform fleet.

In this demo heavy, introductory session we will introduce you to ADS, discuss its origins, and explain why this tool is not just for SQL Server. We will even show you some useful tips and tricks to make your life easier as a data professional!

SessionID: 92693

Hardware 301: Choosing Database Hardware for SQL Server 2019

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Glenn Berry

Title: Hardware 301: Choosing Database Hardware for SQL Server 2019

Description:

Microsoft made some sweeping changes to their software licensing model for SQL Server 2012; moving from socket-based licensing to core-based licensing. This new licensing model alters much of the conventional criteria for hardware selection for database servers that will be running SQL Server 2012 and newer. This change still causes a significant amount of angst, with fears of huge increases in SQL Server licensing costs compared to older versions of the product.

This session will cut through the uncertainty and hype to show you how to properly evaluate and choose your database hardware for usage with SQL Server 2016 and newer. You will learn how to choose hardware for different types of workloads and how to get the best performance and scalability for the lowest licensing cost, whether you are running in a physical or virtualized environment.

SessionID: 92725

Reporting for Developers

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Tillmann Eitelberg, Frank Geisler

Title: Reporting for Developers

Description:

Power BI and Reporting Services can both be addressed with different programming languages, but have fundamentally different developer stories.

SQL Server Reporting Services (SSRS) is fully integrated with Visual Studio to provide a comprehensive development environment and full support for Application LIfecycle Management. SSRS also provides a good API for automatic generation of mass reports. Power BI has more strengths in the management area, but offers fewer possibilities in the programmatic development of reports. Power BI in the embedded flavor offers previously unavailable functions in the integration of a comprehensive reporting platform into own applications.

In this session, we will take a detailed look at the possibilities offered by the different platforms. We show when and where each platform can best be used, whether on-premises or in the cloud. Using many examples and demos, we show which functions the individual platforms offer and which challenges await the developer.

SessionID: 92201

Surviving the Next Azure Outage Like a Boss

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): David Bermingham

Title: Surviving the Next Azure Outage Like a Boss

Description:

It’s 6:30am the morning of Sept. 4th, 2018. You receive the first of what will be many messages regarding offline SQL Servers before your first cup of morning Joe. You try to log on to the Azure Portal, only to discover that the portal itself is unavailable. This is just the beginning of what will turn out to be the longest three days of your entire career as a database professional. This is not an episode of the Twilight Zone, this was the real life scenario of many unfortunate DBAs that discovered their SQL Server instances located in Azure’s South Central Region were running without an adequate business continuity plan in place.

Session attendees will learn what caused the Azure outage and what Microsoft is doing to ensure that type of outage never happens again. Armed with that knowledge, SQL Server HA and DR solutions, along with Azure Site Recovery, Availability Zones, Fault Domains, and more will be examined to determine which configurations will survive the next Azure outage.

SessionID: 92528

Deep Dive into Blocking and Deadlocks Troubleshooting

Back to calendar

Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Dmitri Korotkevitch

Title: Deep Dive into Blocking and Deadlocks Troubleshooting

Description:

SQL Server Concurrency Model is, perhaps, the most confusing and least understood part of SQL Server Internals. Blocking issues and deadlocks occur unexpectedly and negatively impact performance and user experience in the systems. Nevertheless, this model is well-structured and easy to understand when you analyze it from lock types and their lifetime, and compatibility standpoints.

This, two-part session will explain why blocking and deadlocks occur, and how to troubleshoot them in your environments. First, it will provide the overview of SQL Server Concurrency Model and describe SQL Server locking behavior and root-causes of typical blocking issues. Next, the session will discuss how to capture and troubleshoot them using standard SQL Server tools, and how to simplify the analysis using Blocking Monitoring Framework developed by Dmitri.

SessionID: 91415

Hash Match, the Operator

Back to calendar

Event Date: 08-11-2019 09:30 - Category: Half-Day Session (2.5 hours) - Track: Development

Speaker(s): Hugo Kornelis

Title: Hash Match, the Operator

Description:

SQL Server has a lot of different execution plan operators. By far the most interesting, and the most versatile, has to be the Hash Match operator. Hash Match is the only operator that can have either one or two inputs. It is the only operator that can either block, stream, or block partially. And, it is one of just a few operators that contribute to the total memory grant of an execution plan. If you ever looked at execution plans, you will have seen this operator. And, you probably have a rough idea of what it does. But do you know EXACTLY what happens when this operator is used?

In this black belt session we will dive deep into the belly of the operator to learn how it performs. This is going to be a wild ride, so keep your hands, arms, and legs inside the conference room at all times; and please remain seated until the presenter has come to a full stop.

SessionID: 91927

Azure Machine Learning 101

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Kathi Kellenberger

Title: Azure Machine Learning 101

Description:

There are several ways to create a machine learning model. You can use R or Python, or even other languages such as C#. Advanced coding skills are required no matter which language you choose. Once the solution is created, it’s often difficult to deploy.

Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.

If you are experienced in machine learning, but haven’t seen Azure ML, or if you are curious about machine learning and data science, this session is for you.

SessionID: 92365

Database CICD (Continuous Integration and Deployment)

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Simon Cho

Title: Database CICD (Continuous Integration and Deployment)

Description:

10 years ago, DBAs typically maintained a few critical databases.

These days, it's not strange anymore that a DBA maintains several hundred databases.

Without automation CICD pipeline, a DBA would be the bottleneck for the faster deployment.

Industry pretty much required who has the ability to automation of database deployment and operation.

This session will delivery the automation of database operation including deployment and design and architecture of environment.

SessionID: 92387

"What's in a Name?", Data Stories that Would Make the Bard Proud

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Prathy Kamasani, James McGillivray

Title: "What's in a Name?", Data Stories that Would Make the Bard Proud

Description:

Data on its own is useful, but boring. Data in story form makes people sit up and take notice.

Every year, the U.S. Census Bureau compiles a data set of the names given to children born per state. In this session, we'll take this publicly available data set and use it to create an epic data story.

You will learn how to identify key data points, visualize them effectively, and create a compelling narrative to present your findings to any type of audience.

So, whether your data story is a history, a tragedy, or a thriller, you'll learn how to tell it in a way that will captivate and enthrall your audience.

This session is the third session in the Data Visualization and Storytelling Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 94002

Successfully Managing Upwards And Getting Your Boss On Your Side

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Edwin M Sarmiento

Title: Successfully Managing Upwards And Getting Your Boss On Your Side

Description:

Highly effective and productive IT teams are formed when members work together as a team.

But what if your boss/manager isn't being a team player? He doesn't trust you to get the job done. He micromanages every single detail of a project or a task. He lacks vision of what he wants in the team as a contribution to the organization. He makes you feel inferior and does not assign you more challenging tasks. He lacks creativity and innovation when this is what's really needed by the IT team.

Wouldn't it be great if your boss was on your side and the team could get amazing results, contributing to the growth and profitability of the organization? The team can deliver more projects, spur up innovations, and increase morale, so that you will be excited to go to work every single day.

This session talks about how to successfully and effectively manage upwards and get your boss on your side to improve team dynamics and performance. I'll share the S.I.T. Framework for effectively connecting not just with your boss, but your other colleagues as well. This step-by-step game plan can help you get your manager’s buy-in, even if you have never been a manager yourself.

This session is the third session in the Communication for Technical Professionals Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 92697

Improving Database Code Quality with Unit Tests

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Elizabeth Noble

Title: Improving Database Code Quality with Unit Tests

Description:

You're a developer or DBA who cares about code quality, but you don't have automated testing for your T-SQL code --- yet. That's about to change!

In this session, you will learn how to unit test your T-SQL code. You will learn how to build unit tests into your own development environment. You'll see demonstrations of how to create and run unit tests to confirm functionality of database objects using test driven design. You'll leave the session with a knowledge of which tools help you create unit tests for SQL Server and a checklist of how to get started writing your first tests.

SessionID: 92336

AI to the Masses! But How? Pixie Dust?

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Hope Foley

Title: AI to the Masses! But How? Pixie Dust?

Description:

The way you hear about artificial intelligence, it seems like you throw some big data in the cloud and wave a magical AI wand over it and you can predict the future…right? Not exactly.

Azure does have some great options to bring data science to your data, but you need to weigh the options. In this session we'll discuss those options and some questions to answer if you're being tasked with making magical things happen with your data.

SessionID: 91464

Let's Automagically Stage 100 Tables. For SSIS or ADF. With Biml. Live.

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Ben Weissman

Title: Let's Automagically Stage 100 Tables. For SSIS or ADF. With Biml. Live.

Description:

Are you still building manual SSIS packages? Are you struggling with a transformation of on-prem SSIS to Azure Data Factory? Are you bored from repeating the same steps over and over again?

Then this session is just for you! We will explore how the Business Intelligence Markup Language (Biml) can help us to automagically build SSIS packages from meta data, and how we can just use the very same information to spit out all the JSON we need to make this an ADF pipeline. You will leave with the tools, demos, and approaches to implement this at your organization right away!

SessionID: 95455

Take Me to the (Multiple) Clouds Above Seattle

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Johan Ludvig Brattås, Rune Ovlien Rakeie

Title: Take Me to the (Multiple) Clouds Above Seattle

Description:

Cloud computing is very much in focus for many companies, but in the multitude of offerings among the different cloud providers – which one should you choose?

Some cloud providers gain praise and popularity for some of their services, and others for a different set of services – why should a company stay locked in to just a single cloud provider?

Enter the multi-cloud, where companies cherry-pick the best-of-breed solutions from multiple cloud providers to build their data platform.

This approach is gaining traction in the market, but it comes with its own set of challenges that you will need to consider and take into account when designing and implementing your data platform.

Topics covered in this session will be cloud computing strategy, use cases for multi-cloud data management, data integration/migration, and best practices

Join two of Norway’s most experienced cloud solution architects in this session to learn how they work with multi-cloud.

And yes, there will be demos.

SessionID: 98841

Best, Better, Hyperscale! The Last Database You will Ever Need in the Cloud

Back to calendar

Event Date: 08-11-2019 11:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Denzil Ribeiro

Title: Best, Better, Hyperscale! The Last Database You will Ever Need in the Cloud

Description:

Do you struggle with large unwieldy databases and application sprawl? In this session, discover what to use and when, patterns and best practices for moving to Azure with Hyperscale. We'll take a deep dive under the covers of Hyperscale, to show how Microsoft has achieved a truly cloud scale and cloud native database deployment. Come understand how Hyperscale can enable you to innovate with a future-proof, world class, fully managed database that offers all the SQL Server features that you know and love.

SessionID: 92221

Azure DevOps and the SSIS Development Lifecycle

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Andy Leonard

Title: Azure DevOps and the SSIS Development Lifecycle

Description:

Data Integration Lifecycle Management - or DILM - is challenging regardless of your chosen data integration platform.

The primary goal of this session is an explanation - via demonstration - of the production release of an SSIS Project. We will walk this project through lifecycle management using Azure DevOps - from initial development, through testing, to production.

SessionID: 92258

Power Query, M and Dataflow; The Lightsaber for the Data Jedi

Back to calendar

Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Reza Rad

Title: Power Query, M and Dataflow; The Lightsaber for the Data Jedi

Description:

Microsoft Power Query is the transformation engine in Power BI. This is the engine with which you do all data preparation before loading data into the model. This is the keystone of your Power BI solution.

In this session, learn what Power Query can do. Learn how M, the language behind the scenes of Power Query, can be more beneficial than the Power Query graphical interface. See demos of transformations that you can do with M Code. Learn about functions, parameters, generators, and many other amazing features of this tool. The session continues with bringing the important role of Dataflows in Power Query transformations. Prepare to be amazed by what Power Query can do in this demo-filled session!

SessionID: 92539

Capturing SQL Server activity with SQL Server Audit

Back to calendar

Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Ed Leighton-Dick

Title: Capturing SQL Server activity with SQL Server Audit

Description:

In today’s environment, more and more companies are finding that they need to capture the activity on their SQL Server instances. SQL Server Audit is a tool built into SQL Server that is designed to fill that need. With this tool, a DBA can capture nearly any action taken on a SQL Server, even some that cannot be captured by any other method.

In this session, we’ll take a detailed look at the capabilities of SQL Server Audit, how to configure it, and how to use the data it produces. We’ll also look into the areas where SQL Server Audit falls short and how to supplement it with other SQL Server tools to provide a complete auditing solution.

This session is part of the Data Security Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98836

Deep Dive with Data Migration Tools and Azure Database Migration Service (DMS)

Back to calendar

Event Date: 08-11-2019 11:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Charles Christian, Sreraman Narasimhan

Title: Deep Dive with Data Migration Tools and Azure Database Migration Service (DMS)

Description:

SessionID: 91037

Elementary! The Curious Case of Deceptive Query Optimizer

Back to calendar

Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Pinal Dave

Title: Elementary! The Curious Case of Deceptive Query Optimizer

Description:

We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will carefully investigate inside the Query Optimizer together and attempt to understand why it often behaves in a manner which is beyond common sense.

While we investigate our crime scene of poorly running query, we will come across many unusual and usual suspects, like - statistics, query hints, indexes, cardinality, and compatibility.

Just like a true investigator, we will figure out why Query Optimizer is not a criminal, but rather a victim of circumstances. Before we end the session, we will have a revelation of the true culprits.

The journey would not be an easy one, join only if you have a keen desire to solve the mystery and learn advanced level concepts of Query Optimizer.

SessionID: 92451

Should I Move My Production SQL Server Workloads to Containers?

Back to calendar

Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Victor Isakov

Title: Should I Move My Production SQL Server Workloads to Containers?

Description:

With the release of SQL Server 2016 Microsoft started on the journey of containerizing SQL Server's database engine. By the time Microsoft releases SQL Server 2019 you might get the impression that the Windows operating system and/or virtual machines have become second-class citizens of SQL Server; that you should be deploying SQL Server in Containers and/or Kubernetes in the future... Nothing could be further from the truth.

In this session, we will examine the case of whether you should move your production SQL Server workloads to containers. Along the way we will examine the architectural difference and both the advantages and disadvantages of containerizing your production SQL Server workloads.

SessionID: 92240

Giving Feedback: How to Effectively Communicate to your Employees

Back to calendar

Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Christine Assaf

Title: Giving Feedback: How to Effectively Communicate to your Employees

Description:

As a manager or team leader giving effective feedback is vital to the success of projects. Managers often ascend the hierarchy due to their technical skill set, but rarely learn ways to successfully communicate with their team.

In this session, we will discuss soft skills and best practices to give feedback. We’ll learn the essentials for an interaction and how to prepare for tough conversations. Using sample coaching conversations, we’ll run through examples to help you prepare for your next tough dialog. Whether it is a simple coaching sit down, or performance improvement related, and even disciplinary actions, learn how to handle confrontation tactfully.

SessionID: 99244

Introduction To Data Governance

Back to calendar

Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Warren Sifre

Title: Introduction To Data Governance

Description:

Data Governance has been seen by many as a very SCARY and BIG thing requiring biblical efforts to understand and more so to implement. Our discussion will provide context for what, why, and how of Data Governance. You will have an understanding of this and more importantly a road map for how to begin to implement and evangelize within the organization.

SessionID: 91973

Query Analysis Deep Dive: 13 Causes of a Slow Query

Back to calendar

Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Fabiano Amorim

Title: Query Analysis Deep Dive: 13 Causes of a Slow Query

Description:

What if we could analyze a single query with thirteen different performance problems? In this session we’ll explore a query, understand and fix all thirteen of these problems:

  1. There is a nonsargable filter
  2. An index is missing
  3. It is a query optimizer mistake
  4. The subquery is unnecessary
  5. Query join order is incorrect
  6. A filtered statistic is missing
  7. Scalar functions are running twice per each row
  8. High number of reads on worktable
  9. An unknown syntax could be used
  10. Memory grant wasn’t enough
  11. Distributed query doesn't look good
  12. Residual predicates
  13. Avoid window spool ondisk

By the end of this session you'll have a checklist to review the next time your query is running slowly.

SessionID: 99094

Staying Involved with PASS

Back to calendar

Event Date: 08-11-2019 13:00 - Category: Marketing Community Session (45 minutes) - Track: Professional Development (Other)

Speaker(s): Kevin Kline

Title: Staying Involved with PASS

Description:

Learn more about the PASS community and how PASS Summit attendees can stay involved throughout the year with Local Groups, Virtual Groups, Regional Events and more.

SessionID: 95580

Entity Framework Performance Monitoring and Tuning

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Jim Wooley

Title: Entity Framework Performance Monitoring and Tuning

Description:

Object Relational Mapping technologies, including the Entity Framework can drastically simplify the programming model against databases, but when done carelessly, performance can suffer.

In this session, we'll explore some real-life strategies that have solved performance issues in production applications that I have encountered with a variety of customers. We'll discuss the pros and cons of working without stored procs and cover strategies for monitoring and tuning your entity queries.

SessionID: 92382

Query Store In-Depth

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Ola Hallengren

Title: Query Store In-Depth

Description:

Query Store has become one of the most important tools for troubleshooting performance problems. However, there are some quirks that are important to be aware of.

In this session, I will share my experiences about how Query Store is working in different scenarios. We will also look at some real-world cases. Finally, we will look at Query Store in SQL Server 2019.

SessionID: 92668

Managing ETL Change Using BIMLScript

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Russel Loski

Title: Managing ETL Change Using BIMLScript

Description:

Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata.

To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.

SessionID: 92686

Infrastructure for the DBA: An Introduction

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Peter Shore

Title: Infrastructure for the DBA: An Introduction

Description:

It doesn’t matter if you are a Junior DBA, an accidental DBA, or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles. It is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening.

This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization, and operating system layers. Additionally, some suggestions as to where to find more information will be provided.

SessionID: 92467

JSON for the Data Mortals

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Jim Dorame

Title: JSON for the Data Mortals

Description:

Do you see curly brackets stored in your database and wonder what that is? Are you a DBA, with developers storing JSON in your database? As a database administrator or developer, it's important to understand JSON today.

This session will explain what JSON is, where it came from, and why it is showing up all over the place. When you leave this session you will understand how to investigate, manipulate, and validate JSON in your database. You will walk away with example code of how to use Microsoft’s additions to SQL Server to use this data.

SessionID: 91655

MSAs, GMSAs, and Groups - Use SQL Without Traditional User Accounts

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Chris Bell

Title: MSAs, GMSAs, and Groups - Use SQL Without Traditional User Accounts

Description:

Security is becoming more critical in today’s database environment. At times it can seem like the DBA is also a domain admin and security team on top of everything else. Managing user domain accounts access in your DB can get tedious fast, especially as your environment grows.

In this session, we will discuss and see some Active Directory features that can help re-enforce the concept of the separation of duties when it comes to security and ways to reduce the risks and complexities in managing a SQL environment’s security. We will review the process and requirements for implementing AD Groups, Active Directory’s Managed Service Accounts (MSA), and Group MSAs to be used to manage access and operate your SQL environment.

SessionID: 98843

What's new in Security for Azure SQL/MI

Back to calendar

Event Date: 08-11-2019 14:00 - Category: Microsoft Session (75 minutes) - Track: Security

Speaker(s): Andreas Wolter, Rohit Nayak, Mirek Sztajno

Title: What's new in Security for Azure SQL/MI

Description:

As a leader in data security technologies, Azure SQL continues to attract more and more business-critical applications handling financial, healthcare, government and other sensitive data. Join this demo-heavy session to see the latest Azure SQL security innovations in action and learn about new customer scenarios and opportunities the new security technologies unlock. You will get the first-hand look at the new cutting-edge capabilities in network security, authentication, data encryption, security management, and other areas.

SessionID: 98951

SPEAKER IDOL - FINALE

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Hamish Watson

Title: SPEAKER IDOL - FINALE

Description:

Speaker Idol gives 12 community members the opportunity to present a lightning talk with immediate feedback from a panel of judges and compete for a guaranteed speaking spot at PASS Summit 2020. This experience allows you to get in front of the community and make yourself known. In fact, several previous contestants have gone on to speak at PASS Summit, even without winning the competition.

Contestants will compete in groups of four, over three different rounds. One winner will be selected from each round to compete in the Final Round, along with one contestant selected as a wild card.

Speaker Idol was founded by Denny Cherry, who unfortunately cannot attend PASS Summit this year. In his desire to see this competition continue, he supports PASS in facilitating the competition, along with organizer and host, Hamish Watson.

Speaker Idol 2019 Judges:

SessionID: 98844

Ingesting and Managing Petabytes of Data with Azure Data Factory

Back to calendar

Event Date: 08-11-2019 14:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Anand Subbaraj, Gaurav Malhotra

Title: Ingesting and Managing Petabytes of Data with Azure Data Factory

Description:

Today, modern data warehouse and analytics projects require more and more data, but not just that, they also require visibility and accessibility across the entire data estate.

This session explores the improvements, in Azure Data Factory simplifying data integration and management in Azure – including how to enable code-free ETL/ELT, to creating a comprehensive overview of your data. Learn how these improvements will empower you to confidently absorb and manage more data, leading to valuable insights for your enterprise.

SessionID: 92369

From Fear to Confidence – Learn the Art of Influence

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)

Speaker(s): Chad Crawford

Title: From Fear to Confidence – Learn the Art of Influence

Description:

Do you live in fear that future changes in technology will render your skill and experience obsolete? Are your traditional SQL Server installations slowly being replaced by NoSQL, Docker, and Linux, and you are afraid you will be replaced or your influence reduced? Hopefully, co-workers ask for your opinion before making any changes in production. When they do, how do you decide if it’s a good move or not?

Your instinctive response might be to reject new tech and defend the status-quo, but doing that can seriously damage your reputation and career. In this session, you will learn how to impartially evaluate new technology, determine if it fits in your environment, and communicate the results to your coworkers. Most importantly, you will come to understand that questions about new technology represent an incredible opportunity: handling them well will improve your reputation, increase your standing among peers, and make you a stronger leader.

SessionID: 92671

How to Build an Impactful KPI Scorecard in Power BI

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Reid Havens

Title: How to Build an Impactful KPI Scorecard in Power BI

Description:

Knowing the right visuals, DAX, and design to build out a professional scorecard report can be challenging. Follow one development journey as we will leverage native and custom visuals, DAX calculations, and design practices to build out a quality Power BI scorecard. The scorecard talk will be broken down into three sections. Section one will cover the basics of the report design by leveraging a DAX calculated table inside a Matrix Table visual. Section two will cover DAX measures, KPIs, and conditional formatting. The final section three will cover custom visual sparklines, and design practices to clean up the report for delivery to the client.

SessionID: 91248

Comparing Predictive Models from R, Python, SSAS, and Azure ML

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Dejan Sarka

Title: Comparing Predictive Models from R, Python, SSAS, and Azure ML

Description:

There is a lot of overlapping in Microsoft BI suite. For advanced analytics, like data mining, you can use SQL Server Analysis Services (SSAS), or R, or Python, or Azure ML. The question arises, which tool to use? The answer is simple, through another question: Why not all of them?

In data mining, you typically create multiple predictive models for the same task, and then evaluate them to select the best one. So why wouldn’t you use different tools for different models? You will learn how to evaluate the predictive models, then you will see how to bring all of the mining models together and compare them no matter which source they come from. You will see how you can use SQL Server Integration Services, Excel, and other tools for this task.

SessionID: 91230

Azure Data Studio Extension Development

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Drew Skwiers-Koballa

Title: Azure Data Studio Extension Development

Description:

Cross-platform and approachably extensible, Azure Data Studio is a new application for database development and management. Azure Data Studio extensions can create efficiencies by automating a workflow or integrating with an external system.

This session will take the audience through the fundamentals of extension development for Azure Data Studio with Typescript and other open source tools. Our discussion will include available internal APIs, hosting your extension on GitHub, and sharing your work through the extension marketplace. By demonstrating each concept through building an extension in the session, we will end with a working extension utilizing functionality released recently in Azure Data Studio. 

SessionID: 91348

Dynamic SQL: Writing Efficient Queries on the Fly

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Edward Pollack

Title: Dynamic SQL: Writing Efficient Queries on the Fly

Description:

Dynamic SQL is a powerful tool that allows for the creation of fast and efficient queries when the specifics may not be known until run-time. This tool can be used to automate complex processes, facilitate reporting on an unknown number of targets, or perform tasks that would otherwise be time-consuming to develop.

This is an often misunderstood tool that is underused in areas where it can provide immense value or abused by applications that it was never intended for. Well-written dynamic SQL can solve seemingly impossible problems while being easy to read and understand.

Applications that will be demonstrated include: mapping database relationships, schema searching, generating large volumes of TSQL, and much more. Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it!

SessionID: 92819

PowerApps and AI: A Flow of Location Events

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence

Speaker(s): Jeremy Frye

Title: PowerApps and AI: A Flow of Location Events

Description:

The Microsoft Power Platform has become an innovative bridge between data interaction, visualization, and analytics. The possibilities have become almost endless for businesses to engage with their data in amazing ways.

In this session, we will create an application using PowerApps and location services to track latitude and longitude coordinates on Bing maps. Attendees will learn how to configure and demonstrate it on a mobile device. I will also show two approaches using AI within the application by using Azure SQL Database, Cognitive Services and Flow. An end-user will be able to leverage Bing Search for location-aware web searches, while an administrator will be able to leverage the Azure SQL Database and Flow to send alerts based on predefined metrics.

SessionID: 92300

Managing and Monitoring SQL Server on Linux from the Command Line

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Randolph West

Title: Managing and Monitoring SQL Server on Linux from the Command Line

Description:

When SQL Server arrived on Linux in 2017, Microsoft brought with it a database engine that works exactly the same as it does on Windows. While you can manage and monitor SQL Server on Linux, using existing tools designed for Windows, there are command line tools that will feel right at home to seasoned command-line and scripting veterans, including Oracle DBAs.

This session will cover installation (including a Docker install), mssql-conf (for configuring the server instance), mssql-cli (for connecting to the database engine), and dbfs (mounting a virtual file system) to query database management views (DMVs) using bash.

This session is the third session in the Linux for SQL Server Professionals Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 98835

Enterprise-Grade BI with Power BI: Enterprise Information Management (EIM), Scale and Performance

Back to calendar

Event Date: 08-11-2019 14:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Richard Tkachuk, Miki Ben-Ze'ev, Assaf Shemesh

Title: Enterprise-Grade BI with Power BI: Enterprise Information Management (EIM), Scale and Performance

Description:

Power BI is the Microsoft enterprise BI Platform that enables comprehensive, enterprise-scale analytic solutions that deliver actionable insights across your organization.

This session covers new and upcoming experiences that help manage and govern advanced analytical projects and optimize performance at scale. Learn how to track lineage, understand impact across projects, discover organizational assets, and protect your Power BI data with granular policies and controls. Use Power BI to create semantic models that are reused throughout large, enterprise organizations.

SessionID: 92507

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

Back to calendar

Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy

Speaker(s): Thomas Grohser

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

Description:

As with all other items in your toolbox the datacenter (local or in the cloud) needs to be used correctly.

This 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. To wrap things up, we look at ways to validate that the SLA can be fulfilled and how to estimate and compare the costs.

SessionID: 90990

Data Modeling and Prototyping in Power BI Desktop

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Steve Wake

Title: Data Modeling and Prototyping in Power BI Desktop

Description:

Power BI Desktop is often shown as a self-service reporting and analytics tool, but it can also be used earlier in the development cycle for prototyping and data modeling, doing it quicker and easier than other tools made for this purpose.

In this session, we will go through multiple examples showing how Power BI Desktop is the perfect tool to quickly model data from multiple data sources (including web sites, databases, cubes, online services, and even flat files), and perform quick actions to cleanse and connect these various sources to each other using M and DAX functions built-in to Power BI Desktop. Once this model has been built, it can be used to create some quick reports to show how this will be used to help get a project approved/funded. Best of all, using Power BI Desktop to do all of this is completely free, no licensing or Power BI login required!

SessionID: 99069

Code Like a Snake Charmer – Advanced Data Modeling in Python!

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Jamey Johnston

Title: Code Like a Snake Charmer – Advanced Data Modeling in Python!

Description:

This session will dive in-depth into proper data modeling and deployment using the Python language including:

  1. Data extraction
  2. Data cleaning
  3. Data transformation
  4. Data exploration and visualization
  5. Predictive modeling
  6. Model validation/testing
  7. Deployment of the solution.

Attend this session to learn how to use Python to conduct data analysis and modeling. We will use Python and packages like pandas, numpy, matplotlib, scikit-learn and others to explore real-world datasets and build data models using proper techniques like feature engineering, splitting datasets into validation and training datasets, testing data models, interpretability of a machine learning (ML) models and deploying data models into Azure. The focus of this session will be on proper data modeling.

SessionID: 92810

6 Months to 5 minutes, DB & BI Deployments at the Speed of Light

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Jan Mulkens

Title: 6 Months to 5 minutes, DB & BI Deployments at the Speed of Light

Description:

Do you like Scrum as a Cargo Cult, hours of Planning Poker, CAB meetings, unhappy people, processes that are meant to slow down innovation, elaborate change management, and thousands of pages of documentation?

Neither do we.

This is the story of how a team of 6 at one of the largest international banks did everything they could to fight the status quo. From going against management demands and being the ugly duckling team to providing 4 other teams with a platform, services, and training.

You will not learn the typical cool technical tricks in this session. Instead, you'll learn how we overcame organisational barriers to actually work in an Agile mindset and how we slowly implemented Continuous Delivery in our Database, BI, and Document Management systems while under constant outside pressure.

You'll leave with the knowledge to help your team and yourself!

SessionID: 92241

Reporting Services: A Smart Migration Strategy

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Ted Stathakis

Title: Reporting Services: A Smart Migration Strategy

Description:

With Power BI Report Server, you can host traditional paginated reports alongside Power BI analytical reports, KPIs, and mobile reports.

This session will show how to use the data in the ReportServer database to determine a smart migration strategy for upgrading to a new SSRS or Power BI Report Server. Starting with the new features of Report Manager, Mobile Reports, KPIs, and the Mobile Report Publisher app. The session will then focus on how to utilize the report meta data in the ReportServer database, combined with the transaction log table, to show how to determine which reports, data sets, and data sources are being used and determine what objects to migrate.

Learn how to use PowerShell to extract the reports and data sets from the database, instead of downloading them, to facilitate an easy migration to a new implementation. Also, discover a way of determining all TSQL used by the reports. This session is particularly useful for migrating from 2008, but applicable to any migration.

SessionID: 92764

How Do I Ensure my Azure Modern Data Warehouse is Secure?

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Data Platform Strategy

Speaker(s): Sriharsh Adari

Title: How Do I Ensure my Azure Modern Data Warehouse is Secure?

Description:

One of the major concerns customers have when setting up cloud based data platforms is security. 84% of organizations believe that traditional security doesn't work for cloud.

In this session, we will take a case study approach to review how data and Azure Data Platform resources can be secured when setting up a Modern Enterprise Data Platform in Azure. You can understand detailed security options and customer questions regarding network security, open ports, secure client connections, firewall, and limitations around VNET rules and Azure Active Directory across services. In the process, we will also review SQL security features like threat detection, vulnerability assessment, and encryption options. You will leave this session with a comprehensive understanding of all the security options available and how to implement them in Azure Data Platform landscape.

SessionID: 98846

Azure SQL Database Serverless: Compute Autoscaling Solution to Optimize Database Price-Performance

Back to calendar

Event Date: 08-11-2019 15:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration

Speaker(s): Morgan Oslake

Title: Azure SQL Database Serverless: Compute Autoscaling Solution to Optimize Database Price-Performance

Description:

Azure SQL Database Serverless is a new compute tier that optimizes price-performance and simplifies performance management for single databases with intermittent, unpredictable usage. Serverless automatically scales compute for databases based on workload demand and bills only for compute used per second. Serverless also automatically pauses databases during inactive periods when only storage is billed and automatically resumes when activity returns.

Join us for this session to learn about using serverless in SQL Database to reduce costs while achieving performance goals.

SessionID: 92796

Data Quality Round-trip in the MS Dataplatform 2019

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Data Governance/Privacy

Speaker(s): Oliver Engels, Tillmann Eitelberg

Title: Data Quality Round-trip in the MS Dataplatform 2019

Description:

Do you need a Data Quality Solution? Do you work with Data Quality Services (DQS) or Master Data Services (MDS)? Are you interested what the Microsoft Data Platform has to offer in addition? We will show, based on various demos, how you can leverage Machine Learning Services, Common Data Model, Azure Data Factory, SQL Server 2019, and more to solve data quality problems.

SessionID: 90963

ABCs of the Power BI REST API

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Jens Vestergaard

Title: ABCs of the Power BI REST API

Description:

In this session, we will be looking into managing our Power BI content using only the Power BI REST API. While the Power BI REST API is extensive, we will be limiting this session on the following sections of interest: dashboards, datasets, reports, and groups.

How many dashboards are there in a workspace? Which datasource is this dataset configured to use? Who is allowed to see this report? Can I take ownership of this dataset? How do I refresh my dataset? Is my dataset refreshing on a schedule?

Those are just some of the questions we will find the answers to.

Examples will be provided in Powershell, which may require minute skills up front. Not to worry, a quick intro will be provided as well.

Attending this session will make you familiar with the Power BI REST API and provide you with guidance on how to manage the most common tasks in Power BI.

SessionID: 92298

Azure DevOps Pipelines for BI

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Mike Diehl

Title: Azure DevOps Pipelines for BI

Description:

DevOps is all the rage, but how can you achieve this goal with your SQL databases, Analysis cubes, and SSIS packages?

In this session, you'll learn how to build and release Visual Studio SSDT projects and Power BI reports using Azure DevOps Pipelines.

You'll also see the development practices that you can use to track your code changes in source control, but still use development databases to write T-SQL views and procedures and understand the benefits of SQL database projects such as compile-time checking and refactoring support.

DevOps practices can improve code quality significantly by discovering issues early in the development cycle, and increase team velocity by reducing the friction of deployments to different environments.

SessionID: 98845

Large-Scale Migration of On-Premise Big Data Workloads to Azure

Back to calendar

Event Date: 08-11-2019 15:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing

Speaker(s): Elizabeth Oldag, Shane Risk

Title: Large-Scale Migration of On-Premise Big Data Workloads to Azure

Description:

Moving extensive amounts of data from On-Premise to Azure can be a daunting task, but it doesn’t have to be. Discover the resources, best practices, and partner solutions to ensure a successful big data migration using Azure Data Lake Storage (ADLS) Gen2, Azure SQL Data Warehouse, and other associated analytics services. Learn how to utilize Data Box and other data movement offerings to migrate existing data, at petabyte scale, and how to successfully transfer both big data and relational analytics workloads alongside the data.

SessionID: 92480

Continuous Intelligence... What's This All About?

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: DevOps

Speaker(s): Gabi Münster, Benjamin Kettner

Title: Continuous Intelligence... What's This All About?

Description:

Continuous Intelligence combines the terms of Continuous Integration and Business Intelligence and aims at defining and implementing processes to keep your implementation and deployment processes for your BI applications flexible and as seamless as possible.

Even in the near past, support for CI processes of BI projects was almost not there. But, the last few years brought some changes to the perception of this topic and shifted the mindset. Let's look at advantages and challenges for CI in BI and at possibilities to implement such a process for Analysis Services.

SessionID: 92228

Identifying Anti-Patterns in Analytical Queries

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Development

Speaker(s): Bert Wagner

Title: Identifying Anti-Patterns in Analytical Queries

Description:

Nothing is more nerve-racking than waiting for your queries to finish when approaching a tight deadline. In a world where time is money and management wants results yesterday, how do you make sure your queries finish quickly so you can deliver your analytical results on time?

Bert Wagner, a Principal Business Intelligence Developer, regularly advises analysts and developers on how minor changes to their SQL-based jobs can dramatically improve performance. In this session he will demonstrate ways to restructure your analytical jobs and queries to allow you to get the best performance possible.

Whether you strictly write SQL queries or incorporate those queries into tools like Python, R, Power BI, SSRS or SSIS, this session will leave you feeling confident in recognizing and eliminating major performance anti-patterns, ensuring you are able to deliver your work on time.

SessionID: 92498

Upgrading SQL Server - Prepare for Success!

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Mike Walsh

Title: Upgrading SQL Server - Prepare for Success!

Description:

It's (way past) time to upgrade your SQL Server environment, especially you sitting there on SQL Server 2008! Where do you start? What version should you pick? How do you migrate? What about the downtime? ARGH!

Come to this session and take the stress out of your SQL Server upgrade project. In this session, we'll walk through all you need to think about and do before, during, and after your upgrade for success. We'll answer your upgrade questions, but you'll also leave with the right questions to ask everyone else as you prepare for a successful SQL Server upgrade project. We'll talk about successful upgrade checklists, best practices, why roulette is better than in-place upgrades, and how to minimize the strain on your users and teams during the upgrade. You'll leave with a working start on your upgrade checklist and plans too, with a lot of free content and tools!

Come on! Ditch those SQL Server 2008, 2012, and 2014 instances! Also, yes, we'll chat about the cloud some, too.

SessionID: 92281

LIGHTNING TALKS

Back to calendar

Event Date: 08-11-2019 15:30 - Category: Lightning Talk (10 minutes) - Track: Database Administration

Speaker(s): MIKE DONNELLY, Jennifer McCown, Paul Wehland, Jorge Besada, Dennes Torres, Edward Pollack

Title: LIGHTNING TALKS

Description:

This Lightning Talk session will be comprised of six 10-minute talks on PowerShell, SQL Server Administration, Varchar(max), and more!

Sessions and Speakers will include:

Michael Donnelly - Beyond the Database: Going Fullstack to Understand Developers Data Professionals sometimes get trapped in our database bubble. Last year I got curious about technologies I’ve only heard about but never needed to use. I will share what I learned about becoming a full-stack engineer and how it has made me a better DBA. I’ll share why people like ORMs and why developers see the database as a small part of the puzzle. I will also provide information on resources to teach yourself all the technologies I learned.

Jennifer McCown - Complete SQL Server Administration in Ten Minutes In this talk, you will learn about the three essential maintenance tasks, and how the free Minion Maintenance suite makes handling these tasks effortless for DBAs who are new (or very busy!). We'll also talk about how deeply configurable the maintenance solution is, and set up a set of backup tuning configurations. Ten minutes will solve quite a lot of your maintenance problems!

Dennes Torres - Varchar(max) and Text: Hidden Secrets Text field is deprecated and should be replaced by Varchar(max) fields. Are they both really the same? In this talk, I will show some interesting differences among these field types and how you can prevent performance problems when replacing Text by Varchar(max) fields

Jorge Besada - PowerShell From The Trenches - Workflows ...Of Course Yes! The PowerShell Workflows, you have seen them from afar in articles and decided it was too much trouble! I get it, I am describing my personal experience. But in reality, you just need to follow some simple (ok some not so simple) steps to start putting them to good use and augmenting your productivity at work by a big chunk ... which will make the Pointy Haired Boss happy

Edward Pollack - Memory-Optimized Table Variables in 10 Minutes Using Memory-Optimized Table Variables allows for the creation, management, and disposal of temporary data completely within memory, without the need to store data on disk. In this talk, Memory-Optimized Table Variables will be introduced, discussed, and demonstrated. The most common use-cases for this feature will be introduced, as well as how they can allow you to overcome some of the limitations found in Natively Compiled Stored Procedures.

Paul Wehland - 3 Tricks for Faster Index Maintenance on Availability Groups Index rebuilds are a common task for DBAs. But if you are on an Always-On Availability Group, your databases are in FULL Recovery mode. This means that your index rebuild is fully logged, instead of minimally logged when in BULK_LOGGED recovery mode. This makes for some slow index rebuilds and could risk over-running your maintenance windows. This talk will discuss 3 tricks to help speed your index rebuilds on Always-On Availability Groups.

SessionID: 92355

Azure Data Studio: The Challenger

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Database Administration

Speaker(s): Dan de Sousa

Title: Azure Data Studio: The Challenger

Description:

Azure Data Studio is a light-weight, open source, cross-platform database management tool that does not require installation and can run from an external device. It was developed to run on Windows, Linux, and MacOS and supports platforms both on-premises and cloud.

In this session, I will introduce the tool, its capabilities, its features and benefits, and a comparison to its main competitor, SQL Server Management Studio. Be aware that Azure Data Studio does not replace SSMS, and depending on the situation, environment, and requirements/tasks performed, they may work together. I will explain and demonstrate scenarios and which tool you would choose over the other. I will also cover the built-in monitoring functionality, dashboards, widgets and extensions, data export options, and notebooks.

SessionID: 92572

Secure SQL Server Database Design: Tactics and Technology

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Security

Speaker(s): Dan Mallott

Title: Secure SQL Server Database Design: Tactics and Technology

Description:

When we design and build an application, do we think about security first or is it an afterthought? As we read about more and more data breaches, it is clear that we need to think security-first when designing and building our applications.

Where does design start for an application? It starts with the database layer. In this talk, we will discuss strategies for designing a more secure SQL Server database. We will start with simple design decisions for tables, views, stored procedures, and database roles that can improve security before moving on to talk about built-in SQL Server security technologies such as Always Encrypted, Row-Level Security, Dynamic Data Masking, Transparent Data Encryption, and SQL Server Audit. Lastly, we will finish up with some tips on how to retrofit security features onto existing databases and look at how data access from the application may need to change.

SessionID: 99101

Relational Data Modeling Trends for Transactional Applications

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Cloud Solutions

Speaker(s): Ike Ellis

Description:

There is so much confusion regarding data modeling today. NoSQL solutions, Microservices, In-memory data stores, and cloud vendors have all combined to create a confusing atmosphere for the application data modeler. Is the EF Codd era over? Are we over or under normalized? How important is modeling to performance? Do we use the data model to enforce data integrity and business logic rules? Is it OK to repeat data?

When EF Codd made the rules, he was under different constraints and had different priorities than we have. We need to understand the current constraints of the modern application and re-prioritize our design principles to accomodate them. We need to emphasis the ability to change the model to keep up with the rate of change that business is demanding of us. Come to this session to learn how to correctly model data in a fast-changing business application environment.

SessionID: 99398

Effective Requirements Gathering for Successful Project Outcomes

Back to calendar

Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Advanced Analytics

Speaker(s): Kevin Kline

Title: Effective Requirements Gathering for Successful Project Outcomes

Description:

Requirements gather is an essential and early step in every database design and application development project. It seems so easy – just ask a few questions about what the users and customers want, then start building the application and database. But wait! There are numerous pitfalls and problems in your futures if you are not precise and deliberate about how you collect, prioritize, and communicate those requirements. Let’s not fall into those same traps.

This session gives you a simple and easy-to-follow roadmap to the best practices for gathering requirements so that your project delivers results that make your stakeholders happy and enable you to finish the project on time and with minimal stress. You will learn important concepts and best practices, like:

  1. Establishing the scope of the project
  2. Interviewing and communicating with stakeholders to best ensure thorough understanding of the requirements by all parties involved
  3. Documenting the project requirements, with documents samples that you can use in the future
  4. Differentiating the requirements gathering needs of Agile versus traditional software development techniques
  5. Avoiding the most common mistakes in requirements gathering

After completing this session, you’ll have an easy step-by-step process that takes the mystery out of effective requirements gathering and helps to ensure that your database projects and application development endeavors proceed quickly, have fewer issues, and successfully satisfy those demanding users and customers for whom you work. Join us!