Lightning Talks

Sessions and Speakers will include: Michael Grayson - Support What?! SQL Server and MongoDB: A side by side "How To" More and more companies are starting to invest in multiple database platforms and DBAs are needing to develop a skillset to support a mixed-database environment. Database concepts are often the same between platforms, however, the “how” can be very different (and sometimes not that different at all!). Starting with the basics and gradually moving into the more advanced, this talk will show you how to perform the same task in SQL Server and MongoDB. Kimberly StJacques - Introduction to SQL Server 2019 Enhanced PolyBase Do you have ETL processes pulling data from multiple data sources into a data warehouse so you can run reporting from a single source? SQL Server 2019 enhanced the PolyBase feature that was introduced in SQL Server 2016. Come learn how the new PolyBase features enable you to generate reports on data stored in all of your data sources without the need of a physical data warehouse! This is a great introduction for the PolyBase beginner. Jens Vestergaard - PBIRESTAPI, no time for spaces... In this talk, we will be looking into managing our Power BI content using only the Power BI REST API. Examples will be provided in Powershell, which may require minute skills up front. What will be demoed: Can I take ownership of this Dataset? How do I refresh my Dataset? Is my Dataset refreshing on a schedule? Paul Andrew - Using Azure DevOps for Azure Data Factory DevOps as a process is here to stay and is typically a must have requirement for any data platform solution. But how does the concept translate to the technology when implemented? Sadly, the answer isn’t always straight forward. In this short session I’ll introduce how we can continuously integrate and deliver our cloud orchestration resource Azure Data Factory (ADF). We’ll discuss three options for getting our service JSON deployed to production using the popular Azure DevOps environment, previously known as VSTS, and think about the suitability of the Microsoft provided ARM templates for our highly dynamic orchestrator. Does the ADF portal UI really support the DevOps methodology? Can we confidently publish our pipelines? How should we handle the branching of our source code for ADF developers? The answers to these questions and more in this lightning session. Martin Catherall - Data Privacy and the Data Professional World What are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens, the entire concept of data storage become more complex. We will see what is exactly legislation like the General Data Protection Regulation and how will it affect around the world. Eugene Meidinger - Coming soon

Watch the session recording from PASS Summit 2019. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: http://www.red-gate.com/pass