SQLSaturday #666 - Holland 2017
Event Date: 09/30/2017 00:00:00
Event Location:
- Marinus Ruppertgebouw, Universiteit Utrecht
- Leuvenlaan 21
- Utrecht, Utrecht, Netherlands
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Exploring Dark Data with SQL Server 2016 and R [EN]
Abstract: With the addition of R into SQL Server 2016, Microsoft have provided a few extra degrees of freedom for the standard SQL developer. You can now use the R language to wrangle, clean and collect external data, using libraries and functionality that simply wasn’t available to you before with regular T-SQL. Performing data enrichment at scale with SQL Server or even Microsoft R Server can provide extremely valuable new insights for your clients and start reaping the benefits of big data.
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.
Speaker(s):
- Oliver Frost
Track and Room: BI Platform Architecture, Development Administration - Room 042
Title: Understand the Transaction Log, Unlock Greater Throughput
Abstract: Does your application suffer from performance problems even though you followed best practices on schema design? Have you looked at your transaction log? 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.
Speaker(s):
- Lord Richard Douglas
Track and Room: Enterprise Database Administration Deployment - Room Blauw
Title: Always On Multi-Site Patterns
Abstract: Building robust and resilient Data Platform solutions can be complex and costly, building out for both High Availability and Disaster Recovery. The Always On technologies incorporated in the Microsoft SQL Server stack help Data Platform Engineers to do just this. Creating solutions that span multiple locations, in an effort to protect the data that we are tasked to manage on a daily basis.
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.
Speaker(s):
- John Martin
Track and Room: Strategy and Architecture - Room A
Title: Migrating to the cloud options for SQL Server Professionals
Abstract: In this session, I’ll provide an overview of your options when looking to migrate your SQL Server environments to the cloud from either on-site or from another cloud provider. We’ll then go through potential cloud infrastructure options such as cloud implementations, compute offerings, and security.
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.
Speaker(s):
- Kevin Chant
Track and Room: Strategy and Architecture - Room Wit
Title: SQL Server 2017: Graph Database Inside-Out
Abstract: Relational databases has been around since decades. It uses a highly structured schema to store information in tabular form and are optimized to find answers about the data. One of the challenges where relational databases struggle with is to find answers on data relationships.
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.
Speaker(s):
- Raymond Sondak
Track and Room: BI Platform Architecture, Development Administration - Room Wit
Title: Scripting tabular models
Abstract: Introducing the new scripting language for tabular models. Before SQL Server 2016 tabular models was wrapped into a multidimensional constructs. TOM is the new native library for tabular - this makes it easy to maintain, modify and deploy your model.
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
Speaker(s):
- Bent Pedersen
Track and Room: BI Platform Architecture, Development Administration - Room Rood
Title: Customizing SQL Server 2016 Mobile Report Publisher
Abstract: In Reporting Services 2016 Microsoft introduced support for mobile reports. They also released the Mobile Report Publisher for authoring and creation of mobile reports. 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.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: BI Information Delivery - Room 042
Title: Advanced insides into System Versioned Temporal Tables
Abstract: SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
This session takes you behind the basics of Temporal Tables and answers - after a short introduction - the following questions:
- How to handle the change of NULL constraints?
- Can Temporal Tables be renamed and what happens to the System Versioned table?
- What will happen if you change meta data (data length, data type, …)?
- What happens if you drop a column or add another column to the Temporal Table?
- what about security for the system versioned table?
- what about calculated columns in the temporal table?
- …
You are interested in the answers to all the above questions (and more). This session will answer EVERY question about Temporal Tables.
Speaker(s):
- Uwe Ricken
Track and Room: Cloud Application Development Deployment - Room Blauw
Title: Next first steps - selected applications of R
Abstract: You enjoyed the walk-through for R newbies, now you want to take the next steps 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
Speaker(s):
- Thomas Hütter
Track and Room: Analytics and Visualization - Room 042
Title: Predicting demonic possession using AzureML
Abstract: Performing exorcisms is a very difficult and time-consuming process. It isn’t always directly clear whether a person is truly possessed by an evil spirit or if we are dealing with a false-positive. What if we can accurately predict if someone is actually possessed before we start the exorcism? This can help us avoid spending valuable resources, like holy water, and avoids possible lawsuits if it turns out an exorcism wasn’t necessary. 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!
Speaker(s):
- Enrico van de Laar
Track and Room: Advanced Analysis Techniques - Room 042
Title: Using object dependencies to develop smart solutions
Abstract: Imagine you could track down all dependencies between database and related objects. For example: From a KPI in a SSAS Tabular model to a Measure to a Calculated Column, …, to Data Source View, To Database objects in a Data Warehouse and via a stored procedure or SSIS package to a Staging database or even to the queries into or exports from your source production systems.
Then you could:
- Automatically document your BI or database solution;
- You could prove your data lineage;
- You could generate a deployment script given the SSRS Report, SQL View or Tabular database your users are waiting for to get into production.
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!
Speaker(s):
- Frans van der Geer
Track and Room: Professional Development - Room A
Title: T-SQL : Bad Habits and Best Practices
Abstract: Whether you are a developer, DBA, or anything in between, chances are you might skip some best practices when you write T-SQL. Unfortunately, many so-called “bad habits” aren’t always obvious, but can lead to poor performance, maintainability issues, and compatibility problems.
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.
Speaker(s):
- Aaron Bertrand
Track and Room: Application Database Development - Room 040
Title: SQL Server Containers
Abstract: There’s a lot of buzz about containers in tech at the moment but not so much in the SQL Server world which I find odd because as SQL Server people this technology has benefits that we simply shouldn’t be ignoring.
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
Speaker(s):
- Andrew Pruski
Track and Room: Enterprise Database Administration Deployment - Room A
Title: Query Store without SQL 2016 = Open Query Store
Abstract: When SQL Server 2016 was released, it offered a fantastic new feature with the Query Store. Long term, statistics based, query tuning became a reality. But what about the thousands of servers that aren’t upgrading to SQL 2016 or newer? The open source project Open Query Store is designed to fulfill that need.
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.
Speaker(s):
- William Durkin
Track and Room: Enterprise Database Administration Deployment - Room 040
Title: Extent and Page Management in SQL Server
Abstract: In this session (level 300-400) you will learn how SQL Server physically stores data in pages and how they are grouped together based on IAM -, PFS, GAM, SGAM pages and extents. 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.
Speaker(s):
- Torsten Strauss
Track and Room: Enterprise Database Administration Deployment - Room A
Title: Hash Match, the Operator
Abstract: SQL Server has a lot of difference execution plan operators. By far the most interesting, and the most versatile, has to be the Hash Match operator. 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.
Speaker(s):
- Hugo Kornelis
Track and Room: Application Database Development - Room Blauw
Title: A lap around what is new in Power BI and Power BI Embedded
Abstract: Power BI and Power BI Embedded evolve weekly and monthly based on user feedback. In this session we will go through the most important changes to these tools. Serves both beginner as well as advanced users over Power BI.
Speaker(s):
- Jeroen ter Heerdt
Track and Room: BI Information Delivery - Room Rood
Title: Latches, Spinlocks, and Lock Free Data Structures - Part 1
Abstract: You know locking and blocking very well in SQL Server? You know how the isolation level influences locking? Perfect! Join me in this session to make a further deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks. We will cover the differences between both, and their use-cases in SQL Server. You will learn about best practices how to analyze and resolve Latch- and Spinlock contentation for your performance critical workload. At the end we will talk about lock free data structures, what they are, and how they are used by the new In-Memory OLTP technology that is part of SQL Server 2014.
Speaker(s):
- Klaus Aschenbrenner
Track and Room: Enterprise Database Administration Deployment - Room Blauw
Title: Deep Dive into the Azure-Powered Power BI Twitter Brand Campaign Solution
Abstract: With the introduction of Microsoft Solution Templates, you can create an amazing Power BI Brand and Campaign Management solution leveraging Twitter data in just minutes. The solution includes several components, including a pre-built impressive Power BI Dashboard, backed by Azure Cognitive Services, Azure Logic Apps, App Service Plan, Azure Functions running C# code, and several other components.
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/
Speaker(s):
- Sam Lester
Track and Room: BI Platform Architecture, Development Administration - Room Rood
Title: Cloud BI with Azure Analysis Services
Abstract: With Azure Analysis Services (Azure AS) we have full set of PAAS and SAAS services like Azure SQL DWH, Azure SQL DB, Azure AS and Power BI for creating our BI solutions in the cloud. In this session I will introduce Azure AS and how we can use it together with other Azure services for creating complete BI solution in the cloud.
Speaker(s):
- Sergiy Lunyakin
Track and Room: BI Platform Architecture, Development Administration - Room Wit
Title: Tabular Next Top Model
Abstract: Creating a proper Tabular Model is essential for the success of your modern BI solution. If you set up the foundations properly, you will benefit when building the relationships, formulas and visualizations. Also your Self-Service BI users will understand and use the data model better. This talk guides you through the process of creating a Tabular Model. The session will be packed with very practical tips and tricks and the steps you should do to create a proper model. The session is based on “real life” projects, and will be backed with some theory. After this hour you will understand how to create a proper model, how to optimize for memory usage and speed, enhance the user experience, use some DAX expressions and to use the right tools for the job. You will go home with a very useful step-by-step-guide.
Speaker(s):
- Edgar Walther
Track and Room: BI Information Delivery - Room Rood
Title: Scaling out with Integration Services in SQL Server 2017
Abstract: With the release of SQL Server 2017, Integration Services received some love with the addition of its very own Scale Out feature. 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.
Speaker(s):
- Jan Van humbeek
Track and Room: BI Platform Architecture, Development Administration - Room Wit
Title: SQL Server and R for real-time predictions
Abstract: Embedding your R (and soon Python!) models in SQL Server enables you to add predictive capabilities to your applications and your analytics without adding expensive components or going outside your network via expensive API calls.
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.
Speaker(s):
- Stephanie Locke
Track and Room: Advanced Analysis Techniques - Room 042
Title: Latches, Spinlocks, and Lock Free Data Structures - Part 2
Abstract: You know locking and blocking very well in SQL Server? You know how the isolation level influences locking? Perfect! Join me in this session to make a further deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks. We will cover the differences between both, and their use-cases in SQL Server. You will learn about best practices how to analyze and resolve Latch- and Spinlock contentation for your performance critical workload. At the end we will talk about lock free data structures, what they are, and how they are used by the new In-Memory OLTP technology that is part of SQL Server 2014.
Speaker(s):
- Klaus Aschenbrenner
Track and Room: Enterprise Database Administration Deployment - Room Blauw
Title: Deep dive into Query Store on SQL Server 2016
Abstract: Query Store is a new feature that got released on SQL Server 2016 version and is being improved over the last cumulative updates and on SQL Server 2017 vNext CTP’s versions. It’s a very useful and interesting feature that allow DBA’s ( and non-DBA’s :) ) to easily identify performance issues on queries and also allow us to fix it in a fast and simple way. Just the ability to compare a previous execution plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. I want with this session to give you the insight and knowledge to get started using this new and wonderful feature that will change the way how you do performance tuning.
Speaker(s):
- Andre Batista
Track and Room: Enterprise Database Administration Deployment - Room 040
Title: Hacking SQL Server
Abstract: How easy is it to hack a SQL Server? 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.
Speaker(s):
- André Melancia
Track and Room: Enterprise Database Administration Deployment - Room Wit
Title: Problem Solving With The In-Memory Engine
Abstract: There is a vast array of material in the SQL Server community that covers the in-memory engine in great detail, this session will cover some of the internals of the in-memory engine, however what it will also do is fill in the void as to common performance issues and how they can be solved with the in-memory engine, specifically:
- Staging data as fast as possible
- Turbo charging scalar aggregate functions
- Implementing a scalable sequence
- Overcoming the performance limitations of temporary tables
- Making the critical path in your code base run faster
Speaker(s):
- Christopher Adkin
Track and Room: Application Database Development - Room A
Title: SQL Server Statistical Semantic Search
Abstract: SQL Server 2012 introduced an important extension to its integrated Full-text Search, namely the Statistical Semantic Search. In this session you will learn how to install and configure this new functionality, how to use it to extend your existing full-text search capabilities, and how to utilize it properly to improve your information management solutions. You will learn how to automatically extract key phrases from your documents, and how to find similarities between individual documents of your information corpus based on the key phrases that they contain.
Speaker(s):
- Matija Lah
Track and Room: Application Database Development - Room 040
Title: PowerBI On-Premises Vs Cloud
Abstract: Microsoft initially released PowerBI online services which had restriction of developing dashboards and reports online only. Then came the PowerBI desktop for easy onsite development including the complex DAX logics.
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.
Speaker(s):
- Dr. Subramani Paramasivam
Track and Room: Analytics and Visualization - Room Rood
Title: High Availability with SQL Server 2017 on Linux
Abstract: Most database administrators know how to manage and deploy high availability solutions using SQL Server. Most also know parts of Windows clustering. But with SQL Server 2017 there is a old new kid on the block and it is called Linux. The SQL part might be the same, the operating system is certainly not. In this session we will take a look at high availability solutions on Linux and how they fit into SQL Server. How do you manage and deploy availability groups across your organization leveraging Linux. But also, what is new with SQL Server 2017 on Linux as well as Windows.
Speaker(s):
- Robert Hartskeerl
Track and Room: Enterprise Database Administration Deployment - Room A
Title: Introduction to Pester - TDD for PowerShell
Abstract: Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures.
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
Speaker(s):
- Rob Sewell
Track and Room: Application Database Development - Room Rood
Title: Let’s talk Power BI Premium
Abstract: A lot of changes have come to Power BI. Do you understand how Premium fits in? What is an app workspace and why would you use it? And, what the heck is a capacity? We will take a look at Premium, Apps and App Workspaces along with the changes to embedding. We will also see how Power BI Report Server fits into the picture.
Speaker(s):
- Adam Saxton
Track and Room: BI Platform Architecture, Development Administration - Room Rood
Title: Hidden gems of SQL Server 2016
Abstract: SQL Server 2016 is full of new features and improvements. Some of them are “Killer” features like Query Store, Temporal Tables, R Integration, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2016 have several fantastic features and improvements, which are more hidden from our sight.
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!
Speaker(s):
- Denis Reznik
Track and Room: Application Database Development - Room 040
Title: Practical SQL Server Machine Learning Services
Abstract: Admit to yourself that you’ve seen enough basic “R is coming to SQL Server” sessions with the same old examples! 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.
Speaker(s):
- Jan Mulkens
Track and Room: BI Platform Architecture, Development Administration - Room 042
Title: A Look Inside SQL Server Distribution Statistics
Abstract: Where do the estimated rowcount values come from? Look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll also discuss changes in the cardinality estimator in recent versions and look at some new metadata that gives us more statistics information.
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
Speaker(s):
- Kalen Delaney
Track and Room: Enterprise Database Administration Deployment - Room Blauw
Title: Migrating your On Premise database to Azure SQL DW
Abstract: Have you ever tried to migrate your On Premise DataWareHouse solution to a Azure SQL DataWareHouse? Azure SQL DW is a MPP system and requires a lot of changes to your current solution. 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.
Speaker(s):
- Erwin De Kreuk
Track and Room: BI Platform Architecture, Development Administration - Room Wit
Title: PolyBase in SQL Server 2016
Abstract: If you want to mix traditional relational data with semi-structured data stored on Azure or Hadoop, then the out-of-the-box PolyBase functionality in SQL Server 2016 is one of the easiest ways to get started with this. 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.
Speaker(s):
- Nico Jacobs
Track and Room: Application Database Development - Room 040
Title: Power BI security deep dive
Abstract: One hot topic with Power BI is security, in this deep dive session we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored and we even look at how to leverage additional Azure services to secure it even more.
Speaker(s):
- Kasper de Jonge
Track and Room: BI Platform Architecture, Development Administration - Room Rood
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Sam Lester
Contact: http://blogs.msdn.com/b/samlester
Sam Lester has spent the past 14 years working for Microsoft in various SQL Server related roles. After nearly 12 years working in the SQL Server development team in Redmond, WA, he has recently made the switch to a consulting role to work hands-on with European customers. While in the product group, Sam worked on numerous features including setup, migration, SSMS/manageability, Utility Control Point, Data-Tier Application Component, SSDT, Intellisense, amp; TSQL Debugger.
Uwe Ricken
Twitter: - https://twitter.com/dbBerater
LinkedIn: Uwe Ricken
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
Denis Reznik
Twitter: - https://twitter.com/DenisReznik
LinkedIn: Denis Reznik
Contact: http://reznik.uneta.com.ua
Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.
Kalen Delaney
Twitter: - sqlqueen
Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.
John Martin
Twitter: - SQLDiplomat
LinkedIn: John Martin
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
Andre Batista
Twitter: - @klunkySQL
LinkedIn: Andre Batista
Contact: http://klunkysql.info/
Andre Batista, with academic path in the course of Electronics, Telecommunications and Computers ( ISEL - Lisbon ) is currently in Crossjoin Solutions working as SQL Server DBA, performing functions on the client PT (Portugal Telecom). He is interested in all areas related to SQL Server and particularly in architecture, implementation, maintenance and performance. He is a member of the Portuguese SQL Server User Group, SQLPort (http://www.sqlport.com) and also one of the founders of TUGA.
Rob Sewell
Twitter: - sqldbawithbeard
LinkedIn: Rob Sewell
Contact: http://sqldbawithabeard.com
Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.
Raymond Sondak
Twitter: - raymondsondak
LinkedIn: Raymond Sondak
Raymond Sondak is a technical data architect, analytics consultant, and owner of Analyticsaholic. He is also the 1st BimlHero Certified Expert in the Netherlands. Raymond is an expert in agile end-to-end Business Intelligence and Analytics implementation as well as automation focused on Microsoft and Open Source technologies. His technical expertise extends from Microsoft Data Platform and Hadoop to building cloud solutions with Microsoft Azure and AWS. He also delivers training and workshops on various subjects including Biml and very passionate to share his knowledge. Raymond loves to enjoy life, when he is not behind his laptop you’ll find him on adventure trips around the world with his wife and they’re both foodies at heart.
Thomas Hütter
Twitter: - DerFredo
LinkedIn: Thomas Hütter
Contact: https://sqlfredo.wordpress.com/
Thomas holds a degree in Business Administration, but has been a data explorer and a developer at heart ever since the days of dBase and Turbo Pascal. He touched his first SQL Server at V6.5 and used covering indexes before they became a feature.
Thomas has been developing in Navision/Dynamics/Business Central systems for quite some time (since 2001, one year before MS acquired Navision), joined PASS in 2006 and got his hands on R in 2014 (the year before MS bought Revolution Analytics). He has worked for ISVs as well as end-user companies, as a developer, consultant, accidental DBA and is an author for data-related articles as well as a speaker at SQL events across Europe.
Andrea Martorana Tusa
Twitter: - bruco441
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category
Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups.
Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).
Oliver Frost
Twitter: - @OFrost
LinkedIn: Oliver Frost
I currently work predominantly as a Data Engineer for Consolidata Ltd with side roles in Engagement, Marketing and Sales. My background is in Neuroscience and so I would like to cover cross-over topics in the future (machine learning, deep learning and developing algorithms).
My tool set includes: SQL Server, R, Microsoft R Server and Azure. I have a good knowledge of other NoSQL technologies including Hadoop, Spark and Neo4j.
I also have an unconventiona background - I am also a current world record holder for solving the 4x4x4 blindfolded Rubik’sCube blindfolded!
n/a n/a
Dr. Subramani Paramasivam
Twitter: - https://twitter.com/dageop
LinkedIn: Dr. Subramani Paramasivam
Contact: http://www.yoursqlman.com/index.php/blogs
Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.
Enrico van de Laar
Twitter: - twitter.com/evdlaar
LinkedIn: Enrico van de Laar
Contact: https://www.enricovandelaar.com
Enrico has been working with data in all kinds of formats and sizes for over 15 years. He is a Data Advanced Analytics Consultant for Dataheroes where he helps organisations take their first steps in the world of Advanced Analytics. Enrico is a Data Platform MVP since 2014 and a frequent speaker on various data related events all over the world. He authored the book “Pro SQL Server Wait Statistics” and blogs about technologies like Microsoft SQL Server and Azure Machine Learning on his blog at www.enricovandelaar.com
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.
19+ years’ fun developing information and multimedia systems, DBA, project and IT management.
Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.
Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.
Go to http://Andy.PT and you’ll know the same as the NSA…
Bent Pedersen
Twitter: - https://twitter.com/SQLBent
LinkedIn: Bent Pedersen
Contact: http://www.biblog.eu
Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.
Kasper de Jonge
Kasper de Jonge is a Program Manager on the SQL Server Analysis Services team, based out of Redmond, WA. With more than 5 years of experience as a developer and consultant on data warehousing solutions using all products from the Microsoft BI stack, Kasper has worked on everything from corporate intranets using SharePoint and Analysis Services to near real-time reporting in the cloud. He has presented at many technical conferences, including PASS Summit and SQLSaturday. You can read Kasper’s blog at http://www.powerpivotblog.nl.
Henk van der Valk
LinkedIn: Henk van der Valk
Contact: http://www.henkvandervalk.com
Since 2000 Henk has specialized in optimizing large-scale Microsoft application and database solutions.
He’s been authoring and contributing numerous whitepapers around SQL Server performance tuning and also produced the famous ETL Data loading World Record with SSIS.
About a year ago, Henk left Microsoft and co-founded a new company: SQLMasters BV and dedicates his time since in developing cool SQL Estate data management solutions and full stack performance tuning.
During his presentations he usually dives into the real-world performance challenges @customer sites and shares tips that will make you job easier!
Matija Lah
Twitter: - @MatijaLah
LinkedIn: Matija Lah
Contact: http://milambda.blogspot.com
Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.
Aaron Bertrand
Twitter: - @AaronBertrand
Contact: https://blogs.sentryone.com/author/AaronBertrand
Aaron, Product Manager at SentryOne, produces performance and optimization tools for the entire Microsoft data platform, as well as Plan Explorer, a free tool for SQL Server execution plan analysis. In his spare time, he is either playing volleyball, curling, blogging at sqlperformance.com and blogs.sentryone.com, or contributing to SQL Server conversations on Twitter and dba.stackexchange.com. He has worked with SQL Server since 6.5 and has been an MVP since 1997.
Stephanie Locke
Twitter: - @stefflocke
LinkedIn: Stephanie Locke
Contact: https://itsalocke.com
Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.
Erwin De Kreuk
Twitter: - ErwindeKreuk
LinkedIn: Erwin De Kreuk
Contact: https://erwindekreuk.com
Erwin de Kreuk is a passionate and very experienced Microsoft Solution Architect. Working as a Principal Consultant/ Lead Data and AI for InSpark, #1 Microsoft Partner of the Year in the Netherlands. Speaking at different national and international data community events. He is working in the world of data on the Microsoft Platform for last 12 years and the last 4 years he has shifted his focus to the Azure Platform. Answering complex customer cases and technical issues are part of his day-to-day work. In addition to this work, he is a member of the Technology Board within InSpark and leads a team of highly experienced Data Expert in the field of Microsoft Data Platform.
Peter Jonk
Twitter: - https://twitter.com/dba60k/
LinkedIn: Peter Jonk
Contact: http://dba60k.net
Peter Jonk is a Premier Field Engineer for Microsoft Services and supports customers to get the most out of SQL Server. Areas of expertise include high availability, SQL migrations and performance tuning.
Sergiy Lunyakin
Twitter: - slunyakin
LinkedIn: Sergiy Lunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
Frans van der Geer
LinkedIn: Frans van der Geer
Frans is consultant Microsoft Data Platform for VX Company with 20 years of experience. He has a background as software developer, with a focus on backend systems. He was the first Microsoft Certified Master on SQL Server in the Netherlands. He helps customers implement the Microsoft Data Platform with a focus on Business Intelligence workloads. He builds his own tools for monitoring and data warehouse generation and deployment.
Adam Saxton
Twitter: - @GuyInACube
LinkedIn: Adam Saxton
Contact: https://guyinacube.com
Adam Saxton is just a guy in a cube doing the work! He is on the Power BI CAT team at Microsoft, working with customers to help adopt Power BI. He is based in Texas and started with Microsoft supporting SQL Server connectivity and Reporting Services in 2005. Adam has worked with Power BI since the beginning, on the support side, and with documentation. In addition, he produces weekly videos for his Guy in a Cube YouTube channel.
Kevin Chant
Twitter: - kevchant
LinkedIn: Kevin Chant
Contact: https://www.KevinRChant.com/
Senior Database Architect originally from the UK and now living in the Netherlands.
Over 23 years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.
In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications. In addition, was probably the last ever person in the world to gain the MCSD Azure Architect certification and has gained the latest Microsoft DevOps Engineer Expert certification.
Has real life experience with SQL Server and Azure Devops. Currently SQL Server Product Owner of around 1,900 instances.
In addition, done various things over the years for the Data Platform Community.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
Lord Richard Douglas
Twitter: - SQLRich
LinkedIn: Lord Richard Douglas
Contact: http://SQL.RichardDouglas.co.uk
Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.
Jan Van humbeek
Twitter: - janvanhumbeek
LinkedIn: Jan Van humbeek
Jan Van humbeek is a Microsoft BI consultant working for Micropole Belgium. Over the years, he’s gathered experience with all the core BI components the SQL Server stack has to offer. This led him to becoming fully MCSE certified on the SQL Server stack and more recently he achieved an MCSA certification in Office 365. When the working day is done, he loves learning about all the latest and greatest features Microsoft has to offer.
Hugo Kornelis
Twitter: - Hugo_Kornelis
LinkedIn: Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of “the Execution Plan Reference” (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey’s “SQL Server Execution Plans, 3rd edition” and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present).
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
Andrew Pruski
Twitter: - https://twitter.com/DBAFromTheCold
LinkedIn: Andrew Pruski
Contact: https://dbafromthecold.com/
SQL Server DBA with over 10 year’s experience. Originally from Wales but now living in Ireland
Jan Mulkens
Twitter: - https://twitter.com/JanMulkens
LinkedIn: Jan Mulkens
Contact: http://www.janmulkens.be
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
Torsten Strauss
Torsten Strauß (MVP, MCSE Data Platform, MCSE Data Management and Analytics, MCT) has been working with Microsoft SQL Server since the turn of the millennium. He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as Principal Consultant for Sarpedon Quality Lab. Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups in recent years.
Klaus Aschenbrenner
Twitter: - @Aschenbrenner
Contact: http://www.SQLpassion.at/blog
Klaus Aschenbrenner provides independent SQL Server consulting services across the United States and Europe, focusing on the .NET Framework and SQL Server 2005 and 2008. In 2004 and 2005, he received the Microsoft MVP award for his support of the .NET community. Klaus has also written a book, “Pro SQL Server 2008 Service Broker,” published by Apress (2008).
Peter ter Braake
Twitter: - @pbraake
LinkedIn: Peter ter Braake
Peter ter Braake, SQL Server MVP, co-founder of the Dutch PASS Chapter and organizer of the Dutch SQLSaturday, teaches SQL Server since 2002. Teaching is for Peter the perfect opportunity to share his SQL Server knowledge and his enthusiasm for the product. Since 2008 he works as an independent contractor giving him the opportunity to use his classroom experience in the real world and use his real world experience in the classroom.
Robert Hartskeerl
Twitter: - @rhartskeerl
Contact: http://robert.hartskeerl.nl
With over 10 years of experience with SQL Server my knowledge goes a long way. But there is always room for more. That’s the reason why I love to help people face and solve their everyday or incidental challenges. This helps me to get more out of SQL Server. My main role is as a DBA but I love to hang around in Visual Studio and not afraid to take you up on a discussion about ADO.NET or the Entity Framework.
Alex Yates
Twitter: - @alexyates
LinkedIn: Alex Yates
Contact: http://www.workingwithdevs.com
Alex Yates has been helping organisations to apply DevOps principles to relational database development and deployment since 2010. He’s most proud of helping Skyscanner develop the ability to deploy 95 times a day. Originally for Redgate, later for DLM Consultants, Alex has worked with clients on every continent except Antarctica – so he’s keen to meet anyone who researches penguins.
A keen community member, he co-organises SQL Relay, is the founder of www.SpeakingMentors.com and has been recognised as a Microsoft Data Platform MVP since 2017.
Nico Jacobs
Twitter: - sqlwaldorf
LinkedIn: Nico Jacobs
Contact: http://blogs.u2u.be/u2u/author/Nico-Jacobs.aspx
Dr. Nico Jacobs is a Microsoft Business Intelligence and SQL Server trainer at the U2U training center since 2004. Before that, he was a machine learning researcher at the university of Leuven, Belgium. At U2U, Nico creates and delivers courses on the SQL Server business intelligence stack (Integration Services, Analysis Services, Reporting Services …), Power BI, the traditional relational database environment (database development and administration) and the Azure AI and Big Data stack (Azure Data Factory, Machine Learning, Synapse Analytics,…)
Christopher Adkin
Twitter: - ChrisAdkin8
LinkedIn: Christopher Adkin
Contact: http://www.chrisadkin.io
Chris is a freelance SQL consultant who has been working with SQL Server since 2000, his passion is for squeezing every last drop of performance out of SQL Server and understanding the database engine at a level which conventional tools cannot provide any insights on.
Adam Saxton
Twitter: - @GuyInACube
LinkedIn: Adam Saxton
Contact: https://guyinacube.com
Adam Saxton is just a guy in a cube doing the work! He is on the Power BI CAT team at Microsoft, working with customers to help adopt Power BI. He is based in Texas and started with Microsoft supporting SQL Server connectivity and Reporting Services in 2005. Adam has worked with Power BI since the beginning, on the support side, and with documentation. In addition, he produces weekly videos for his Guy in a Cube YouTube channel.
William Durkin
Twitter: - @sql_williamd
LinkedIn: William Durkin
Contact: http://williamdurkin.com
William Durkin is a DBA, Data Platform MVP, and Data Platform Architect for Data Masterminds (http://datamasterminds.io). He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, William has worked as a Database Developer and DBA on projects ranging from single server installations, up to environments spanning 5 continents, using a range of high availability solutions. William is a regular speaker at conferences around the globe, organizes the popular event SQLGrillen (http://sqlgrillen.com).
Jeroen ter Heerdt
Twitter: - https://twitter.com/jeroenterheerdt
LinkedIn: Jeroen ter Heerdt
Contact: http://www.dutchdatadude.com
Dutch Data Dude. Program Manager for Azure SQL Database at Microsoft. He is passionate about “all things data”; whether it is about databases, data warehousing, BI, big data, data visualizations, self-service BI, Hadoop, real-time BI or anything even remotely related to data or insight. He strives to apply these concepts in his life as much as possible. Jeroen combines enthusiasm, vision and hands-on experience into fresh, entertaining and thought-provoking talks. His blog is http://www.dutchdatadude.com can be found on twitter at @jeroenterheerdt.
Edgar Walther
Twitter: - @edgarwalther
LinkedIn: Edgar Walther
Contact: http://www.itsmart.eu/Blog/tabid/180/Default.aspx
Edgar Walther has been an independent BI consultant for over 12 years and specializes in the Microsoft Data Platform. He runs a BI consulting firm, ITsmart, based in the Netherlands, and he is one of the founders of the Dutch Power BI User Group. With a background of both Business Economics and IT development the area of Business Intelligence is where he can bridge the gap between Business and IT. He is very eager to stay up to date with the latest developments in Microsoft BI products, and he likes to share them with other BI enthusiasts. He has been a speaker at several SQL Server and Power BI events.
Sponsors
The following is a list of sponsors that helped fund the event: