SQLSaturday #775 - Gothenburg 2018

Event Date: 09/15/2018 00:00:00

Event Location:

  • Beda
  • Forskningsgången 3
  • Göteborg, Västra Götalands län, 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: Headless chicken - calming the sysadmin that turned DBA

Abstract: Last night you went to bed as a sysadmin, but today you are realizing with a rising dread that you have woken up as a DBA. It sounds like a bad dream, but it doesn’t seem to go away. Maybe the previous DBA won a million bucks and quit on the spot or was hit by a bus and will spend the next couple of months in the hospital; the fact remains that you’re now THE DBA. It really doesn’t matter if you have a single database on-prem or thirty in the cloud - you’ve pulled the short straw and you quickly need to get up to speed. This session is a fast-paced, exciting and fun database primer for sysadmins. You will learn how to best feed and care for your new toy, where to scratch, where to kick and most importantly - what never to do. Bring me your fear and despair and I will give you the confidence needed to continue your new DBA journey.


  • Alexander Arvidsson

Track and Room: Enterprise Database Administration Deployment - Room A

Title: Making reports in SSRS: beyond standard tools

Abstract: Reporting Services is used by years as the main tool to create and delivery reports for SQL Server data platform users. But although we are accostumed to use it, there are many tips and tricks that can help us to significantly improve the output we produce. For example:

  • writing custom function to perform non-standard actions or to create personalized charts
  • export multiple sheets in Excel
  • dealing with merge cells when exporting in Excel
  • using interactive and dynamics filters inside a report
  • creating alternate rows backgrounds in tables or matrix The release of SQL Server 2016 introduced support for R, the most common and powerful analytical and statistical language. With R inside SQL Server it’s possible to embed R charts straight into Reporting Services, exploiting countless opportunities offered by the powerful graphic libraries shipped into the language.


  • Andrea Martorana Tusa

Track and Room: BI Information Delivery - Room C

Title: Automate your work processes with Microsoft Flow and Power BI

Abstract: You use different apps to organize your work. Outlook, Onedrive, Onenote, Sharepoint, Power BI and so on. All for different tasks. Microsoft introduced Flow to let these apps talk to each other. This allows us to create new automated workflows in an easy way. And the beauty is, you don’t need to be a developer!

In these workflows Power BI can play an important role. Power BI generates data alerts which can be used to create emails, work tasks or even start a new flow. Also, you can automatically publish data to Power BI from apps like Outlook and SharePoint to analyze your email and documents.

In this session we’ll introduce Flow and look at use cases to integrate apps with Power BI. By using different demo’s, you will get a good understanding how to use Power BI and Flow to automate new work processes.


  • Hylke Peek

Track and Room: Analytics and Visualization - Room C

Title: Data Wrangling as the key to success with Data Lake

Abstract: Self-Service Data Preparation aka Data Wrangling is becoming more and more popular in BigData and Enterprise world. Data Lake stores tons of different data and it is not easy to get value from it. Traditional approach doesn’t work here, data analysts and data scientists have to wait until IT guys gather requirements and prepare a right dataset for them. Time from raw data to insights is too long. In this session, I invite you together look closer at Self-Service Data Prep and show how it would help to get insights and make decisions faster, onboard new data sources without IT, and increase efficiency for data analysts and data scientists.


  • Sergiy Lunyakin

Track and Room: BI Information Delivery - Room C

Title: Not just polish – How good code also runs faster

Abstract: I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvements that won’t change a lot of code, won’t generate weeks of testing and validation for your colleagues, and can be relatively quick to implement.

But most of all, they’ll make the code prettier and easier to understand for the next person.

We’ll look at common ways that null values, implicit datatype conversions and foreign key constraints can radically affect the performance of your queries. Inspired by an actual client case, where I tuned a 20 hour query down to a few minutes, with only a minor code change.

This presentation is all-code, some execution plans, and no-powerpoint.


  • Daniel Hutmacher

Track and Room: Application Database Development - Room B

Title: Natural Born Killers, Performance Issues to Avoid

Abstract: Learning SQL is easy, mastering it is hard. In this session you’ll learn simple but effective tricks to design your database objects better and write more optimized code. As an attendee you will gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.

Ever thought that you were adhering to best practices but still seeing performance problems? You might well be. In this session I will be covering why the optimizer isn’t using all available processors, when the database engine fails to report all the resources a query has used and why the optimizer doesn’t always use the best plan.

You will leave this session with a list of things that you can check for in your environment to improve performance for your users.


  • Lord Richard Douglas

Track and Room: Application Database Development - Room A

Title: FILETABLEs: What They Are and How to Use Them

Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d


  • Matija Lah

Track and Room: Application Database Development - Room B

Title: The Road to The Autonomous Databases

Abstract: Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure Sql PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.


  • Janusz Rokicki

Track and Room: Strategy and Architecture - Room C

Title: Azure Stream Analytics Machine learning: better together

Abstract: In the current just-in-time world we want to analyze what is happening now, not what happened yesterday. Companies start to embrace Azure Stream Analytics, which makes it easy to analyze streams of incoming events without going into advanced coding. But for advanced analytics we need machine learning to learn patterns in your data. Azure Machine learning can do this for you. But the real beauty is that both products can easily work together. So if you want to see how within 60 minutes we can learn patterns in streams of data and apply them on live data, be sure to attend this demo-oriented session.


  • Nico Jacobs

Track and Room: Advanced Analysis Techniques - Room B

Title: How to build solution for High Availability/Disaster Recovery

Abstract: How does your SQL Server environment meet the RPO and RTO service levels? In this session, we will cover all aspects of HA / DR. We will cover all technology options and compare the benefits between them. We will also talk about processes to maintain your RPO and RTO level.


  • Marcelo Fernandes

Track and Room: Strategy and Architecture - Room C

Title: Scaling Out Workload Processing Using SQL Server Running Inside Containers

Abstract: Scaling out workloads such OLTP using the traditional database engine always leads to certain bottlenecks being encountered, namely around spinlocks and the logging infrastructure. This session will cover these bottlenecks and present ways and means for overcoming these using SQL Server running inside containers. Use cases for these solutions include ingesting the massive amounts of data encountered in IoT and micro services style applications.


  • Christopher Adkin

Track and Room: Application Database Development - Room A

Title: My 10 favorite PowerShell commands

Abstract: As a DBA I am always trying to automate the tasks that I have to do. In this session I want to show you 10 Powershell commands that will make your life easier and increase your productivity. I promise that at least one new thing you will learn it


  • Marcos Freccia

Track and Room: Enterprise Database Administration Deployment - Room A

Title: DevOPS for DBAs - Where is your magic wand?

Abstract: DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!

Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . In this session let us overview where exactly DBAs can make miracles with their magic wand, let’s talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices.

Take away best practices associated in DEVOPS and DBA world.


  • Satya Jayanty

Track and Room: Enterprise Database Administration Deployment - Room C

Title: SQL Server GDPR

Abstract: GDPR is coming and only a few companies are ready to apply. In this session we will see how SQL Server can help us to be compliance with regulation.

Discover Manage Protect Report Monitoring


  • Francisco Racionero

Track and Room: Enterprise Database Administration Deployment - Room B

Title: Encryption in SQL Server

Abstract: An application that you administer stores sensitive data in the database and you would like to keep them safe in Microsoft SQL Server - how to approach this issue? What type of encryption should you use in your environment? On the session I will walk through available options in Microsoft SQL Server and show when to use encryption, how to identify threats, and countermeasure them by using options like Transparent Data Encryption, SSL certificates, Always Encrypted, etc. After this session, you will know a set of best practices that you can apply in your environment.


  • Michal Sadowski

Track and Room: Enterprise Database Administration Deployment - Room A

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.


  • Erland Sommarskog

Track and Room: Application Database Development - Room A

Title: SQL Server, Next station Azure

Abstract: This session will cover the main aspects to start or migrate from an OnPremise model to one of the two architectures available in SQL Server on Azure, providing the keys to select the more suitable environment for our requirements. We will cover:

  1. Red pill or blue pill SQL Server on Azure VM (IaaS) vs SQL Azure DB (PaaS) Which one?
  2. Always available. High availability in Azure
  3. Now what … Best practices and configuration connectivity.


  • Jose Manuel Jurado Diaz

Track and Room: Cloud Application Development Deployment - Room B

Title: Let the Cognitive Services to help you to find your favourite cocktail.

Abstract: Who does not know the problem, you sit in the bar and just don’t know which cocktail to order? The Cogntive services offer here with face, emotion and recommendation three APIs that can help you. How do you best combine these services to get a suggestion for your cocktail?


  • Alexander Klein

Track and Room: Cloud Application Development Deployment - Room B


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

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.

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.

Lord Richard Douglas

Twitter: - SQLRich

LinkedIn: Lord Richard Douglas

Contact: http://SQL.RichardDouglas.co.uk

Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.

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

Francisco Racionero

Twitter: - @fracionero

LinkedIn: Francisco Racionero

I am a SQL Server specialist with more than 20 years working in database systems. During my work life, I worked for some of the most important software companies in the world Accenture, IBM or Microsoft.

Always with high responsabilities in the projects involved, focusing in the interest of the customers.

This way has been my best presentation, across my counterparts along my career.

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

Sergiy Lunyakin

Twitter: - slunyakin

LinkedIn: Sergiy Lunyakin

Contact: https://slunyakin.wordpress.com

Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.

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

Marcos Freccia

Twitter: - @sqlfreccia

LinkedIn: Marcos Freccia

Contact: http://marcosfreccia.wordpress.com

Currently working as a Microsoft SQL Server DBA at Zalando SE, Marcos has over 9 years of SQL Server experience, working from small to enterprise environments with High Availability, Disaster Recovery, Database Optimization, etc.. Holding several Microsoft certifications such as: MCITP DBA DEV, MCSE Data Plataform and his last certification on Microsoft Azure Design and Implement Cloud Data Platform Solutions. In 2013 Marcos was awarded as a Microsoft MVP by his contributions in the Brazilian SQL Server community. Marcos is a frequent speaker in the SQL Server Community and he was the organizer of the first SQLSaturday in South Brazil.

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.

Daniel Hutmacher

Twitter: - @dhmacher

LinkedIn: Daniel Hutmacher

Contact: https://sqlsunday.com/

Senior database developer with a long-running passion for performance tuning on SQL Server. I run my own consultancy business where I help companies with database development, ETL work, performance tuning and technical training on SQL Server. Board member of the Swedish SQL Server usergroup 2017-2019, organizer of SQLSaturday Stockholm, and co-organizer of GroupBy.org.

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

Hylke Peek

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

LinkedIn: Hylke Peek

Hylke is a BI and Data Analytics consultant. He delivers data and BI solutions for various organizations for more than 10 years. His focus is SQL Server, Azure, Power Platform and Python. But he founds everything interesting, as long as it involves data.

Hylke also provides training on these topics and speaks regularly on national and international events. The biggest fun of all this? Gaining new knowledge!

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.

Janusz Rokicki

Twitter: - DataSic

LinkedIn: Janusz Rokicki

Contact: https://www.datasic.com/

Microsoft Data Platform Expert and certified Azure Solutions Architect with over 12 years’ experience working in the City of London in the Financial Services Industry (retail and investment banking, multi-asset class trading systems). He has passion for secure, high-performance, maintainable data-driven applications that can be deployed with confidence on-premises and in-cloud. With educational background in intelligent sensor networks and machine learning he is always in search of automation and optimisation opportunities.

Has presented at SqlBits, PASS Summit, SqlDay and multiple SQLSaturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.

Marcelo Fernandes

Twitter: - marcelodba

LinkedIn: Marcelo Fernandes

Contact: http://marcelodba.wordpress.com

Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba

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.

Jose Manuel Jurado Diaz

Twitter: - jmjuradodiaz

LinkedIn: Jose Manuel Jurado Diaz

José Manuel Jurado currently works as SQL Escalation Engineer and Subject Matter Expert in Azure SQL Database at Microsoft Spain. With over 20+ years of experience in SQL Server environments (administration and database development), he is a speaker for internal events at Microsoft and for public events such as SQLSaturday, SQL Nexus, SQLBits, Pass Summit, SQL Server Konferenze, TechReady, DotNetConference, and Azure BootCamp. In the past, he worked as Project Manager for large global retail company for more than 10 years developing projects using different Microsoft Technologies.


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

Back to the SQLSaturday Event List

Back to the home page