| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | John Deardurff | Application Database Development | A Beginners Guide to Transactions |
| 08:30:00 | Julie McLain-Harper | Application Database Development | Large Transactional Data Migration: A Sr. DBA Case Study From The Trenches |
| 08:30:00 | Dave Mattingly | Cloud Application Development Deployment | Alexa, Talk to Me |
| 08:30:00 | Hope Foley | Advanced Analysis Techniques | Throw a Brick at Your Data: Intro to Azure Databricks |
| 08:30:00 | Eugene Meidinger | Enterprise Database Administration Deployment | What's New with SQL Server 2019? |
| 08:30:00 | Slava Trofimov | BI Platform Architecture, Development Administration | Better Together: Power BI Dataflows and Azure Data Lake Storage |
| 08:30:00 | Jeff Moden | Enterprise Database Administration Deployment | “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance |
| 09:45:00 | Jim Miller | BI Platform Architecture, Development Administration | Populating a Data Warehouse with SSIS and Biml Patterns |
| 09:45:00 | Grant Fritchey | Application Database Development | Extending DevOps To SQL Server |
| 09:45:00 | Jess Pomfret | Enterprise Database Administration Deployment | Install Configure SQL Server with PowerShell DSC |
| 09:45:00 | Phillip Labry | Cloud Application Development Deployment | Analysis Services is in Azure? Seriously!? Let's build a model! |
| 09:45:00 | Jeff Moden | Enterprise Database Administration Deployment | “Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks. |
| 09:45:00 | Warren Sifre | BI Platform Architecture, Development Administration | Introduction To Data Lakes |
| 09:45:00 | Vanessa Kesten | BI Platform Architecture, Development Administration | Help Me SSIS Logging, You're My Only Hope! |
| 11:00:00 | John Deardurff | Application Database Development | Inside the Database Engine |
| 11:00:00 | Ben Weissman | Other | SQL Server Big Data Clusters - A game changer? |
| 11:00:00 | Vladimir Oselsky | Application Database Development | Performance Tuning for SQL Developer through Execution Plans |
| 11:00:00 | Sriharsh Adari | BI Platform Architecture, Development Administration | Modernize Data Platform - A Detailed Case Study |
| 11:00:00 | Greg Deckler | Analytics and Visualization | Building a Machine Learning Regression Model with Zero Code in PowerBI |
| 11:00:00 | Erin Stellato | Enterprise Database Administration Deployment | Extending Your Use of Extended Events |
| 13:00:00 | Thomas Grohser | Application Database Development | You should use Column Store but Avoid the Mistakes I made. (1/2) |
| 13:00:00 | Thomas Grohser | Application Database Development | Implementing Key Value Store in SQL Server |
| 13:00:00 | Cassandra Faris | Professional Development | Business Technology: A Communication Guide |
| 13:00:00 | Bert Wagner | Analytics and Visualization | The Analyst’s Guide To Finding and Fixing Performance Anti-Patterns |
| 13:00:00 | Andy Mallon | Application Database Development | Demystifying Data Compression |
| 13:00:00 | Allen White | Enterprise Database Administration Deployment | Emergency! Are You Ready for Disaster to Strike? |
| 13:00:00 | Rayis Imayev | Cloud Application Development Deployment | Continuous integration and delivery (CI/CD) in Azure Data Factory |
| 13:00:00 | Kerry Tyler | BI Platform Architecture, Development Administration | 45 Minutes to Your First Tabular Model |
| 13:00:00 | David Maxwell | Professional Development | Starting your own consulting firm without getting sued. |
| 14:15:00 | Kevin Feasel | Advanced Analysis Techniques | Classification With Naive Bayes |
| 14:15:00 | Jonathan Stewart | BI Information Delivery | Now you see it, but did you really? Correcting visual fallacies... |
| 14:15:00 | Drew Furgiuele | Enterprise Database Administration Deployment | SQL Server and PowerShell: Let's Get Serious |
| 14:15:00 | Thomas Grohser | Application Database Development | You should use Column Store but Avoid the Mistakes I made. (2/2) |
| 14:15:00 | Joe McTaggart | Enterprise Database Administration Deployment | A TCP packet walks into a bar - Connectivity Issues and Bad Jokes |
| 14:15:00 | Tamera Clark | Professional Development | The Community Speaks: WIT, LGBTQ, diversity and inclusion. |
| 15:30:00 | Sam Nasr | Application Database Development | Data Time Travel with SQL Server Temporal Tables |
| 15:30:00 | Ben Weissman | Information Delivery | Let’s Build SSIS Packages with Biml – Live! |
| 15:30:00 | Lucas Feiock | Cloud Application Development Deployment | Lambda architecture design using Azure Databricks for advanced analytics |
| 15:30:00 | Jeff McKenzie | Application Database Development | Hey, You Got Your TDD in my SQL DB! |
| 15:30:00 | David Maxwell | Enterprise Database Administration Deployment | Watch this space! |
| 15:30:00 | Erin Stellato | Other | Joker's Wild! |
Event Date: 08-06-2019 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 08:30:00 - Track: Application Database Development
I'll show you the Data Migration Script that the Mid Level Developer gave me to start with, and you will be AMAZED at the transformation to the final product! Walk thru the steps I took for the data migration and the additional database implications moving the data has. As a Sr. DBA, my code has a special focus on performance and resource utilization throughout the development and implementation process. Participants will learn of the techniques that can make for a smooth data migration, development through testing through production deployment. In additon, some of the gotchas I uncovered as well as their resolutions will be reviewed. I will share scripts related to table partitioning, indexing, as well as pre and post data migration scripts that partitipants will find easy to implement in their own Data Migrations.
Event Date: 08-06-2019 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
In this session, we'll create a simple skill from scratch, and show how to get into some of the more advanced options.
Event Date: 08-06-2019 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
Event Date: 08-06-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 08-06-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
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: 08-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Attend to see how Biml can revolutionize your SSIS development!
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
This demo heavy session will be focused on setting up Azure Analysis Services, deploying a model, loading the model with data and finally reporting from your Azure Analysis Services instance.
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
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: 08-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 08-06-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
SSIS logging may be the last thing on your mind when starting a new project, but getting it right in the beginning is well worth your while. Logging can help troubleshoot errors, tackle inefficiencies, and even raise a red flag when there are issues in your data flow. Newer versions of SQL Server have brought new options for logging. Learn what information is available for each option along with how to implement custom logging when the built-in options aren't robust enough for your project's needs.
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Other
Let's take a look at what that means and how you can make use of the extended PolyBase capabilities, built-in Spark queries and more!
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
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 Team XE 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: 08-06-2019 - Session time: 13:00:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: Professional Development
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: Analytics and Visualization
Bert Wagner, a principal business intelligence developer, regularly advises analysts and developers on how minor changes to their SQL-based jobs can dramatically improve performance. In this session he will show how to spot common anti-patterns that negatively impact performance, and apply solutions that will correct them.
Whether you strictly write SQL queries or incorporate those queries into tools like Python, R, Power BI, SAS, SSIS, etc… this session will teach you how to recognize poor-performing patterns in your queries as well as how to fix them for improved performance.
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: Application Database Development
Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.
By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: Cloud Application Development Deployment
Let's explore how we can use Microsoft DevOps and GitHub to build and release our ADF pipelines to other environments.
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
In this session, we will talk about what Tabular is and what it does, in addition to the various "flavors" it comes in. We'll explore development processes and will wind up with a model ready for ad-hoc querying through Excel or Power BI.
Event Date: 08-06-2019 - Session time: 13:00:00 - Track: Professional Development
This is a sponsor session provided by Arenstein and Andersen Co., LPA. Our presenters will be Nicholas I Andersen and Christen M Shore.
Event Date: 08-06-2019 - Session time: 14:15:00 - Track: Advanced Analysis Techniques
Event Date: 08-06-2019 - Session time: 14:15:00 - Track: BI Information Delivery
Event Date: 08-06-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.
Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.
Event Date: 08-06-2019 - Session time: 14:15:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 14:15:00 - Track: Professional Development
Event Date: 08-06-2019 - Session time: 15:30:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 15:30:00 - Track: Information Delivery
Let’s see, how that goes… :)
PS: Even if you have not heard about Biml but are still tired of manually building SSIS packages or ADF pipelines, this is the right session for you!
Event Date: 08-06-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment
Event Date: 08-06-2019 - Session time: 15:30:00 - Track: Application Database Development
Event Date: 08-06-2019 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-06-2019 - Session time: 15:30:00 - Track: Other
This session features a smattering of lightning talks covering a range of DBA- and developer-focused SQL Server topics, interspersed with interactive games to keep the speakers and audience on their toes.
Plan for plenty of sarcasm, laughs, and eye rolls in this thoughtfully structured yet highly improvised session.
We can't guarantee what you'll learn, but we do promise a great time!
*Slot machine will not generate real money for "winners"