| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Mike Byrd | Application Database Development | Indexing Like a Rocket Scientist |
| 08:30:00 | Pat Byrne | BI Platform Architecture, Development Administration | Dynamic Hierarchical Row Level Security for Power BI using SSAS Tabular and Active Directory |
| 08:30:00 | Shehab El-Najjar | Enterprise Database Administration Deployment | Performance Dreams started at SQL Server 2014 and came true now at SQL Server 2016,2017 |
| 08:30:00 | Thomas Norman | Application Database Development | Encrypting Data within Sql Server |
| 08:30:00 | Michael Viron | Professional Development | Careers in IT - Pensacola 2019 |
| 08:30:00 | Steve Jones | Application Database Development | Future Database Development with Containers |
| 10:00:00 | Monica Rathbun | Enterprise Database Administration Deployment | Performance Tuning, Getting the Biggest Bang for Your Buck |
| 10:00:00 | Jamey Johnston | BI Platform Architecture, Development Administration | Microsoft Azure Modern Data Warehouse |
| 10:00:00 | Alexander Fleming | Application Database Development | Why You Should Consider Implementing Indexed Views |
| 10:00:00 | Christine Assaf | Professional Development | Giving Feedback: How to Effectively Communicate to your Employees |
| 10:00:00 | Rie Irish | Enterprise Database Administration Deployment | How to Build Your Disaster Recovery Plan |
| 10:00:00 | Dustin Dorsey | Application Database Development | Exploring the latest T-SQL enhancements |
| 10:00:00 | Ed Watson | BI Platform Architecture, Development Administration | A Beginner's Guide to Power BI |
| 11:15:00 | Mike Byrd | Application Database Development | A Primer on SQL Server Clustered Index Architecture |
| 11:15:00 | John Morehouse | Cloud Application Development Deployment | Azure Basics for the DBA |
| 11:15:00 | William Assaf | Enterprise Database Administration Deployment | SQL Admin Best Practices with DMVs |
| 11:15:00 | Jason Hall | Application Database Development | SSMS to Azure Data Studio: The Big Switch |
| 11:15:00 | Steve Jones | Application Database Development | Adopting a Compliant Database DevOps Process |
| 11:15:00 | John Wells | Application Database Development | Fundamentals That Will Improve Your Query Performance! |
| 11:15:00 | Thomas LeBlanc | BI Platform Architecture, Development Administration | Managing Packages in Integration Services (SSIS) |
| 12:45:00 | Rie Irish | Professional Development | Women in Tech: Thriving Not Just Surviving |
| 12:45:00 | Jason Hall | Strategy and Architecture | SentryOne Success Stories |
| 13:45:00 | Sven Aelterman | Cloud Application Development Deployment | What's new in Azure SQL Database |
| 13:45:00 | Rodney Landrum | BI Platform Architecture, Development Administration | Azure Databricks (ADB) and the Traditional DBA |
| 13:45:00 | Jonathan Stewart | BI Platform Architecture, Development Administration | Performance Tuning for the BI Professional |
| 13:45:00 | Elizabeth Noble | Enterprise Database Administration Deployment | Migrate Your Database(s) with Distributed AGs |
| 13:45:00 | Mike Burek | Application Database Development | Understanding Deadlock Printouts in the Error Log |
| 13:45:00 | Angela Henry | Application Database Development | Data Types Do Matter |
| 13:45:00 | Paul LaGrone | BI Platform Architecture, Development Administration | Do I need to know about BIML? Of course you do! |
| 15:00:00 | Travis Page | Enterprise Database Administration Deployment | Look, over there, your permissions are showing! |
| 15:00:00 | Johnathan Sluder | Professional Development | My IT career is an accident. |
| 15:00:00 | Dale Sullenberger | Application Database Development | Temporal Tables: Creation, Use, and Optimizing |
| 15:00:00 | Samir Behara | Cloud Application Development Deployment | Designing Data Intensive Cloud Native Applications |
| 15:00:00 | Bill Anton | BI Platform Architecture, Development Administration | Level Up: Data Modeling for the Power BI Rockstar |
| 15:00:00 | Carl Roepe | Enterprise Database Administration Deployment | How to perform a health check |
| 15:00:00 | Rob Volk | Enterprise Database Administration Deployment | Revenge: The SQL! |
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: Application Database Development
performance. As a SQL Developer, do you understand the difference between a clustered and non-clustered index or what a covering index is? What is different between OLTP and data warehouse databases when it comes to indexing? This session is a deep dive into Clustered indexes Non-clustered indexes B-Tree traversal Primary Keys Covering indexes
This session will feature live query demos illustrating index utilization and performance using statistics and query plans. Understand indexing like a rocket scientist by attending this session!
Some knowledge of T-SQL and Management Studio is recommended.
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-06-2019 - Session time: 08:30: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. The session will deep dive into setting up Always Encrypted encryption and share my experiences implementing the encryption. In addition, the session will review auditing of sensitive data usage.
You will leave the session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. In addition, you will gather information on how to fully protect and review your sensitive data usage.
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: Professional Development
Event Date: 29-06-2019 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-06-2019 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
This session will give an overview of each of the pieces of this modern data warehouse and demos of how to setup this architecture for you environment.
Event Date: 29-06-2019 - Session time: 10:00:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 10:00:00 - Track: Professional Development
Event Date: 29-06-2019 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-06-2019 - Session time: 10:00:00 - Track: Application Database Development
In this demo heavy session, we will go over several of the new features, provide a demonstration of how you can use them, and share any considerations that you may need to consider before doing so. This session is intended for anyone interested in what’s new in the T-SQL language and will focus primarily just on enhancements to traditional T-SQL for the database engine.
Event Date: 29-06-2019 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-06-2019 - Session time: 11:15:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 11:15:00 - Track: Cloud Application Development Deployment
Event Date: 29-06-2019 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-06-2019 - Session time: 11:15:00 - Track: Application Database Development
I'm starting to use Azure Data Studio over SSMS where possible, and this talk is meant to share my experience with others. Azure Data Studio is certainly different, and it offers some interesting and impressive new ways to interact with our SQL Server instances.
Event Date: 29-06-2019 - Session time: 11:15:00 - Track: Application Database Development
DevOps is transforming software development, with many organizations and individuals adopting lean development practices, implementing Continuous Integration (CI), Continuous Deployment (CD), and performing on-demand deployments to their production environments. However, the database is largely ignored and seen as a bottleneck for a DevOps software development process. We will discuss the challenges of database development and deployment and examine why many developers find the database to be an impediment. We examine the risks of sensitive data in the development process and how you can ensure that data security concerns do not get in the way of the need for speed and agility. We’ll look at how you can adopt a Compliant Database DevOps approach that removes the database bottleneck while ensuring compliance with regulations governing the use of data within your organization such as GDPR, HIPPA or SOX. We’ll discuss the techniques used to include the data
Event Date: 29-06-2019 - Session time: 11:15:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration
This session will start with the installation and configuration of the catalog. The flow will change to the project management of packages. Here, project parameters will be used to configure different steps of a package and how this configuration can be shared with multiple packages. The project will be deployed as well as a single package deployment. The configuration will be changed at the SQL Server Agent Job and deployed project levels. Environments will be setup to show development versus QA versus production. The report monitoring dashboard will conclude the session showing error messages as well as a package performance chart.
Event Date: 29-06-2019 - Session time: 12:45:00 - Track: Professional Development
But it's about more than just living in a man's world. Let's talk tech, Where we've been Where it's going. How we keep our skills sharp. How we mentor other women. How YOU can mentor other women.
Event Date: 29-06-2019 - Session time: 12:45:00 - Track: Strategy and Architecture
Event Date: 29-06-2019 - Session time: 13:45:00 - Track: Cloud Application Development Deployment
Event Date: 29-06-2019 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-06-2019 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-06-2019 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.
NOTE: This session expects that attendees are already familiar with Availability Groups.
Event Date: 29-06-2019 - Session time: 13:45:00 - Track: Application Database Development
Going through the error log is a pain. There are many extraneous values. The details you want are buried in there somewhere, and don't always make sense. Why isn't it easier to find exactly where the deadlock is occurring?
Come walk with me through the error log to find all the details we need. There are many helpful details in the log you didn't know existed because they were hard to read. We can find out where in the code a deadlock happened, which objects deadlocked, and why they deadlocked. We'll go through the extra values to help put meaning to them. After doing this a few times, it gets easier to find the main details you want, and have supporting evidence when you need it.
Event Date: 29-06-2019 - Session time: 13:45:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
If you have data to move, BIML could be your new friend!
Event Date: 29-06-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-06-2019 - Session time: 15:00:00 - Track: Professional Development
Event Date: 29-06-2019 - Session time: 15:00:00 - Track: Application Database Development
Event Date: 29-06-2019 - Session time: 15:00:00 - Track: Cloud Application Development Deployment
With technology changing rapidly, there are new possibilities for processing data efficiently. Come join me in this session to learn more about the tools and technologies that will help you to design data intensive systems. We will take a structured approach towards architecting data-centric solutions, covering technologies like message queues, data partitioning, search index, data cache, event sourcing and NoSQL solutions.
If you are a Data professional, Software Engineer or Architect, come join me in this session to understand the high-level design principles that will help you build scalable, resilient and maintainable systems in cloud.
Event Date: 29-06-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Not only will good data modeling result in better Power BI solutions that support a wider range of reporting requirements, but they will also be easier for the business users to understand and work with.
In this session, you'll learn how to create flexible data models that can be expanded upon over time, unlock the power of the date table, and a variety of DAX patterns supporting common but complex business logic. If your Power BI solutions typically contain a single table, if you're frequently banging your head against the wall trying to figure out how to write a DAX calculation, or if you've never heard the term "dimensional model" this session is for you.
Event Date: 29-06-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
In this session we will start by discussing the importance of performing a Health Check. We will then show how to run the popular Blitz script by Brent Ozar. After that we will review the other key areas to check like the VM configuration, Windows Configuration, SQL Configuration, Security configuration, and Database configuration. Finally, we’ll show how to save the results for capacity and trending analysis
At the end of the session you will be able to: (1) Perform a Health Check on a server; (2) List the key areas for improvement; (3) Save the results for capacity and trending analysis.
Event Date: 29-06-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Hint: You attend Revenge: The SQL! This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * in ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.