| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Thomas Hütter | Analytics and Visualization | Next first steps - selected applications of R |
| 09:00:00 | Jeroen ter Heerdt | BI Information Delivery | A lap around what is new in Power BI and Power BI Embedded |
| 09:00:00 | Aaron Bertrand | Application Database Development | T-SQL : Bad Habits and Best Practices |
| 09:00:00 | Frans van der Geer | Professional Development | Using object dependencies to develop smart solutions |
| 09:00:00 | Klaus Aschenbrenner | Enterprise Database Administration Deployment | Latches, Spinlocks, and Lock Free Data Structures - Part 1 |
| 09:00:00 | André Melancia | Enterprise Database Administration Deployment | Hacking SQL Server |
| 10:15:00 | Kevin Chant | Strategy and Architecture | Migrating to the cloud options for SQL Server Professionals |
| 10:15:00 | Andrew Pruski | Enterprise Database Administration Deployment | SQL Server Containers |
| 10:15:00 | Edgar Walther | BI Information Delivery | Tabular Next Top Model |
| 10:15:00 | Klaus Aschenbrenner | Enterprise Database Administration Deployment | Latches, Spinlocks, and Lock Free Data Structures - Part 2 |
| 10:15:00 | Jan Mulkens | BI Platform Architecture, Development Administration | Practical SQL Server Machine Learning Services |
| 10:15:00 | Andre Batista | Enterprise Database Administration Deployment | Deep dive into Query Store on SQL Server 2016 |
| 11:30:00 | John Martin | Strategy and Architecture | Always On Multi-Site Patterns |
| 11:30:00 | Bent Pedersen | BI Platform Architecture, Development Administration | Scripting tabular models |
| 11:30:00 | Hugo Kornelis | Application Database Development | Hash Match, the Operator |
| 11:30:00 | Stephanie Locke | Advanced Analysis Techniques | SQL Server and R for real-time predictions |
| 11:30:00 | William Durkin | Enterprise Database Administration Deployment | Query Store without SQL 2016 = Open Query Store |
| 11:30:00 | Erwin De Kreuk | BI Platform Architecture, Development Administration | Migrating your On Premise database to Azure SQL DW |
| 13:30:00 | Uwe Ricken | Cloud Application Development Deployment | Advanced insides into System Versioned Temporal Tables |
| 13:30:00 | Raymond Sondak | BI Platform Architecture, Development Administration | SQL Server 2017: Graph Database Inside-Out |
| 13:30:00 | Enrico van de Laar | Advanced Analysis Techniques | Predicting demonic possession using AzureML |
| 13:30:00 | Robert Hartskeerl | Enterprise Database Administration Deployment | High Availability with SQL Server 2017 on Linux |
| 13:30:00 | Sam Lester | BI Platform Architecture, Development Administration | Deep Dive into the Azure-Powered Power BI Twitter Brand Campaign Solution |
| 13:30:00 | Adam Saxton | BI Platform Architecture, Development Administration | Let's talk Power BI Premium |
| 14:45:00 | Oliver Frost | BI Platform Architecture, Development Administration | Exploring Dark Data with SQL Server 2016 and R [EN] |
| 14:45:00 | Dr. Subramani Paramasivam | Analytics and Visualization | PowerBI On-Premises Vs Cloud |
| 14:45:00 | Sergiy Lunyakin | BI Platform Architecture, Development Administration | Cloud BI with Azure Analysis Services |
| 14:45:00 | Torsten Strauss | Enterprise Database Administration Deployment | Extent and Page Management in SQL Server |
| 14:45:00 | Kalen Delaney | Enterprise Database Administration Deployment | A Look Inside SQL Server Distribution Statistics |
| 14:45:00 | Denis Reznik | Application Database Development | Hidden gems of SQL Server 2016 |
| 14:45:00 | Kasper de Jonge | BI Platform Architecture, Development Administration | Power BI security deep dive |
| 16:00:00 | Jan Van humbeek | BI Platform Architecture, Development Administration | Scaling out with Integration Services in SQL Server 2017 |
| 16:00:00 | Lord Richard Douglas | Enterprise Database Administration Deployment | Understand the Transaction Log, Unlock Greater Throughput |
| 16:00:00 | Christopher Adkin | Application Database Development | Problem Solving With The In-Memory Engine |
| 16:00:00 | Andrea Martorana Tusa | BI Information Delivery | Customizing SQL Server 2016 Mobile Report Publisher |
| 16:00:00 | Nico Jacobs | Application Database Development | PolyBase in SQL Server 2016 |
| 16:00:00 | Rob Sewell | Application Database Development | Introduction to Pester - TDD for PowerShell |
Event Date: 30-09-2017 - Session time: 09:00:00 - Track: Analytics and Visualization
and get your eyes and hands on some R code?
Let's elaborate on two topics you might have seen in my "From SQL to R and beyond" presentation, plus we'll check who obeys Benford's law and who doesn't.
Here are the three subjects that this slightly code-heavy session will cover: • How to create dynamic T-SQL using R functions, for example to query your multi-company database • Visualizations in R based on shapefiles (those geographic polygons) and some choropleth technique • Applying Benford's law, which actually is not about crime and fraud, but may help you to detect them
Event Date: 30-09-2017 - Session time: 09:00:00 - Track: BI Information Delivery
Event Date: 30-09-2017 - Session time: 09:00:00 - Track: Application Database Development
In this session, you will learn about several bad habits, how they develop, and how you can avoid them. While we will briefly discuss advice you’ve probably heard before, like avoid SELECT * and be careful with NOLOCK, you will also learn some subtleties in SQL Server that might surprise you, how some shorthand can bite you in the long run, and a very easy way to improve cursor performance.
By changing your techniques and ditching some of these bad habits for best practices, you will take new techniques back to your environment that will lead to more efficient code, a more productive workflow, or both.
Event Date: 30-09-2017 - Session time: 09:00:00 - Track: Professional Development
Then you could:
But why use your imagination? Just come to see how I did it. I will demo it! This session is a mix of SQL and SSAS DMV's, T-SQL data models, build tools and some Powershell glue. My goal is to inspire you!
Event Date: 30-09-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 30-09-2017 - Session time: 09:00: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, RLS, and more. More important, 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: 30-09-2017 - Session time: 10:15:00 - Track: Strategy and Architecture
After that we’ll dive into in to an overview of the main cloud providers and providing some examples where they might be a good fit for various SQL Server environments; as well as what you might want to take into consideration during for your migration like your HADR strategy and if your SQL Server data would be better suited in another solution that your chosen cloud provider offers.
Event Date: 30-09-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
My session aims to take attendees through what containers are and how they can benefit us. There are drawbacks which will also be covered but I'm hoping after this session, attendees will be able to go back to their respective companies and be able to evaluate container technology to determine whether or not it will be of benefit.
Attendees will be taken through the following: - The definition of containers Virtual Machines vs Containers Container networking fundamentals Configuring Windows Server 2016 to run containers Installing the docker engine Pulling SQL images from the docker repository Running SQL Server containers Creating custom container images A real world implementation of containers
Event Date: 30-09-2017 - Session time: 10:15:00 - Track: BI Information Delivery
Event Date: 30-09-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 30-09-2017 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Enough of that, in this session we'll walk through a real SQL Server Machine Learning Services scenario from idea to code and from deployment to monitoring maintenance. Learn how you can easily roll out your own Data Science projects or support the data scientists and analysts at your company.
Event Date: 30-09-2017 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 30-09-2017 - Session time: 11:30: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: 30-09-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
During this session I will go through and explain some examples and best practices on generating a SSAS tabular model by using the new TOM. I will spend some time showing and explaining a real world example on pushing measure creation and changes to the key business stakeholders and to ensure quick time to market.
The last thing i will show is how you speed up your development free up up to 50% of the time you spend building tabular models with the simple and advanced features of Tabular Editor 2.0
Event Date: 30-09-2017 - Session time: 11:30:00 - Track: Application Database Development
Hash Match is the only operator that can have either one or two inputs. It is the only operator that can either block, stream, or block partially. And it is one of just a few operators that contribute to the total memory grant of an execution plan. If you ever looked at execution plans, you will have seen this operator. And you probably have a rough idea of what it does. But do you know EXACTLY what happens when this operator is used? In this 500-level session, we will dive deep into the bowels of the operator to learn how it performs. It is going to be wild ride, so keep your hands, arms, and legs inside the conference room at all times; and please remain seated until the presenter has come to a full stop.
Event Date: 30-09-2017 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
In this demo-packed talk, you’ll see how you can go from a model built in R to making predictions on the fly in SQL Server 2016.
Event Date: 30-09-2017 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
This session will give a short introduction to the Query Store feature in SQL 2016 and then dive into the Open Query Store (OQS) solution. Enrico and William (the co-creators of the OQS project) will explain the design of OQS and demonstrate the features. You will leave this session with an understanding of the features of Query Store and Open Query Store, and a desire to implement OQS in your systems when you return to the office.
Event Date: 30-09-2017 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
What are the best practices to Migrate your solution with as little impact to users as possible? Why should you migrate to a Azure SQL DW? I did, and would like to share my experience.
I will take you in this session through all the steps you have to take care off. The following points will be discussed Distribution keys, Replicated Tables, identity Colums, CTAS, scaling, pausing, monitoring and much more.
Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Event Date: 30-09-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Graph databases uses graph theory to store information in a collection of nodes and edges. Graph databases are optimized to find answers about the relationships. With graph data processing available in SQL Server 2017 we will get the best of both relational and graph databases in a single product.
In this session the audience will learn about what is graph databases, why graph databases, and how to use the new graph data processing extension of SQL Server 2017.
Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
In this very special session, created specifically for the six-hundredth-and-sixty-six edition of SQLSaturday, we will use the power of Azure Machine Learning to find out if we can predict demonic possession and bring the worlds of data science and exorcisms closer together! We will go through all the steps for building a reliably machine learning model together. From analyzing the data to optimizing the model to increase the prediction accuracy. The end result? A machine learning prediction model that will help identify possible possession victims!
Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 30-09-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
In this talk, we'll explore the Power BI Dashboard, getting started with the setup, and a deep dive into the technical components that power this solution. We'll also cover the pricing model and suggestions for right-sizing the components that I've used to help several customers with this amazing solution.
Solution details can be found here: https://powerbi.microsoft.com/en-us/solution-templates/brand-management-twitter/
Event Date: 30-09-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 30-09-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
In this session, Consolidata’s Oliver Frost shows you how to develop your own application for tapping into ‘dark data’. Ollie will demonstrate how to stream live tweets, perform aggregations in R and pipe the output to a Power BI dashboard, giving you a full end-to-end experience of the importance of learning some basic R code in 2016.
This session is for anyone who is new to R and is interesting expanding their skill set beyond their comfort zone in SQL Server.
Event Date: 30-09-2017 - Session time: 14:45:00 - Track: Analytics and Visualization
PowerBI support to SQL Server 2016 Reporting Services is a major breakthrough for any dashboards without any need to host in the Cloud.
In this session, we will explore and compare the features availale on PowerBI Online Services and PowerBI On-prem SSRS 2016. This session also covers the PowerBI Roadmap for both on-prem and cloud solutions.
Event Date: 30-09-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 30-09-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Additionally we will have a look into partitions and allocation units and the different types of pages like in-row, row-overflow (row overflow pointer) and LOB. Alongside we will analyze the page header, payload applying the FixedVarFormat and the row offset array.
Event Date: 30-09-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Goals: • Explore the output of DBCC SHOW_STATISTICS • Describe when the density information is useful • Look at some problem scenarios for which the statistics can’t give good estimates • Understand why cardinality estimation involves more than just the statistics
Event Date: 30-09-2017 - Session time: 14:45:00 - Track: Application Database Development
In this session, we will learn a lot about these features and improvements. Which features? This is a secret :) Come to the session and discover them with me!
Event Date: 30-09-2017 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 30-09-2017 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
In this session we'll see what kind of impact horizontal scaling has on your ETL's performance and how it performs compared to vertical scaling.
Event Date: 30-09-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
There's no doubt about it, the transaction log is treated like a poor cousin. The poor thing does not receive much love. The transaction log, however, is a very essential and misunderstood part of your database. There will be a team of developers creating an absolutely awesome elegant design the likes of which have never been seen before, but the leave the transaction log using default settings. It's as if it doesn't matter, an afterthought, a relic of the platform architecture. In this session, you will learn to appreciate how the transaction log works and how you can improve the performance of your applications by making the right architectural choices.
Event Date: 30-09-2017 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 30-09-2017 - Session time: 16:00:00 - Track: BI Information Delivery
Developers can create dashboards and KPI and publish them on Reporting Services in a very straightforward way. The downside is that Mobile Report Publisher offers simple features and settings for data visualization and parameterization. Nevertheless there are some poor-documented customizations users can apply to have a more flexible products and to determine objects visibility. Want to add parameters to a mobile report? Want to add drillthrough and navigation from one report to another? Want to design and import a custom map, for your visualizations? Want to implement security and filter visibility based on the user's grants? Want to apply a custom layout to your portal? In this session you'll find the solutions that best fit your needs based on real implementation in a large company.
Event Date: 30-09-2017 - Session time: 16:00:00 - Track: Application Database Development
In this session we first introduce the PolyBase architecture, then show how to setup and query PolyBase. This demo-rich session helps both developers and DBAs in understanding the potential and practical use of PolyBase.
Event Date: 30-09-2017 - Session time: 16:00:00 - Track: Application Database Development
I will take you on a journey from nothing to a complete function, making sure that all of the code works as expected, is written according to PowerShell best practices and has a complete help system.
You will leave this session with a good understanding of what Pester can do and a methodology to develop your own PowerShell functions