| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:15:00 | Melody Zacharias | Data Science, Analytics and Visualization | Not Your Grand Mother's AI |
| 09:15:00 | David Lundell | Professional Development/Other | How to Be an MVP (in Life and a Microsoft MVP) |
| 09:15:00 | Konstantin Kosinsky | Application Database Development | Using Columnstore indexes in Azure DevOps Services. Lessons learned |
| 09:15:00 | Monica Rathbun | Enterprise Database Administration Deployment | How to Get SQL Server to Run Better on Crappy Hardware. |
| 09:15:00 | Sean McCown | Application Database Development | The Master Stored Procedure Workshop: Part 1 |
| 09:15:00 | Ami Levin | Application Database Development | One key to rule them all - how to effectively destroy data consistency, and ruin query performance |
| 09:15:00 | Jared Kirkpatrick | Professional Development/Other | How to build a T-SQL Framework |
| 09:15:00 | Marsha Pierce | Enterprise Database Administration Deployment | Virtualizing SQL Server |
| 10:30:00 | Ted Stathakis | PASS Summit Preview | Reporting Services: A Smart Migration Strategy |
| 10:30:00 | Melody Zacharias | Professional Development/Other | Confidence – The Best Super-Power |
| 10:30:00 | Julie Koesmarno | Enterprise Database Administration Deployment | Azure SQL Database Edge - Tiny but mighty |
| 10:30:00 | Monica Rathbun | Professional Development/Other | I'm It - Survival Techniques for the Lone DBA |
| 10:30:00 | Sean McCown | Enterprise Database Administration Deployment | The Master Stored Procedure Workshop: Part 2 |
| 10:30:00 | Andrew Karcher | Application Database Development | Getting started with Azure Database for PostgreSQL |
| 10:30:00 | Martin Perez | Application Database Development | T-SQL Tools: Using JSON as a Data Source |
| 10:30:00 | Mike Burek | Application Database Development | Basic Windowing Functions |
| 10:30:00 | Dustin Vannoy | PASS Summit Preview | Azure Data Lakes and Data Warehouses: |
| 12:15:00 | Diane Schuster | BI Architecture, Development Administration | CozyRoc: Dynamic Data Flows in SSIS Without Programming |
| 12:15:00 | Marsha Pierce | Enterprise Database Administration Deployment | Pure Storage: How Fast Can You Restore Your Database? |
| 13:30:00 | Jamey Johnston | Data Science, Analytics and Visualization | Code Like a Pirate ... Intro to R and Data Science Tools in MS |
| 13:30:00 | Amod Singhal | Application Database Development | SQL Query Foundations |
| 13:30:00 | Ami Levin | BI Architecture, Development Administration | Big Data, Big Dupe: A little session about a big bunch of nonsense. |
| 13:30:00 | Kevin Boles | Application Database Development | Know What Your Code is Doing to SQL Server! |
| 13:30:00 | Steve Rezhener | BI Architecture, Development Administration | ETL, Introduction to SSIS, and third-party tools like MelissaData and CozyRoc |
| 13:30:00 | Richard Waymire | Cloud Application Development Deployment | Running SQL Server on AWS |
| 13:30:00 | Mike Burek | Application Database Development | Columnstore Indexes for Everyone |
| 13:30:00 | Melody Zacharias | Professional Development/Other | Women in Technology Panel Discussion |
| 13:30:00 | Thomas Hull | Enterprise Database Administration Deployment | From the Trenches - Case Study of a Data Warehouse Migration Upgrade |
| 14:45:00 | Jay Falck | Enterprise Database Administration Deployment | Introduction to Linux for SQL Server Professionals |
| 14:45:00 | Leslie Andrews | BI Architecture, Development Administration | A Perfect Ten: The Data Model |
| 14:45:00 | Patrick Partin | Enterprise Database Administration Deployment | What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf |
| 14:45:00 | Zia Khan | Data Science, Analytics and Visualization | Utilizing AI to Predict Customer Churn |
| 14:45:00 | Jamey Johnston | Data Science, Analytics and Visualization | Power BI Dataflows and How to Leverage for Data Science |
| 14:45:00 | Benjamin Nevarez | Application Database Development | Dive into the Query Optimizer - Undocumented Insight |
| 14:45:00 | Jennifer McCown | Professional Development/Other | The SQL Career Roadmap for Women (and Men) |
| 14:45:00 | Martin Perez | BI Architecture, Development Administration | T-SQL Tools: Change Automation with Change Data Capture |
| 16:00:00 | Jay Falck | Professional Development/Other | Setting up a test lab with Hyper-V |
| 16:00:00 | Janice Gerbrandt | Application Database Development | Automate tests in your database with tSQLt |
| 16:00:00 | Ben Thul | Enterprise Database Administration Deployment | Table Diaspora - A Tale from the Trenches |
| 16:00:00 | Ted Stathakis | BI Architecture, Development Administration | Reporting Services Introduction |
| 16:00:00 | Ike Ellis | Data Science, Analytics and Visualization | Data Modeling Trends for 2019 And Beyond1 |
| 16:00:00 | Manguirish Sardessai | Cloud Application Development Deployment | Assessing and Planning SQL Database Migrations to Azure |
| 16:00:00 | Kevin Boles | Application Database Development | Tune Like a Guru - The Big Three! |
| 16:00:00 | Andrew Karcher | Data Science, Analytics and Visualization | Getting Started with Azure Databricks Delta |
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Data Science, Analytics and Visualization
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Professional Development/Other
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Application Database Development
Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions records and daily growth in 10s of millions, only a few minutes delay from operation store, sub second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries. Working on it, I've learned a lot of DOs and DON'Ts about columnstore indexes. Session covers how to:
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Application Database Development
Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Application Database Development
If I told you that these keys that you take for granted, are the primary factor that destroy your database's consistency, performance, scalability, and modularity, you'd probably think I'm crazy. But what if I can prove it, scientifically, and beyond any reasonable doubt? "It ain't what you don't know that gets you into trouble. It's what you know that just ain't so..." Join me on this fascinating journey down the rabbit hole, where we will shed new light on some of the most fundamental aspects of database design. You will experience hands-on how you can drastically improve your database consistency, simplify your queries, improve performance by orders of magnitude, allow for unprecedented scalability, and modularity. Prepare for a paradigm shift. By the end of this session, you will chant with me: "The key, the whole key, and nothing but the key, so help me Codd".
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Professional Development/Other
In this session we will create a framework that we can leverage through a template that will take care of the tedious tasks that come with development. These tasks or features include audit logging, designing a dynamic data driven error handling process, and control level batching in order to document, troubleshoot, and base line your code base. Once these features are developed you can spend more time in doing what really needs to happen like developing logic to perform processes while allowing the framework to control the necessary error handling tasks for you so you can continue to produce rapid development code.
Event Date: 21-09-2019 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: PASS Summit Preview
This session will show how to use the data in the ReportServer database to determine a smart migration strategy for upgrading to a new SSRS or Power BI Report Server. Starting with the new features of Report Manager, Mobile Reports, KPIs, and the Mobile Report Publisher app. The session will then focus on how to utilize the report meta data in the ReportServer database, combined with the transaction log table, to show how to determine which reports, data sets, and data sources are being used and determine what objects to migrate.
Learn how to use PowerShell to extract the reports and data sets from the database, instead of downloading them, to facilitate an easy migration to a new implementation. Also, discover a way of determining all TSQL used by the reports. This session is particularly useful for migrating from 2008, but applicable to any migra
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: Professional Development/Other
Confidence is only 25% genetic. Let’s improve the other 75%.
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Running on Arm and x64 architecture with a reduced footprint, the proven performant and most secure Microsoft SQL engine is coming to the Edge in interactive devices and edge gateways. Combining new capabilities on data streaming and time-series, with in-database machine learning (ML), Azure SQL Database Edge is optimized for low-latency analytics right on the Edge. This session will showcase the scenarios Azure SQL Database Edge can enable.
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: Professional Development/Other
This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Here are a few of the things you’ll learn: When and how to use stored procedures The benefits and basics of contractual programming How to write stored procedures from scratch How to structure and organize stored procedures Key techniques for ideal stored procedure management Troubleshooting and debugging stored procedures The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: Application Database Development
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: Application Database Development
We will look at the benefits of a loosely defined schema and how to transform the data to work in a relational model.
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: Application Database Development
Event Date: 21-09-2019 - Session time: 10:30:00 - Track: PASS Summit Preview
Event Date: 21-09-2019 - Session time: 12:15:00 - Track: BI Architecture, Development Administration
Event Date: 21-09-2019 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Data Science, Analytics and Visualization
Come to this session to get an introduction to the R language including:
We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Application Database Development
This tutorial will focus on crucial foundational knowledge needed to retrieve data from SQL tables, i.e., the “R” (Read) in CRUD. Throughout, the emphasis is on concepts, rules, and avoiding "gotchas" - not on syntax. Topics covered will include: A review of SELECT statement, Logical Execution Order of SQL SELECT’s clauses, How SQL JOINs work, NULL values, etc.
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: BI Architecture, Development Administration
For over a decade, Big Data has managed to delude far too many smart, honest, hard-working data practitioners, with nothing but the best intentions. This session is a plea for your common sense and decency. Together, we will use history, facts, authority, and logic to expose it for what it really is. Layer by layer, we will peel off the Confusion, Illusion, Deception, Distraction and the Regression that is "Big Data". You will realize just how much progress and value Big Data has bestowed on us over the past decade. But more importantly, we will see what we can and must do to make data practice, and consequently the world, a better place. Brace yourself for a thought-provoking session, filled with "Aha" moments. I promise that after this session, you will never look at big data the same way as you did before you stepped into the room.
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: BI Architecture, Development Administration
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Professional Development/Other
Event Date: 21-09-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
We'll outline pitfalls to avoid, and walk you through hard-won lessons and strategies for success. We'll discuss our automated process for continuous deployment, which greatly reduced downtime and risk. Of course, we'll share relevant technical tips tricks. Possible guest-starring appearances from Chris and Dan, who were key players in the success of this project.
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: BI Architecture, Development Administration
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
As a DBA, you very likely have SQL Server well covered, but what about if/when you support Cassandra? Mongo? MySQL? What if you're DevOps and need something from ASP .Net? IIS? Nginx?
In this interactive session, we'll go over show you how to locally install and configure InfluxDB to store your data, get Telegraf to pull, and with Grafana, create some quick dashboards. Time permitting, we can set some thresholds, and send them to Slack.
All of these tools are completely free, and if you don't have the right monitoring, or any, this is perfect for you.
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Data Science, Analytics and Visualization
In this session theDevMasters will take you on a journey into AI and machine learning algorithms. We will not go into much of the math behind them, but instead learn what each algorithm is good for, and how to train them.
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Data Science, Analytics and Visualization
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: Professional Development/Other
This is not ideal, and we could all use some help navigating through resumes, job hunting, interviews, and negotiating. You’ll learn about all that in this session. We will also talk about how to get around a big obstacle for both women and men: how to get back to work after a long period of not working. How can I get a database job with no experience? What’s the best way to learn the newest technology? What resources are out there? Bring your questions, and we’ll explore the answers.
Event Date: 21-09-2019 - Session time: 14:45:00 - Track: BI Architecture, Development Administration
Data professionals interested in reducing development time for ETL or Reporting work.
In this session we will introduce you to Change Data Capture set up, usage and administration exploring different ways you can audit data changes, populate a reporting database all while saving time.
Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Professional Development/Other
Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Application Database Development
This session explores how and why application unit testing is performed, and then focuses on unit testing database code with tSQLt. We will learn how tests are structured, and how to set up realistic tests. We will talk about how much testing coverage is enough and when you can stop.
Even if you aren't able to fully implement Test Driven Development tomorrow, you'll walk away knowing how to future-protect that next tricky bit of logic with tests that will ensure your code produces desired results, not only the first time, but with all future modifications as well.
Event Date: 21-09-2019 - Session time: 16:00: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: 21-09-2019 - Session time: 16:00:00 - Track: BI Architecture, Development Administration
Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL: You’ve already paid for it, so put it to use! In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services. From building a data set through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort. Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.
Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Data Science, Analytics and Visualization
It is true that data modeling has changed, but there is no need to throw out great practices that have served us for years and can continue to do so. This session will cover what has changed for data modeling, why it changed, and how to take advantage of those changes. Combine new thinking with classic data architecture and you will create great analytic and transactional systems for your data.
Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
In this presentation, we will do assess the on-premises environment and determining what workloads and databases are ready to make the move and what can you do to improve their Azure readiness while reducing downtime during the migration. Planning and assessment plays a critical role in moving to the cloud. We would see wide range of resources and tools to get assessment completed with ease while identifying workload dependencies with practical tips and tricks focusing on sizing and costs. And finally, we'll assess the SQL instances and identify their readiness for Azure as well. By the end of this presentation , you'll be able to confidently identify your on-premises workloads and databases that are Azure-ready, or almost ready.
Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 21-09-2019 - Session time: 16:00:00 - Track: Data Science, Analytics and Visualization