SQLSaturday #851 - Stockholm 2019

Event Date: 05/04/2019 00:00:00

Event Location:

  • GIH, The Swedish School of Sport and Health Sciences
  • Lidingövägen 1
  • Stockholm, Stockholm County, Sweden

PDF of Schedule

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


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Daily indexing problems and its - possible - solution

Abstract: Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!

  • Why performance degradation in spite of maintenance jobs?
  • just one more database in the result set and the query runs really bad - why?
  • usage of literals is completely different from the usage of variables - why?
  • identical data types but the query runs in part perfect and in part bad…
  • your execution plan shows an INDEX SEEK - but the table will be scanned!
  • you get a query from the business which performs really bad but when you test it it runs pretty cool - why?


  • Uwe Ricken

Track and Room: Application Database Development - Aulan

Title: Azure IoT, Windows 10 Core Raspberry PI (DIY)

Abstract: This session will begin, with a high level introduction to Azure Internet of Things, Windows 10 Core and Raspberry PI. Once we have established the basics about the technology, we will be connecting the dots with a live demo on some of the parts. The focus during the demo, will mainly be on Azure IoT Hub, Windows 10 Core and the Raspberry PI and how to DIY. As visualization we will be using Power BI to present the data. This session is not for the Enterprise rather has a more DIY approach.


  • Jens Vestergaard

Track and Room: Analytics and Visualization - 1504

Title: Arguing with myself - self-service BI from an infrastructure perspective

Abstract: Self-service BI is coming, and as an infrastructure professional it’s time to either get with the program or get run over. The infrastructure control that the IT department spent years consolidating is starting to unravel, and left to its own devices, self-service BI will spell as much technical doom as business boom. But what IS “self-service BI”, what can it provide and why would the infrastructure people care? This session outlines how the notion of self-service BI really impacts the technical infrastructure, explains the risks of a governance disaster, and tells the story of how a Power BI implementation skirted disaster and turned into a success - all done in three different voices and from two different viewpoints.


  • Alexander Arvidsson

Track and Room: BI Platform Architecture, Development Administration - Aulan

Title: Intelligent Query Processing in SQL Server 2019

Abstract: SQL Server 2017 started with query processing improvements called Adaptive Query Processing. Now, in SQL Server 2019 CTP2, there are additional improvements, and all of them are packed in a feature with the most promising name - Intelligent Query Processing.

The intention of these improvements is to fix poor performing queries due to wrong cardinality estimations and other sub-optimal plan decisions, and hereby enhance query performance with almost no code changes.

This session will cover briefly all these features: Batch and Row Mode Memory Grant Feedback, Batch Mode Adaptive Join and Interleaved Execution, Table Variable Deferred Compilation, and Approximate Query Processing.

The session will address questions such as do I need to tune queries anymore, does the IQP solves parameter sniffing issues and so on, and also suggest how much improvements you should expect with this promising set of feautures.


  • Miloš Radivojević

Track and Room: Application Database Development - 1506

Title: Extending DevOps To SQL Server

Abstract: Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.


  • Grant Fritchey

Track and Room: Application Database Development - Aulan

Title: A refresher on geospatial data in SQL Server

Abstract: Microsoft introduced geospatial data types already in SQL Server 2008, some enhancements followed in version 2012. Today, geo data is used almost everywhere. Time to refresh your memories of geometry and geography!

We’ll walk through which data types are supported - from 0 to 2 dimensions, from points to polygons and some more - and see how to get spatial data into and out of SQL Server tables.

Then there are built-in functions to determine relationships between geo objects, such as intersection, inclusion or shortest distance. And of course there will be examples of practical applications of geospatial data.


  • Thomas Hütter

Track and Room: Application Database Development - 2303

Title: SQL Graph Databases: Beyond Relational

Abstract: Since SQL Server 2017 the Graph Database feature was released, enabling us to mix the relational model with a Graph model. Some existing flaws in this release are being fixed in SQL Server 2019, bringing graph objects closer to SQL Serve reality.

In this session, you will discover how Graph Databases in SQL Server works and what’s new for them in SQL Server 2019


  • Dennes Torres

Track and Room: Application Database Development - 1504

Title: Don’t Cross the Streams! A Closer Look at Azure Stream Analytics

Abstract: Azure is ready to receive all your event and device data for storage and analysis. But which options in the Azure message handling portfolio should you use to receive and manage your data? In this session I will explain the different options, take a closer look at how they work and what this means for you. Furthermore, I will take a closer look at the Azure Stream Analytics (ASA) language. You will learn how to develop both simple and complex ASA queries, and how to debug. We will look at the possibilities, limitations and pitfalls in the Azure Stream Analytics language. And finally, look at the different input and output choices and when to use which one. This includes a look at how to build a live stream dashboard with Stream Analytics data in PowerBI. The session is based on real world project experiences and will use real world data in the demos.


  • Johan Ludvig Brattås

Track and Room: Cloud Application Development Deployment - 1506

Title: Construct Visual Data Flows by using Azure Data Factory

Abstract: Moving and transforming data has always been, and will always likely be, a very large part of the day-to-day operational requirements of a data analytics practitioner. Cloud technologies and “Big Data” have complicated this task to a degree, and understanding how to effectively and efficiently produce ETL/ELT data pipelines is a necessary skill in today’s data landscape.

In this session, attendees will be introduced to Azure Data Factory Mapping Dataflows, which allows users to develop comprehensive data pipelines using a graphical interface. These pipelines are executed in Azure Databricks, which provides a very efficient Spark-based execution context. Attendees will learn how to effectively build visual pipelines using common transformations, and will learn how to monitor and debug ETL and ELT pipelines by using Azure Data Factory.


  • Ted Malone

Track and Room: BI Platform Architecture, Development Administration - 1505

Title: Integrating Power BI and Azure Data Lake with dataflows and CDM Folders

Abstract: Power BI dataflows are powered by Azure Data Lake Storage gen2, but by default the Power BI service manages the storage details. This is great for self-service data preparation and analyst-driven reuse, but Power BI doesn’t stop there. Through its support for CDM Folders, Power BI dataflows integrate with a wide range of Azure data services.

In this session, Power BI program manager Matthew Roche will explore integration scenarios between Power BI dataflows, Azure Data Lake Storage gen2, and additional Azure services such as Azure Data Factory. If you want to bridge the worlds of IT and self-service, and to enable easy reuse in both directions, this is a session you to not want to miss.


  • Matthew Roche

Track and Room: BI Platform Architecture, Development Administration - 1506

Title: Analyzing Performance Problems Using XEvents, DMVs Query Store

Abstract: Extended Events, Dynamic Management Views, and Query Store are highly useful tools that give you a lot of data when analyzing performance problems. The challenge is which tool to use for which problems and how to correlate the data.

You are troubleshooting a performance problem in a business-critical database, a query is not completing, the users are complaining, and you are trying to understand what is happening. You have data from Extended Events, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?

In this session, we will look at how the tools work in different scenarios, how to correlate the data, and how you can use them in your performance troubleshooting.


  • Ola Hallengren

Track and Room: Enterprise Database Administration Deployment - 1505

Title: Kick Start! SQL Server 2017 Performance Tips and Tricks

Abstract: Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 has introduced many new features. This session is carefully crafted to help overcome the beginner’s inertia for DBAs who have been using SQL Server for a while but aren’t sure how to get started with the new features introduced in SQL Server 2017.

Here is a glimpse of the features we will cover in this session: • Adaptive query plans • Batch mode adaptive join • New cardinality estimates for optimal performance • Indexing Improvements • Automatic Tuning • Memory optimizations

At the end of the session, DBAs will learn 3 essential processes which can be game changers for their career. After implementing the suggestions discussed in this session, DBAs will have extra time to handle more pressing issues which they were not able to focus on earlier.

This 75 minutes will be the most productive time for any DBA or Developer.


  • Pinal Dave

Track and Room: Application Database Development - Aulan

Title: 5 Critical Considerations When Moving to the Cloud

Abstract: Migrating an existing on-premises SQL Server application to the cloud can be a daunting task that consists of many complicated steps. In this session, we will focus on what is perhaps the MOST important step of the process – those that lead up to the actual move to the cloud. We will dive deep into the most critical considerations for moving your data and databases into the cloud, whether you use Microsoft Azure, Amazon, or another cloud provider. We will cover: • The importance of cleansing your data before a major migration • Fully documenting your data sources and metadata • Choosing from many different tools and techniques to actually move data • How to test data for fidelity • How to maintain parallel systems during transitional phases We’ll also share demos and overviews of native features within SQL Server that enable you to move data, as well as show powerful tools from the SentryOne product set that can make data migrations painless!


  • Kevin Kline

Track and Room: Cloud Application Development Deployment - Aulan

Title: Off-load data from production using Replication Change Tracking

Abstract: A common problem is to have too much old data in the production database, which affects administration and sometimes also performance of the production environment. SQL Server comes with many tools that, when properly used, can make your life a whole lot easier; some of which are: SQLCMD scripting, the Change Tracking system, Transactional Replication and the MERGE command. In this session you will be presented to a simple toolkit that will utilize these tools to set up synchronization of your production data to an offline database in a way that is easy to configure and manage. The toolkit contains a very small number of T-SQL and SQLCMD scripts together with a “How to” instruction, AND it´s available in SQL Server Standard edition!


  • Joakim Nyström

Track and Room: Enterprise Database Administration Deployment - 2303

Title: Azure SQL Containers

Abstract: As containers are becoming more and more prevalent, this session provides an introduction to the different options of running containers in Azure.

I’ll cover the following different options for running Docker containers in Azure: Azure Container Registry Azure Container Instances Azure Container Services (AKS)

This session is aimed at SQL Server DBAs and Developers who have some experience with Docker (Docker for desktop) 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.


  • Andrew Pruski

Track and Room: Enterprise Database Administration Deployment - 1504

Title: Exploiting Artificial Intelligence within Power BI

Abstract: Artificial Intelligence is dominating the world and not most of them had any chance to experience these features, due to various complicated reasons. How about if this can be made very easy and to exploit these AI features to visualise in our day to day Power BI? This AI session will cover all AI capabilities within Power BI and also using Azure Cognitive Services to build a live BOT QnA, Vision (Face API), Language (Text Analytics).


  • Dr. Subramani Paramasivam

Track and Room: Analytics and Visualization - 1505

Title: SQL Server Magic Show

Abstract: The most beautiful and fun way to get know the depths of SQL Server is through magic. You will see a series of SQL Server experiments that look like a trick or illusion. But they are not. It is just exploiting the deep knowledge of how SQL works. This will deepen your knowledge and increase ability to solve real-world challenges. The tricks: Select count(*) from table - returns wrong count (any # you like) Deadlock - single statement, without transactions Database - without files Online index changes - on Standard edition Reading plaintext data of TDE-encrypted database - without SQL access


  • Vedran Kesegic

Track and Room: Application Database Development - 1506

Title: 10 Things that you already knew about SSIS

Abstract: We dive into the common knowledge subjects and principles that we already know about but forget to use or just blatantly ignore,

Delta management, Project recovery, Best and Worst practice and more.

Session is recommended for the intermediate to advanced but the beginner will also gain from this.


  • Andreas Bergstedt

Track and Room: BI Platform Architecture, Development Administration - 1505

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.


  • Satya Jayanty

Track and Room: Cloud Application Development Deployment - 1504

Title: SQL Server docker containers from the development to the production

Abstract: The Docker democratisation process has begun with developers.
Nowadays containers are part of the CI/CD pipeline and Microsoft kept up by providing a support for MSSQL databases on Docker regardless the underlying operating system and the environment context as well.

In this session, I propose you a feedback about the first steps and challenges we had to take up in the docker world for both database development and production scenarios.


  • David Barbarin

Track and Room: Enterprise Database Administration Deployment - 1504

Title: How to implement Row Level Security in SQL Server and Why?

Abstract: How to implement Row Level Security in SQL Server and Why?


  • Andreas Bergstedt

Track and Room: Enterprise Database Administration Deployment - 2303

Title: SQL Server installation and configuration cookbook

Abstract: After a small hardware review, let’s talk about Virtualization best practices and Windows configuration. Then, we will talk about the famous Next Next Next Finish and the options we can choose during the setup. And, finally, we will show how to properly configure SQL Server for better performance and easier troubleshooting.


  • Christophe Laporte

Track and Room: Enterprise Database Administration Deployment - 2303

Title: Working in Batches

Abstract: Early in your career you learnt that loops are bad and that you should use set-based statements. However, there are situations when trying to processing all at once takes you into problems. In this session we will learn what these situations are and how we can address them by splitting up the work in batches. We will learn techniques for batching and pitfalls to watch out for so that we don’t introduce new performance issues.

We will also look at batching from a different angle: problems that requires a loop for, say, a single customer, but where we can process all customers abreast for better performance.


  • Erland Sommarskog

Track and Room: Application Database Development - 1505

Title: New capabilities of Azure Data Factory v2

Abstract: Azure Data Factory v1 has not been considered a full blown ETL solution on the market. Data Factory v2 is now introduced to fill in the gaps. We will deliver the understanding of the different features functionalities of both versions as well as a summary comparison between the two. We will also demonstrate the latest and greatest capabilities by orchestrating an end-to-end pipeline with Data Factory v2 including machine learning workloads with Azure DataBricks.


  • Oskari Heikkinen

Track and Room: BI Platform Architecture, Development Administration - 1504

Title: An introduction To SQL Server 2019 Big Data Clusters

Abstract: SQL Server 2019 introduces a new data platform in the form of “Big data clusters”, this runs on a container orchestration platform that is taking the IT industry by storm, in the form of Kubernetes. What is this, how does it hang together, what is the big data clusters architecture what tools can be used with it and how does it scale out. If you would like the answers to all of these questions and more, then this session is for you.


  • Christopher Adkin

Track and Room: BI Platform Architecture, Development Administration - 2303

Title: Power BI Cheat Sheet explained!

Abstract: In this demo-rich session, Dave Marc discuss the Power BI Cheat Sheet that went viral on social media. The sheet is crammed with Power BI tips and best practices based on years of experience, but with little to no room for comments. No worries! We will describe, demonstrate and discuss all the items! And of course, there will be a Cheat Sheet for everyone attending!


  • Dave Ruijter

Track and Room: Analytics and Visualization - 1506

Title: It depends - don’t mistake your Google search for my database knowledge

Abstract: “It depends”. The answer to most questions about database development and database design. In this 60 minute session I will go through some “smart” solutions which turned out to be performance killers in the end. I will also try kill some myths about “best practices” in database development. My powerpoints usually look terrible, so I will focus on T-SQL and execution plans.


  • Magnus Ahlkvist

Track and Room: Application Database Development - 1506

Title: A Masters view on Locking and blocking

Abstract: How do the wait stats show you that you have a locking issue? This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.


  • Mikael Wedham

Track and Room: Enterprise Database Administration Deployment - Aulan

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.


  • Alexander Klein

Track and Room: Analytics and Visualization - 1505

Title: Deep Dive into the M language for Power BI/ Power Query

Abstract: Are ready to do more advance data cleaning transformations than what you can achieve with the Power Query interface? Or maybe you have been tinkering with the M language for a while, but now you want to take your M language skills to the next level? If your answer is yes to either questions, come to this session were I will take a deep dive through the M language to cover things like values, syntax, tokens, row context and more so you can take your data cleaning skills to the next level.


  • Ruth Pozuelo Martinez

Track and Room: BI Platform Architecture, Development Administration - 2303


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

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.

Dennes Torres

Twitter: - Dennes

LinkedIn: Dennes Torres

Contact: https://www.red-gate.com/simple-talk/author/dennes-torres/

Dennes Torres is a Data Platform MVP with more than 25 years of experience in the IT area. He improves Data Platform Architectures and turns data into knowledge. As a Brazilian living in Malta, Dennes works as a software developer and leads the Malta MDP User Group. Having the MCSE Data Platform, Business Intelligence, and Microsoft Certified Trainer (MCT) certifications, Dennes has been in love with database servers since he was introduced to SQL Server 6.5, more years ago than he would like to admit.

Ruth Pozuelo Martinez

Twitter: - @ruthpozuelo @curbalen

LinkedIn: Ruth Pozuelo Martinez

Contact: https://www.curbal.com

Ruth Pozuelo Martinez is the MD and owner of Curbal AB, a BI consultant company based in Sweden. Ruth has a Mechanical Engineering degree by the University of Oviedo (Spain) and a Aeronautical Engineering degree by the University of Wales. Ruth is also a Microsoft Data Platform MVP mainly for her contributions to the Power BI community. She publishes weekly videos on her YouTube channel (http://aka.ms/Curbal) where she has more than 17k followers (at the time of writing). She also contributes on her own company blog: curbal.com as well as Microsoft Power BI community. Ruth is the Power BI User Group leader and arranges around 4-5 meetups every year in Stockholm.

Oskari Heikkinen

LinkedIn: Oskari Heikkinen

I have several years of experience in using Azure for data analytics at large scale. I have been implementing numerous projects for some of the largest companies in the Nordics.

I am a Microsoft MVP, and I currently hold the MCSE: Data Management and Analytics certification. As a Microsoft Certified Trainer (MCT), I hold classes for subject-matter experts and consultants internally as well as give external customer training sessions. I am also an active speaker on community events.

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

David Barbarin

Twitter: - mikedavem

LinkedIn: David Barbarin

Contact: http://www.dbi-services.com/index.php/blog/dbi-bloggers/blogger/listings/dab

David Barbarin is Consultant at dbi services. He has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies and associated topics such as installation, migration, security audits, troubleshooting of performance issues, or high availability architectures etc. David Barbarin is SQL Server MVP (since 2010), Microsoft Certified Master (MCM) for SQL Server, and Microsoft Certified Trainer (MCT).

Ola Hallengren

LinkedIn: Ola Hallengren

Contact: https://ola.hallengren.com

Ola Hallengren is a database architect from Sweden. Currently he’s working in an investment bank in Copenhagen.

Ola is the author of the popular maintenance solution at https://ola.hallengren.com and a Microsoft MVP.

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.

Pinal Dave

Twitter: - pinaldave

LinkedIn: Pinal Dave

Contact: https://blog.sqlauthority.com

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Dave Ruijter

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

LinkedIn: Dave Ruijter

Contact: https://moderndata.ai

Dave is Technology Consultant Data Analytics at Macaw, bringing a decade’s worth of Microsoft Azure Data Platform and Power Platform experience to the table. He is a very passionate Power BI evangelist, eager to share his knowledge and experiences from the field.

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

Johan Ludvig Brattås

Twitter: - intoleranse

LinkedIn: Johan Ludvig Brattås

Contact: http://brattas.org/sqlmusings

Johan Ludvig Brattås is a managing consultant at Capgemini, and a dedicated community guy. He has worked with MS SQL server since late 1999, mostly with BI in one form or another. The last 6 years, most of his work has been in Azure working on data platforms, Power BI and the last three years expanding to Azure IoT and Stream Analytics.

Combining his passion for Microsoft SQL Server with his passion for sharing knowledge, he has spoken at various events in the SQL Community. This is also a way to give back to the community for all the things he has learned over the years. When not working, Johan Ludvig either spends his time with his kids, playing with new technology, or teaching coeliacs how to bake glutenfree food.

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

Alexander Arvidsson

Twitter: - arcticdba

LinkedIn: Alexander Arvidsson

Contact: http://www.arcticdba.se

Alexander is a principal solutions architect at Atea in Linköping, Sweden. Nobody really knows what it means to be a principal solutions architect, but he spends his days helping clients of all shapes and sizes to take better care of their data.

He has spent the last 23 years toying with databases and related infrastructure services such as storage, networking and virtualization, occasionally emerging from the technical darkness to attend a Star Wars convention somewhere in the world.

He is a frequent international speaker, a Data Platform MVP, podcaster, blogger and a Microsoft Certified Trainer, focusing on SQL Server, the Azure data stack and Power BI.

Christophe Laporte

Twitter: - conseilit

LinkedIn: Christophe Laporte

Contact: http://conseilit.wordpress.com/

Christophe Laporte is based in Toulouse, France and has worked with SQL Server since 1997, starting with SQL Server 6.5. Focusing on high availability, VLDBs, and virtualization, Christophe also delivers performance audits on SQL Server and helps companies in choosing the appropriate architectures (Cloud, OnPremise, or Hybrid). In addition to his MCM certification, Christophe is also a SQL MVP, speaker, and Microsoft Certified Trainer since 2000.

Vedran Kesegic

Twitter: - @VedranKesegic

LinkedIn: Vedran Kesegic

Contact: http://blog.sqlxdetails.com

Vedran Kesegic is a Microsoft Certified Master for SQL Server, with Oracle background. With 14+ years enjoyed in exploration of SQL Server depths, developing smart algorithms, optimizing SQL Servers and SANs. He is the author of XDetails, Addin for SQL Management Studio that shows detailed info about indexes and other objects. He likes to hang out, share knowledge, and talk about more or less important things in life.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

Andreas Bergstedt

Twitter: - @AndreasBergstedt

LinkedIn: Andreas Bergstedt

Contact: https://blog.bi360.ml

24+ Years in the IT Sector, Last 12 years in the BI Space, Passionate about knowing and understanding data and what business actually want from their information.

Andreas Bergstedt

Twitter: - @AndreasBergstedt

LinkedIn: Andreas Bergstedt

Contact: https://blog.bi360.ml

24+ Years in the IT Sector, Last 12 years in the BI Space, Passionate about knowing and understanding data and what business actually want from their information.

Matthew Roche

Twitter: - SQLAllFather

LinkedIn: Matthew Roche

Contact: https://ssbipolar.com/

Matthew Roche is a Senior Program Manager in Microsoft’s Cloud + Enterprise Group, where he focuses on business intelligence, enterprise information management, metadata, and data warehousing.

Matthew is currently a member of the Power BI CAT team, where he was saddened to learn that there were not actually any cats. Previously he has worked on Azure Data Catalog, SQL Server Integration Services, Master Data Services, and Data Quality Services. Before joining Microsoft, he worked as an architect, consultant, and trainer focusing on ETL, data warehousing, and business intelligence.

When he’s not enabling the world to get more value from its data, Matthew enjoys reading, baking, heavy metal, and competitive longsword combat.

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.

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

Joakim Nyström

Twitter: - @nystrom65

LinkedIn: Joakim Nyström

Contact: http://sqlservice.se/sv/start/blogg.aspx

PhD in physical biology (particle accelerator appliance) in 1995. SQL Server interest since 1994, and full time since 1997. Dedicated DBD (Database developer), focusing on system integration, architecture and data warehouse design and implementation.

Ted Malone

Twitter: - @tedmalone

LinkedIn: Ted Malone

Contact: http://blog.sqltrainer.com

Ted is currently a Data and AI Solution Architect with Microsoft’s Customer Success organization. In this role, he works with large organizations to ensure that they properly and efficiently apply AI, Machine Learning, Data Analytics, and Business Intelligence technologies to achieve their business goals. Prior to taking this role, Ted worked with the US Federal Government to help solve “Big Data” problems through the use of cloud technologies.

Prior to joining Microsoft, Ted was an architect in EMC’s CTO organization, and led data development teams for a variety of startup organizations.

Ted has worked with SQL Server since it’s inception, and focuses on applying new technologies and techniques to age-old problems.

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.

Mikael Wedham

Twitter: - @wedham

Contact: http://www.wedham.com

Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.

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.

Magnus Ahlkvist

Twitter: - @Transmokopter

LinkedIn: Magnus Ahlkvist

Contact: http://www.tsql.nu

Independent database consultant and certified trainer with a passion for chasing that extra millisecond. 20 years of database development and administration but trying to be humble enough to understand that I’m still learning.

Miloš Radivojević

Twitter: - MilosSQL

LinkedIn: Miloš Radivojević

Contact: https://milossql.wordpress.com/

Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page