| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:45:00 | David Maxwell | Enterprise Database Administration Deployment | Using Extended Events for Wait Stats Analysis |
| 08:45:00 | Jennifer Brocato | Strategy and Architecture | HA/DR Solutions Using Distributed Availability Groups (Read-Scalable AGs too!) |
| 08:45:00 | Leslie Weed | BI Platform Architecture, Development Administration | Innovative Data Modeling: Make Data Warehousing Cool Again Part 1 |
| 08:45:00 | Joseph Hobbs | BI Information Delivery | [Automating Data Integrity Checks- SQL |
| 08:45:00 | Dave Bland | Enterprise Database Administration Deployment | How to do a Complete SQL Server Assessment |
| 08:45:00 | Pat Phelan | Professional Development | Ethics, Morals, and Laws for the DBA 101 |
| 10:15:00 | Daniel Maenle | Advanced Analysis Techniques | Solving Problems with Extended Events. |
| 10:15:00 | David Klee | Enterprise Database Administration Deployment | Zen and the Art of Baselines |
| 10:15:00 | Jeff Renz | BI Platform Architecture, Development Administration | Innovative Data Modeling: Make Data Warehousing Cool Again Part 2 |
| 10:15:00 | Brian Hansen | Enterprise Database Administration Deployment | Real-World PowerShell for SQL Administration |
| 10:15:00 | Rob Kraft | Other | Defense in Depth - Minimizing the Risk of SQL Injection |
| 12:15:00 | Bill Fellows | Other | Rockhurst University Business Intelligence Analytics Programs |
| 12:15:00 | Bill Fellows | Advanced Analysis Techniques | PureStorage |
| 12:45:00 | Adam Koehler | Enterprise Database Administration Deployment | XML? What’s this doing in my database? |
| 12:45:00 | Kathi Kellenberger | Enterprise Database Administration Deployment | What is DevOps and Why Should DBAs Care? |
| 12:45:00 | Alberto Ferrari | BI Platform Architecture, Development Administration | Inside xVelocity In-Memory Analytics Engine |
| 12:45:00 | Jennifer McCown | Application Database Development | Beginning T-SQL |
| 12:45:00 | John Byrnes | Advanced Analysis Techniques | Predicting the NFL with SQL Server 2017 ML Services |
| 12:45:00 | Bill Graziano | Application Database Development | What I Wish Developers Knew About SQL Server |
| 14:15:00 | Thomas Norman | Application Database Development | Encrypting Data within SQL Server |
| 14:15:00 | Steve Wake | BI Platform Architecture, Development Administration | Lessons Learned from a Successful Enterprise Power BI Deployment |
| 14:15:00 | Russel Loski | BI Platform Architecture, Development Administration | Managing ETL Change Using BIMLScript |
| 14:15:00 | Ed Leighton-Dick | Application Database Development | Principle of Least Privilege: The Key to Strong Security |
| 14:15:00 | Matthew Sharkey | Application Database Development | Building Web-Apps with R and SQL Server |
| 14:15:00 | Ameena Lalani | Enterprise Database Administration Deployment | SQL Server 2019 - New Features and Enhancements |
| 15:45:00 | Meagan Longoria | BI Information Delivery | Power BI Datasets: Where Should My Data Live? |
| 15:45:00 | Kevin Mackey | Application Database Development | Graph Databases–How and Why |
| 15:45:00 | Ben Thul | Enterprise Database Administration Deployment | Table Diaspora - A Tale from the Trenches |
| 15:45:00 | Ed Leighton-Dick | Application Database Development | Always Encrypted - Now with Enclaves! |
| 15:45:00 | Sean McCown | Enterprise Database Administration Deployment | Loading SQL Server Data with Powershell |
| 15:45:00 | Steve Wake | Advanced Analysis Techniques | More Lessons Learned from a Successful Enterprise PBI Deployment |
Event Date: 14-09-2019 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-09-2019 - Session time: 08:45:00 - Track: Strategy and Architecture
We will walk through how to set up and configure an HA/DR solution from beginning to end, review possible alerts, and how to monitor. We will take a look at the new SQL2017 Read-scale Availability Groups and why to use them. We will architect one of many possible VM solutions to host your HA/DR implementation.
Finally, we will see Automatic Failover and see how to perform a Manual Failover.
Event Date: 14-09-2019 - Session time: 08:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-09-2019 - Session time: 08:45:00 - Track: BI Information Delivery
This talk is an intermediate level solution to that pain point. We'll walk through a simple data ecosystem and how to build in testing at each failure point. Then we'll focus on setting up automated alerts.
Event Date: 14-09-2019 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-09-2019 - Session time: 08:45: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: 14-09-2019 - Session time: 10:15:00 - Track: Advanced Analysis Techniques
Event Date: 14-09-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-09-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-09-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
In this session, I'm assuming that you know the basics of PowerShell. What we're going to cover are some of the "gotchas" and nuances that I've run into when I've been working with the language, and particularly with the SQL Agent's flavor of PowerShell.
And then we'll spend the balance of our time looking at real-world, practical scripts that I use pretty much every day. PowerShell is an awesome way to automate so many processes and relieve some of the everyday monotony of SQL administration.
Event Date: 14-09-2019 - Session time: 10:15:00 - Track: Other
Event Date: 14-09-2019 - Session time: 12:15:00 - Track: Other
Event Date: 14-09-2019 - Session time: 12:15:00 - Track: Advanced Analysis Techniques
Event Date: 14-09-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
In this session, we’ll learn how XML data can be stored in the database, how to index it appropriately for performance, and tips and tricks to make your SQL queries against XML data faster.
Event Date: 14-09-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Attend this session to learn how DevOps is changing the DBAs world for the better.
Event Date: 14-09-2019 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-09-2019 - Session time: 12:45:00 - Track: Application Database Development
Event Date: 14-09-2019 - Session time: 12:45:00 - Track: Advanced Analysis Techniques
Event Date: 14-09-2019 - Session time: 12:45:00 - Track: Application Database Development
Event Date: 14-09-2019 - Session time: 14: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. Also, let’s learn how to classify data which should be protected and how to audit sensitive data usage.
You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.
Event Date: 14-09-2019 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 14-09-2019 - Session time: 14: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: 14-09-2019 - Session time: 14:15:00 - Track: Application Database Development
In this session, we'll talk about the Principle of Least Privilege in more detail, and we'll discuss ways to implement it for the three primary classes of users - general users, applications, and administrators. Each has their own set of needs that requires a separate approach to allowing the security to meet those needs. You'll leave with actionable ideas on ways that you can improve your company's security while minimizing the impact of the changes.
Event Date: 14-09-2019 - Session time: 14:15:00 - Track: Application Database Development
Here are a few topics we'll address:
Event Date: 14-09-2019 - Session time: 14:15: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: 14-09-2019 - Session time: 15:45:00 - Track: BI Information Delivery
Event Date: 14-09-2019 - Session time: 15:45:00 - Track: Application Database Development
In this session we'll look at graph databases for how to model graph databases how to easily express relationships between interconnected data how to efficiently retrieve interrelated data
We'll look at the MATCH predicate in T-SQL and the MATCH statement in Cypher, the query language for Neo4j.
Event Date: 14-09-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
You'll never believe it - this happened to me! In this session, I'll outline how I did it. You'll learn about triggers, computed columns, module signing, SSIS, and just enough BIML to be dangerous.
Event Date: 14-09-2019 - Session time: 15:45:00 - Track: Application Database Development
Enter SQL Server 2019. With Always Encrypted with Secure Enclaves, the benefits of Always Encrypted are retained, but the SQL Server engine gains the ability to carry out operations on the data - without the data ever leaving the server, and without decryption. How is this possible? Does it live up to its promises? Come to this session to find out and to see how to use it in your applications.
Event Date: 14-09-2019 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 14-09-2019 - Session time: 15:45:00 - Track: Advanced Analysis Techniques
Prerequisites: Understanding of reporting/modeling in an enterprise setting is helpful, but not required for this session