| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Ravi Kumar | Analytics and Visualization | Power BI In a day Hands-On |
| 09:00:00 | Rick Lowe | pre-con | Keeping Your DBA Happy. Why Some Practices Drive Admins Crazy. |
| 09:00:00 | Kevin Feasel | pre-con | Enter the Tidyverse: R for the Data Professional |
| 08:20:00 | Paresh Motiwala | BI Platform Architecture, Development Administration | BI Infrastructure in Azure: Points to Consider |
| 08:20:00 | Eugene Meidinger | Application Database Development | Execution Plans 101 |
| 08:20:00 | Jose Chinchilla | Strategy and Architecture | Azure Data Factory + SSIS: Migrating your ETLs to the Cloud. |
| 08:20:00 | Hasan Savran | Strategy and Architecture | What's new in SQL Server 2017 |
| 08:20:00 | Shawn Meyers | Enterprise Database Administration Deployment | Encryption, Encryption, Encryption! Protect your data at the right level |
| 08:20:00 | John Morehouse | Application Database Development | Temporal Tables – The New Hotness in Data Auditing |
| 08:20:00 | Mike Walsh | Cloud Application Development Deployment | Azure Managed Instances: A Primer |
| 09:45:00 | David Patrick | Application Database Development | 3 Ways for Getting Data from SharePoint : SSIS, Excel and Access |
| 09:45:00 | Ravi Kumar | BI Information Delivery | DAX 101 |
| 09:45:00 | Allen White | Application Database Development | Find and Fix those Troublesome Queries |
| 09:45:00 | Kevin Feasel | Analytics and Visualization | Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques |
| 09:45:00 | Slava Murygin | Advanced Analysis Techniques | Data Profiling or Statistics 201 |
| 09:45:00 | Carlos L Chacon | Application Database Development | How can containers for my database help me? |
| 09:45:00 | Rick Lowe | Cloud Application Development Deployment | SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Services? |
| 11:10:00 | Ray Kim | Professional Development | Whacha just say? Talking technology to non-technical people |
| 11:10:00 | Allen White | Application Database Development | Get Near Realtime ETL with Service Broker |
| 11:10:00 | James Serra | Professional Development | How to build your career |
| 11:10:00 | Azhagappan Arunachalam | Application Database Development | SQL Graph |
| 11:10:00 | Jose Chinchilla | Analytics and Visualization | Become a Power BI superstar under 1 hour! |
| 11:10:00 | Monica Rathbun | Enterprise Database Administration Deployment | Always Encrypted for Beginners |
| 11:10:00 | Elizabeth Noble | Strategy and Architecture | Using distributed AGs for your migrations |
| 12:45:00 | Shawn Meyers | Enterprise Database Administration Deployment | Successfully Virtualizing SQL Server on vSphere |
| 13:40:00 | Ray Kim | Professional Development | Networking 101: Building professional relationships |
| 13:40:00 | Jonathan Stewart | Analytics and Visualization | Now you see it, but did you really? Correcting visual fallacies... |
| 13:40:00 | Kevin Feasel | Advanced Analysis Techniques | Cleaning Is Half The Battle: Launching A Data Science Project |
| 13:40:00 | Greg Moore | Other | Pocket-sized SQL Server |
| 13:40:00 | Jamie Wick | Enterprise Database Administration Deployment | SQL Restore: Optimizing Your Data Recovery |
| 13:40:00 | Jon Tupitza | Application Database Development | Using SQL Server 2017 Machine Learning Services to Implement Common Machine Learning Tasks |
| 13:40:00 | Jason Horner | BI Platform Architecture, Development Administration | Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2 |
| 15:05:00 | Paresh Motiwala | Professional Development | How to Get and Nail Your Job Interviews |
| 15:05:00 | James Serra | BI Platform Architecture, Development Administration | Big data architectures and the data lake |
| 15:05:00 | Thomas Grohser | Application Database Development | Shaving off Microseconds |
| 15:05:00 | Matt Cushing | Professional Development | Networking 101: Getting Ready for a SQL Event |
| 15:05:00 | Jason Horner | BI Platform Architecture, Development Administration | Dimensional Modeling Design patterns beyond the basics |
| 15:05:00 | Sebastian Meine | Application Database Development | SQL Server Indexing for Developers and Accidental DBAs |
| 15:05:00 | Jack Corbett | Application Database Development | What about the Data Dude? SSDT Database Projects |
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: Analytics and Visualization
Power BI Desktop: What is Power BI and what it is not Introduction Connecting to the data Shaping data at query time Modeling Data Dax Calculations Building Reports
Power BI Service: What is Power BI Service Publishing Power BI Desktop file to the Service (Instructor will provide logins to a test Power BI Service tenant) Get the online data Sharing reports and desktops Refreshing the data Mobile Reports
Power BI On Premises Server: How is Power BI On Premises server different from Power BI Service When should you use Power BI Server SSAS Tabular: What it is and how it integrates with Power BI
Pre-requisite: Please have Power
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: pre-con
SQL Server supports two table types - heaps and tables with clustered indexes. We almost always create a unique clustered index on tables ... but why? Since heaps are part of the product they must have a use case but what is it? Any what is the secret sauce in clustered indexes that makes them so popular?
There is a substantial body of best practice information in the SQL Server community. Many of these practices are routinely ignored in some organizations, presumably because the consequences of not following aren't always clear. Come join this full day session for in-depth explanations of why we give some of the advice that we do.
Query hints, indexing, LINQ to Entities, common table expressions, looping vs set-based operations and more
Event Date: 08-12-2018 - Session time: 09:00:00 - Track: pre-con
Over the course of the day, we will look at several problem domains. For database administrators, areas of note will include visualizing SQL Server data, predicting error occurrences, and estimating backup times for new databases. We will also look at areas of general interest, including analysis of open source data sets.
Event Date: 08-12-2018 - Session time: 08:20:00 - Track: BI Platform Architecture, Development Administration
a) Better access to data and b) Increased operational efficiency How can you set up your own BI infrastructure in the cloud to address these? What components do we consider? We can do that by proper selection of technology and vendors from Azure Market Place. How do we keep an eye on possible use of Big Data for your BI. We will also look at the best practices for doing so. We will take a fleeting look at some of the storage options for us in Azure and some Big Data concepts as well. We will learn about Copy Data Virtualization in Azure Market Place that can help you provision terabytes worth of information in matter of minutes. We will also learn about setting up teams and ways to train them(and yourself) in this fast evolving world of Azure.
Event Date: 08-12-2018 - Session time: 08:20:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 08:20:00 - Track: Strategy and Architecture
Event Date: 08-12-2018 - Session time: 08:20:00 - Track: Strategy and Architecture
I will cover the following features. Linux Support Graph Tables Intelligent Query Processing Resumable Online Index Rebuild How to run R/Python with Machine Learning Services In-Memory Tables (NoSQL in SQL Server)
Event Date: 08-12-2018 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-12-2018 - Session time: 08:20:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 08:20:00 - Track: Cloud Application Development Deployment
Come to this session and find out. We’ll do some obligatory slides talking about use case, the pros, the cons and compare it with other services out there (Amazon RDS, Azure SQL, etc) and then we’ll spend a lot of time doing an interactive demo where we will build an Azure SQL Managed Instance, deploy to it and interact with our instance of SQL up in the cloud.
Event Date: 08-12-2018 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 09:45:00 - Track: BI Information Delivery
Currently DAX is used in Power BI and SSAS Tabular. Attend this session to learn DAX basics and get started with DAX.
Event Date: 08-12-2018 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 09:45:00 - Track: Analytics and Visualization
Event Date: 08-12-2018 - Session time: 09:45:00 - Track: Advanced Analysis Techniques
When all these queries are already pre-set or dynamic or you are doing profiling via SQL Server Data Tools, it is not a problem on relatively small data set, but what if your table contains billions of records, and stretches for multiple gigabytes? All queries against that large data set will do a full table scan, which will produce very heavy I/O, and take forever. In order to make the process faster, we will use a hidden gem of SQL Server: Statistics. Only one table scan will be needed to generate them, and then we can use the science behind them to do research over our data.
Event Date: 08-12-2018 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
Event Date: 08-12-2018 - Session time: 11:10:00 - Track: Professional Development
Event Date: 08-12-2018 - Session time: 11:10:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 11:10:00 - Track: Professional Development
I'll cover tips I learned over my career on everything from interviewing to building your personal brand. I'll discuss perm positions, consulting, contracting, working for Microsoft or partners, hot fields, in-demand skills, social media, networking, presenting, blogging, salary negotiating, dealing with recruiters, certifications, speaking at major conferences, resume tips, and keys to a high-paying career.
Your first step to enhancing your career will be to attend this session! Let me be your career coach!
Event Date: 08-12-2018 - Session time: 11:10:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 11:10:00 - Track: Analytics and Visualization
Event Date: 08-12-2018 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment
Event Date: 08-12-2018 - Session time: 11:10:00 - Track: Strategy and Architecture
In this session I will discuss what distributed AGs are, show how to set them up, and show how to monitor distributed AGs.
Event Date: 08-12-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment
Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by a member of the VMware's SQL Server Experts Group.
Event Date: 08-12-2018 - Session time: 13:40:00 - Track: Professional Development
In this interactive session, we will discuss networking -- what it is, why it's important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn't previously have!
Event Date: 08-12-2018 - Session time: 13:40:00 - Track: Analytics and Visualization
Event Date: 08-12-2018 - Session time: 13:40:00 - Track: Advanced Analysis Techniques
Event Date: 08-12-2018 - Session time: 13:40:00 - Track: Other
At the other end of the spectrum there's an amazing amount of power available in very small form-factors. This session will explore what can be done with cheap off the shelf "computers on a board" form factors and Linux to build cheap and easy to deploy small SQL solutions that can be useful for a variety of data collection activities.
Event Date: 08-12-2018 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
How long will the restoration process take?
Can it run faster?
In this session, we'll answer these questions by looking at how to establish and maintain a Restoration Baseline and the options available for performance tuning database restores.
Event Date: 08-12-2018 - Session time: 13:40:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 13:40:00 - Track: BI Platform Architecture, Development Administration
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Event Date: 08-12-2018 - Session time: 15:05:00 - Track: Professional Development
In this session I'll share personal and some real-life stories. You’ll learn techniques for finding new opportunities in a competitive job market. I’ll also share how to exploit the social media to your advantage. (They are not bad if used judiciously) What can you do once you get that rare and elusive interview? There are several things we need to take care of like, overall appearance, food habits, arrival, sitting posture, small talk or ice-breakers and humor. The most important parts of the limited interviewing opportunities are closing and follow up. I’ll share my own experience and notes from the field. You will also learn the importance of interview logs. Never stop looking!
Event Date: 08-12-2018 - Session time: 15:05:00 - Track: BI Platform Architecture, Development Administration
Event Date: 08-12-2018 - Session time: 15:05:00 - Track: Application Database Development
Event Date: 08-12-2018 - Session time: 15:05:00 - Track: Professional Development
In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
Event Date: 08-12-2018 - Session time: 15:05:00 - Track: BI Platform Architecture, Development Administration
Event Date: 08-12-2018 - Session time: 15:05:00 - Track: Application Database Development
Join Sebastian Meine, Ph.D. for this truly interactive session and discover how indexes in SQL Server work. After attending, you’ll be able to answer common index questions, like:
But even more important, you’ll be able to explain how indexes are organized in SQL Server and what mechanism is responsible for the amazing performance gains you can achieve with them.
Don’t miss this unique session. Attend, and you might just turn into an indexing superstar.
Event Date: 08-12-2018 - Session time: 15:05:00 - Track: Application Database Development