| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:15:00 | Stijn Wynants | Enterprise Database Administration Deployment | SQL Server Problem Tombola |
| 09:15:00 | Torsten Strauss | Application Database Development | Database tuning advisor vs. database management views |
| 09:15:00 | Nico Jacobs | Cloud Application Development Deployment | Azure Machine Learning |
| 09:15:00 | Peter Larsson | Application Database Development | Idling for Performance? |
| 10:45:00 | Britton Gray | BI Platform Architecture, Development Administration | MPP – Master Parallel Productivity in Azure SQL DW |
| 10:45:00 | Alexander Klein | Cloud Application Development Deployment | Playground of cognitive services - Even big kids play here |
| 10:45:00 | Alexander Arvidsson | Application Database Development | Abusing your SQL Server for fun and profit |
| 10:45:00 | Mohamed Mawla | Analytics and Visualization | SQL DataFactory for heterogenous data source |
| 12:00:00 | Remko de Boer | BI Platform Architecture, Development Administration | Master Data Services: Unknown thus unloved |
| 12:00:00 | John Martin | Strategy and Architecture | Always On Multi-Site Patterns |
| 12:00:00 | Torsten Strauss | Application Database Development | Index Fragmentation |
| 12:00:00 | David Williams | Enterprise Database Administration Deployment | SQL Server on Linux - SQL Server goes cross platform! |
| 14:00:00 | Sergiy Lunyakin | BI Platform Architecture, Development Administration | Azure SQL DWH: Tips and Tricks for developers |
| 14:00:00 | Daniel Hutmacher | Enterprise Database Administration Deployment | Management Studio level-up |
| 14:00:00 | Uwe Ricken | Application Database Development | Are Temporal Tables a useful feature? |
| 14:00:00 | Håkan Winther | Application Database Development | GDPR for SQL Server |
| 15:15:00 | André Melancia | Enterprise Database Administration Deployment | Hacking SQL Server |
| 15:15:00 | Arne Bartels | Application Database Development | SSIS Custom Pipeline Component |
| 15:15:00 | Erland Sommarskog | Application Database Development | When Things go Wrong - Error Handling in SQL Server |
| 15:15:00 | Andrea Martorana Tusa | BI Platform Architecture, Development Administration | Power BI behind the scene: security and user management |
| 16:30:00 | Rob Sewell | Enterprise Database Administration Deployment | Green is good, Red is bad - Turning your Checklists into Pester Tests |
| 16:30:00 | Rudi Bruchez | Application Database Development | Discover the new graph features of SQL Server 2017 |
| 16:30:00 | Mike Byrd | BI Platform Architecture, Development Administration | Change Tracking: A Near Bullet-Proof ETL Synchronization Control |
| 16:30:00 | Emanuele Zanchettin | Application Database Development | JSON before and after SQL Server 2016 |
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Application Database Development
This session is about the difference of the database tuning advisor and the missing index database management views of the query engine. You will learn the limitations of both approaches in order to avoid applying wrong indexes.
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
To get started with Azure machine learning you don't need to be an expert: Microsoft provides ready made models that can be used immediately (Cognitive Services). For other business problems (e.g. churn) Microsoft provides a template, but we need to tune this template to our business data. And for some analysis problems we need to build machine learning solutions from scratch. In this demo-oriented session you will see demonstrations of these three ways of working with Machine Learning in the Azure cloud.
Event Date: 23-09-2017 - Session time: 09:15:00 - Track: Application Database Development
However, in most cases, solving the real problem with the code, gives you the performance you want. In this presentation I will show you how to spot the performance blockers.
Event Date: 23-09-2017 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration
• Getting up and running • Loading and migrating data • Designing tables and optimizing queries to extract maximum performance
This session will also include some benchmarks and Power BI demos with different DWU and storage options on a very large data set.
Event Date: 23-09-2017 - Session time: 10:45:00 - Track: Cloud Application Development Deployment
Event Date: 23-09-2017 - Session time: 10:45:00 - Track: Application Database Development
The database is very good at doing some things - and exceptionally bad at others. Combine these facts with a general lack of understanding of the database engine and the road to perfomance hell is truly plotted. Join Alexander for a session of examples how developers can and do abuse SQL Server - both intentionally and unintentionally.
Event Date: 23-09-2017 - Session time: 10:45:00 - Track: Analytics and Visualization
Event Date: 23-09-2017 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-09-2017 - Session time: 12:00:00 - Track: Strategy and Architecture
Together we will walk through the architecture patterns, technology requirements, and configuration options that you need to know in order to build a solid Data Platform. Understanding the implementation differences between on-premises and cloud based deployments is important. Especially as there are specific requirements that need to be met for up-time SLAs to be applicable, as well as mitigating for region failures.
All of these elements mean that it is more than just simple wizards to follow in order to have a solid, reliable, and robust SQL Server Data Platform.
Event Date: 23-09-2017 - Session time: 12:00:00 - Track: Application Database Development
You will get a deep understanding of the reasons of fragmentation like
Event Date: 23-09-2017 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment
SQL PAL (SQL Platform Abstraction Layer)
SQLOSv2
The (very small) host extension which is platform specific
Installation with demo,yes that fast!
Backups and Restores cross platform
Clustering on Linux
AlwaysOn Availability Groups cross platform
SQL Agent for Log Shipping
Compiling/Deploying CLR code for both platforms with demo
How the Linux layer is compiled
Debugging a combined Windows PE and Linux ELF execution including getting a stack dump
New DMVs for Linux and DMVs which are replaced as they are not cross platform
Performance goals
Limitations with the current implementation
Event Date: 23-09-2017 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-09-2017 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
Some of the things I’ll cover:
No undocumented stuff, no registry editor, and nothing you wouldn’t put into production. Just really clever productivity tips that will take some of the burden off your everyday work.
But I’m not going to sugarcoat it. Your code may still run slow, and you’ll probably write just as many bugs – but you’ll write them a lot quicker and with so much more style and panache.
Event Date: 23-09-2017 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 14:00:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment
In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, and more. Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again
Event Date: 23-09-2017 - Session time: 15:15:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 15:15: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: 23-09-2017 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration
But, what about the new licensing model recently introduced for Power BI? How it can fits to your needs? Every organization is a complex system with rules and limitations. Users belong to groups each with visibility profile. So you need to know how security in Power BI works: how to configure and restrict access, how to filter data based on the logged user, how to implement static and dynamic Row-level security (RLS), how to control usage of specific features.
Furthermore you deal with a large number of users you can’t leverage by hand. Power BI provides an admin portal that allows you to manage users and groups in the Office 365 admin center. Come to this session to discover what’s behind the scenes in Power BI and how to implement a solution compliant to your security and governance model.
Event Date: 23-09-2017 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment
I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success criteria that had to be met. Checking all of these by hand (eye) would have been error prone, so I wrote a test to do this for me and an easy for management to read HTML report using PowerShell and Pester.
The session has come from that situation and is about enabling you to provide an easy to read output to quickly and repeatedly show that infrastructure is as expected for a set of checks, also known as Operational Validation using Pester. There are many use cases for this type of solution; DR testing, installation, first line checks, presentation setups
After this session you will have a basic understanding of how Pester works and the capability to examine your checklists and create your own validation tests and provide some reporting for manager
Event Date: 23-09-2017 - Session time: 16:30:00 - Track: Application Database Development
Event Date: 23-09-2017 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-09-2017 - Session time: 16:30:00 - Track: Application Database Development