SQLSaturday #765 - Denmark 2018

Event Date: 10/06/2018 00:00:00

Event Location:

Microsoft Danmark
Kanalvej 7
Kongens Lyngby, Capital Region, Denmark

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Abstract: Docker has taken the world of IT by storm and looks to be ushering in the greatest platform paradigm shift since virtualisation and the public cloud. The transient nature of Docker containers makes them the perfect fit for spinning up and then tearing down SQL Server instances as part of continuous integration pipelines. Jenkins is the most popular build automation engine in the open source community, it has phenomenal plugin support, it is used by the likes of Netflix and eBay and excels in its ability to handle build pipelines as code. In this session you will learn how a simple build pipeline that takes a SQL Server data tools project checked out from source code control, built into a DACPAC which is then deployed to a SQL Server instance can be extended to use containers, multi-branch build pipelines, tSQt testing and much much more.

Speaker(s):

Christopher Adkin

Track and Room: Application Database Development - CUST 1.06M

Title: The language of graph databases and SQL Server

Abstract: SQL Server 2017 introduced the extension for graph databases. As there are millions of SQL Server users worldwide, this feature broadens enormously the audience of potential users. But, what to expect exactly from a graph database? How to query it? Is SQL Server fully featured compared to other products? In this session we answer these questions. We start illustrating the concepts behind the model; how relationships are handled and what are the common patterns and issues for a graph. What are the data connections a graph can easily represent. Then we compare the semantic model with SQL Server to discover how to apply it to real world. We analyze some case study: pattern matching, path finding, aggregation, ranking … For each of them we show how to use standard T-SQL and how to rewrite the query using graph objects. What is the benefit of reformulate our queries in terms of clearness and performances, what is already available in order to consider SQL Server a valuable player.

Speaker(s):

Andrea Martorana Tusa

Track and Room: Application Database Development - CUST 1.11M

Title: Start testing your SSIS packages with ssisUnit

Abstract: How do you test your SSIS packages? Do you prepare them, set the parameters and variables, maybe get some sample or production data and run few times by hand in SSDT? It’s not a bad practice when you start your ETL journey, but after some time you probably think about automation. If not – you should. Perhaps you have some SQL scripts that verify data in the tables after package execution, but if you are like me, somewhere inside you feel that it’s not enough. It’s time you start automated SSIS unit and integration testing.

On this session, I will show you why you should and 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.

Speaker(s):

Bartosz Ratajczyk

Track and Room: Application Database Development - CUST 1.02M

Title: Dealing with CosmosDB

Abstract: CosmosDB service is a NoSQL is a globally distributed, multi-model database database service designed for scalable and high performance modern applications. CosmosDB is delivered as a fully managed service with an enterprise grade SLA. It supports querying of documents using a familiar SQL over hierarchical JSON documents. Azure Cosmos DB is a superset of the DocumentDB service. It allows you to store and query noSQL data, regardless of schema. In this presentation, you will learn: • How to get started with DocumentDB you provision a new database account. • How to index documents • How to create applications using CosmosDb (using REST API or programming libraries for several popular language) • Best practices designing applications with CosmosDB • Best practices creating queries.

Speaker(s):

Mihail Mateev

Track and Room: Cloud Application Development Deployment - CUST 1.11M

Title: Boosting SSAS productivity with Tabular Editor

Abstract: Authoring SSAS tabular models using the standard tools (SSDT) can be a pain when working with large models. Tabular Editor is an open-source alternative, that relies only on the Model.bim metadata and the Tabular Object Model (TOM). Compared to SSDT, making changes to measures, calculated columns, display folders, etc. is lightning fast, and the UI provides a “what-you-see-is-what-you-get” experience, making it much easier to manage and author large models. In this session, we will briefly go over the basic features, and then dive into the productivity enhancing features of Tabular Editor, such as scripting, custom actions, the Best Practice Analyzer, command-line build and deployment, and much more. You will never want to use Visual Studio for Tabular Modelling ever again! Attendees will also have the opportunity to ask questions or provide feedback about the tool.

Speaker(s):

Daniel Otykier

Track and Room: BI Platform Architecture, Development Administration - CUST 1.06M

Title: SQL Server Containers in Azure

Abstract: Running SQL Server in Docker containers brings benefits that data professionals shouldn’t be ignoring. Over the last year the images provided by Microsoft have matured to a point where running SQL Server containers in production is a viable option.

However, running standalone Docker containers presents challenges so other technologies are need to support them. This session will provide an introduction to the various options for running SQL Server containers in Azure.

I’ll cover the following different topics:- The Azure Container Registry Azure Container Instances Azure Container Services

This session is aimed at SQL Server DBAs and Developers who have some experience with Docker and want to know the different options that are available in Azure.

Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies

Speaker(s):

Andrew Pruski

Track and Room: Cloud Application Development Deployment - CUST 1.11M

Title: Collecting Performance Metrics

Abstract: Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? What information would you use to answer these questions? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will be combining three open source tools - Telegraf, InfluxDB, and Grafana - into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we’ll put it all together in an interactive dashboard for easy visualization.

Speaker(s):

Tracy Boggiano

Track and Room: Enterprise Database Administration Deployment - CUST 1.01M

Title: Graph Data in SQL 2017

Abstract: When I read that Microsoft have added graph data to SQL Server 2017 I was intrigued as to what graph data is so I started doing some research. This presentation is the culmination of my investigations. If you design complex OLTP relational databases or have data that doesn’t fit the rigid hierarchy of a relational database then this talk is for you. You may be in for a surprise!

Some of the questions we will look at: What is Graph Data? Who uses it? What is it used for? How does it compare to traditional relational database design? What other companies support graph databases? How does it work in SQL 2017? Is there a new language to learn? What is the so-called Kevin Bacon problem?

And finally. Will it replace traditional relational database design within the next 10 years?

Speaker(s):

David Postlethwaite

Track and Room: Application Database Development - CUST 1.11M

Title: Shard Attack - Horizontal Scaling in Azure SQL Database

Abstract: Traditionally, when a server starts to reach its limit we have simply thrown more resources at it, either more CPU, memory or disk. However there comes a point, especially in the cloud, where it is no longer possible to add more resources to a single database. Here we need a different solution. Instead of scaling up we must scale out, sometimes called horizontal scaling or sharding.

In this talk we will look at how to scale out in Microsoft Azure SQL database using the Azure Elastic Database tools We will look at the requirements and options for horizontal scaling in Azure and then we will have a go at sharding an Azure SQL database and then querying and updating the different shards We will be using t-sql, PowerShell and c# so come prepared for some serious coding

Speaker(s):

David Postlethwaite

Track and Room: Application Database Development - CUST 0.01M

Title: Now Where Did THAT Estimate Come From?

Abstract: The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there’s nothing you can do about it. Or is there?

In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.

Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.

Speaker(s):

Hugo Kornelis

Track and Room: Application Database Development - CUST 0.01M

Title: Data Ingestion Tricks w/ M

Abstract: In this session I will be demonstrating how easy Power BI lets you ingest almost anything; Like complex multi-file scenarios and tricks to get your data mashed up. While at entry level we would be spending most time in the GUI we will be spending most of the time in this session in the Advanced Editor. In detail we will be looking at these topics: Variable number of columns in multiple files for same source Multiple File Formats (think historical changes in format) Binding Multiple Imports into a single table Error handling Dynamic File Format Handling General Tips ’n Tricks for M

Attending this session, you’ll learn the basics of Power BI Desktop, get to see M code in action, as well as learn some neat tricks to get your daily chores done more efficiently. Additionally, I will demonstrate how to deploy your home-grown model into Azure Analysis Services

Speaker(s):

Jens Vestergaard

Track and Room: Analytics and Visualization - CUST 1.11M

Title: Continuous Delivery for BI projects

Abstract: If you are releasing new reports, SSAS cubes or SSIS packages on a regular basis, you’ve probably offered up your share of blood, toil, tears and sweat on getting them delivered into production in working condition. Continuous Delivery is a way to bridge the gap between developers and IT professionals and for that we need to address the both the toolchain to support the practices as well as the mindset on the team. Microsoft offers a set of tools that’ll help you on your journey towards the end goal: Maximize predictability, efficiency, security and maintainability of operational processes.

We will in detail be looking at:

Agile Development Frame of Mind The Path Ahead (direction) Visual Studio Online (tool) Feature/User Story/Work Item (concept) Team Services Code Branching (concept) Build Agents (tool) Releases (tool)

Speaker(s):

Jens Vestergaard

Track and Room: BI Platform Architecture, Development Administration - CUST 1.01M

Title: Big Data with Azure: where to begin? Concepts and best practices

Abstract: In order to ascertain the abilities of cloud computing platform, let us overview what is available offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.

Speaker(s):

Satya Jayanty

Track and Room: Analytics and Visualization - CUST 1.02M

Title: Azure Cognitive Services - AI for everyone

Abstract: Microsoft Cognitive Services (formerly Project Oxford) are a set of APIs, SDKs, and services that developers can use to make their applications smarter, more engaging, and more discoverable. Cognitive Services extend Microsoft’s KI platform.

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.

Speaker(s):

Alexander Klein

Track and Room: Cloud Application Development Deployment - CUST 1.02M

Title: Automation and best practices for ADFv2

Abstract: A lot of new functionality and features have been introduced with Azure Data Factory. Using regular SSIS packages you have great flexibility using BIML.

As part of this session we will be looking into the automation functionality for ADFv2 and how you get started with data extraction and best practices using PowerShell for automation.

Speaker(s):

Bent Pedersen

Track and Room: BI Platform Architecture, Development Administration - CUST 1.11M

Title: Choose your own Database Adventure

Abstract: Based on real life scenarios, in this audience interactive session we will go through some scenarios you might encounter whilst dealing with SQL Server databases and you will be provided with some options about what to do. Members of the audience will then select from these options what to do and we will follow that path and see what the outcome is from there.

Each selection will have a different outcome, and along the way you will probably learn some new things.

Speaker(s):

Kevin Chant

Track and Room: Enterprise Database Administration Deployment - CUST 1.02M

Title: End-to-end Business Intelligence solution in Azure

Abstract: How do you setup and build a complete Microsoft BI solution with only Azure Services? Lessons learned from a project with eleven different source systems in the one end and 12.000 users in seven countries in the other end.

Extracting, transforming and loading with the help from Functions, Data Factory, Data Lake Store, Polybase, SQL Data Warehouse, SQL Database, Automation Runbooks, Analysis Services and Power BI Embedded.

A look into the overall architecture and the different components and how they work together.

Speaker(s):

Just Blindbaek

Track and Room: BI Platform Architecture, Development Administration - CUST 1.06M

Title: Database corruption

Abstract: In this session, you will learn how to detect and avoid common problems related to database corruption. There will be a description of the data structures in SQL Server and how it can affect the availability of SQL Server during corruption. On the session, there will be not only theoretical knowledge but many real life examples with demos.

Speaker(s):

Michal Sadowski

Track and Room: Enterprise Database Administration Deployment - CUST 1.01M

Title: SQL Server Memory Internals Troubleshooting

Abstract: Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. Join Microsoft Certified Master of SQL Server, Amit Bansal, and find your way out from the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. This session will be an eye-opener for you. Assured.

Speaker(s):

Amit R S Bansal

Track and Room: Application Database Development - CUST 0.01M

Title: Build your next BI solution in azure

Abstract: Azure offers a variety of services that can be combined to form a BI solution in the cloud. What options does Azure currently offer to create a modern BI architecture? The components currently available range from Azure SQL DB and SQL DWH to Data Factory, Stream Analytics, Logic App, Analysis Services and Power BI to name a few. This is a very good toolbox, with which you can achieve your first successes very quickly. Step by step you will learn how to create the classic ETL in the cloud and analyze the results in Power BI.

Speaker(s):

Alexander Klein

Track and Room: BI Platform Architecture, Development Administration - CUST 1.02M

Title: Dataflows for Power BI

Abstract: Get and overview of Dataflows and how it integrates data lake and ETL technology directly into Power BI to enable anyone with Power Query skills.

Before diving into details we will go through the architecture and demonstrate the bigger picture for Dataflows in Power BI.

We will go through how you can create, customize and manage data within the Power BI experience in a simpler way. Part of this will also be to go through Common Data Models which contains the business entities across your organisation.

This will help your organisation simplifying modeling and is intended to prevent multiple definition for the same data.

Speaker(s):

Bent Pedersen

Track and Room: Analytics and Visualization - CUST 1.01M

Title: Device provisioning with Azure IoT in a Nutshell

Abstract: Scaling from a few connected devices while developing a proof of concept to thousands or millions of devices deployed in the field is not trivial. In the IoT device life cycle, provisioning is key for scaling securely. This talk is about main concepts and implementation when we need to provision IoT devices for modern Azure IoT Solutions. During this session, you’ll get a sneak peek into how Azure IoT enables seamless, zero-touch registration of devices to IoT Hub with security that begins at the device and ends with our cloud.

Speaker(s):

Mihail Mateev

Track and Room: Cloud Application Development Deployment - CUST 1.06M

Title: Working with complicated data models in DAX

Abstract: Have you ever watched a demo of DAX functionality, and marvelled at how simple the language is, but yet, when you work on your own data model, it just doesn’t work as expected?

In this session, we’ll look at 4 common problems which occur when you’re using more complicated data modelling techniques, and design and implement a simple solution to overcome these complications.

From role-playing dimensions and bi-directional filters to advanced filter context and overriding the default blank behaviour, we’ll learn to solve a variety of problems and add value to our data models.

Speaker(s):

James McGillivray

Track and Room: BI Information Delivery - CUST 0.01M

Title: Azure Cosmos DB - What you need to know to build globally distributed apps?

Abstract: In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.

Speaker(s):

Satya Jayanty

Track and Room: Cloud Application Development Deployment - CUST 1.06M

Title: Who will be Denmark’s next Primeminister?

Abstract: The Danish parliament just opened for its last session before the next general election. It is election season in Denmark. In this talk I will play around with Danish polling data and show you how to predict who will be Denmark’s next Primeminister.

Heavy usage of R in this session

Speaker is NOT Kenneth, but will be MIkkel Freltoft Krogsholm

Speaker(s):

Kenneth Nielsen

Track and Room: Dynamics 365 - CUST 1.01M

Title: Azure stream analytics

Abstract: In many database applications we first log data and then, a few hours or days later, we start analyzing it. But in a world that’s moving faster and faster, we sometimes need to analyze what is happening NOW. Azure Stream Analytics allows you to analyze streams of data while they arrive. In this session you will see how to get started with Stream Analytics. We build and use a real-time application in this session. First we get started with Azure event hubs to collect data, then dive deeper into the temporal queries for analyzing the data.

Speaker(s):

Nico Jacobs

Track and Room: Cloud Application Development Deployment - CUST 1.06M

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 - CUST 0.01M

Title: Automate your SSIS Deployments with VSTS

Abstract: Microsoft VSTS offers cloud based portal and services to fully automate your builds and release processes.

While SSIS is not officially supported we will walk you through the process of setting up VSTS for automated build of your BI projects, leading onto automated release and deployment.

Topics include:

VSTS overview
Deploying Agents
Automating Build
Automating Release

Speaker(s):

Bob Duffy

Track and Room: Cloud Application Development Deployment - CUST 0.01M

Title: Don’t Use Cursors or Why You Maybe Should Use a Cursor After All

Abstract: You might have heard “don’t use cursors, they are slow!”. In this presentation, you will learn what actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presenation also gives some tips how you can troubleshoot performance problems with loops.

Speaker(s):

Erland Sommarskog

Track and Room: Application Database Development - CUST 1.01M

Title: SQL server window functions

Abstract: All database users know about regular aggregate functions which operate on an entire table and are used with a GROUP BY clause. But few people use Window functions in SQL. These operate on a set of rows and return a single aggregated value for each row.

The main advantage of using Window functions over regular aggregate functions is: Window functions do not cause rows to become grouped into a single output row, the rows retain their separate identities and an aggregated value will be added to each row.

In this session I will walk through the syntax of window functions as well as demonstrate common use cases for where window functions.

Speaker(s):

Martin Hansen

Track and Room: Application Database Development - CUST 1.02M

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

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.

Amit R S Bansal

Twitter: - A_Bansal

LinkedIn: Amit R S Bansal

Amit R. S. Bansal is a SQL Server Specialist at SQLMaestros. He leads the SQL Server practice with a focused team providing consulting, training, and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences on SQL Server performance tuning, which is his core expertise. Amit is also honored with Microsoft Regional Director status, MVP award, and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission-critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal.

Bent Pedersen

Twitter: - https://twitter.com/SQLBent

LinkedIn: Bent Pedersen

Contact: http://www.biblog.eu

Alexander Klein

Twitter: - @SQL_Alex

LinkedIn: Alexander Klein

Alexander Klein is a senior Business Intelligence consultant with more than 15 years of experience. He focuses on Business Intelligence and Data Warehouse projects with Microsoft technologies like SQL Server, Power BI, Azure ML or Cortana Intelligence.

Since 2008, he has been a self-employed consultant in large and medium-sized projects in all sectors across Europe. He has been visiting SQLSaturdays and other Data Conference all over Europe since 2013. Speaker at national and international events since 2017.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

Just Blindbaek

Twitter: - justblindbaek

LinkedIn: Just Blindbaek

Contact: http://blog.justb.dk

Independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk). Is a Microsoft Certified Trainer at Orange Man.

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.

Alexander Klein

Twitter: - @SQL_Alex

LinkedIn: Alexander Klein

Martin Hansen

LinkedIn: Martin Hansen

Data warehouse architect

transitional on-premise datawarehouse: database and ETL, but understands the whole BI system stack
Azure based datalake

Bob Duffy

Twitter: - @bob_duffy

LinkedIn: Bob Duffy

Contact: http://blogs.prodata.ie/author/bob.aspx

Bob Duffy is a SQL Server MVP from Dublin, Ireland who is MCA, MCM. and Analysis Services Maestro certified.

Bob works as a Database Architect at the Prodata SQL Centre of Excellence where he specializes in business intelligence and performance tuning.

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).

Jens Vestergaard

Twitter: - @vestergaardj

LinkedIn: Jens Vestergaard

Contact: http://www.t-sql.dk

Jens performs the traditional BI disciplines from imports in Integration Services through data consolidation in Analysis Services, to report in Power BI or Reporting Services. Jens has worked with The Stack since SQL 2000 and has a core competence in Integration Services and Analysis Services. Along with the certified skills in Microsoft SQL Server, Jens has also worked with Microsoft .Net platform for more than 15 years and currently manages a BI Platform in Azure for the CatMan Solution application(s).

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.

David Postlethwaite

Twitter: - @postledm

LinkedIn: David Postlethwaite

Contact: http://www.gethynellis.com/

David Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England since 2008 He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services. In 2015 David built and deployed the company’s first cloud solution using Microsoft Azure SQL Database and web services

Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator.

He is an occasional blogger on www.gethynellis.com

David is a regular speaker for SQLSaturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL

Daniel Otykier

Twitter: - DOtykier

LinkedIn: Daniel Otykier

Contact: https://tabulareditor.github.io/blog

Daniel Otykier is a Principal Architect at Kapacity A/S - a Danish consulting company dealing mostly with Business Analytics on Microsoft technology. He has 12+ years on Microsoft SQL Server, the BI stack and C#/.NET development. He is the author of Tabular Editor, a free alternative for developing Analysis Services Tabular models, and as of 2019 he is also a Microsoft Data Platform MVP.

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

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Mihail Mateev is a technical consultant, community enthusiast, PASS Regional Mentor for CEE, chapter lead, Microsoft Azure MVP, Microsoft Regional Director. He works as a Senior Solutions Architect at EPAM Systems, focused on Data Platform, IoT and cloud related solutions. He also worked many years like a Technical evangelist in the Infragistics. Last years Mihail was focused on various areas related to technology Microsoft: Data Platform, Visual Studio, ASP.Net, Windows client apps, Data Platform, and Microsoft Azure. Michael also has a PhD in cloud computing area. He is a university lecturer on Smart Homes and Smart Energy IoT Solutions.

Michal Sadowski

Twitter: - SadowskiMichal

LinkedIn: Michal Sadowski

Contact: https://sqlplayer.net/michal-sadowski

Senior Database Platform Engineer, leader of Krakow chapter of Data Community Krakow (former Polish SQL Server User Group) - PASS Chapter. With more than 10 years of experience in Microsoft technology, helps in advisory for performance optimization on database and application levels. Active speaker on SQL Server related events like SQLSaturday, SQLDay, MCT Global Summit etc. Holds many Microsoft certificates including MCSE: Data Platform, MCSA: SQL Server 2012/2014/2016, MCSA: Windows Server 2008/2012/2016 and MCT.

Kenneth Nielsen

Twitter: - https://twitter.com/DoktorKermit

LinkedIn: Kenneth Nielsen

Contact: http://funkylab.com

Kenneth M. Nielsen currently work at Microsoft as Data Platform Solution Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.

Bartosz Ratajczyk

Twitter: - @b_ratajczyk

LinkedIn: Bartosz Ratajczyk

Contact: http://blog.bartekr.net/

Database developer and (sometimes) administrator working with SQL Server Data Platform. Currently focusing on ETL development, delivery automation using TFS, query tuning, SQL Server training. Data Community Poland (DC) member, local group and conference speaker.

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

David Postlethwaite

Twitter: - @postledm

LinkedIn: David Postlethwaite

Contact: http://www.gethynellis.com/

Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator.

He is an occasional blogger on www.gethynellis.com

David is a regular speaker for SQLSaturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL

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.

Mihail Mateev

Twitter: - mihailmateev

LinkedIn: Mihail Mateev

Contact: https://mmateev.wordpress.com/

Tracy Boggiano

Twitter: - TracyBoggiano

LinkedIn: Tracy Boggiano

Contact: http://databasesuperhero.com

Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

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,…)

Jens Vestergaard

Twitter: - @vestergaardj

LinkedIn: Jens Vestergaard

Contact: http://www.t-sql.dk

Christopher Adkin

Twitter: - ChrisAdkin8

LinkedIn: Christopher Adkin

Contact: http://www.chrisadkin.io

Erland Sommarskog

Contact: http://www.sommarskog.se

Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.

James McGillivray

Twitter: - JamesMcG_MSBI

LinkedIn: James McGillivray

Contact: https://jimbabwe.co.za/blog-posts/

James McGillivray, Data Management and Analytics MCSE, has been working in Business Intelligence for over a decade. He spends his working hours building solutions that allow people to make informed decisions quickly and accurately. James is a director at Cobalt Analytics.

Before his career in data, James was an avid musical theatre student and musician. This love for performance has developed into a passion for developing and delivering presentations that are informative and enjoyable. James speaks frequently at the Johannesburg SQL User Group, and has delivered sessions at numerous SQLSaturdays, PASS Summit, Power BI World Tour and SQL Bits.

SQLSaturday #765 - Denmark 2018

Sessions

Title: Continuous Integration Pipelines With Jenkins, Docker and SQL Server

Title: The language of graph databases and SQL Server

Title: Start testing your SSIS packages with ssisUnit

Title: Dealing with CosmosDB

Title: Boosting SSAS productivity with Tabular Editor

Title: SQL Server Containers in Azure

Title: Collecting Performance Metrics

Title: Graph Data in SQL 2017

Title: Shard Attack - Horizontal Scaling in Azure SQL Database

Title: Now Where Did THAT Estimate Come From?

Title: Data Ingestion Tricks w/ M

Title: Continuous Delivery for BI projects

Title: Big Data with Azure: where to begin? Concepts and best practices

Title: Azure Cognitive Services - AI for everyone

Title: Automation and best practices for ADFv2

Title: Choose your own Database Adventure

Title: End-to-end Business Intelligence solution in Azure

Title: Database corruption

Title: SQL Server Memory Internals Troubleshooting

Title: Build your next BI solution in azure

Title: Dataflows for Power BI

Title: Device provisioning with Azure IoT in a Nutshell

Title: Working with complicated data models in DAX

Title: Azure Cosmos DB - What you need to know to build globally distributed apps?

Title: Who will be Denmark’s next Primeminister?

Title: Azure stream analytics

Title: Problem Solving With The In-Memory Engine

Title: Automate your SSIS Deployments with VSTS

Title: Don’t Use Cursors or Why You Maybe Should Use a Cursor After All

Title: SQL server window functions

Speakers

Sponsors