| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Andy Leonard | BI Platform Architecture, Development Administration | Faster SSIS |
| 09:00:00 | Peter Shore | Enterprise Database Administration Deployment | Infrastructure for the DBA: An Introduction |
| 09:00:00 | Katie Novotny | BI Platform Architecture, Development Administration | Azure Databricks: A Beginner's Journey |
| 09:00:00 | Ravi Kumar | BI Information Delivery | Power BI Suite: What services make up Power BI? |
| 09:00:00 | Allen White | Application Database Development | Scalable Application Design with Service Broker |
| 09:00:00 | Mike Burek | Application Database Development | Columnstore Indexes for Everyone |
| 09:00:00 | Tyler Graham | BI Platform Architecture, Development Administration | Dimension Management for Power BI |
| 09:00:00 | William Wolf | Application Database Development | Stop Doing That! Common T-SQL Anti-Patterns |
| 09:00:00 | Marsha Pierce | Enterprise Database Administration Deployment | Virtualizing SQL - An overview of what you need to do to virtual |
| 10:15:00 | Vladimir Oselsky | Application Database Development | Performance Tuning for SQL Developer through Execution Plans |
| 10:15:00 | Thomas Norman | Application Database Development | Encrypting Data within SQL Server |
| 10:15:00 | Russel Loski | BI Platform Architecture, Development Administration | Managing ETL Change Using BIMLScript |
| 10:15:00 | Rick Heiges | Enterprise Database Administration Deployment | Azure SQL DB Managed Instance: Today |
| 10:15:00 | Ed Wagner | Enterprise Database Administration Deployment | DBA - What's Most Important |
| 10:15:00 | Dave Bland | Enterprise Database Administration Deployment | How to use Execution Plans to find Performance Issues |
| 10:15:00 | Stephanie Bruno | BI Platform Architecture, Development Administration | Avoiding angry calls: Power BI model optimization |
| 10:15:00 | Pat Phelan | Professional Development | Ethics, Morals, and Laws for the DBA 101 |
| 11:30:00 | Angela Tidwell | Professional Development | Become the Most Valuable Player: Soft Skills for the Hard Market |
| 11:30:00 | Andy Mallon | Enterprise Database Administration Deployment | When to use Indexing ProTools |
| 11:30:00 | Slava Murygin | BI Information Delivery | Power BI: From Zero to 101 |
| 11:30:00 | Ravi Kumar | BI Platform Architecture, Development Administration | Azure Analysis Service or SSAS Tabular: How they work |
| 11:30:00 | Allen White | Enterprise Database Administration Deployment | Emergency! Are You Ready for Disaster to Strike? |
| 11:30:00 | Eugene Meidinger | Professional Development | Drinking From the Firehose: a Guide to Keeping Up with Technology |
| 11:30:00 | Ameena Lalani | Enterprise Database Administration Deployment | SQL Server 2019 - New Features and Enhancements |
| 11:30:00 | Jim Donahoe | Cloud Application Development Deployment | Getting started with Azure SQL Database: What You Need To Know! |
| 12:55:00 | Diane Schuster | BI Platform Architecture, Development Administration | CozyRoc: Dynamic Data Flows in SSIS Without Programming |
| 12:55:00 | Matt Nelson | Professional Development | Quest - Lunchtime chat |
| 12:55:00 | Matt Nelson | Other | Pure Storage lunchtime chat |
| 12:55:00 | Matt Nelson | Professional Development | Profisee - Lunchtime chat |
| 12:55:00 | Matt Nelson | Information Delivery | Snowflake - Lunchtime chat |
| 13:40:00 | Rayis Imayev | Cloud Application Development Deployment | Using Azure Data Factory Mapping Data Flows to load Data Vault |
| 13:40:00 | Angela Tidwell | Other | Data Collection and Usage: Illegal or Unethical? |
| 13:40:00 | Slava Murygin | Enterprise Database Administration Deployment | What treasures are hidden in the Plan Cache? |
| 13:40:00 | Janis Griffin | Enterprise Database Administration Deployment | Inside the Query Store. What Knowledge can You Gain? |
| 13:40:00 | Peter Shore | Professional Development | Learn Like Your Life Depends On It |
| 13:40:00 | Jess Pomfret | Enterprise Database Administration Deployment | Install Configure SQL Server with PowerShell DSC |
| 13:40:00 | Dave Bland | Enterprise Database Administration Deployment | An Introduction to Azure Data Studio |
| 13:40:00 | James Loesch | Application Database Development | Opening SQL Window Functions |
| 14:50:00 | Andy Leonard | Cloud Application Development Deployment | Moving Data with Azure Data Factory |
| 14:50:00 | Paul Stanton | Application Database Development | SQL DevOps Simplified with Production Databases |
| 14:50:00 | Andy Mallon | Professional Development | How to get your Dream Job: Resume job hunting tips |
| 14:50:00 | George Woods | BI Platform Architecture, Development Administration | Power BI - A guide to each product and licensing |
| 14:50:00 | Jeff Moden | Strategy and Architecture | “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance |
| 14:50:00 | Jess Pomfret | Enterprise Database Administration Deployment | Life Hacks: dbatools edition |
| 14:50:00 | Eugene Meidinger | BI Information Delivery | Introduction to M (a.k.a Power Query) |
| 16:00:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Using Open Source Software to Collect Performance Metrics |
| 16:00:00 | Sam Nasr | Application Database Development | Data Time Travel with SQL Server Temporal Tables |
| 16:00:00 | Peter Shore | Cloud Application Development Deployment | Hello My Friends, Welcome to CosmosDB |
| 16:00:00 | Jeff Moden | Strategy and Architecture | “Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks. |
| 16:00:00 | Dave Bland | Enterprise Database Administration Deployment | How to do a Complete SQL Server Assessment |
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.
Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
By the end of this session, you will have a better understanding of Azure Databricks and how you might take advantage of this new PaaS Big Data offering.
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: BI Information Delivery
There will be brief demonstration of each product.
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Application Database Development
Learning Objectives: Session Goal 1 Understand the Service Broker architecture Session Goal 2 Understand the difference between critical and non-critical updates Session Goal 3 Demonstrate how the non-critical updates are best handled asynchronously
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how to unlock more value from your analytics.
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Application Database Development
In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.
By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rock star!
Event Date: 05-10-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Application Database Development
In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.
You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-10-2019 - Session time: 10:15:00 - Track: Professional Development
Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.
This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Professional Development
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Over the years, Microsoft has given us many different indexing options and flavors. Today there are many more considerations beyond "clustered or non clustered". We'll cover all those different flavor options: Filtered, Compressed, Columnstore, included columns, and Partitioning.
We won't only talk about what these options are, we'll also cover how and when to use these different indexing options, and how to make sure you have enough--but not too many--indexes for your workload.
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: BI Information Delivery
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
Come to this session to learn: 1-Strengths and weaknesses for each. 2-How to leverage a hybrid model in your organization. 3- Introduction on how to administer both of the environments.
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
This session will focus on the kinds of situations that can dramatically affect a data center, and how to practice recovery processes to assure business continuity.
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Professional Development
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
This is an introductory session to introduce you to these new features. There will not be enough time to do any meaningful demo but there will be plenty of time to ask questions. You will leave this session with a solid understanding of some of the best new features of SQL Server 2019 which will help you and your company make decisions such as when and why to upgrade your database platform.
Event Date: 05-10-2019 - Session time: 11:30:00 - Track: Cloud Application Development Deployment
Prerequisites: Have some understanding of Azure, and PowerShell. Familiar with HA/DR terms utilized today.
Event Date: 05-10-2019 - Session time: 12:55:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-10-2019 - Session time: 12:55:00 - Track: Professional Development
Event Date: 05-10-2019 - Session time: 12:55:00 - Track: Other
Event Date: 05-10-2019 - Session time: 12:55:00 - Track: Professional Development
Event Date: 05-10-2019 - Session time: 12:55:00 - Track: Information Delivery
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Cloud Application Development Deployment
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 to fulfill Extracting-Loading-Transforming (ETL) patterns for your data.
In this session, I will share my experience of populating a Data Vault repository by using Data Flows in Azure Data Factory.
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Other
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
In this session, we’ll look at Plan Cache, what it is and what it contains, how query plans get into the Cache , how they are reused and how they get out.
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
You will learn:
How to quickly find plan changes and analyze performance issues How to use the new wait classifications in order to get clues on how to tune your statements About the new adaptive query processing features and SQL Operation Studio
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Professional Development
This session is designed to help with just that. In addition to talking about a learning plan that fits your needs, we will discuss how to execute that plan, including lab environments, as well as resources to help you execute those plans. If you have reached this point, you simply need to be in this session, see you there.
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-10-2019 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 14:50:00 - Track: Cloud Application Development Deployment
Attend this session to learn:
Event Date: 05-10-2019 - Session time: 14:50:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 14:50:00 - Track: Professional Development
In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I'll give some helpful tricks to getting your next job. You'll learn how to write a resume that gets you noticed, how to navigate interviews, and learn how to decide if a potential job and employer is right for you.
Bring your own resume to this session, and I'll provide you some personal (and private) feedback on what I would do to help improve your resume so you can land your Dream Job.
Slides handouts available on GitHub: http://am2.co/dream-job-ppt
Event Date: 05-10-2019 - Session time: 14:50:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-10-2019 - Session time: 14:50:00 - Track: Strategy and Architecture
In this 1st of two back-to-back sessions, we'll learn how the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory/disk space, costly/continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance and how it all negatively impacts your code even if it’s perfect code.
We'll also discover the true costs of page splits, how REORGANIZE can perpetuate them, their effect on performance, introduce and learn how to use "sp_IndexDNA™" to see indexes as you've never seen them before, and introduce methods to make even active GUID-based indexes 100% fragmentation free for months at a time, which will also fix the problems we’ve discovered.
This 1st session is also a recommended segue into the second session.
Event Date: 05-10-2019 - Session time: 14:50:00 - Track: Enterprise Database Administration Deployment
This session’s life hacks will include, among others:
Event Date: 05-10-2019 - Session time: 14:50:00 - Track: BI Information Delivery
In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.
Event Date: 05-10-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
In this session, we will discuss sp_whoisactive and Query Store to track what queries are running. Then we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive and easy to set up system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances, Azure Managed Instances and Azure SQL Databases.
Attendees will see how easy it is to get good performance data and visualize it interactively and combine with other tools to troubleshoot issues. Finally, we will look at problem I solved using this solution as an example.
Event Date: 05-10-2019 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 05-10-2019 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
Event Date: 05-10-2019 - Session time: 16:00:00 - Track: Strategy and Architecture
In this 2nd of two back-to-back sessions, we’ll learn the 5 main “Insertion Patterns” and how they cause or prevent fragmentation, introduce the additional page splitting/fragmenting horror of “ExpAnsive Updates”, continue to learn about the true costs of using REORGANIZE and why it should be avoided, how it all affects performance and disk/memory usage, how it all affects Index Maintenance, and steps that can be taken to seriously improve all of that.
We'll also learn that simply reducing Fill Factors isn't the "fix" for fragmentation and can actually cost you serious amounts of additional totally wasted memory while providing little to no value.
Unfortunately, there won’t be time to cover it all but well documented code will be provided to help identify the sources of page splits and “ExpAnsive Updates” so that they can be eliminated.
Session #1 is a strongly recommend prerequisite for this session.
Event Date: 05-10-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment