| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Marsha Pierce | Enterprise Database Administration Deployment | SQL Server with Docker Containers |
| 09:00:00 | Steve Jones | Professional Development | Branding Yourself for a Dream Job |
| 09:00:00 | Alex Grinberg | Enterprise Database Administration Deployment | Take the changes under control |
| 09:00:00 | Rick Heiges | Cloud Application Development Deployment | Cloudy with a Chance of Data |
| 09:00:00 | John Morehouse | Enterprise Database Administration Deployment | SQL Server Databaseology: A Deep Dive Into Database Internals |
| 09:00:00 | Ravi Kumar | Analytics and Visualization | Introduction to Azure Machine learning |
| 09:00:00 | Eugene Meidinger | BI Platform Architecture, Development Administration | Power BI Internals: a Deep Dive |
| 10:00:00 | Brian Beswick | BI Platform Architecture, Development Administration | Managing Enterprise Data Quality with Data Quality Services 2016 |
| 10:15:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Intro to Query Store |
| 10:15:00 | Jens Vestergaard | Cloud Application Development Deployment | Azure IoT, Windows 10 Core Raspberry PI (DIY) |
| 10:15:00 | Steve Grier | Application Database Development | Deep Dive: RedGate's SQL Change Automation tool for database delivery |
| 10:15:00 | John Sterrett | Enterprise Database Administration Deployment | Automate the Pain Away with Adaptive Query Processing and Automatic Tuning |
| 10:15:00 | Monica Rathbun | Enterprise Database Administration Deployment | I'm It - Survival Techniques for the Lone DBA |
| 10:15:00 | Rayis Imayev | BI Information Delivery | Power BI with Maps: Choose Your Destination |
| 10:15:00 | Jeff Moden | Enterprise Database Administration Deployment | “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance |
| 11:15:00 | Michael Schulte | Application Database Development | Working Smarter by Using Window Functions |
| 11:30:00 | Chris Bell | Enterprise Database Administration Deployment | Build a White/Blacklist Bouncer. Who Gets into Your SQL Club? |
| 11:30:00 | Kevin Feasel | Analytics and Visualization | Cleaning Is Half The Battle: Launching A Data Science Project |
| 11:30:00 | Bert Wagner | Application Database Development | I Want To Go Faster! A Beginner's Guide To Indexing |
| 11:30:00 | John Morehouse | Application Database Development | Temporal Tables – The New Hotness in Data Auditing |
| 11:30:00 | Jeff Moden | Enterprise Database Administration Deployment | “Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks. |
| 11:30:00 | Andy Yun | Application Database Development | T-SQL Tips Tricks to Make Your Life Easier! |
| 13:30:00 | Marsha Pierce | Enterprise Database Administration Deployment | Mom Rules for Managing Enterprise Database Environments |
| 13:30:00 | Drew Furgiuele | Enterprise Database Administration Deployment | SQL Server and PowerShell: Let's Get Serious |
| 13:30:00 | Drew Furgiuele | Enterprise Database Administration Deployment | SQL Server Transactional Replication: A Deeper Dive |
| 13:30:00 | Steve Jones | Enterprise Database Administration Deployment | Adopting A DevOps Process for Your Database |
| 13:30:00 | Monica Rathbun | Enterprise Database Administration Deployment | Always Encrypted for Beginners |
| 13:30:00 | Alex Grinberg | Application Database Development | XML and JSON, does the DBA need it? |
| 13:30:00 | Ed Wagner | Other | DBA - What's Most Important |
| 13:30:00 | Jonathan Stewart | Application Database Development | Relationship Goals: The SQL Server Graph Database |
| 13:30:00 | Janis Griffin | Application Database Development | HiHo! HiHo! SQL Server on Linux, We Go! |
| 14:40:00 | Slava Murygin | Advanced Analysis Techniques | Data Profiling or Statistics 201 |
| 14:40:00 | Allen White | Enterprise Database Administration Deployment | Emergency! Are You Ready for Disaster to Strike? |
| 14:40:00 | Kevin Feasel | Strategy and Architecture | Much Ado About Hadoop |
| 14:40:00 | Bert Wagner | BI Platform Architecture, Development Administration | High Performance SSRS: Techniques for Faster Reporting |
| 14:40:00 | Jens Vestergaard | Analytics and Visualization | Power BI Basics - On Coke |
| 14:40:00 | Kimberly StJacques | Enterprise Database Administration Deployment | I have to support what!? SQL, Oracle, and Mongo - A side by side “how to” |
| 14:40:00 | Hasan Savran | Application Database Development | Introduction to Spatial Data with the help of SQL Server 2016/17 |
| 14:40:00 | John Deardurff | Application Database Development | The Vocabulary of Performance Tuning |
| 15:50:00 | Chris Bell | Enterprise Database Administration Deployment | 5 Minute No Sweat SQL Security Audits |
| 15:50:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Tips on Managing Lots of SQL Servers |
| 15:50:00 | Allen White | Application Database Development | Troubleshooting and Tuning Query Performance |
| 15:50:00 | Thomas Grohser | Other | "Schadenfreude" - Let's enjoy the mistakes other people made... |
| 15:50:00 | Brian Carrig | Enterprise Database Administration Deployment | Successfully Running SQL Server in AWS |
| 15:50:00 | Sam Nasr | Application Database Development | 14 T-SQL Functions You May Not Know |
Event Date: 29-09-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 09:00:00 - Track: Professional Development
Event Date: 29-09-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
Event Date: 29-09-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 09:00:00 - Track: Analytics and Visualization
Event Date: 29-09-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-09-2018 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 29-09-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.
In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.
Event Date: 29-09-2018 - Session time: 10:15:00 - Track: Cloud Application Development Deployment
This session is not for the Enterprise rather has a more DIY approach.
Event Date: 29-09-2018 - Session time: 10:15:00 - Track: Application Database Development
Event Date: 29-09-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 10:15:00 - Track: BI Information Delivery
Power BI itself a great tool that could feed your appetite for an adventure using built-in and custom map visualizations. Let's explore them!
Event Date: 29-09-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
This isn’t your typical presentation on Index Maintenance.
In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice” methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code.
Event Date: 29-09-2018 - Session time: 11:15:00 - Track: Application Database Development
In this session, you will learn how to use window functions in your queries. You'll also see some typical window function use cases and you'll get to look at some common mistakes people make with window functions so you can avoid them yourself. If you can write a query that uses a simple join, then these functions may be the next tool to add to your repertoire.
Event Date: 29-09-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
When it comes to this type of problem the consensus is to get with your network and domain admins to adequately configure access options. What happens when you can't wait or don't even have folks in that role to get the configuration right?
A blacklist is a list of what cannot access something you are trying to protect. (Like the TSA no-fly list. If you are on the list, you are not getting anywhere fast.)
A whitelist is just the opposite. It is a list of what is permitted to access something. If whatever is attempting access is not on the list, it isn’t getting in. In this session, we will go through the process to create and test your own SQL based whitelists and blacklists and also take a look at how whitelisting is being used in SQL 2017 to control what CLR objects can be trusted to run in your environment.
Event Date: 29-09-2018 - Session time: 11:30:00 - Track: Analytics and Visualization
Event Date: 29-09-2018 - Session time: 11:30:00 - Track: Application Database Development
In this session you will learn the basics of how to create performance improving indexes. We'll discuss how to identify when a performance problem is due to a missing or poorly defined index, the different types of indexes available in SQL Server, and how to know when to use each type (as well as what columns to include!).
Event Date: 29-09-2018 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 29-09-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
This isn’t your typical presentation on Index Maintenance.
In this second of two back-to-back sessions, we’ll learn of several incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it, virtually eliminate “Bad” page splits, reduce wasted memory, make your log file and log file backups a whole lot more happy, and increase the overall performance of even perfect code.
We’ll also learn that no simple method is a panacea, what to do about the horror of "expAnsive" updates, and how to make even GUID-keyed indexes work well.
Event Date: 29-09-2018 - Session time: 11:30:00 - Track: Application Database Development
This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.
This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!
Event Date: 29-09-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 13:30: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: 29-09-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
In this session, we'll discuss the transactional replication model and what it offers. You'll see plenty of examples of how to monitor transactions as they get from your publishers to your subscribers. There will also be examples of how you can change the behavior of your transactions too, and what benefits (and potential pitfalls) these changes offer.
Finally, you'll see examples on how to configure transactional replication in high availability scenarios.
Event Date: 29-09-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 13:30:00 - Track: Application Database Development
Event Date: 29-09-2018 - Session time: 13:30:00 - Track: Other
Event Date: 29-09-2018 - Session time: 13:30:00 - Track: Application Database Development
One of the best new features of SQL Server 2017 is the Graph Database! It brings us the best of both worlds in one easy platform! Come learn about the history of graph databases, how they work and why you should be using it!
Event Date: 29-09-2018 - Session time: 13:30:00 - Track: Application Database Development
The participant will learn:
Event Date: 29-09-2018 - Session time: 14:40: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: 29-09-2018 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 14:40:00 - Track: Strategy and Architecture
Event Date: 29-09-2018 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration
This rapid-fire session looks at T-SQL and SSRS specific techniques that can be used to make your reports blazing fast. Attendees can expect to improve the performance of their reports by learning to handle parameter selectivity issues, utilizing subreports efficiently, and executing insert/update/delete queries within SSRS for performance gains.
Event Date: 29-09-2018 - Session time: 14:40:00 - Track: Analytics and Visualization
In detail we will be looking at these topics: Straight up file (csv, xlsx) Scraping Web Page Data (html) Header/Footer issues Variable number of columns Multiple File Formats (think historical changes) Binding Multiple Imports into a single table Crude Error handling
Attending this session you'll learn the basics of Power BI Desktop, as well as some neat tricks to get through the more complex scenarios.
Additionally I will demonstrate how to deploy your home grown model into Azure Analysis Services
Event Date: 29-09-2018 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 14:40:00 - Track: Application Database Development
I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.
Event Date: 29-09-2018 - Session time: 14:40:00 - Track: Application Database Development
Event Date: 29-09-2018 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.
Event Date: 29-09-2018 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.
Event Date: 29-09-2018 - Session time: 15:50:00 - Track: Application Database Development
Event Date: 29-09-2018 - Session time: 15:50:00 - Track: Other
And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let's have some "Schadenfreude"! After a log day, come in and have some fun before the evening event starts
Event Date: 29-09-2018 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment
Event Date: 29-09-2018 - Session time: 15:50:00 - Track: Application Database Development