| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | John Deardurff | Application Database Development | A Beginners Guide to Transactions |
| 08:30:00 | Farouq Abukhamireh | BI Platform Architecture, Development Administration | Building a Microsoft Business intelligence Solution step-by-step |
| 08:30:00 | Chirag Shah | Enterprise Database Administration Deployment | Troubleshooting AlwaysOn Availability Groups - Common Customer Scenarios |
| 08:30:00 | Thomas Norman | Application Database Development | Encrypting Data within Sql Server |
| 08:30:00 | Wylie Blanchard | Professional Development | Become a SQL Pro who’s in High Demand |
| 08:30:00 | H. Ross Reed | Enterprise Database Administration Deployment | SQL Server Auditing |
| 08:30:00 | Phillip Labry | Cloud Application Development Deployment | Analysis Services is in Azure? Seriously!? Let's build a model! |
| 08:30:00 | Joseph D'Antoni | Enterprise Database Administration Deployment | Containers, Pods, and Databases- The Future of Infrastructure |
| 08:30:00 | Pat Phelan | Enterprise Database Administration Deployment | PowerShell for the Reluctant Administrator |
| 08:30:00 | Arthur Daniels III | Enterprise Database Administration Deployment | Performance tuning with SQL Server memory grants |
| 09:50:00 | David Maxwell | Enterprise Database Administration Deployment | Using Extended Events for Wait Stats Analysis |
| 09:50:00 | Ross LoForte | Enterprise Database Administration Deployment | Azure SQL Database Managed Instance for DBAs |
| 09:50:00 | David Giard | Cloud Application Development Deployment | How Cloud Computing Empowers a Data Scientist |
| 09:50:00 | Jim Miller | BI Platform Architecture, Development Administration | Populating a Data Warehouse with SSIS and Biml Patterns |
| 09:50:00 | Andy Wickman | Professional Development | Lessons from Consulting: Third-Party Vendors |
| 09:50:00 | Joseph D'Antoni | Application Database Development | Automagic Tuning - SQL Server 2017 and Beyond |
| 09:50:00 | Ravi Kumar | Analytics and Visualization | Introduction to Azure Machine learning |
| 09:50:00 | Allan Hirt | Enterprise Database Administration Deployment | Top Tips for Deploying AGs and FCIs On Premises or In the Cloud |
| 09:50:00 | Chris Hyde | Analytics and Visualization | Python in SQL Server 2017 |
| 09:50:00 | Kevin Kline | Enterprise Database Administration Deployment | SentryOne Tools for Productivity and Performance |
| 11:10:00 | Rob Volk | Application Database Development | That's So Metadata: Discover Your Database From The Inside |
| 11:10:00 | Jordan Anderson | Analytics and Visualization | Real-time Analytics with Azure |
| 11:10:00 | Jim Dorame | Cloud Application Development Deployment | COSMOS DB Develop Local Deploy Globally |
| 11:10:00 | Sean Forgatch | BI Platform Architecture, Development Administration | Azure Data Factory Ingestion Framework |
| 11:10:00 | Deborah Melkin | Application Database Development | Back to the Basics: T-SQL 101 |
| 11:10:00 | David Klee | Enterprise Database Administration Deployment | Modern CPU Architecture and SQL Server Performance |
| 11:10:00 | Lonny Niederstadt | Enterprise Database Administration Deployment | Laying down the Law with SQL Server Resource Governor |
| 11:10:00 | Tyler Graham | BI Platform Architecture, Development Administration | Master Data Management: BI and Data Science’s Best Friend |
| 11:10:00 | David Bermingham | Enterprise Database Administration Deployment | Why Clustering for SQL Server High Availability? |
| 11:10:00 | Janis Griffin | Enterprise Database Administration Deployment | Database Performance Monitoring |
| 12:40:00 | Rob Volk | Enterprise Database Administration Deployment | Revenge: The SQL! |
| 12:40:00 | Neal Waterstreet | BI Platform Architecture, Development Administration | Master Data Management with SQL Server MDS |
| 12:40:00 | Anthony Nocentino | Cloud Application Development Deployment | Containers - You Better Get on Board! |
| 12:40:00 | Lynn Ballard | Analytics and Visualization | Beginner's Guide to Text Mining: What We Learn from SQL Saturday Presentation Abstracts |
| 12:40:00 | Brian Hansen | Application Database Development | The Amazing Utility of ROW_NUMBER() |
| 12:40:00 | John Eisbrener | Professional Development | Got the Consulting Itch? The Ins and Outs of being a Contractor for a Living |
| 12:40:00 | Jay Falck | Enterprise Database Administration Deployment | Introduction to Linux for SQL Server |
| 12:40:00 | Ola Hallengren | Enterprise Database Administration Deployment | Analyzing Performance Problems Using XEvents, DMVs Query Store |
| 12:40:00 | Deji Akomolafe | Enterprise Database Administration Deployment | Virtualizing SQL Server on vSphere - Straight from the Source |
| 12:40:00 | Allan Hirt | Enterprise Database Administration Deployment | Modern Infrastructure Fundamentals for Database Professionals |
| 14:00:00 | Jim Donahoe | Enterprise Database Administration Deployment | New Instance, Now what? |
| 14:00:00 | Angela Henry | Application Database Development | Profiling Your Data |
| 14:00:00 | Michael Johnson | BI Platform Architecture, Development Administration | Get started with Power BI Dataflows |
| 14:00:00 | Joe Obbish | Application Database Development | Improving Columnstore Load Scalability on Large Servers |
| 14:00:00 | John Sterrett | Cloud Application Development Deployment | Successfully Migrating Existing Databases to Azure SQL Database |
| 14:00:00 | Riley Major | Application Database Development | Refactoring Monolith Database Stored Procedures |
| 14:00:00 | Kevin Kline | Application Database Development | Ten Query Tuning Techniques Every SQL Programmer Should Know |
| 14:00:00 | Bryan Walsh | Enterprise Database Administration Deployment | #GetModern with Dell EMC |
| 14:00:00 | Marsha Pierce | Enterprise Database Administration Deployment | How To Talk To Your Storage Admin |
| 14:00:00 | Wylie Blanchard | Professional Development | You’re hired! Creating value before and after the interview to be |
| 15:15:00 | Hasan Savran | Application Database Development | Not your Dad's SQL Server; Contemporary twist on a classic standby. |
| 15:15:00 | Lucas Feiock | Cloud Application Development Deployment | Lambda architecture design using Azure Databricks for advanced analytics |
| 15:15:00 | Peter Shore | Cloud Application Development Deployment | Hello My Friends, Welcome to CosmosDB |
| 15:15:00 | David Bermingham | Enterprise Database Administration Deployment | High Availability and Disaster Recovery for SQL Server in Azure IaaS |
| 15:15:00 | Mike Byrd | Application Database Development | Climbing the SQL Server Index B-Tree |
| 15:15:00 | Dave Bland | Enterprise Database Administration Deployment | Is my SQL Server having Memory Pressure? |
| 15:15:00 | Jake Manske | Application Database Development | Diagnosing and fixing deadlocks in SQL Server |
| 15:15:00 | Amy Herold | Enterprise Database Administration Deployment | PowerShell for the DBA |
| 15:15:00 | Paul Stanton | Application Database Development | Azure SQL DevOps Simplified with Production Data |
| 15:15:00 | David Klee | Professional Development | My Brain Has Blue Screened - Let's Laugh |
Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 23-03-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
BI Solution Topology BI solution requirements Data Modeling Relational Dimensional Data Warehouse ETL Tabular and Multidimensional Models. Insights and Visualization Agile methodologies Tips for success
Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
• Lease Timeout
• Unplanned automatic failovers
• Factors that prevents automatic failovers
• Common configuration issues
• Cannot join database to Availability Groups
• Listener Creation failure
Event Date: 23-03-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: 23-03-2019 - Session time: 08:30:00 - Track: Professional Development
Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 08:30: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: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
This session will help you understand what PowerShell is, how it integrates into the tools you know and love, and how it can help make your everyday work go faster and more smoothly. Along with the background on PowerShell, you'll see some simple but useful tools and ideas for how you can use those tools and make your own tools too.
This session was designed for the non-PowerShell user and the new PowerShell user. It is intended to help people understand what PowerShell is and start to use PowerShell, and it will touch on advanced ideas but only assumes only basic scripting/coding experience like understanding a variable, a loop, etc.
Event Date: 23-03-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
In this session, we'll talk about analyzing requested and granted memory inside execution plans, the plan cache, and in currently running queries.
We'll also talk about troubleshooting your system when many queries have memory grants.
Prerequisites: General knowledge of execution plans and query writing
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
In this session, learn:
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Cloud Application Development Deployment
Azure offers a number of tools for building data science solutions: From a drag and drop interface to Jupyter Notebooks as a service to a Virtual Machine pre-configured with powerful Machine Learning tools. In this session, you will learn how the cloud has impacted data science, the most useful tools in Azure for a data scientist, and when it is appropriate to use each tool.
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: BI Platform Architecture, Development Administration
Attend to see how Biml can revolutionize your SSIS development!
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Professional Development
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Application Database Development
• Had a query suddenly slow down at 2 AM when you were on call? • Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt? • Had the optimizer choose the wrong type of join and send your query off to never finish?
Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Analytics and Visualization
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Analytics and Visualization
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Event Date: 23-03-2019 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Application Database Development
SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:
We will also cover the official Microsoft documentation on these features and other resources on how to use them.
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Analytics and Visualization
enable real-time analytics. We begin our session with an overview of real-time analytics and its role in business today, then we dive into streaming data architecture on Azure, followed by a demo where we build a fully-functional streaming data pipeline with Azure Stream Analytics and present insights in real-time with Power BI.
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Cloud Application Development Deployment
Do you need to support JSON, Graph, et al? Done. Join me and see how easy it is to get started. We will set up a local instance of CosmosDB, load JSON data and build a PowerBI visualization. Along the way I’ll point out a couple of things to watch out for. At the end of the session you will then learn how, with a couple of commands, to switch your visualization to the cloud.
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Application Database Development
This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
This session will detail use of the Resource Governor to distinguish resource utilization among the different workloads. We'll explore the resource limits and controls available in Resource Pool and Workload Group configuration, and how they relate to resource limits at other levels. We'll also cover potential performance and scaling effects of Resource Governor, and how to monitor and evaluate behavior under a given set of configurations. Real-world examples will detail how greater query concurrency and better performance was achieved for the most important work on systems.
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 12:40: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.
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Cloud Application Development Deployment
In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Analytics and Visualization
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Application Database Development
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Professional Development
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment
You are troubleshooting a performance problem in a business-critical database, a query is not completing, the users are complaining, and you are trying to understand what is happening. You have data from Extended Events, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?
In this session, we will look at how the tools work in different scenarios, how to correlate the data, and how you can use them in your performance troubleshooting.
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment
This session will update the core infrastructure concepts anyone responsible for SQL Server should know whether you have physical, virtualized, or public cloud deployments. As a bonus, you will be able to work better with the other administrators back in the office now that you can speak their language.
If you want to ensure that your SQL Server deployments are available, reliable, and perform well, this is the session for you.
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.
By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Dataflows are an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can quickly be consumed by business analysts, improving the speed at which business value is delivered. Dataflows can also be used to provide the single version of the truth that has traditionally been provided by data warehouses.
During this talk, we will demonstrate the creation of a dataflow using multiple data sources and also have a look at how you can get started for free using your Power BI Pro subscription.
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Cloud Application Development Deployment
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Application Database Development
Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.
Attend this session to take your query writing and query tuning skills to the next level!
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 14:00:00 - Track: Professional Development
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development
Linux Support Graph Tables Intelligent Query Processing Resumable Online Index Rebuild How to run R/Python with Machine Learning Services In-Memory Tables (Let's create NoSQL DB in SQL Server)
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Cloud Application Development Deployment
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
While on-prem high availability and disaster recovery options for SQL Server are well defined, moving those instances to Azure immediately presents some questions and challenges. Can I simply lift and shift my SQL Server Failover Cluster Instance to the cloud? Do I need to upgrade to SQL Server Enterprise Edition and us Always On Availability Groups? What about shared storage and failover clustering? What about disaster recovery, what are my options there? Load Balancers, Fault Domains, Availability Zones, Azure Site Recovery and Region Pairs, what are these things and why do they matter to me?
Cloud Datacenter MVP David Bermingham takes explains all this and more in the session.
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development
keep clustered index width small unique indexes perform better keep non-clustered index width small compressed indexes have fewer logical reads add one index for each column
But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development
In this session, we will discuss how you can use free tools to detect and analyze deadlocks in your system. We will do a deep dive on deadlock XML with an eye toward interpreting the information automatically collected by SQL Server when the free tools fall short.
Attendees will leave with the understanding they need to develop solutions to deadlocks in their systems.
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Application Database Development
Event Date: 23-03-2019 - Session time: 15:15:00 - Track: Professional Development