| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 10-11-2020 00:00 | Christine Assaf | Lightning Talk (10 minutes) | Professional Development (Other) | The Human In the Machine |
| 10-11-2020 00:00 | Carlos Robles | General Session (75 minutes) | DevOps | Embracing Database DevOps through CI/CD |
| 10-11-2020 00:00 | Brad Llewellyn, Khendr'a Reid | General Session (75 minutes) | Big Data | Power of Electric Snakes! PySpark for Big Data and Data Science |
| 10-11-2020 00:00 | Christine Assaf | General Session (75 minutes) | Professional Development (Other) | Giving Feedback: How to Effectively Communicate to your Employees |
| 10-11-2020 00:00 | Erin Stellato | General Session (75 minutes) | Database Administration | Query Store Best Practices |
| 10-11-2020 00:00 | John Sterrett | General Session (75 minutes) | Hybrid Infrastructure | Building your First Hybrid Lab |
| 10-11-2020 00:00 | Leslie Andrews | General Session (75 minutes) | Professional Development (Other) | So, You Want to Be an Azure Data Engineer When You Grow Up? |
| 10-11-2020 00:00 | Richard Waymire, Pooya Amini | General Session (75 minutes) | Business Intelligence and Data Warehousing | SQL Server Business Intelligence on Amazon RDS |
| 10-11-2020 00:00 | David Klee | General Session (75 minutes) | Cloud Solutions | 10 Cloudy Questions to Ask Before Migrating Your SQL Server |
| 10-11-2020 00:00 | Ryan Wade | General Session (75 minutes) | Advanced Analytics | Best Practices for Creating Stunning R Visuals in Power BI |
| 10-11-2020 00:00 | Jose Manuel Jurado Diaz, Juan Moreno | General Session (75 minutes) | Database Administration | Attention Contention! |
| 10-11-2020 00:00 | David Maxwell | General Session (75 minutes) | Database Administration | Understanding Accelerated Database Recovery |
| 10-11-2020 00:00 | Alberto Ferrari | General Session (75 minutes) | Advanced Analytics | Budgeting with Power BI |
| 10-11-2020 00:00 | Jeff Duncan | Partner Session (75 minutes) | Cloud Solutions | Accelerate SQL Server Migration to the Cloud: Approach & Methodology |
| 10-11-2020 00:00 | Mihail Mateev | General Session (75 minutes) | Artificial Intelligence | Azure Digital Twins in a Nutshell |
| 10-11-2020 00:00 | Mihail Mateev | General Session (75 minutes) | Data Platform Strategy | Deep Dive on Embedded Analytics with Power BI |
| 10-11-2020 00:00 | Anton Els | Partner Session (75 minutes) | Development | Don't Let Triggers, Foreign, and Primary Keys be a "Constraint" |
| 10-11-2020 00:00 | Michael Lee | Partner Session (75 minutes) | Advanced Analytics | Cleansing, Formatting and Verifying Contact Data Within US and the World |
| 10-11-2020 00:00 | Grant Fritchey | Partner Session (75 minutes) | Database Administration | Monitoring AWS RDS Using SQL Monitor |
| 10-11-2020 00:00 | Steve Jones | Partner Session (75 minutes) | Security | Continuously Classify and Protect Your Sensitive Data |
| 10-11-2020 00:00 | Nathan Boster | General Session (75 minutes) | DevOps | Moving Your SSRS Project to DevOps/Visual Studio |
| 10-11-2020 00:00 | Dennes Torres | General Session (75 minutes) | Big Data | Data Virtualization: Data Lake Power Using SQL Big Data Cluster |
| 10-11-2020 00:00 | Argenis Fernandez | General Session (75 minutes) | Database Administration | Modern High Availability and Disaster Recovery Topologies |
| 10-11-2020 00:00 | Argenis Fernandez | General Session (75 minutes) | Database Administration | Modern Storage Technologies for Data Professionals |
| 10-11-2020 00:00 | Alain Dormehl, Anna Hoffman, Emily Lisa | Microsoft Session (75 minutes) | Cloud Solutions | Azure SQL Built-in High Availability |
| 10-11-2020 00:00 | Arnaud Comet | Microsoft Session (75 minutes) | Advanced Analytics | Self-Service Analytics Using Azure Synapse Link for Azure Cosmos DB |
| 10-11-2020 00:00 | Juan Yu, Thiyagarajan Arumugam | General Session (75 minutes) | Big Data | Navigate Your Big Data Journey with AWS Big Data Services |
| 10-11-2020 00:00 | Yoav Eilat | General Session (75 minutes) | Cloud Solutions | Building a Highly-Available, Scalable Application with Amazon Aurora |
| 10-11-2020 00:00 | Rob Reinauer | Partner Session (75 minutes) | Cloud Solutions | Managing the Transition to Hybrid Cloud |
| 10-11-2020 00:00 | Grant Fritchey, Stuart Ainsworth, Kathi Kellenberger, Mindy Curnutt, Angela Tidwell | General Session (75 minutes) | DevOps | Real-World Challenges to Implementing Database DevOps |
| 10-11-2020 00:00 | Veljko Vasic | Microsoft Session (75 minutes) | Advanced Analytics | Unlocking The Data Lake With Azure Synapse SQL Serverless |
| 10-11-2020 00:00 | Abdul Rasheed | General Session (75 minutes) | Cloud Solutions | Unlock Business Value From Your SQL Server Backups as You Head to the Cloud |
| 10-11-2020 00:00 | Kellyn Pot'Vin-Gorman, Hasham Niaz, DeNisha Malone, Homer McEwen | General Session (75 minutes) | Professional Development (Other) | Diversity, Equality & Inclusion Within Data Community and Outside World |
| 10-11-2020 00:00 | Chris Voss | General Session (75 minutes) | Professional Development (Other) | Neurodiversity and the Data Platform |
| 10-11-2020 00:00 | Rohit Nayak, Jakub Szymaszek, Ron Matchoro, Mirek Sztajno | Microsoft Session (75 minutes) | Security | What’s New in Security & Networking for Azure SQL |
| 10-11-2020 00:00 | Glenn Berry | Half-Day Session (2.5 hours) | Database Administration | Dr. DMV with Jupyter Notebooks |
| 10-11-2020 00:00 | Dan Mallott | General Session (75 minutes) | Development | The Right Tool for the Right Job: Serving Data From SQL Server |
| 10-11-2020 00:00 | Hylke Peek | General Session (75 minutes) | Data Platform Strategy | Common Data Service, Why Is It Not Common Yet? |
| 10-11-2020 00:00 | Erin Stellato | General Session (75 minutes) | Database Administration | Extending Your Use of Extended Events |
| 10-11-2020 00:00 | Wolfgang Strasser | General Session (75 minutes) | DevOps | Let Me Automate You - Take Power BI To The Next Level |
| 10-11-2020 00:00 | James Serra | General Session (75 minutes) | Business Intelligence and Data Warehousing | Azure Synapse Analytics: A Data Lakehouse |
| 10-11-2020 00:00 | Ajay Jagannathan, Anna Hoffman | Microsoft Session (75 minutes) | Cloud Solutions | Azure SQL: What to Use, When, and What's New |
| 10-11-2020 00:00 | Ted Stathakis | General Session (75 minutes) | Business Intelligence and Data Warehousing | Designing Reports for Effective Storytelling |
| 10-11-2020 00:00 | Kathi Kellenberger | General Session (75 minutes) | Database Administration | Intelligent Query Processing |
| 10-11-2020 00:00 | Borko Novakovic, Srdan Bozovic | Microsoft Session (75 minutes) | Cloud Solutions | Modernize Your SQL Applications With the Recently Enhanced Version of Azure SQL Managed Instance |
| 10-11-2020 00:00 | Joe Sack, Pedro Lopes | Microsoft Session (75 minutes) | Cloud Solutions | Azure SQL: Path to an Intelligent Database |
| 10-11-2020 00:00 | Sanjay Mishra, Abdul Sathar Sait | Microsoft Session (75 minutes) | Data Platform Strategy | Elevation to the Cloud – How Our Customers Are Using Azure SQL |
| 10-11-2020 00:00 | Bob Ward, Denzil Ribeiro | Microsoft Session (75 minutes) | Cloud Solutions | Inside Azure SQL Database Hyperscale |
| 10-11-2020 00:00 | Patrick LeBlanc, Adam Saxton | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | What is Power BI Doing to My Database? |
| 10-11-2020 00:00 | Raj Pochiraju, Amit Banerjee | Microsoft Session (75 minutes) | Data Platform Strategy | Lift and Shift Your SQL Servers to Azure SQL Virtual Machines |
| 10-11-2020 00:00 | Amir Netz, Arun Ulagaratchagan | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Microsoft Power BI: Business Intelligence Strategy, Vision, and Roadmap Update |
| 10-11-2020 00:00 | Christian Wade, Priya Sathy | Microsoft Session (75 minutes) | Business Intelligence and Data Warehousing | Microsoft Power BI for the Data Engineer |
| 10-11-2020 00:00 | Dustin Vannoy | General Session (75 minutes) | Business Intelligence and Data Warehousing | Building Data Lakes in Azure |
| 10-11-2020 00:00 | Ben DeBow | General Session (75 minutes) | Professional Development (Other) | Congratulations, You Are Now a DBA |
| 10-11-2020 00:00 | Bob Ward, Anna Hoffman | Pre-Conference Session (Full Day) | Database Administration | The Azure SQL Workshop |
| 10-11-2020 00:00 | Forrest McDaniel | General Session (75 minutes) | Database Administration | Animated Query Plans for the Visual Learner |
| 10-11-2020 00:00 | Tracy Boggiano | General Session (75 minutes) | Professional Development (Other) | Mental Health in IT: Safeguarding Our Most Precious Resource |
| 10-11-2020 00:00 | Erland Sommarskog | General Session (75 minutes) | Development | Splitting Up Your Work in Chunks |
| 10-11-2020 00:00 | Adam Anderson | General Session (75 minutes) | DevOps | Advanced Development Pipelines |
| 10-11-2020 00:00 | Vern Rabe | General Session (75 minutes) | Database Administration | Statistics Techniques Can Fix Tough Performance Issues |
| 10-11-2020 00:00 | Davide Mauri, Silvano Coriani | Microsoft Session (75 minutes) | Development | Azure SQL Is The Best Choice For Building Back-End REST API: Discuss! |
| 10-11-2020 00:00 | Morgan Oslake | Microsoft Session (75 minutes) | Cloud Solutions | Maximize Performance For Less Cost Using Azure SQL Database Serverless |
| 10-11-2020 00:00 | Daniel Shrader | General Session (75 minutes) | Development | Learn Faster in a Container - A Docker Introduction |
| 10-11-2020 00:00 | Angela Henry | General Session (75 minutes) | Data Platform Strategy | Intro to Azure Data Catalog |
| 10-11-2020 00:00 | Brandon Leach | General Session (75 minutes) | DevOps | SQL Server Configuration And Deployment With Powershell DSC |
| 10-11-2020 00:00 | Meagan Longoria | General Session (75 minutes) | Professional Development (Other) | Inclusive Presentation Design |
| 10-11-2020 00:00 | Meagan Longoria | General Session (75 minutes) | Advanced Analytics | Implementing Data-Driven Storytelling Techniques in Power BI |
| 10-11-2020 00:00 | Bob Pusateri | General Session (75 minutes) | Big Data | The ABCs of BDCs: Big Data Clusters for Beginners |
| 10-11-2020 00:00 | Peter Shore | General Session (75 minutes) | Database Administration | A Query Runs Through It: An Introduction to the SQL Server Engine |
| 10-11-2020 00:00 | John Morehouse | General Session (75 minutes) | Security | Understanding Modern Data Encryption Offerings for SQL Server |
| 10-11-2020 00:00 | Benni De Jagere | General Session (75 minutes) | Business Intelligence and Data Warehousing | Troubleshooting Power BI Report Performance |
| 10-11-2020 00:00 | Ed Watson | General Session (75 minutes) | Professional Development (Other) | Public Speaking for the Data Professional |
| 10-11-2020 00:00 | Michael Johnson | General Session (75 minutes) | Development | What’s Your Bacon Number, An Introductions to Graph Databases |
| 10-11-2020 00:00 | Sandy Winarko | General Session (75 minutes) | Business Intelligence and Data Warehousing | Accelerating the Migration of Legacy SSIS with Azure Data Factory |
| 10-11-2020 00:00 | Daniel Glenn | General Session (75 minutes) | Business Intelligence and Data Warehousing | Give Power [BI] to the People - Securely Share Your Insights |
| 10-11-2020 00:00 | Andy Yun | General Session (75 minutes) | Database Administration | A Beginner's Guide to Becoming a Performance Tuner |
| 10-11-2020 00:00 | Kevin Feasel | General Session (75 minutes) | Data Platform Strategy | The Curated Data Platform |
| 10-11-2020 00:00 | Andy Yun | General Session (75 minutes) | Development | Advanced Plan Explorer Usage for Tuning Execution Plans |
| 10-11-2020 00:00 | Randolph West | General Session (75 minutes) | Database Administration | Database Administration Through the Ages |
| 10-11-2020 00:00 | Marija Stojanovic | Partner Session (75 minutes) | Development | From Zero to Hero on SQL Server Source Control |
| 10-11-2020 00:00 | Raoul Illyés | Partner Session (75 minutes) | Database Administration | Data Modernization |
| 10-11-2020 00:00 | James Rowland-Jones | Microsoft Session (75 minutes) | Data Platform Strategy | Big Data Clusters First Birthday |
| 10-11-2020 00:00 | Ben Miller, Brandon Leach, Greg Moore, Rob Sewell, Hamish Watson | General Session (75 minutes) | Database Administration | All About PowerShell Panel Discussion |
| 10-11-2020 00:00 | Janis Griffin | General Session (75 minutes) | Database Administration | Do You Feel the Need… the Need for Speed in Your SQL Server Database? Are You Frustrated With Your Tuning Efforts? |
| 10-11-2020 00:00 | Erin Stellato, John Morehouse, Anthony Nocentino, Monica Rathbun, Matt Gordon | General Session (75 minutes) | Professional Development (Other) | Panel Discussion: Consulting 101 - Help Us to Help You |
| 10-11-2020 00:00 | Steve Jones, Rob Volk, Mike Byrd, Chris Hyde, Nathan Boster, Tariq Younas | General Session (75 minutes) | Database Administration | LIGHTNING TALKS |
| 10-11-2020 00:00 | Martin Cairney, Christine Assaf, Johan Ludvig Brattås, Edward Pollack, Indira Bandari | General Session (75 minutes) | Database Administration | LIGHTNING TALKS |
| 10-11-2020 00:00 | Chris Webb, Kasper de Jonge, Reza Rad, Leila Etaati, Phillip Seamark | General Session (75 minutes) | Advanced Analytics | Power BI Panel |
| 10-11-2020 00:00 | Angela Tidwell | General Session (75 minutes) | Professional Development (Other) | Introduction to PASS Virtual Summit |
| 10-11-2020 00:00 | Bryan Gartner | Partner Session (75 minutes) | Hybrid Infrastructure | Modernizing SQL Server Operations with Kubernetes |
| 10-11-2020 00:00 | Mike Shen | Partner Session (75 minutes) | Business Intelligence and Data Warehousing | A High-Performance, High-Concurrency Architecture for Analytics on Azure |
| 10-11-2020 00:00 | Louis Imershein | Partner Session (75 minutes) | Database Administration | Microsoft SQL Server for Red Hat Solutions |
| 10-11-2020 00:00 | Don Pinto, Zak Berrie | General Session (75 minutes) | Business Intelligence and Data Warehousing | Microsoft SQL Server Machine Learning Workloads on Red Hat Enterprise Linux and Red Hat OpenShift |
| 10-11-2020 00:00 | Andrea Mascher | General Session (75 minutes) | Professional Development (Other) | Diversity, Belonging, & Allyship: Essential DBA Skills for the Data Professional |
| 10-11-2020 00:00 | Patrick LeBlanc | General Session (75 minutes) | Professional Development (Other) | Brand Building Panel Discussion |
| 10-11-2020 00:00 | David Teague | Partner Session (75 minutes) | Database Administration | How Cloud-Agnostic DBaaS with Nutanix Era Can Give You Your Nights and Weekends Back |
| 10-11-2020 00:00 | Hope Foley, Mala Mahadevan, Tracy Boggiano, DeNisha Malone, Jess Pomfret, Anna Hoffman | General Session (75 minutes) | Professional Development (Other) | Diversity in Data Panel Discussion: For the Professional Woman |
| 10-11-2020 00:00 | Thomas LeBlanc | Half-Day Session (2.5 hours) | Business Intelligence and Data Warehousing | Data Warehouse Automation Using Agile Methods |
| 10-11-2020 00:00 | Andy Leonard | General Session (75 minutes) | Business Intelligence and Data Warehousing | Moving Data with Azure Data Factory |
| 10-11-2020 00:00 | Eugene Stepanov | General Session (75 minutes) | Cloud Solutions | Running Managed SQL Server on AWS |
| 10-11-2020 00:00 | Phil Ekins | General Session (75 minutes) | Cloud Solutions | Migrating SQL Servers to AWS |
| 10-11-2020 00:00 | Janis Griffin | General Session (75 minutes) | Database Administration | A Deep Dive into Execution Plans & How to Use Them! |
| 10-11-2020 00:00 | Leonard Lobel | General Session (75 minutes) | Development | Data Modeling and Partitioning Patterns in Azure Cosmos DB |
| 10-11-2020 00:00 | Martin Cairney | Lightning Talk (10 minutes) | Cloud Solutions | Exploring the World of Azure Data Explorer |
| 10-11-2020 00:00 | Grant Fritchey | General Session (75 minutes) | DevOps | Deploy Your Database Using AWS DevOps |
| 10-11-2020 00:00 | Anupama Natarajan | General Session (75 minutes) | Advanced Analytics | Understanding Machine Learning Algorithms Through Examples |
| 10-11-2020 00:00 | Elizabeth Noble | General Session (75 minutes) | Development | Increase Deployment Flexibility with Feature Flags |
| 10-11-2020 00:00 | Niko Neugebauer | General Session (75 minutes) | Database Administration | When & Where to Use Columnstore Indexes |
| 10-11-2020 00:00 | Niko Neugebauer | Half-Day Session (2.5 hours) | Cloud Solutions | Migrating & Running SQL Server on Azure VMs |
| 10-11-2020 00:00 | Nic Hernandez | Partner Session (75 minutes) | Database Administration | Unlock The Value of Your SQL Server Data - Turn Secondary Copies into a Data Lake |
| 10-11-2020 00:00 | Bhakti Hinduja | Partner Session (75 minutes) | Cloud Solutions | SQL Server on AMD-Based VMs in Azure |
| 10-11-2020 00:00 | Ginger Grant | General Session (75 minutes) | Advanced Analytics | Data Analysis with Spark and Databricks in Azure Synapse |
| 10-11-2020 00:00 | Chris Adkin | Partner Session (75 minutes) | Data Platform Strategy | Be a Copy Data Management Hero With These Data Solutions Built into Pure Storage |
| 10-11-2020 00:00 | Steve Jones | Lightning Talk (10 minutes) | Hybrid Infrastructure | The Future of Database Development with Containers |
| 10-11-2020 00:00 | Steve Jones | General Session (75 minutes) | DevOps | Continuous Integration with Local Agents and Azure DevOps |
| 10-11-2020 00:00 | Greg Moore | General Session (75 minutes) | Database Administration | PowerShell for DBA Beginners |
| 10-11-2020 00:00 | Thomas Grohser | General Session (75 minutes) | Data Platform Strategy | Scaling a DWH Beyond the Petabyte |
| 10-11-2020 00:00 | Doug Bernhardt | Partner Session (75 minutes) | Big Data | Power Up Your SQL Databases with Dell Technologies |
| 10-11-2020 00:00 | Dan Mallott | General Session (75 minutes) | Development | ORMs and the DBA: How to Keep Both Happy |
| 10-11-2020 00:00 | Brian Lewis | Partner Session (75 minutes) | Cloud Solutions | AWS, The Proven, Most Reliable And Secure Cloud for Windows |
| 10-11-2020 00:00 | Stephen McMaster | General Session (75 minutes) | Database Administration | Azure Arc – What Does This Mean For Your SQL Server Journey And Infrastructure Transformation From Edge To Core To Hybrid Cloud? |
| 10-11-2020 00:00 | Ed Leighton-Dick | General Session (75 minutes) | Security | Building a Security Dashboard for SQL Server |
| 10-11-2020 00:00 | Ola Hallengren | General Session (75 minutes) | Database Administration | Getting the Most Out of the "SQL Server Maintenance Solution" |
| 10-11-2020 00:00 | Paul Turley | General Session (75 minutes) | Business Intelligence and Data Warehousing | Tabular Data Modeling Solutions for Challenging Problems |
| 10-11-2020 00:00 | Ed Leighton-Dick | General Session (75 minutes) | Security | Securing SQL Server in Containers |
| 10-11-2020 00:00 | Daniel Maenle | Partner Session (75 minutes) | Database Administration | 10 Extended Events Every DBA Needs In Their Toolkit |
| 10-11-2020 00:00 | Oscar Zamora, Avnish Rastogi | General Session (75 minutes) | Cloud Solutions | Migrating Hundreds of SQL Server Instances to Azure at Scale |
| 10-11-2020 00:00 | Leila Etaati | General Session (75 minutes) | Artificial Intelligence | Microsoft Automated ML the Next Generation of Machine Learning |
| 10-11-2020 00:00 | Leila Etaati | General Session (75 minutes) | Advanced Analytics | Charticulator: Create Custom Visual with No Code in Power BI |
| 10-11-2020 00:00 | John Martin | General Session (75 minutes) | Database Administration | Securing Network Access to Your SQL Servers |
| 10-11-2020 00:00 | Denis Reznik | General Session (75 minutes) | Database Administration | Deadlocks. Understanding and Troubleshooting. |
| 10-11-2020 00:00 | josh smith | General Session (75 minutes) | Security | SQL Security for Everybody: Understanding Logins, Users, and Roles |
| 10-11-2020 00:00 | Joseph D'Antoni | General Session (75 minutes) | Cloud Solutions | Building a Query Store Telemetry Pipeline |
| 10-11-2020 00:00 | Ray Kim | General Session (75 minutes) | Professional Development (Other) | Blogging for Success: Advancing Your Career by Blogging |
| 10-11-2020 00:00 | Monica Rathbun | General Session (75 minutes) | Database Administration | Performance Tuning, Getting the Biggest Bang for Your Buck |
| 10-11-2020 00:00 | Rie Irish | General Session (75 minutes) | Artificial Intelligence | Real World Implications of Bias in Coding & Machine Learning |
| 10-11-2020 00:00 | Ben Weissman | General Session (75 minutes) | Big Data | Deploying SQL Server Big Data Clusters |
| 10-11-2020 00:00 | Jason Horner | General Session (75 minutes) | Business Intelligence and Data Warehousing | Dimensional Modeling: Beyond the Basics |
| 10-11-2020 00:00 | Taiob Ali | General Session (75 minutes) | Development | Think Like the Cardinality Estimator |
| 10-11-2020 00:00 | James McGillivray | General Session (75 minutes) | Business Intelligence and Data Warehousing | The Fundamentals of DAX Contexts |
| 10-11-2020 00:00 | Miloš Radivojević | General Session (75 minutes) | Database Administration | Demystifying Query Store Plan Forcing |
| 10-11-2020 00:00 | Marco Russo | General Session (75 minutes) | Business Intelligence and Data Warehousing | Inside the VertiPaq Engine |
| 10-11-2020 00:00 | Dejan Sarka | General Session (75 minutes) | Advanced Analytics | Data Science: Unsupervised Learning |
| 10-11-2020 00:00 | Indira Bandari | Lightning Talk (10 minutes) | Advanced Analytics | 5 Power Query Hidden Treasures to Improve Your Productivity |
| 10-11-2020 00:00 | Tariq Younas | Lightning Talk (10 minutes) | Data Platform Strategy | Azure SQL: (IaaS) or (PaaS)? What to use When? |
| 10-11-2020 00:00 | Itzik Ben-Gan | General Session (75 minutes) | Development | Workarounds for T-SQL Restrictions and Limitations |
| 10-11-2020 00:00 | Kellyn Pot'Vin-Gorman | General Session (75 minutes) | Cloud Solutions | Migrating Oracle Workloads to Azure |
| 10-11-2020 00:00 | Jeff Renz | Pre-Conference Session (Full Day) | Data Platform Strategy | Introduction to NoSQL Solutions |
| 10-11-2020 00:00 | Ginger Grant | Pre-Conference Session (Full Day) | Business Intelligence and Data Warehousing | Modern Data Warehousing and Advanced Analysis with Azure Synapse |
| 10-11-2020 00:00 | Edward Pollack | Lightning Talk (10 minutes) | Professional Development (Other) | Improving Communication with Jupyter Books |
| 10-11-2020 00:00 | Rie Irish | General Session (75 minutes) | Professional Development (Other) | Identifying, Understanding, and Combating Gender Bias & Inequality |
| 10-11-2020 00:00 | William Assaf | General Session (75 minutes) | Security | SQL Security Principals 101 |
| 10-11-2020 00:00 | Edward Pollack | General Session (75 minutes) | Business Intelligence and Data Warehousing | Improving Analytics Performance With Columnstore Indexes |
| 10-11-2020 00:00 | Leonard Lobel | Pre-Conference Session (Full Day) | Development | Developer Dive into SQL Server 2019 |
| 10-11-2020 00:00 | Itzik Ben-Gan | Pre-Conference Session (Full Day) | Development | Advanced T-SQL Querying and Query Tuning |
| 10-11-2020 00:00 | Hugo Kornelis | General Session (75 minutes) | Development | Execution Pans ... Where Do I Start? |
| 10-11-2020 00:00 | Hugo Kornelis | General Session (75 minutes) | Development | Normalization Beyond Third Normal Form |
| 10-11-2020 00:00 | John Morehouse | Pre-Conference Session (Full Day) | Cloud Solutions | Avoiding the Storms When Migrating to Azure |
| 10-11-2020 00:00 | Allan Hirt | Pre-Conference Session (Full Day) | Database Administration | Modern Strategies for SQL Server Availability |
| 10-11-2020 00:00 | Rob Sewell | Pre-Conference Session (Full Day) | Database Administration | Introduction to PowerShell |
| 10-11-2020 00:00 | Kevin Feasel | Pre-Conference Session (Full Day) | Development | SQL Server on the Edge: IoT with SQL Server and .NET Core |
| 10-11-2020 00:00 | Christophe Laporte | General Session (75 minutes) | Database Administration | From Docker to Big Data Cluster - a New Era for SQL Server |
| 10-11-2020 00:00 | Deborah Melkin | General Session (75 minutes) | Development | Data Integrity Demystified |
| 10-11-2020 00:00 | Denny Cherry | Pre-Conference Session (Full Day) | Data Platform Strategy | Microsoft Azure Platform Infrastructure |
| 10-11-2020 00:00 | Denny Cherry | General Session (75 minutes) | Database Administration | Selecting the Correct Azure Data Solution for your Application |
| 10-11-2020 00:00 | Thomas Norman | General Session (75 minutes) | DevOps | DevOps: SSDT Makes Deployment Consistent |
| 10-11-2020 00:00 | Dave Bland | General Session (75 minutes) | Database Administration | The DBA Guide to Surviving an Audit |
| 10-11-2020 00:00 | Thomas Norman | General Session (75 minutes) | Data Governance/Privacy | The Art of Data Classification and Protection |
| 10-11-2020 00:00 | Allan Hirt | General Session (75 minutes) | Hybrid Infrastructure | Deploying Availability Groups in Virtualized Architectures |
| 10-11-2020 00:00 | Meagan Longoria | Pre-Conference Session (Full Day) | Advanced Analytics | Building Power BI Reports that Communicate Insights and Engage People |
| 10-11-2020 00:00 | Neil Hambly | Half-Day Session (2.5 hours) | Artificial Intelligence | Designing Azure Data Science & AI Projects |
| 10-11-2020 00:00 | Pinal Dave | Pre-Conference Session (Full Day) | Data Platform Strategy | Zero to Hero: SQL Server Performance Tuning for Everyone |
| 10-11-2020 00:00 | Alberto Ferrari | Pre-Conference Session (Full Day) | Advanced Analytics | Data Modeling with Power BI and Tabular |
| 10-11-2020 00:00 | Sriharsh Adari | General Session (75 minutes) | Cloud Solutions | Enable Real-time Analytics and Machine Learning with Azure Stream |
| 10-11-2020 00:00 | Chris Hyde | Pre-Conference Session (Full Day) | Advanced Analytics | An Introduction to Data Science With Python for Data Professionals |
| 10-11-2020 00:00 | Martin Catherall | General Session (75 minutes) | Cloud Solutions | SQL Professional to Cosmic Superstar in 75 minutes |
| 10-11-2020 00:00 | Kevin Kline, Louis Imershein | General Session (75 minutes) | Database Administration | SQL Server on Linux Performance |
| 10-11-2020 00:00 | Anthony Nocentino, Ben Weissman | Pre-Conference Session (Full Day) | Hybrid Infrastructure | The Future of Deployment for Modern Data Platform Applications |
| 10-11-2020 00:00 | Hugo Kornelis | Pre-Conference Session (Full Day) | Development | Execution Plans in Depth |
| 10-11-2020 00:00 | Randolph West | Pre-Conference Session (Full Day) | Database Administration | SQL Server on Linux from A to Z |
| 10-11-2020 00:00 | David Klee | Pre-Conference Session (Full Day) | Data Platform Strategy | Amplify Your Virtual SQL Server Performance |
| 10-11-2020 00:00 | Pinal Dave | General Session (75 minutes) | Development | Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos |
| 10-11-2020 00:00 | Steve Wake | Half-Day Session (2.5 hours) | Business Intelligence and Data Warehousing | Move Your Entire BI Platform to Azure and Power BI |
| 10-11-2020 00:00 | Mike Byrd | General Session (75 minutes) | Database Administration | A Self-Tuning Fill Factor Technique for SQL Server |
| 10-11-2020 00:00 | Mike Byrd | Lightning Talk (10 minutes) | DevOps | How Bad Are Bad Page Splits? |
| 10-11-2020 00:00 | Reza Rad | General Session (75 minutes) | Business Intelligence and Data Warehousing | Aggregation and Composite Model: Power BI Fast and Furious |
| 10-11-2020 00:00 | Guy Glantser | General Session (75 minutes) | Data Platform Strategy | Modernizing Your Data Platform |
| 10-11-2020 00:00 | Ben Miller | General Session (75 minutes) | Development | Getting Started with PowerShell as a DBA |
| 10-11-2020 00:00 | Allan Hirt | General Session (75 minutes) | Cloud Solutions | The Good, Bad, and Ugly of Migrating SQL Server to Public Clouds |
| 10-11-2020 00:00 | Will Velida | General Session (75 minutes) | Advanced Analytics | Machine Learning in C#?! Introduction to ML.NET |
| 10-11-2020 00:00 | Bill Anton | General Session (75 minutes) | Business Intelligence and Data Warehousing | Power BI Time-Intelligence: Beyond the Basics |
| 10-11-2020 00:00 | Erin Dempster | General Session (75 minutes) | Development | Navigating Row Level Security |
| 10-11-2020 00:00 | Fabiano Amorim | General Session (75 minutes) | Database Administration | The Cases of The Unexplained Memory Problems |
| 10-11-2020 00:00 | Jamey Johnston | General Session (75 minutes) | Advanced Analytics | Code Like a Snake Charmer Version 2.0 - Introduction to Python! |
| 10-11-2020 00:00 | Bob Ward | Microsoft Session (75 minutes) | Database Administration | Inside Waits, Latches, and Spinlocks Returns |
| 10-11-2020 00:00 | Buck Woody | Microsoft Session (75 minutes) | Artificial Intelligence | Machine Learning with SQL Server - From the Edge to the Cloud |
| 10-11-2020 00:00 | Asgeir Gunnarsson | General Session (75 minutes) | Cloud Solutions | Checking in with Power Apps, Flow, and Power BI |
| 10-11-2020 00:00 | Vicky Harp, Ken Van Hyning | Microsoft Session (75 minutes) | Data Platform Strategy | What’s New in the SQL Server Tools? |
| 10-11-2020 00:00 | Vasiya Krishnan | Microsoft Session (75 minutes) | Advanced Analytics | Extend SQL Applications to the Edge with Azure SQL Edge |
| 10-11-2020 00:00 | Raj Pochiraju, Mukesh Kumar | Microsoft Session (75 minutes) | Cloud Solutions | App Modernization and Migration from End to End, Using Data Migration Tools and Azure SQL |
| 10-11-2020 00:00 | Umachandar Jayachandran | Microsoft Session (75 minutes) | Hybrid Infrastructure | Taking Your Data Hybrid With Azure Arc Enabled Data Services |
| 10-11-2020 00:00 | Jarupat Jisarojito, Michelle Wallig | Microsoft Session (75 minutes) | Hybrid Infrastructure | The Evolution of Machine Learning on Hybrid Cloud |
| 10-11-2020 00:00 | Nathan Boster | Lightning Talk (10 minutes) | Development | Write Queries Faster with AutoHotKey |
| 10-11-2020 00:00 | Johan Ludvig Brattås | General Session (75 minutes) | Cloud Solutions | Build a Data Lineage DB in Cosmos DB with Gremlin API |
| 10-11-2020 00:00 | Jared Poché | General Session (75 minutes) | Database Administration | One Bite at a Time |
| 10-11-2020 00:00 | Rob Volk | Lightning Talk (10 minutes) | Development | 10 Minutes of Lesser-Used SQL Server Features |
| 10-11-2020 00:00 | Buck Woody | General Session (75 minutes) | Big Data | SQL Server Big Data Clusters Architecture |
| 10-11-2020 00:00 | Buck Woody | General Session (75 minutes) | Artificial Intelligence | Machine Learning, Artificial Intelligence, and Deep Learning Explained |
| 10-11-2020 00:00 | Allen White | General Session (75 minutes) | Database Administration | Find (So You Can Fix) Those Troublesome Queries |
| 10-11-2020 00:00 | Manohar Punna | General Session (75 minutes) | Development | PowerApps & Power Automate - DB Best Practices |
| 10-11-2020 00:00 | Kenneth Fisher | General Session (75 minutes) | Development | Demystifying Dynamic SQL |
| 10-11-2020 00:00 | Greg Low | General Session (75 minutes) | Cloud Solutions | Make a Real SQL Cloud Transformation, Not Just a Migration |
| 10-11-2020 00:00 | Brian Hansen | General Session (75 minutes) | Database Administration | Get Your Optimizer to Give Up All Its Secrets |
| 10-11-2020 00:00 | Hamish Watson | General Session (75 minutes) | Database Administration | How to Put DevOps Into Action for Your Databases |
| 10-11-2020 00:00 | Glenn Berry | General Session (75 minutes) | Database Administration | Building a Home Computer Lab |
| 10-11-2020 00:00 | Asgeir Gunnarsson | General Session (75 minutes) | Business Intelligence and Data Warehousing | What's Going On in My Power BI Environment? |
| 10-11-2020 00:00 | Eduardo Pivaral | General Session (75 minutes) | Development | Getting Started with Azure Data Studio |
| 10-11-2020 00:00 | Russel Loski | General Session (75 minutes) | Business Intelligence and Data Warehousing | Consuming API Data using Built in SSIS Components |
| 10-11-2020 00:00 | Reid Havens | General Session (75 minutes) | Advanced Analytics | Guiding User Experiences With Advanced Reporting Features |
| 10-11-2020 00:00 | Daniel Otykier | General Session (75 minutes) | DevOps | Power BI CI/CD with Tabular Editor |
| 10-11-2020 00:00 | Raj Pochiraju, Mukesh Kumar | Microsoft Session (75 minutes) | Cloud Solutions | Database Modernization Best Practices and Lessons Learned Through Customer Engagements |
| 10-11-2020 00:00 | Gethyn Ellis | General Session (75 minutes) | Data Platform Strategy | Pay Less, Get More. A Guide to SQL Server Licensing |
| 10-11-2020 00:00 | Kevin Kline | General Session (75 minutes) | Hybrid Infrastructure | Surprising Setbacks for Data Modernization and Azure Migration |
| 10-11-2020 00:00 | Johan Ludvig Brattås | Lightning Talk (10 minutes) | Cloud Solutions | Get The Most Bang For Your Bucks in Azure SQL |
| 10-11-2020 00:00 | Yoram Solomon | General Session (75 minutes) | Professional Development (Other) | Leading Virtual Teams with Trust |
| 10-11-2020 00:00 | Rob Sewell | General Session (75 minutes) | Database Administration | Notebooks, PowerShell, and Excel Automation |
| 10-11-2020 00:00 | Chris Hyde | Lightning Talk (10 minutes) | Development | The Warlock Of Graph-Table Mountain |
| 10-11-2020 00:00 | Chris Hyde | General Session (75 minutes) | Advanced Analytics | Data Engineering Brick-by-Brick: An Intro To Azure Databricks |
| 10-11-2020 00:00 | Michael Wall | General Session (75 minutes) | Database Administration | Polybase - It's What's for Dinner! |
| 10-11-2020 00:00 | Marsha Pierce | General Session (75 minutes) | Data Platform Strategy | Standardize Your Environments Leveraging Infrastructure As Code |
| 10-11-2020 00:00 | Rob Volk | General Session (75 minutes) | Database Administration | Log Shipping In SQL Server |
| 10-11-2020 00:00 | Johan Ludvig Brattås | General Session (75 minutes) | Business Intelligence and Data Warehousing | The Battle of Cloud Data Warehouses: Snowflake, Synapse, and More |
| 10-11-2020 00:00 | Jason Brimhall | General Session (75 minutes) | Development | The Anatomy of Select |
| 10-11-2020 00:00 | Amit R S Bansal | General Session (75 minutes) | Development | Developer Best Practices in SQL Server |
| 10-11-2020 00:00 | Tejas Shah, Amit Khandelwal | Microsoft Session (75 minutes) | Database Administration | Deployment, High Availability and Performance Guidance for SQL Server on Linux in Azure IaaS Ecosystem |
| 10-11-2020 00:00 | Vin Yu, Amit Khandelwal | Microsoft Session (75 minutes) | Development | SQL Server Containers in Action |
| 10-11-2020 00:00 | Matt Gordon | General Session (75 minutes) | Artificial Intelligence | Dialogue with your Data: Interactive AI with Cognitive Services |
| 10-11-2020 00:00 | Jeff Renz | General Session (75 minutes) | Data Platform Strategy | Securing Your Data in Azure: Tips and Tricks |
| 10-11-2020 00:00 | Pam Lahoud, David Pless | Microsoft Session (75 minutes) | Data Platform Strategy | Best Practices for Deployment of SQL Server on Azure Virtual Machines |
| 10-11-2020 00:00 | Melissa Coates | General Session (75 minutes) | Data Governance/Privacy | Power BI Governance: Top Tips |
| 10-11-2020 00:00 | Kevin Farlee | Microsoft Session (75 minutes) | Database Administration | HA/DR in SQL Server, Putting the Puzzle Pieces Together and Planning for the Future |
| 10-11-2020 00:00 | Pam Lahoud, Pedro Lopes | Microsoft Session (75 minutes) | Database Administration | Practical Guidance to Make Your Tier-1 SQL Server Roar |
| 10-11-2020 00:00 | Anthony Nocentino | General Session (75 minutes) | Database Administration | Deploying and Managing SQL Server with dbatools |
| 10-11-2020 00:00 | Slava Murygin | General Session (75 minutes) | Database Administration | Think like a Terminator. Internals of Classic SQL Server Indexes. |
| 10-11-2020 00:00 | Rick Lowe | General Session (75 minutes) | Database Administration | Monitoring SQL Server on Linux |
| 10-11-2020 00:00 | Edwin Sarmiento | General Session (75 minutes) | Database Administration | Providing High Availability to SQL Server on Linux |
| 10-11-2020 00:00 | Melissa Coates | Pre-Conference Session (Full Day) | Business Intelligence and Data Warehousing | Power BI Deployment and Governance for the Enterprise |
| 10-11-2020 00:00 | Kevin Kline | General Session (75 minutes) | Data Governance/Privacy | Data Governance for Beginners |
| 10-11-2020 00:00 | Markus Ehrenmueller-Jensen | General Session (75 minutes) | Business Intelligence and Data Warehousing | Localizing Reports in Power BI |
| 10-11-2020 00:00 | Markus Ehrenmueller-Jensen | General Session (75 minutes) | Advanced Analytics | Understanding Numeric Calculations in DAX |
| 10-11-2020 00:00 | David White | Partner Session (75 minutes) | Cloud Solutions | Running Your Windows Workloads on Google Cloud |
| 10-11-2020 00:00 | Ori Kashi | General Session (75 minutes) | Database Administration | Getting to Know Google Cloud SQL for SQL Server |
| 10-11-2020 00:00 | Shawn Meyers, Rob Girard | General Session (75 minutes) | Hybrid Infrastructure | Next Gen: Intelligent Infrastructure |
| 10-11-2020 00:00 | Andy Yun, Devon Leann Wilson | Partner Session (75 minutes) | Database Administration | Tales From the Performance Monitoring Trenches |
| 10-11-2020 00:00 | Darren Gosbell | General Session (75 minutes) | Advanced Analytics | DAX Studio |
| 10-11-2020 00:00 | Rayis Imayev | General Session (75 minutes) | Business Intelligence and Data Warehousing | Design your Data Vault and Load it with Azure Data Factory |
| 10-11-2020 00:00 | Markus Strauss | General Session (75 minutes) | Database Administration | Monitoring and?Tuning?Your?Database(s) as a Service?Performance |
| 10-11-2020 00:00 | Jared Hensle, John Potocny | Partner Session (75 minutes) | Database Administration | Don’t Let Database Health Infect Your Application Performance? |
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
This session will provide you with answers and guidelines to get you started, to embrace the Database DevOps practice for your organization. You will learn the aspects, methods, and strategies to build and manage your database deployments through CI/CD pipelines with open source tools like Flyway, Kubernetes, and cloud collaborative tools like Azure DevOps.
You will be able to build your first database migration through a CI/CD pipeline at the end of this session.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Big Data
In this introductory session, we'll see how easy it is to get started with Big Data Analytics using Spark and Python. We'll learn how to perform standard analytical tasks, like creating RDDs and Data Frames, transforming columns, and creating aggregations. Be sure to bring your rubber suits, because we'll be playing with lightning...snakes.
Event Date: 10-11-2020 00:00 - 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: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
In this session, we will discuss what a Data Engineer needs to know regarding storage and security, some of the duties one might be expected to perform (such as devops and automation), and resources for additional information for helping you pass the certification exams that will take your career to the next level.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
This session will dive deep the Relational Database Service (RDS) offering of Microsoft Business Intelligence as well as how to configure RDS instances for each BI component. We will review options for security, availability, and reliability operations provided for each offering.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
In this session, I will introduce you to the grammar of graphics concept that is commonly used to develop visualizations in R as well as best practices that should be considered when creating R visuals in Power BI.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
When it comes to budgeting, each company is a unique scenario. In this session, you will see some common techniques to use when building a budget model with Power BI and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on products that do not yet exist.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Cloud Solutions
Recent cloud breaches may have some organizations hesitant to take the leap and move to the cloud, however market-leading cloud providers are making every attempt in adhering to compliance guidelines while boosting their security framework and reliability offerings. They are also becoming more competitive by managing their cost more effectively.
For both homogeneous and heterogeneous migrations, planning plays a critical role in moving to the cloud. Preparing a checklist and asking the right questions to stakeholders lays the groundwork in this planning. There are different methods to migrate databases from on-premises to the AWS cloud.
In this presentation, we will discuss various methods and explain the advantages and disadvantages of using each method. We’ll also showcase the surprises and pitfalls to avoid as we venture into the process.
Learn more on what trends you can expect to see, what the future holds for cloud, and see how the DBA role and their responsibilities are undergoing changes to fit into the new profile necessary in managing the cloud framework.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
There are already huge advantages in being able to digitally monitor and control physical objects near or far and at any time. It also possible to explore and experiment further on these objects by building virtual models of them. Digital twins allow engineers to work with objects in ways that would be impossible in the real world. Nowadays, Microsoft Azure offers this capability on its Internet of Things (IoT) platform with Azure Digital Twins. This technology enable spaces and individual devices to be modelled and let users develop scalable, reusable structures that can combine digital and physical data. This presentation is about Azure Digital Twins: the main business benefits and technical advantages. Presentation demonstrate the key features of technology the context of Microsoft Azure with real use cases and live demos.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
This talk is about the best practices designing and implementing in business solutions Power BI Embedded and Power Bi Premium: which version to use and how to take the best advantage from different version and tier of Power BI, offered from Microsoft.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Development
In this fast-paced world, taking the time to plan and design can yield excellent results down the line.?
This session will focus on a few key aspects, such as Primary Keys, Foreign Keys, Unique Constraints, and Triggers that you should consider when building your next database solution.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
Come to this session to see your enterprise estate through a single pane of glass at long last.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Security
In this session Steve Jones will show how this process can be refined over time and distributed across a team of individuals in your organization.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
This presentation will give best practices, tested in actual project environments, to help answer this question.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Big Data
In order to build this environment, we will see scripts to configure the Big Data Cluster, how to setup data virtualization, and how to process unstructured and structured data together, wherever they are.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session we will explore multiple technologies that are widely used today to increase availability of SQL Server, and allow for proper management of disaster recovery situations for SQL Server environments. We will go over a ton of options, regular backups, availability groups, log shipping, VM-level replication, storage-layer replication. To take things up a level, we will spend some time discussing HA/DR for containers and Kubernetes.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Big Data
With new tools that address the entire data management cycle, big data technologies make it feasible to collect and store larger datasets and to analyze them to derive insights. It is often overwhelming with the number of options available. In this session, you will learn the portfolio of AWS big data services, how to accelerate the pace of the building a big data solution by using Jupyter notebooks to easily integrate a big data solution for the entire data lifecycle. Including:
Streaming ingestion to data warehouse
Analyze the data using Amazon Redshift
Export data and build datalake
Discover metadata, build a central data catalog
Build visual on the whole dataset
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
Join our panel of industry experts as they discuss their thoughts on dealing with database DevOps implementation, including challenges they have faced and how to surmount them.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Abdul Rasheed, Sr. Director of Product Management at Clumio, will show how data mobility across platforms is achieved for SQL Server with Clumio's Enterprise Backup as a Service. Clumio provides data mobility through platform-independent data protection, with no software or infrastructure to manage. Users can instantly retrieve data from backups with a query, opening the door to unlock the business value in corporate data.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
In this session, we will look at neurodiverse behavior and empowerment, focusing on the autism spectrum and the data platform. There are qualities which make a person on the spectrum great with data, and pitfalls in relation to job interviews and getting the most from large conferences like PASS Summit. Whether you manage the person, or whether you are the person, there is something to be gained from a recognition on the differences in how one's brain works.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Security
Event Date: 10-11-2020 00:00 - 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: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
In this session, you will learn strategies for getting data from SQL Server that align with the use case. You will learn when to use stored procedures, when to use ORMs, and when to use other methods. The pros and cons of each approach will be reviewed, and you will see how to implement each approach using the three most popular methods in .NET: Entity Framework, Dapper, and ADO.NET. Lastly, you will learn where to start with performance tuning application data access, as well as some strategies for structuring the database for query performance.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
In this session, we have a good look at CDS and find his strengths and weaknesses. We'll see how to build, ingest and extract data from CDS using demos. When you're using the Power Platform and/or curious about CDS but haven't used it yet, join me at this session.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session we will discuss the targets, actions, and predicates available in Extended Events and see how you can leverage them to look at problems in SQL Server in ways that you never could before. We will step through as many demos as possible in the time available so you can see why joining #TeamXE was one of the best decisions you ever made. You’ll walk away with a deeper understanding of Extended Events along with a new methodology for approaching and solving issues in SQL Server.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
Join this session to learn how common Power BI administration tasks can be automated using the CLI, PowerShell and C#, how Azure DevOps can work together with Power BI for continuous integration and in addition, learn how create Power BI artefacts in an automated way.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Attend this session to learn about these enhancements, when they will and when they won’t help performance without making code changes.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
If you think about digital transformation in Azure, start exploiting the increased productivity and cost savings that the managed instance can provide to you. Managed Instance remains to be one of the strategic investments in Azure SQL product portfolio. Over the last year it has been greatly enhanced in terms of new programmability surface area and increased application compatibility, improved price-performance, networking security and compliance, and better migration and manageability experience. Come and hear about the best practices of migration to managed instance, the latest product enhancements, and get a sneak peek at the future product roadmap.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Come join us in the intelligent database world!
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
In this session, we will present the internals of the Hyperscale distributed architecture including the details of compute, multi-tiered caching, transaction log service and read-scale replicas. If you love SQL Server internals this is your session as we will describe how we have utilized the power of the SQL Server engine to provide built-in scalability and high availability with Hyperscale. We will also cover unique diagnostics to help gain insights into the performance aspects of Hyperscale. Hyperscale is the future of Azure SQL and in this session we will show you why.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
In this session we will discuss topics and questions that DBAs should ask before, during and after Power BI is deployed in their organization. In addition, we will demonstrate what the FRENCH TOAST Power BI is doing to your database.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Attendees will leave the session with a firm grasp of why we build data lakes and how Azure enables the BI professional to be successful in their data lake projects.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
After the workshop, you should be able to: • Determine which Azure SQL deployment option and service tier should be used in order to meet the needs of your application in various scenarios. • Deploy, configure, monitor, and troubleshoot security, performance, and availability scenarios in Azure SQL using both familiar and new tools and techniques. • Harness the “power of the cloud”, including automation and intelligent capabilities of Azure SQL. • Translate your existing SQL Server expertise to Azure SQL expertise.
This day will be extremely interactive and the engineering team always provides details on “how it works”. All attendees are required to bring their own laptop which, at minimum, can connect to a Virtual Machine with a Remote Desktop application. At the end of the day, you will walk away with all the materials, code, slides, and demos for future use.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
This session starts with a discussion of some scenarios where chunking may come into play. The session then goes into important techniques you need to employ to get good performance when you implement chunking – done wrong, chunking can lead to worse performance than without chunking. The session also discusses other things you need to consider when you implement chunking: How is the application affected? How to restart an interrupted chunking operation? What to consider when it comes to testing?
The last section demonstrates how you can use chunking to improve performance in situations where you cannot use set-based statements, because you cannot accept that you lose all rows as a result of a few rows failing to load.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
We will start by creating a multi-threaded build that includes a database and a .NET application and learn about build dependencies while we're at it. After we are warmed up, we will attempt a database build that is tightly coupled with other databases and throw in using a container as the build agent for good measure. Lastly, we will finish strong with environment automation and management. This may seem like a lot, and it is, but with training and dedication anything is possible.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
The statistics that are automatic created and maintained are usually sufficient for the optimizer to come up with a good plan. But there are exceptions. In this session, after a brief overview of what statistics are, we’ll see how filtered statistics can help performance against very large tables (especially with skewed data), how the statistics on computed columns can help, when and how to override the default sample size, how to identify and fix performance problems due to stale statistics on ascending keys, how manually created statistics can help queries against correlated columns, and more. With these techniques you WILL improve query performance.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Development
In this session we’ll go through all the reasons why Azure SQL is a great choice for the creation of a backend API that can provide REST API for the most common frontend (mobile, web, anything). From implementing a full CI/CD pipeline for the database, to scaling from a few hundreds to thousands request per second…and more. All using the most loved thing since bread and butter: JSON. And not only that, as security is another big challenge that cannot be overlooked: we’ll also add row-level security to make sure data is served fast and securely. Demo and content heavy, bring developers and coffee.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
Additionally configuration can change over time. These changes need to be managed and unexpected changes can cause issues. Can you say for certain that your systems are configured exactly as you expect?
Desired State Configuration (DSC) in Powershell is a key tool for moving towards a culture of Infrastructure as Code (IaC) in a windows environment. It can help make your deployments more consistent while speeding them up. Additionally it can help you monitor, report, and correct configuration drift automatically.
In this session we will go over the core principles of Infrastructure as Code, the various components of DSC, how to set up a pull server. We will also use DSC to deploy and setup a two replica availability group with the push of a button.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Big Data
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Security
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
After some usage, users have reacted that it's a bit sluggish in usage, and they're not keen on using it anymore.
Starting off with the new Performance Analyzer Pane, we'll demonstrate how you can pinpoint bottlenecks in your report, and take actions on these insights.
With the myriad of root causes that are out there, an elimination approach might suit us very well. Some of the main causes will be explained, and we'll get you going on how you can fix it for yourselves.
Be it DAX-measures, modelling issues, or an overload of visuals. Every report can be tuned to handle like a dream, and you can do it too!
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
However there are some pitfalls with sharing - if you don’t know your options and set proper governance, you could be on your way to a data breach or giving your private information to the competition.
In this session, you will get a short introduction to Power BI and understand where data resides, why and how you should share with your colleagues and outside partners, and get a strategy for setting governance for your data. You will walk away with the outline of a governance plan, an understanding of your sharing options, and the sharing settings you should immediately turn off.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Then join me for a survey of worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.
When you leave, you'll be armed with knowledge and tools to get a jump start on your journey to specializing as a performance tuner.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Join me to learn how you can go beyond the basics. This demo-heavy (and marketing free) session will teach you advanced use of Plan Explorer by exploring practical T-SQL anti-patterns.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Join me on an exploration of what it means to be a DBA in the modern era, and how your existing skills can be leveraged, no matter the platform. Maintenance plans, monitoring, even disaster recovery all work in pretty much the same way across Windows, Linux, Azure SQL DB, and containers.
Then when you go back to work on Monday, you will have a starting point on how to modernize your existing environment and future-proof your career.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Development
In this talk, we will:
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
Key to this is Data Modernization. Data Modernization starts with the recognition that existing systems, architectures and processes may not be sufficient to handle the requirements of a data-driven enterprise, and that new innovative solutions need to be adopted to succeed. While the replacement of legacy technology is not a new phenomenon, the particular sets of pressure points, leading to the current wave of modernization, are.
In this session we will delve into the very real pressures pushing enterprises down the path of data modernization, and approaches to achieving this goal with success.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
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.
To illustrate how Foglight can overcome many challenges of tuning, we’ll demonstrate 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 • Use SQL Optimizer to rewrite the query to get the best execution plan
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
• The Future Database Development with Containers - Steve Jones
Containers and DevOps are some of the most talked about topics these days. Come see a vision of what building a database driven application might look like in the future with containerization, databases as a service (DBaaS), and a DevOps mindset.
• Write Queries Faster with AutoHotKey - Nathan Boster
AutoHotKey (AHK) is an open source Windows application used to create macros, hot keys, and "text expansions". Nathan has used this program for years in many different ways, but he finds it especially useful in SQL Server Management Studio. Come and see how AHK can put a library of code snippets--and full queries--at your fingertips.
• How Bad Are Bad Page Splits? - Mike Byrd
Everybody agrees that bad page splits hurt performance, but there is almost no documentation showing actual performance numbers. This session will show an example highlighting the performance degradation encountered during a series of bad page split as well as the ongoing effects of the bad page splits on a SELECT query. Results for this example indicate a potentially larger performance hit than anticipated.
• The Warlock Of Graph-Table Mountain - Chris Hyde
When I was a child I was obsessed with the Fighting Fantasy series of gamebooks, as well as other similar series like Choose Your Own Adventure. Thanks to the new SQL Graph feature introduced in SQL Server 2017, I was able to write an entire game engine to simulate these books, and it took me less than ten minutes to do so! Please join me for this light-hearted introduction to SQL Graph Database to find out how I did it.
• Azure SQL: (IaaS) OR (PaaS) What to use When? - Tariq Younas
Learn about the latest capabilities in the Azure SQL family (VM, SQL Managed Instance, SQL Database) in the past year, along with migration updates.
• 10 Minutes of Lesser-Used SQL Server Features - Rob Volk
SQL Server has hundreds of features and keeps adding more, but not all of them are widely known. This lightning talk will explore a few of these lesser-known features that may be useful to you, such as:
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
• Improving Communication With Jupyter Books - Edward Pollack
Included in Azure Data Studio is a feature that allows text, markup, and code to be stored all in one place: Jupyter Books. With Jupyter Books, presentations, documentation, and knowledge-sharing can be simplified by allowing for all types of content to be created and stored in one file and shared in a single application. This fast-paced session introduces this tool, provides the top uses for it, and demonstrates how a presentation can be improved by using it.
• The Human In the Machine - Christine Assaf
In this lightening talk we will learn about preserving human-elements in an increasing tech-heavy, distance world and how inherent human needs have transformed and have stayed the same.
• 5 Power Query Hidden Treasures to Improve Your Productivity - Indira Bandari
In this session you will get to know 5 Power BI tips that will improve your productivity when you work with Power BI files. Know how to sort Parameters you define in Power Query when you Manage Parameters. Know how to Cancel Refresh in Power Query. This is not very intuitive Know how to easily grab a column for an existing query table as a list Change data type for multiple columns Add emojis to table names
• Exploring The World of Azure Data Explorer - Martin Cairney
If you have large volumes of log or telemetry data, then Azure Data Explorer (ADX) may be the tool you need to perform ad-hoc queries to extract insights for diagnostics, monitoring, or reporting purposes. This introductory session will give you a taste of the power and flexibility of ADX and the Kusto Query Language. A demonstration will show the ease of ingesting Azure Metrics into ADX and a number of ways to query this data, including Azure Data Studio and Power BI.
• Get The Most Bang For Your Bucks in Azure SQL - Johan Ludvig Brattås
While the original DTU service model was annoying with it's black box approach to cpu/memory and IOPS at least it was divided into easy to understand pricing tiers. Now you have serverless, General Purpose, Business Critical and Hyperscale... Oh and Managed Instance as well... So, what database configuration should you pick for your project? Stay a while, and listen!
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Hybrid Infrastructure
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Business Intelligence and Data Warehousing
The Kyligence platform provides an intelligent precomputation layer, AI-assisted data modeling and query optimization, and virtually limitless concurrency and scale for OLAP, SQL, and MDX analytics on Azure. This session will explore how a Kylin-powered architecture can achieve sub-second response times for queries against terabytes or even petabytes of Azure data.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
With SQL Server 2019 on Red Hat platforms, you can build a highly customized system to address your application’s specific performance and availability requirements. We’ll introduce you to products such as Red Hat Enterprise Linux, Red Hat Virtualization and Red Hat OpenShift and discuss how they deliver advanced support for SQL Server 2019.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Attend this session to learn how you can do data preprocessing, feature discovery, and model training without moving the data out. We will also explain how containers can help you run ML models in production efficiently and effectively and we’ll discuss how this all fits into Microsoft SQL Server Big Data Clusters on Red Hat OpenShift.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
This session will challenge the understanding that advocating for Diversity, Equity, and Inclusion (DEI) is a voluntary action; expand on cultivating cultures of belonging; and provide techniques on becoming a better ally.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
Join us to learn how Nutanix HCI and Nutanix Era provide a cloud-agnostic database lifecycle management solution that can dramatically reduce the time spent on repetitive manual tasks, giving the DBAs back the time they need to focus on more valuable work. David will cover how easy it is deploy standardized and hardened versions of SQL Server, migrate from end of support versions like SQL Server 2008 R2, automate database copy and refresh operations for your developers and more. If you want to learn how to free up the evening and weekend time taken up by SQL Server support, this is the session for you!
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: Half-Day Session (2.5 hours) - Track: Business Intelligence and Data Warehousing
The real funs begins when metadata (data about data) is used to automate some processes. The metadata can use the repeatable patterns for structured ETL or ELT whether using T-SQL or SSIS. The end result will include documentation for management from this metadata.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Attend this session to learn how to build a ""native ADF"" pipeline, how to lift and shift SSIS to the Azure Data Factory integration Runtime, and how to use ADF Design Patterns to execute and monitor pipelines and packages.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
We’ll share best practices for system sizing and configuration, security, and automation for your SQL Server workloads. We’ll also cover how you can modernize your current SQL Server workloads by moving to open-source and cloud-native AWS databases.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
This presentation will show how to read and fine tune the query plan for better performance. We’ll quickly go over the different types of execution plans and when to use them. We’ll examine the different operators, their statistics and costs, then determine which steps to focus on tuning. Finally, several trouble shooting techniques will be shown so you can increase your tuning skills.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
In this session, we discuss the key strategies for modeling and partitioning data effectively in Cosmos DB. Using a real-world NoSQL example based on the AdventureWorks relational database, we explore key Cosmos DB concepts—request units (RUs), partitioning, and data modeling—and how their understanding guides the path to a data model that yields the best performance and scalability. Attend this session, and acquire the critical skills you’ll need to design the optimal database for Cosmos DB.
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Cloud Solutions
This introductory session will give you a taste of the power and flexibility of ADX and the Kusto Query Language. A demonstration will show the ease of ingesting Azure Metrics into ADX and a number of ways to query this data, including Azure Data Studio and Power BI.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
You will also get to learn about the Azure Machine Learning Solutions that will help you to automate the time consuming Machine Learning tasks for common problems without writing code.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
In this session, you’ll learn how feature flags can be used to allow you to dark deploy. You will how you can write your T-SQL code differently so that you can dark deploy your database changes at any time. You’ll see demonstrations on how to update for T-SQL code to use features flags and how those feature flags will affect your application. When you leave this session, you’ll know how to incorporate feature flags into your deployment process so that you can deploy without impacting Production!
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session we shall be choosing the right platform for BI / DataWarehousing scenarios (SQL Server, Azure SQL DB, Azure SQL DB Hyperscale, Azure SQL DB Managed Instance or Synapse Analytics) and consider their advantages and limitations.
Further, we shall dive into Query Processor advantages and limitations when processing Columnstore Workloads.
Event Date: 10-11-2020 00:00 - Category: Half-Day Session (2.5 hours) - Track: Cloud Solutions
You shall learn how to create infrastructure in a basic as well as in the efficient (aka repeatable & reconfigurable) way for your SQL Server in Azure VMs.
In the migration part we shall consider from the formal offline paths of Backup and Restore and explore the available online paths such as Log Shipping and Transactional Replication and even expanding the AG Cluster to add a replica.
In the running part we shall consider common procedures, such as Azure Infrastructure optimisations (including disk caching), backups to Azure Blob Storage for SQL 2014 & SQL 2016+, Resource Governance, etc.
In the securing part the typical network infrastructure considerations shall be brought on the table, such as Firewall & NSGs configurations.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
Nic Hernandez, System Engineer at Clumio, will show how with Clumio you can turn your secondary copies into a data lake and query it in minutes. Forget altogether about restoring, rehydrating or rebuilding anything. With Clumio, there’s no software or infrastructure, no thick agents, no headaches or surprises, and no limits. Even proactive monitoring and automatic ticket logging is a transformational experience when using Clumio. So join us, we’ll show you how unlocking the value of your data is so much more revolutionary than worrying about backups.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Cloud Solutions
During this session, we will share performance results and provide guidance on how to choose the right virtual machine size and supporting storage options for your SQL Server workload. Additionally, we will outline recommended settings and tuning parameters to help you extract as much performance as possible.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Data Platform Strategy
Fortunately this session has the answers! We will go through techniques for rapidly seeding test and development databases, be they on-premises or in the public cloud? along with innovative ways of accelerating continuous integration. And as an added bonus some of the topics will cover solutions to one of the most challenging problems of our time, protection against ransomware.
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Hybrid Infrastructure
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
We will explain CI and Azure DevOps as an orchestrator and see a live DevOps flow of the process running on local instances, but controlled from the cloud. Learn how this can start improving your database development teamwork immediately.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
PowerShell has become a go to tool for automating deployments, upgrades, collecting data and more.
This session will build start with a basic PowerShell Script and build upon that with the use of a JSON file to show how a PowerShell script can be written to deploy SQL Scripts to multiple servers and environments.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Big Data
Microsoft SQL Server continues to evolve and your infrastructure not only needs to keep pace but do it seamlessly by reducing complexity through automation and self-service for DBAs. Dell Technologies has the powered-up storage and data protection solutions to handle your entire Microsoft Data estate. Dell EMC PowerStore can consolidate all of your Microsoft SQL Server versions. It is the ideal platform for deploying Big Data Clusters, because while you may be able to gain insights on your data where it sits…. Where it sits effects your performance, agility, security and business continuity. PowerProtect appliances in combination with PowerProtect Data Manager allows for deduplicated policy based or self-service backups and restores for DBAs.
From the edge, to the core, to the cloud….?? Dell Technologies.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
This talk focuses on the problems ORMs can cause and strategies and solutions to mitigate or solve them, focusing on Entity Framework and Entity Framework Core, since those are the most common ORMs in use in .NET today.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Now enter Azure Arc which brings Azure data services to on-premises, multi-cloud, and edge environments. It is an enabler for edge computing. This makes it possible for organizations to draw insights from data where it is created, and the data created here, in many cases, is the most valuable data to the business.
Join us as review how SQL Server 2019 has helped you accelerate your IT transformation and discuss what’s next with the addition of Azure Arc.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Security
In this session, we'll discuss what information you need to collect from your SQL Servers to effectively monitor security. You'll also see how to build a simple security dashboard for your own use using Power BI.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session we will take a look at the latest features, and see how they can be used in different scenarios.
The session will cover availability groups, smart backup, environments with large number of databases, Managed Instances, SQL Server on Linux, backup to Azure blob storage, improvements to statistics and many other areas.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Data modeling is an essential skill in Power BI design and hard problems require creative solutions. In this session, we will enumerate common challenges and demonstrate modeling techniques to resolve them.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Security
Containers are fantastic for development and DevOps, among other things. However, they have traditionally been thought of as a weak point in an infrastructure - early container platforms really didn't enable security. That's changing as the need for strong security increases. In this session, we'll discuss the things you need to think about before you implement containers and how to improve their security.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Together we will look at effective network segmentation strategy and what this means for your SQL Servers. Then we will look at how to prevent lateral movement to make sure you minimise the attack surface of your servers. Finally, we will look at what options exist in Microsoft Azure when using IaaS VMs.
All of this helps prevent attacks from ransomware like NotPetya and others which use common network misconfigurations and vulnerabilities to spread within a network.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
One of the rules, which I always keep in mind, sounds: "You can not design a database, in which deadlock can't happen". So, we should deal with them. The algorithm is simple:
In this session, we will remind the concepts of locks and transaction isolation levels, and then look at ten various deadlocks scenarios and find the root cause of the deadlocks. After that, you will see how easy solution searching could be if we did a good job on the previous step.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Security
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
In this presentation, I’ll tell you how I got started with ‘blogging, where it’s taken me since then, and lessons I’ve learned along the way. We’ll discuss ‘blog platforms, how to get started, what to write about, and what to do (and what NOT to do) when writing articles.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
You've got an idea for a new app and it's going to change the world! Right? You're working on the GUI for your company's web portal and you know just what information to collect from the user. Are you sure about that? Odds are pretty good that the information you're going to collect is a reflection of your life & your experiences.
Learn how to identify bias when it seeps in, how to code to be inclusive instead of exclusive , and some quick tips & tricks to make sure you're accounting for all the users that will use YOUR application to change the world. Instead of just the ones that look like you.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Big Data
You will leave with a toolbox and scripts to deploy your first Big Data Cluster right away!
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
In this session, we will first understand the basics of dimensional modeling. Then we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data. Do you know how the CE generates these numbers? What happens when you have multiple predicates, range predicates, variable values that are 'NOT KNOWN' to the optimizer, or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using a value that is outside of the histogram range?
In this session, I will show you how CE estimates in all these scenarios, and you will walk out better equipped to tackle those nasty, hard to solve query plans.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Plan forcing is a very powerful feature, but a bit controversial. This session will demystify it; you’ll see what Query Store exactly does when an execution plan is forced, when the forced plan is respected, and when and why is not, and the most important – when you have to force a plan in the production system and when plan forcing can bring additional troubles.
We’ll also cover in detail is automatic tuning. You will understand the benefits and potential issues you can have with this feature and how to leverage it with no or minimal risk.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Advanced Analytics
Know how to sort Parameters you define in Power Query when you Manage Parameters.
Know how to Cancel Refresh in Power Query. This is not very intuitive
Know how to easily grab a column for an existing query table as a list
Change data type for multiple columns
Add emojis to table names
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Data Platform Strategy
This session will examine different non-relational (NoSQL) data models, those being Key-Value, Document, Column, Graph, Object-Oriented database models, and in memory databases. Attendees will learn about advantages and disadvantages of the different approaches.
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Professional Development (Other)
With Jupyter Books, presentations, documentation, and knowledge-sharing can be simplified by allowing for all types of content to be created and stored in one file and shared in a single application.
This fast-paced session introduces this tool, provides the top uses for it, and demonstrates how a presentation can be improved by using it.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Security
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Columnstore indexes provide a speedy and convenient way to store OLAP data within SQL Server. Compression allows the data to be much smaller than other storage methods, allowing for faster reads. Column metadata provides the tools needed for SQL Server to be able to service queries over massive data sets quickly and efficiently.
The basics of columnstore indexes allow an administrator to improve the performance of analytics, but there is much more to learn! Understanding the internals of columnstore indexes allows querying to be even more efficient.
Columnstore indexes have evolved greatly since their introduction in SQL Server 2012. This presentation explores this feature in SQL Server 2017 and SQL Server 2019 and how its newest features can turbo-charge your analytics workloads!
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Development
In this session, you'll explore the latest Intelligent Query Processing enhancements that deliver groundbreaking performance improvements to the query engine. We’ll then move on to discussing the latest development platform improvements, including machine learning services with R and Python, integrated JSON support, graph databases, stretch database, and temporal tables. Next, we’ll explore security features, such as dynamic data masking, row-level security, Always Encrypted, and the newest support for secure enclaves with rich queries of encrypted data in use. You’ll also see the new data classification features to help you cope with GDPR and HIPPA compliance. Finally, we’ll wrap up with the latest PolyBase enhancements to query external data in Azure Blob Storage, Cosmos DB, Oracle, and other remote data sources.
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
But sometimes it doesn’t. Sometimes a query takes too much time. You need to find out why, so you can fix it. That’s where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it’s slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Do you believe the people who claim that these statements are myths?
Or do you prefer to form your own opinion?
If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Cloud Solutions
In this full-day, hands-on session, you will learn about the foundations of the Microsoft Azure SQL Platform ecosystem. We will examine the differences between Azure SQL Database, Managed Instances, and SQL Server in an Azure VM, as well as how to migrate to each of these options. We will ensure that you understand the basics around networking in Azure and how the network connects back to your on-premises environment. After performing some live migrations, we will explore topics such as ensuring data safety, including high availability, disaster recovery, security controls, and encryption.
By the end of this session, you will obtain newfound confidence to help you get data up into the cloud in a safe, secure, cost effective, and successful manner!
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
During this full day, you will: • Learn practical and real world considerations, differences, gotchas, and tips for deploying highly available SQL Server instances and databases using AGs and FCIs on premises and in the public cloud. • Understand improvements in SQL Server introduced in recent versions, such as distributed availability groups. • Learn how to achieve successful hybrid availability architectures. • Learn how PaaS changes the availability story for SQL Server.
Attending will make you a business continuity hero, whether you need to get up to speed fast or you want to modernize existing availability skills.
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
In this session, we will go on a journey to become more comfortable using PowerShell which will enable you to benefit from its power.
Whether you only work in a Windows estate or are a Unix/Mac user, PowerShell can help you to automate and create repeatable processes.
You will learn: • How to run the different versions of PowerShell, from Windows PowerShell 5.1 to PowerShell 7. • How to utilize four, everyday tips that enable you to educate yourself. • How to stop being worried about the sea of red errors and learn to love the information. • How to automate a variety of scenarios. • How to use some dbatools, however this is not the main focus.
This will be presented using Jupyter Notebooks, which you will be able to take away with you and repeat to re-enforce your learning and to teach others.
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Development
From there, we will learn about device management through the Azure IoT Hub, including installation of applications from the Azure marketplace and the development and deployment of custom Docker containers in an Azure Container Registry.
Over the course of the day, we will build out a practical scenario and take a look at features in Azure SQL Edge, including handling time series data and machine learning on edge devices. As we expand out from a single device, we will learn how to automate deployment and updates at scale using capabilities in Azure IoT Hub.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
This session will drive DBAs on their path to modernize their skills. Starting with a single container on a Docker host, the session will also cover Big Data Cluster creation and usage though T-SQL and basic Python scripts.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
In this session, we will explore how the basic constructs in our database design enforce data integrity. We will look at this from table design down through details, like data types and constraints. Additionally, we will discuss the difference between objects that support data integrity and those that support database performance. At the end of the session, you will have a better understanding of what data integrity is, how to implement and enforce it in your databases, and why it is so important for our data. Summary (150 characters): Data integrity guarantees your data has meaning. This session will help you better understand data integrity and how to
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Data Platform Strategy
This session will cover the following topics: • Understanding design decisions and impacts. • Designing for performance. • When lack of speed can mean high performance. • Moving deployments from Classic to Research Manager. • Understanding Azure Security.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session, we'll look at the options of Azure SQL Database, Azure SQL Database Managed Instance, and Cosmos DB to see when these are all going to be the correct option, and when these aren't going to be the right option; both from a price and performance perspective.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
In this session, we will learn how to bring the database deployment process to a new level to be able to deploy code in the Azure Dev Ops pipeline. First, we must create the database code capable of being deployed to many different environments such as QA, UAT, and Production. We will create a consistent release for all database objects including security, reports, jobs, and anything else stored in the database. You will leave this session with a clear understanding of setting up all database objects for successful, repeatable deployments inside a Azure DevOps pipeline, as well as how to deploy database code accurately ever time.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
That is what this session is about, developing that plan! There are many common bits of information auditors ask for every audit. This information can include providing evidence of backups, key job failures and evidence of who has elevated access to key financial databases. This is just the beginning. Auditors have also asked for information about SSRS, SSAS and SSIS. This session we will use Azure Data Studio Notebooks to retrieve much of the information you may need during an audit. When pulling the evidence, the auditors are asking for, it is also important to know what to say and even more important, what not to say.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
In this session, we will learn why and how to classify the data in our databases. SQL Server Management Studio (SSMS) has options to help us classify data. Let’s go into depth and see how to use the Data Discovery and Classification tool along with the Information Protection Policy tool found inside SSMS. Once the data is classified, let’s report on the data we classified. Lastly, let’s set up auditing and find out who is accessing the classified data. You will leave the session with a clear understanding of how to properly classify, report, and audit the newly classified data, allowing us to better adhere to compliance regulations.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
This session will use lecture, demos, and hands-on activities to learn about Power BI features, techniques for building reports, visual design concepts, and the basics of human perception and learning. You'll learn how to define your message, choose an appropriate visual, and format the visual to optimize information intake. We'll also discuss how to arrange our visuals coherently in a report and how to implement storytelling in Power BI.
You'll leave the session with an understanding of defining success in data visualization, how humans consume visual information and interact with reports, and how to create a report to communicate and stimulate viewer engagement. Attendees will receive a list of resources to use in future report design endeavors.
Event Date: 10-11-2020 00:00 - Category: Half-Day Session (2.5 hours) - Track: Artificial Intelligence
Where to start?
This session takes a Start-Finish workshop approach to creating a Data Science / AI Project. A team based approach, leveraging the latest Azure process and technologies available for fast design and deployment. Example project from Design - Deployment in 2 hours Full Project & instructions available in Github
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Data Platform Strategy
The basic philosophy behind this day-long training is that everyone (Dev, DBA, or IT Pro) should have a customized, highly-effective toolbox (Knowledge + Script) that they can use when they face adverse situations. We will go over various details about how to build scripts that are database server independent.
We will explore a common, two-step workflow for fixing performance problems: Part 1: Run Diagnostic Queries Part 2: Run Problem Resolving Queries
In order to understand the fundamentals of SQL Server performance tuning, we will take the above workflow and play the role of a new employee within the organization.
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
This seminar introduces the techniques of shaping data models in Excel, Power BI, and SSAS Tabular, making no assumptions on previous knowledge of data modeling. We will also cover real-world examples that will help you look at your reports in a different way. As you’ll soon see, with the correct data model, the right answer is always a simple one!
You will familiarize yourself with star schemas, snowflakes, and common modeling techniques; learn the importance of granularity; manage calendar-related calculations using the proper date tables; use snapshots to compute quantity on hand; work with multiple currencies in the most efficient way; and analyze events with durations, including overlapping ones.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Advanced Analytics
Together we will work through some real-world data analyses using several of the most popular Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. Next, we'll cover collecting and importing data, and introduce basic statistics around our data. From there, we'll move on to create simple visualizations of our data to help us identify trends and patterns, and then finish by putting our new-found Python skills to the test through tackling a detailed, real-world scenario.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Great, all those things will be invaluable. But you’ll encounter terms that’ll likely trip you up and could result in an expensive learning experience. Lots of Cosmos terms and concepts are familiar to the SQL professional, but may not mean what you think they mean. You’ll be encouraged to leave the safety of normalization, absolute transactional consistency, rows, columns and even joins and embrace a brave new world. You know that monitoring in SQL Server is important, but you’ll need to understand its imperative with CosmosDB – unless of course you have VERY deep pockets. You’ll enter the world of NoSQL, JSON and multi-models. You have an exciting journey ahead. Come along to this session and find out how you can transition those hard-earned SQL Server skills into superstar CosmosDB ones.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Hybrid Infrastructure
First, we will cover the basics of Kubernetes: what is it, who can use it, what can it be used for, why is this different or better than old school deployments through virtual machines? Then, we'll show you how to build a Kubernetes cluster and deploy applications into this cluster. Building on those Kubernetes deployment fundamentals, you will also learn how to deploy a SQL Server Big Data Cluster to showcase how you can deploy a complex stateful application in Kubernetes. We will close the day by working our way through the next gamechanger for deployments: Azure Arc Data Services, a solution that allows us to deploy managed Azure Data Services to any hardware running Kubernetes, including any cloud vendor, on-premises or in the cloud.
You will leave this session with the knowledge, scripts, and tools to get started with Kubernetes and Kubernetes based applications.
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Development
In this full-day, pre-con session, you will learn everything you need to take your understanding of execution plans to the next level. For most operators you'll find in execution plans, we will look at the inner workings and properties that affect their behaviour. We will also look at how the operators within a plan interact with each other. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.
In addition to explaining most operators, we will also look at how these operators interact. This will help you understand which areas in complex execution plans can cause performance issues. If you have seen some execution plans but feel you need to bring your understanding to the next level, then this pre-con session is for you!
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Database Administration
You will learn the key differences between Windows and Linux as they relate to SQL Server. You will also work through practical examples as you build your own SQL Server instance from scratch.
By the end of this full-day session, you will be able to build, configure and maintain a SQL Server instance on Linux, and transfer this knowledge to others.
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Data Platform Strategy
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. New features such as SQL Server containers and hybrid cloud architectures will be demonstrated. Backups, high availability, and disaster recovery guidelines will also be reviewed. Most importantly, this seminar informs you on methods and terminology to improve your collaboration with your infrastructure team in order to streamline your critical SQL Server performance.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Slow Running Queries are the most common problem that developers face while working with SQL Server. While it is easy to blame SQL Server for unsatisfactory performance, the issue often persists with the way queries have been written, and how Indexes has been set up. The session will focus on the ways of identifying problems that slow down SQL Server, and Indexing tricks to fix them. We will see a few different scenarios where indexes will actually negatively affect the performance of queries. By removing some of the indexes, we can easily improve the performance of overall system. This is a very unique session and will explore the dark side of indexes and its resolutions. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately.
Event Date: 10-11-2020 00:00 - Category: Half-Day Session (2.5 hours) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: DevOps
This session will show an example highlighting the performance degradation encountered during a series of bad page split as well as the ongoing effects of the bad page splits on a SELECT query. Results for this example indicate a potentially larger performance hit than anticipated.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
In this session, we will learn about a structured approach for such a modernization project. We will focus on the Microsoft data platform. We will cover the latest versions of SQL Server as well as Azure SQL Database and Azure Managed Instance. We will also learn about migration tools and techniques, such as the Data Migration Assistant (DMA), the Azure Database Migration Service, Transactional Replication, Log Shipping, and more.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
With the release of ML.NET, this is no longer the case!
In this session, I'll cover what ML.NET is and how you can use it to add machine learning capabilities to your .NET applications. I'll cover the capabilities that the API offers in terms of preparing our data and evaluating our models. I'll also talk about the capabilities that the ML.NET Model builder and how that can simplify how we choose what type of model we want to build and I'll also talk about how we can deploy our models into production.
So ditch that data scientist (in a nice way of course) and come and see how you can leverage your existing .NET skills to use ML.NET to build some interesting machine learning applications!
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
The key to mastering time-intelligence in Power BI is a good date table and understanding how to control the filter context. This session will teach you about both!
In this (demo-heavy) session, we’ll quickly review Power BI’s built-in time intelligence capabilities and when you should avoid them! We’ll also cover the importance of a good date table, what attributes it should include, and how it can be leveraged to simplify complex time-intelligence calculations. Finally, we’ll breakdown many of the 40+ DAX time-intelligence functions, showing you how they work under the covers (hint: filter context) and how they can be used in combination to accommodate complex business logic.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
If you want to learn Python but you don't know the best place to start, attend this session to get an introduction to Python using a real-world dataset to walkthrough the basics of Python using the Anaconda distribution of Python and Visual Studio Code. We will cover all the necessary basic skills needed to get started with Python such as, installation, variables, control flow, and packages. We will go over the basics to building proper machine learning models in Python using packages like scikit-learn, pandas, numpy, matplotlib, seaborn, tensorflow, keras, and more.
This is a completely new, updated version of my intro session It is a guided intro to both Python and building a machine learning model in Python using a real-world dataset.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Artificial Intelligence
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the users location when a button is pressed. The Power Automate flow we create in this session will take the location and user information and write it to an Excel file. We will also look at the Power BI connector in Power Automate that will allow us to refresh a Power BI data set. In the Power BI report we will create, we will connect to an Excel file with the location information in it and display it in a report including the location on a map.
The audience will take away useful information about Power Apps, Flow and Power BI including
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Hybrid Infrastructure
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Hybrid Infrastructure
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session, we'll discuss how to create procedures that update or delete large amounts of data while keeping our operations bite-sized and our performance smooth.
We'll talk about the TOP operator, the flow of row mode execution, and how to avoid blocking operators. We'll have examples from public databases based on real world cases, and we'll talk about anonymizing 15 million records containing PII in 5 minutes.
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Development
The presenter will demonstrate these features during the lightning talk and briefly describe scenarios where they can best be used.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Big Data
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
However, as with any product, with great simplification comes greater problems. As a data professional, it is our responsibility to make sure the data layer is accessed with proper security and efficiency. In this session, I will explore different methods to connect to the data from PowerApps and Power Automate. In this demo filled session, I will cover different scenarios for sending and receiving data in PowerApps using Power Automate.
Key Learning: The attendees will learn design best practices in PowerApps and Power Automate while working with data layer.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session, I will clarify the concepts of DevOps and explain the top things Data Professionals need to consider around what DevOps can do for them. The topics covered will include getting a database into source control, setting up automated unit tests, and how to push your changes to production in an automated deployment pipeline.
We will focus on two aspects of DevOps - Continuous Integration & Continuous Delivery. Continuous Integration is the integration and automated build and testing of committed code in source control. Continuous Delivery is the process of automating the deployment of code to test, staging, and production environments.
Through the use of comprehensive live demos, attendees will learn the benefits and how to implement DevOps processes in their database deployments.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00: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.
Lastly we will show how you can automate the data collection via Azure and PowerShell and report on the results.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
This tool is open-source, lightweight, and fully customizable.
On this session we will show you how to start using and customize it, we will learn how to:
Get the source code!
Basic navigation and customization options
Creating data insights
Creating custom code snippets
Installing and using extensions
Creating and using Notebooks and different kernels
Creating your own extensions (quick dashboard and typescript demos)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Learn about advanced features such as: bookmark capture states and uses, button configurations and formatting, report tooltip applications, and the wide applicability of measure based formatting.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: DevOps
In this session, we will demonstrate an end-to-end Azure BI solution with a Power BI Dataset on top, which is continuously built, tested, and deployed using GIT and Azure DevOps. The secret sauce is Tabular Editor's Command-line Interface, which allows us to make validation deployments, run a Best Practice analysis, and more, directly from within an Azure DevOps pipeline. In Power BI, this is all enabled by the XMLA read/write endpoint. Furthermore, thanks to Tabular Editor's folder serialization, merge conflicts are a thing of the past - even when multiple developers work simultaneously on the same data model!
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
SQL Server licensing is a complex beast. It is not always transparent and straight forward to understand what licensing you need. In this session, we will look at how you best license your SQL Servers to get the best return on investment. We will discuss What SQL Server editions you need to license SQL Server and software assurance – why you might need both How can you buy your licenses? Licensing models o Core based o Server+CAL How to license SQL Server in a virtual environment Licensing scenarios o High availability o Application mobility o Non-production o SQL Server on containers
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure
• The hidden dangers of the “lift and shift” strategy • How a properly planned Azure landing zone can make or break a migration project • Forecasting the cost of migration and why so many teams get costs wrong • Why performance monitoring saves many data monetization and migration projects from failure • What factors lead to ideal team composition and maturity for successful data migration You also see examples of native features within SQL Server and Azure SQL DB that enable you to move data, monitor activity, and keep costs under control. We will also show the migration tools that takes the risk out of data modernization and Azure migrations. Join us for this informative session so that you know where the danger awaits in your data modernization and Azure migration!
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Professional Development (Other)
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
A particular use-case that my clients have found very useful is to quickly create Excel sheets of information using Notebooks, PowerShell, and the ImportExcel module.
Let me share my experience with you and show you how to create your own Notebooks for your users and the tactics I have learned to enable users to self-service and create their own Excel Workbooks.
Event Date: 10-11-2020 00:00 - Category: Lightning Talk (10 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Azure Databricks provides a cloud-based Apache Spark environment that can be scaled up and out to tackle your big data analytics needs. We'll look at how to set up your first Azure Databricks cluster, how to use shared notebooks in a collaborative environment, and how to leverage the integrated Azure Machine Learning capabilities. We'll also discuss where Azure Databricks fits in the modern cloud data warehouse.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
These demonstrations of log shipping will give attendees a better understanding of when and how it can fit their business needs.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then, we take it a step further to dive into some of the complexities tied directly to this particular statement.
This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Development
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration
In this session, you will learn about how to quickly deploy production grade SQL Server on Linux in Azure ecosystem, including new fully supported High Availability configuration. You’ll learn how to configure AD authentication reliably and quickly with new and improved experience. You’ll also see suggestions on how to get best performance out of SQL Server on Linux in Azure. We look forward to seeing you there!
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Development
In this session, we’ll bring you quickly up to speed on SQL Server containers, discuss use cases, and demo containers in action with recent improvements. We’ll also cover the roadmap of what’s next for SQL Server containers.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Artificial Intelligence
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Platform Strategy
I will demonstrate Azure SQL Database security concepts such as firewall settings, roles, schema, and data masking; how to securely create, store, and retrieve user passwords for applications; fix common mistakes when creating connections strings in C#, SSIS, Python, and R; how to leverage Azure Key Vault; sharing and accessing data using blob storage; storing and accessing data using CosmosDB; and finally, securing reports and data sets in Power BI.
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Data Platform Strategy
Finally, we will discuss the benefits of the resource provider and what you need to know about licensing SQL Server on Azure virtual machines.
Expect a focused session on best practices and proven methods to get the most out of making the transition to Azure SQL.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: Microsoft Session (75 minutes) - Track: Database Administration
In this session, the SQL Server team lays out the current guidance for configuring and tuning SQL Server on modern, high-end hardware.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session we will go through Clustered and Non-Clustered Indexes from the computer's point of view. We will look how SQL Server allocates a space for different types of Indexes and how the Engine uses Indexes for the simple Select operations. I will show how to use "DBCC IND" and "DBCC PAGE" commands to dig into pages' binary code to understand how SQL Server uses different kinds of Indexes and which one works faster and why. We will talk about different Index related problems, such as Page Splits and fragmentation, and how to fight them with FillFactor. Will cover Index "Rebuild" and "Reorganize" commands, which one to use and when. By the end of the session you will have a full understanding not only on how to create best performing Indexes, but also on the best way to maintain them.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
Now that Linux has joined the family this is changing a little bit. Different operating system means that some of the tools that we're used to will have to change. This session will some of the more popular tools that are available for monitoring Linux along with discussion of how to get a started automating data collection."
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session, learn how to configure Linux Pacemaker for providing high availability solutions to SQL Server on Linux. We will look at its similarities to Windows Server Failover Cluster and how to properly architect SQL Server on Linux with Pacemaker."
Event Date: 10-11-2020 00:00 - Category: Pre-Conference Session (Full Day) - Track: Business Intelligence and Data Warehousing
In this session, we will review a series of real-world situations related to content delivery, data trustworthiness, security, data protection, reusability, change management, auditing, user adoption, user support, roles, and responsibilities. The objective is to maximize user productivity while balancing risk and security.
Lessons learned and stories from Power BI deployment projects will be shared, and numerous demos will be used throughout the day to explain and reinforce suggestions. Attendees will leave this session with specific, actionable recommendations which can be used right away for well-managed and governed enterprise-level deployments.
Bonus premium content: Attendees will receive the comprehensive Power BI Deployment and Governance Checklist, as well as several templates to use in their implementation.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Data Governance/Privacy
Enter data governance, a set of concepts centered on the ensuring that an organization has secure and high quality data throughout its life cycle. In this session, you will learn the basics of data governance as it applies to the Microsoft Data Platform, in addition to important related concepts, like master data management and data stewardship. Finally, you will learn practical steps you can to prepare for a data governance project, along with several kinds of documentation efforts you can undertake to give your organization many of the benefits of data governance without all of the work.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
• Content of textual columns • Headlines • Model (names of tables, columns and measures) • Power BI Desktop and Power BI service You will learn to extend Power BI’s data model to allow for multi-language support of column content and headlines (and how you can automate the translation of the texts with Azure Cognitive Services). I will show you how you can implement currency conversion and how to translate the model’s meta data. Finally we take a look on how to change the language in Power BI Desktop in in Power service.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Cloud Solutions
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session, we'll cover best practices on leveraging Cloud SQL-specific functionality for SQL Server as well as the robust ecosystem of tools to interact with it. Attendees who already work with SQL Server should come away with an understanding of when and how to utilize this managed offering.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Hybrid Infrastructure
AIOps is emerging and Intelligent Infrastructure is a critical part of realizing its full potential. This session will explain: • What is Intelligent Infrastructure and how it will change mundane tasks for SQL Server DBAs • What exists today to simplify management and troubleshoot SQL Server databases at scale • What the future may hold to make the life of the DBA easier and it is coming sooner than people think
It is time for the DBA to leverage Intelligent Infrastructure to remove routine tasks to allow them to focus on higher payoff activities. Allowing them to do MORE with LESS.
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
Join us as we share tales from the trenches that will make you laugh, cry, and run to your laptops to check a thing or two. As an added bonus, you'll learn how SentryOne's various monitoring solutions for SQL Server on-premises, cloud, VMware, Hyper-V, and beyond have helped our customers.
By the end of the session, you will come away with an understanding of how SentryOne's monitoring products work, things to watch for in your own environment, and have hopefully had a good laugh or two.
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Advanced Analytics
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Business Intelligence and Data Warehousing
There are many different use-case scenarios that can be covered by Data Flows, considering that Data Flows in SQL Integration Service (SSIS) projects are still playing a big role in fulfilling Extracting-Loading-Transforming (ETL) patterns for your data.
In this session, I will share my experience of populating a Data Vault repository with the help of Mapping Data Flows in Azure Data Factory."
Event Date: 10-11-2020 00:00 - Category: General Session (75 minutes) - Track: Database Administration
In this session,?we’ll?cover the benefits and pitfalls of cloud platform provider built-in toolsets and the benefits of using purpose-built?database performance monitoring solutions, wherever your database lives.???
Database?performance?monitoring is still critical, whether it’s “as-a-service” or not.?
Event Date: 10-11-2020 00:00 - Category: Partner Session (75 minutes) - Track: Database Administration
Enter?SolarWinds®?Database Performance?Analyzer (DPA) and Database Performance?Monitor (DPM). Visibility?into?database health gives?you?the same view of performance data, enabling such benefits as real-time triaging capabilities, closer collaboration between developers and DevOps, and overall?better application performance—no matter where your database lives.?
Jared Hensle?and John?Potocny?of SolarWinds?will cover:?