| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Mark Broadbent | Enterprise Database Administration Deployment | Persistence is Futile - Implementing Delayed Durability in SQL Server |
| 08:30:00 | Sergiy Lunyakin | BI Platform Architecture, Development Administration | Azure SQL DWH: Tips and Tricks for developers |
| 08:30:00 | Mary Fealty | BI Information Delivery | Chronicles of Power BI |
| 09:30:00 | Matt Gordon | Strategy and Architecture | Where Should My Data Live (and Why)? |
| 09:30:00 | Andrea Martorana Tusa | Application Database Development | T-SQL advanced: Grouping and Windowing |
| 09:30:00 | Mark Pryce-Maher | Enterprise Database Administration Deployment | SQL Server on your favourite operating system....Linux |
| 09:30:00 | Kevin Kline | Application Database Development | End-to-End Troubleshooting for SQL Server |
| 10:45:00 | Rob Sewell | Enterprise Database Administration Deployment | Administrating SQL Server with PowerShell dbatools |
| 10:45:00 | Alex Yates | Application Database Development | Database version control deployment: model or migration scripts |
| 10:45:00 | Jen Stirrup | BI Information Delivery | Data Storytelling for Business Intelligence with SQL Server 2017 |
| 10:45:00 | Jose Manuel Jurado Diaz | Application Database Development | Azure SQL Database - Lessons learned from the trenches |
| 11:45:00 | Bob Duffy | BI Platform Architecture, Development Administration | Planning and Deploying PowerBI Report Server – On Premise! |
| 11:45:00 | Christoph Seck | BI Information Delivery | Blockchain - The data platform perspective |
| 11:45:00 | Douglas McDowell | Professional Development | Realizing ROI for Data Projects |
| 11:45:00 | Daire Cunningham | BI Platform Architecture, Development Administration | Azure SQL Data Warehouse: One Cog in the Cortana Intelligence Sui |
| 13:30:00 | Erland Sommarskog | Application Database Development | When Things go Wrong - Error Handling in SQL Server |
| 13:30:00 | Jan Mulkens | Advanced Analysis Techniques | Data Science, easy until it's not |
| 13:30:00 | Various Speakers | Advanced Analysis Techniques | Lightning Talks! |
| 14:30:00 | Sander Stad | Application Database Development | PowerShell - Grow Your Script From Simple to Module |
| 14:30:00 | Callum Green | BI Information Delivery | Query Folding in Power BI |
| 14:30:00 | Dan Galavan | Strategy and Architecture | Enterprise Data Warehousing - the Data Architectural perspective |
| 14:30:00 | Stephanie Locke | Advanced Analysis Techniques | R for Reporting |
| 15:45:00 | Rudi Bruchez | Professional Development | Discover the new graph features of SQL Server 2017 |
| 15:45:00 | Satya Jayanty | Cloud Application Development Deployment | Azure Cosmos DB - What you need to know to build globally distributed apps? |
| 15:45:00 | Andrew Pruski | Enterprise Database Administration Deployment | Partitioning 101 |
Event Date: 09-06-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things.
Attend this session and you will be assimilated!
Event Date: 09-06-2018 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-06-2018 - Session time: 08:30:00 - Track: BI Information Delivery
She will give us a walk through of the many updates to Power BI and will demo some of the more recent additions. It's a fun session that demonstrates the pace at which the Power BI team at Microsoft continue to deliver improvements to an amazing piece of software.
Event Date: 09-06-2018 - Session time: 09:30:00 - Track: Strategy and Architecture
Event Date: 09-06-2018 - Session time: 09:30:00 - Track: Application Database Development
With grouping and ranking functions you can calculate in your query grandtotal, running totals, find islands in intervals, select the last-not-null value, etc. Windows functions apply directly on a set of rows defined by the OVER clause ("a window"). Windows function do not perform aggregation on group level and do not hide row details. So they allow mixing detail and total elements in the same query. The session is mainly based on a copious array of demos, to make explicit every concept introduced taking into account the impact on performances for every solution.
Event Date: 09-06-2018 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
In this session, I will talk about where and when SQL Server on Linux is a good fit, how it works under the covers ( don't worry I won't go into too much deal ) - then we will hit the demos; installing and configuring, but mostly showing it's just the same great SQL Server we know and love, just not on Windows. I will also show SQL Server in docker container for those of your that love docker.
Event Date: 09-06-2018 - Session time: 09:30:00 - Track: Application Database Development
Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Afraid of PowerShell? Worried its too complicated? Don't want to go through the learning curve?
Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday
Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session
Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Application Database Development
Which is better? Well, that question has a tendency to divide the room.
I'm irritated whenever I go to a "how to do database DevOps" session and the speaker presents just one as "the right way", perhaps referring to the other as "the wrong way". Like most things, it depends.
I'll illustrate the limitations of each approach with a simple scenario. I'll describe which projects are better suited to a model or a migrations approach. I'll also discuss whether it's possible to get the best of both worlds.
Event Date: 09-06-2018 - Session time: 10:45:00 - Track: BI Information Delivery
Takeaways:
Join this session to get the inside scoop on SQL Server 2017 from the Business Intelligence perspective.
Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Application Database Development
Event Date: 09-06-2018 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration
Topic covered are:
Event Date: 09-06-2018 - Session time: 11:45:00 - Track: BI Information Delivery
What is technically behind the ominous blockchain, what does it have to do with databases and data warehousing? Are smart contracts only interesting for the financiers? And why should you program contracts? In the first part of this session, we deliver the background, and not just technically.
In the second part we take a closer look at the Bitcoin Blockchain as a "database". Starting point here: How anonymous really is the whole thing, when everything must be visible to everyone? After a brief introduction to its structure, we load the blockchain of bitcoin (that is, all the transactions that have been done so far) into Neo4J, a graph database and look what analyzes are possible (and why does a Graph DB work better here? And why aren’t we using the new exciting Graph stuff of SQL Server 2017???) Visualization and further analysis we do with Power BI, directly connected to Neo4j.
Event Date: 09-06-2018 - Session time: 11:45:00 - Track: Professional Development
Event Date: 09-06-2018 - Session time: 11:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Application Database Development
This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
You’re a DBA or BI Developer? You don’t have time to become an expert in R or Python? You’re sick of these data science sessions that assume everyone knows statistics? Using demo’s in SQL Server 2017 ML Services, I’ll share my experience applying Machine Learning experiments as both a DBA and BI Developer. This way you’ll finally see how easy it can actually be to build and bring a Machine Learning experiment to production. I’ll share good practices you should apply to make your job easier and will guide you through the end to end process using Microsoft’s Team Data Science Process. That way you'll also have all the practical knowledge you need to do this yourself.
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Event Date: 09-06-2018 - Session time: 14:30:00 - Track: Application Database Development
We're talking about multiple functions interacting with each other, parameter validation, pipelines, use of the -WhatIf, modules, classes etc.
If you're someone who wants to learn more to upgrade your current scripts to advanced functions, come to my session. I'll show you in a couple of easy steps how a simple script can be turned into something beautiful.
Have you written a couple of scripts but want to get them to the next level. Than you'll want to attend this session and we'll see how far the rabbit hole goes.
Event Date: 09-06-2018 - Session time: 14:30:00 - Track: BI Information Delivery
So, how can we speed up data transformations in Power BI and in turn, enhance the capabilities of the Query Editor? The answer is Query Folding. This technique takes the processing strain away from Power BI and the machine you are developing on, instead using the greater capabilities from where the data is sourced.
The 1 hour session will explain Query Folding in more detail, give examples of where/when it can be used and tips of how to get transformations to perform at their best.
Event Date: 09-06-2018 - Session time: 14:30:00 - Track: Strategy and Architecture
The Data Modelling life cycle necessitates solid foundation stones, from maintained Glossaries Data Dictionaries, to Data Stewardship and Master and Reference Data Management, to ensuring regulatory compliance and Business buy-in of all of the above.
This session will cover:
Event Date: 09-06-2018 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
We’ll look at building dashboards, from connecting to our database, wrangling our data, to presenting good looking charts back to the user.
Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Professional Development
Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Cloud Application Development Deployment
Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos.
Topics covered will be: - Partitioning definition Partitioning key Indexing considerations Overview of partitioning functions and schemes Table design considerations Splitting and merging partitions Switching data Implementing sliding windows