| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Kasper de Jonge | BI Platform Architecture, Development Administration | Understanding the Power BI data model |
| 09:00:00 | Alexander Klein | Cloud Application Development Deployment | Azure Cognitive Services - AI for everyone |
| 09:00:00 | Rob Sewell | Enterprise Database Administration Deployment | dbachecks - The PowerShell Module to validate your SQL Estate |
| 09:00:00 | Christopher Adkin | Application Database Development | Scaling Out Workload Processing Using SQL Server Running Inside Containers |
| 09:00:00 | Koen Verbeeck | BI Platform Architecture, Development Administration | Introduction to Biml - Generating your SSIS packages from scratch |
| 09:00:00 | Eelco Drost | Enterprise Database Administration Deployment | Deploy database changes using SSDT, VSTS and DACPAC |
| 10:15:00 | David Postlethwaite | Enterprise Database Administration Deployment | New Security Features in SQL Server 2016 |
| 10:15:00 | Gabi Münster | BI Platform Architecture, Development Administration | Azure Analysis Services - An important step for BI in the cloud? |
| 10:15:00 | Niels Naglé | Advanced Analysis Techniques | Combining Azure Cognitive Services and ML.net for AI empowerment! |
| 10:15:00 | Paul Mooij | Application Database Development | U-SQL custom extractor for multi-gigabyte XML |
| 10:15:00 | Manon van den Burg | Advanced Analysis Techniques | Techniques to implement privacy for Data analytics |
| 11:30:00 | Torsten Strauss | Enterprise Database Administration Deployment | Database tuning advisor vs. dynamic management views |
| 11:30:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Monitoring Availability Groups |
| 11:30:00 | Callum Green | BI Platform Architecture, Development Administration | Embedding PowerApps into a Power BI Dashboard |
| 11:30:00 | Nico Jacobs | Advanced Analysis Techniques | Using Azure Machine Learning in Stream Analytics |
| 11:30:00 | Daniel Hutmacher | Application Database Development | Not just polish – How good code also runs faster |
| 13:30:00 | John Martin | Strategy and Architecture | GDPR, A European Horror Story |
| 13:30:00 | Erwin De Kreuk | BI Platform Architecture, Development Administration | Migrating to an Azure SQL Datawarehouse with Azure Data Factory V2 |
| 13:30:00 | Arne Bartels | Application Database Development | Step-by-step towards building a SSIS Custom Pipeline Component |
| 13:30:00 | Hans Geurtsen | Advanced Analysis Techniques | Building solutions with Azure Databricks |
| 13:30:00 | Jose Manuel Jurado Diaz | Enterprise Database Administration Deployment | Azure SQL Database - Lessons learned from the trenches |
| 14:45:00 | Stijn Wynants | BI Platform Architecture, Development Administration | Datawarehouse Lightning Performance with Columnstore! |
| 14:45:00 | Joseph D'Antoni | Enterprise Database Administration Deployment | Containers, Pods, and Databases-The the Future of Infrastructure |
| 14:45:00 | Jan Mulkens | BI Platform Architecture, Development Administration | Automating Power BI |
| 14:45:00 | Hylke Peek | Analytics and Visualization | Automatisch werkproces met Microsoft Flow en Power BI |
| 14:45:00 | Hugo Kornelis | Application Database Development | Deep dive into Adaptive Query Processing |
| 16:00:00 | Enrico van de Laar | Advanced Analysis Techniques | Moving advanced analytics to your SQL Server databases |
| 16:00:00 | Chrissy LeMaire | Enterprise Database Administration Deployment | Simplifying XEvents Management with dbatools |
| 16:00:00 | Tobias Koprowski | Enterprise Database Administration Deployment | SQL Security in the Cloud |
| 16:00:00 | Bartosz Ratajczyk | BI Platform Architecture, Development Administration | Start testing your SSIS packages with ssisUnit |
| 16:00:00 | Kevin Boles | Application Database Development | Know What Your Code is Doing to SQL Server! |
Event Date: 13-10-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 13-10-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment
This is a large playground for young and old. Here you can try out to your heart's content what will be in use tomorrow. With the various building blocks such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to name but a few, impressive applications can be assembled in a short time.
Event Date: 13-10-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
How long since your last backup? How long since your last DBCC Check? Are your Agent Operators Correct? Is AutoClose, AutoShrink, Auto Update Stats set up correctly? Is DAC Allowed? Are your file growth settings correct, what about the number of VLFs? Is your latency, TCP Port, PS remoting as you expect? Is Page Verify, Data Purity, Compression correctly set up?
and many more checks (even your own) can be achieved using the dbachecks PowerShell module brought to you by the dbatools team.
Join one of the founders of the module, Rob Sewell MVP. and he will show you how easy it is to use this module and release time for more important things whilst keeping the confidence that your estate is as you would expect it
Event Date: 13-10-2018 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 13-10-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
With Biml - Business Intelligence Markup Language - you can cut back on development time by
In this session, we will go over the basics of Biml and BimlScript and learn how we can use metadata to create a framework for automating your data integration tasks. After this session, you can start with the automation of your SSIS packages.
A working knowledge of Integration Services package development is necessary.
Event Date: 13-10-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
In this demo only session we will build a CI/CD pipeline from scratch! From an empty Visual Studio Project, all the way to deployment to Azure using SSDT, VSTS and DACPAC.
Event Date: 13-10-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Ensuring that your data is secure has become more important than ever.
With this in mind, in SQL Server 2016, Microsoft gave us three new features that have the potential to improve the security of your SQL database, either on premises or in the cloud. These are: Dynamic Data Masking which allows us to obfuscate data in real time Always Encrypted which helps protect data both at rest and in motion with a master key Row Level Security that gives us control over who can see which rows in a table based on the user's rights
In this session we will have an overview of these important security features and demos on how to configure them and make them work.
Event Date: 13-10-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
But why should you switch from your existing on-premise solution to the cloud or plan your new approach with it? What are the big advantages of Azure Analysis Services? And what actually are the differences to PowerBI? Why is Azure Analysis Services an important step to enhancing the possibilities for BI in the cloud? This session offers answers to your questions and provides insight to support the positioning of Azure Analysis Services in your Business Intelligence strategy.
Event Date: 13-10-2018 - Session time: 10:15:00 - Track: Advanced Analysis Techniques
This by using Microsoft Cognitive Services and ML.Net: • Microsoft Cognitive Services is a collection of cloud-hosted API’s that empowers every developer to easily add AI capabilities for vision, speech, language, knowledge and search into applications and devices. • ML.NET, a cross-platform, open source machine learning framework. ML.NET will allow .NET developers to use and develop their own models and infuse custom ML into their applications
Event Date: 13-10-2018 - Session time: 10:15:00 - Track: Application Database Development
During this session we will explore and compare DOM, Streaming, LINQ, XPath, and .NET serialization for processing big XML. In the final Azure Data Lake approach, you will see how to separate the concerns of large file handling and parsing complex XML. Running on Azure Data Lake enables for integrating this into your serverless big-data pipeline.
Hands-on stuff where solutions will be shared with attendees.
Event Date: 13-10-2018 - Session time: 10:15:00 - Track: Advanced Analysis Techniques
Event Date: 13-10-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
SQL Server mainly offers two different tools we can use for this purpose: DTA Database Tuning Advisor and Missing Index Dynamic Management Views. But what are the differences in terms of reliability, usage, limitations and tuning recommendations? So, we will try to answer these questions in this deep dive session (300-400).
Event Date: 13-10-2018 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
Event Date: 13-10-2018 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
What if we could use PowerApps and Power BI together? Can we embed a PowerApp into a Dashboard/Report and give the end user the ability to write back data to a visual? How does the Common Data Service (CDS) 2.0 and CDS for Analytics (CDSA) impact the integration and functionality between both applications?
The 1-hour session includes other technologies such as Azure SQL Database, Common Data Service (CDS) and Flow. In particular, I will demonstrate how you integrate these technologies with PowerApps and Power BI. Whilst all levels of expertise are welcome, users require prior knowledge of Power BI Dashboards and
Event Date: 13-10-2018 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
So if you want to see how within 60 minutes we can learn patterns in streams of data and apply them on live data, be sure to attend this demo-oriented session.
Event Date: 13-10-2018 - Session time: 11:30:00 - Track: Application Database Development
But most of all, they’ll make the code prettier and easier to understand for the next person.
We’ll look at common ways that null values, implicit datatype conversions and foreign key constraints can radically affect the performance of your queries. Inspired by an actual client case, where I tuned a 20 hour query down to a few minutes, with only a minor code change.
This presentation is all-code, some execution plans, and no-powerpoint.
Event Date: 13-10-2018 - Session time: 13:30:00 - Track: Strategy and Architecture
Together we will talk through what GDPR is, how to know if it applies to you and the business that you work for. Looking at the scope of the regulation and understanding the rights of the data subjects and what we need to do to make sure that they are observed.
Event Date: 13-10-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
From setting up the Data Management Gateways, Azure Data Factory and of course an Azure SQL DW. After setting up these Azure Components we will do the preparation, the migration and the steps you have to care off after the migration. It will be a session with a lot of demo’s and after the session you should have a basic knowledge how you can achieve such a Migration yourself.
Event Date: 13-10-2018 - Session time: 13:30:00 - Track: Application Database Development
The session will be a step by step demo to programming a generic Custom Pipeline Component. The complete process from setting up a matching Visual Studio project to deploying and debugging will be shown. Only free tools will be used. Basic C# knowledge is recommended.
Event Date: 13-10-2018 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Event Date: 13-10-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 13-10-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created, and some dangers with performance you might face when working with Columnstore Indexes as seen in the field! After this session things like segment elimination, auto adjust buffer size, Delta Store,... will no longer be a mysterious concept for you you will be ready to start implementing the different flavors of Columnstore Indexes in your environment.
Event Date: 13-10-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 13-10-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Deployments tend to be all manual which is error prone and possibly not compliant. Monitoring usually is not in place or done manually as well. This means developers have no idea who is using what, Operations has no metrics telling them ideal planned maintenance windows, licensing issues, compliance issues, etc ... Depending on audience choice and time, we'll cover Power BI Service and/or the on-premises Report Server. You'll walk out of this session knowing:
Event Date: 13-10-2018 - Session time: 14:45:00 - Track: Analytics and Visualization
Power BI kan hier een belangrijke rol in spelen. Door het genereren van data alerts in Power BI kan je een email sturen, werktaken maken of zelfs een heel nieuw werkproces starten. Je kunt ook automatisch data naar Power BI publiceren vanuit Outlook en Sharepoint zodat emails en documenten kunnen worden geanalyseerd.
In deze sessie introduceren we Flow en kijken we naar use cases om Power Bi te integreren in werkprocessen. Aan de hand van demo’s krijg je een goed beeld hoe Power BI samen met Flow kan worden gebruikt in het automatiseren van je werkprocessen.
Event Date: 13-10-2018 - Session time: 14:45:00 - Track: Application Database Development
SQL Server 2017 changes this! Three new features now allow execution plans to adapt to reality. Memory Grant Feedback increases or decreases assigned memory based on past experience. The Adaptive Join operator allows the optimizer to create two alternative plans, the best of which will be decided at execution time. And with Interleaved Execution, parts of the plan are even completely recompiled mid-execution, with much better cardinality estimates.
If you are more interested in how all this ACTUALLY works than in shiny marketing slides, come to this session. We will spend the full 60 minutes knee-deep in execution plan internals!
Event Date: 13-10-2018 - Session time: 16:00:00 - Track: Advanced Analysis Techniques
With the release of SQL Server 2016 Microsoft integrated a solution to the questions above, in-database analytics, allowing you to bring the analytics to your data instead of the other way around. Through in-database analytics we can design, train and score models directly from SQL Server without moving data out and back into the database.
Event Date: 13-10-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Now, it's easier than ever to set up, control and inspect Extended Events sessions with dbatools! Not only does it simplify your basic interaction with XEvents, but it also helps solve your day-to-day problems, such as capturing and notifying deadlocks or blocking sessions.
Join SQL Server MVP Gianluca Sartori and PowerShell MVP Chrissy LeMaire to see how PowerShell can simplify and empower your Extended Events experience. Say goodbye to #TeamProfiler and join #TeamXE with the power of dbatools.
Event Date: 13-10-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 13-10-2018 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
On this session, I will show you how to start with automated testing of the packages and the whole projects using ssisUnit – the free SSIS testing library. I will start with some basics and move forward to the real-life examples of the unit and integration testing of the SSIS packages/ projects/solutions. You will see the benefits of automated testing and that testing is hard only at the beginning.
Event Date: 13-10-2018 - Session time: 16:00:00 - Track: Application Database Development