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
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: 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?
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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).
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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?
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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!
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- Ruth Pozuelo Martinez
Track and Room: BI Platform Architecture, Development Administration - 2303
Speakers
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.
Sponsors
The following is a list of sponsors that helped fund the event: