| 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 |
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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.
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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*.
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Security
So, developers... what are you going to do about it?
In this one-day session, we're going to discuss a range of topics that developers need to know in order to improve their applications' data security and privacy. We'll cover SQL injection, one of the most common exploits over the last twenty years, in-depth, along with other common vulnerabilities. We'll talk about how to apply permissions and encryption properly in SQL Server to directly protect your data. We'll see how the new class of privacy regulations, including Europe's GDPR and California's CCPA, impact your business - no matter where your company is based. And we'll discuss what you're likely to encounter as your company moves toward a culture of data privacy.
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: DevOps
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 .
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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.
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
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.
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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.
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Big Data
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.
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
Event Date: 04-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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:
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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*.
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
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:
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
This session will take a look at many of the new features of SQL Server and how they can best be leveraged for performance tuning your workload. From In-Memory OLTP to Columnstore Indexes, Query Store, and Extended Events, this session will guide you in finding the source of the problems, and solutions available to make your workload faster and consistently reliable. We’ll even take a look at different alternatives using older features of SQL Server that you may be leaving on the shelf that are a better fit to solving certain kinds of problems.
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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.
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Development
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!
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Development
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
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.
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing
Event Date: 05-11-2019 08:30 - Category: Pre-Conference Session (Full Day) - Track: Data Platform Strategy
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
Event Date: 06-11-2019 00:00 - Category: Luncheon (105 minutes) - Track: Professional Development (Other)
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
Event Date: 06-11-2019 00:00 - Category: Marketing Community Session (45 minutes) - Track: Professional Development (Other)
Event Date: 06-11-2019 00:00 - Category: PASS Event (90 minutes) - Track: Professional Development (Other)
Event Date: 06-11-2019 00:00 - Category: Vendor - Track: Professional Development (Other)
Event Date: 06-11-2019 00:00 - Category: Keynote (90 minutes) - Track: Database Administration
Event Date: 06-11-2019 00:00 - Category: PASS Event (90 minutes) - Track: Professional Development (Other)
Event Date: 06-11-2019 00:00 - Category: Keynote (90 minutes) - Track: Security
Event Date: 06-11-2019 00:00 - Category: Vendor - Track: Professional Development (Other)
Event Date: 06-11-2019 00:00 - Category: Vendor - Track: Professional Development (Other)
Event Date: 06-11-2019 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Sponsored by: Solarwinds
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Big Data
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.
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
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:
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 06-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: DevOps
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.
Event Date: 06-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: 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.
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 06-11-2019 10:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 10:45 - Category: Partner Session (75 minutes) - Track: Business Intelligence and Data Warehousing
In this session we’ll explore:
Event Date: 06-11-2019 10:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: DevOps
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.
Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
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
Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)
In this session I will show you how to get started. We will go over how to develop your idea, create session content, and I will share my favorite tips and tricks. You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Event Date: 06-11-2019 10:45 - Category: Partner Session (75 minutes) - Track: Development
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
Event Date: 06-11-2019 10:45 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 06-11-2019 12:30 - Category: Marketing Community Session (45 minutes) - Track: Professional Development (Other)
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Big Data
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?
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 06-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 06-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Big Data
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.
Event Date: 06-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Database Administration
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!
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security
This session is the second session in the Data Security Learning Pathway. For more information please visit our Learning Pathways page.
Event Date: 06-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 06-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 06-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Professional Development (Other)
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.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 06-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Database Administration
This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 06-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 15:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
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).
Event Date: 06-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Business Intelligence and Data Warehousing
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Development
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
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!
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Come and learn how to partition, select the right datatypes, and insert the data into a Clustered Column Store Index.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration
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 ;-)
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 06-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 06-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 06-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Development
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 06-11-2019 16:45 - Category: Partner Session (75 minutes) - Track: DevOps
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration
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!
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Data Platform Strategy
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 06-11-2019 16:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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:
Event Date: 07-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 07-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
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.
Event Date: 07-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: Big Data
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.
Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Development
AGENDA: 0. Intro to PowerApps
I look forward to seeing you there!
Event Date: 07-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: Cloud Solutions
This session is part of the Cloud migration Learning Pathway. For more information please visit our Learning Pathways page.
Event Date: 07-11-2019 10:15 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 07-11-2019 10:15 - Category: General Session (75 minutes) - Track: Cloud Solutions
This session will demonstrate how containers are a game changer for deploying and managing SQL Server. It will also showcase how the Azure Kubernetes Service (AKS) is a scalable and highly available platform for SQL Server running in containers.
Demonstrations will show how easy it is to create containers, deploy SQL Server in them, and how to automate and manage your SQL Server containers using Kubernetes on the Azure platform.
This session will show you the exciting future of SQL Server and you will walk away with knowledge of practical scenarios where SQL Server running in containers on Kubernetes may be the right deployment model for you.
Event Date: 07-11-2019 10:15 - Category: Partner Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)
This session is the second session in the Technical Leadership Learning Pathway. For more information please visit our Learning Pathways page.
Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 10:45 - Category: General Session (75 minutes) - Track: Big Data
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Big Data
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Security
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.
Event Date: 07-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Hybrid Infrastructure
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.
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 07-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Hybrid Infrastructure
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.
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)
This session is the third session in the Technical Leadership Learning Pathway. For more information please visit our Learning Pathways page.
Event Date: 07-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 07-11-2019 13:30 - Category: Partner Session (75 minutes) - Track: Database Administration
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!
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
We'll show you demos on:
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
This session will be an introduction to the Python language including:
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.
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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!
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Development
Event Date: 07-11-2019 13:30 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 13:30 - Category: Microsoft Session (75 minutes) - Track: Development
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.
Event Date: 07-11-2019 15:15 - Category: Half-Day Session (2.5 hours) - Track: Cloud Solutions
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 07-11-2019 15:15 - Category: Lightning Talk (10 minutes) - Track: Advanced Analytics
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
Event Date: 07-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Data Platform Strategy
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 15:15 - Category: Partner Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Data Platform Strategy
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure
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.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 15:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
This session is part of the Cloud Migration Learning Pathway. For more information please visit our Learning Pathways page.
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 15:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 07-11-2019 15:15 - Category: General Session (75 minutes) - Track: Database Administration
These learnings are the fruit of Microsoft CSS support cases and customer field engagements. This session includes several demos.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Big Data
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 07-11-2019 16:45 - Category: Partner Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 07-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Development
In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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:
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: DevOps
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Security
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 07-11-2019 16:45 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 07-11-2019 16:45 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: DevOps
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 08:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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:
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: DevOps
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Development
AGENDA:
5 DEMOS
I look forward to seeing you there!
Event Date: 08-11-2019 08:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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:
Let's bring order to your chaos!!
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Development
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!)
Event Date: 08-11-2019 08:00 - Category: Partner Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 08-11-2019 08:00 - Category: General Session (75 minutes) - Track: Database Administration
This presentation will explain some simple techniques of tuning the queries and will demonstrate before and after performance differences.
Event Date: 08-11-2019 09:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 08-11-2019 09:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2019 09:30 - Category: Microsoft Session (75 minutes) - Track: Big Data
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Data Platform Strategy
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 08-11-2019 09:30 - Category: Keynote (90 minutes) - Track: Advanced Analytics
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: DevOps
Event Date: 08-11-2019 09:30 - Category: Partner Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Database Administration
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!
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 08-11-2019 09:30 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 09:30 - Category: Half-Day Session (2.5 hours) - Track: Development
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: DevOps
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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!
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 08-11-2019 11:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 11:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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!
Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Security
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.
Event Date: 08-11-2019 11:15 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 08-11-2019 11:15 - Category: General Session (75 minutes) - Track: Database Administration
By the end of this session you'll have a checklist to review the next time your query is running slowly.
Event Date: 08-11-2019 13:00 - Category: Marketing Community Session (45 minutes) - Track: Professional Development (Other)
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Security
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.
Event Date: 08-11-2019 14:00 - Category: Microsoft Session (75 minutes) - Track: Security
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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:
Event Date: 08-11-2019 14:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Development
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!
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 14:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 14:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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!
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
This session will dive in-depth into proper data modeling and deployment using the Python language including:
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: DevOps
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!
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Data Platform Strategy
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.
Event Date: 08-11-2019 15:30 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Join us for this session to learn about using serverless in SQL Database to reduce costs while achieving performance goals.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: DevOps
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
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.
Event Date: 08-11-2019 15:30 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: DevOps
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Development
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 15:30 - Category: Lightning Talk (10 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Database Administration
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Security
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Cloud Solutions
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.
Event Date: 08-11-2019 15:30 - Category: General Session (75 minutes) - Track: Advanced Analytics
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:
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!