SQLSaturday #988 - Gothenburg 2020
Event Date: 09/05/2020 00:00:00
Event Location:
- Svea
- Forskningsgången 4
- Göteborg, Västra Götalands län, 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: What’s New in SQL Server 2019: 100% Demos
Abstract: You haven’t installed SQL Server 2019 yet, and you don’t want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don’t have time to rewrite all your queries or learn new languages - you just want the database to go faster.
I’m Brent Ozar, and I’ll give you the whirlwind tour. I’ll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I’ll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.
No slides here - not even an about-me slide. Let’s dive into some queries!
Speaker(s):
- Brent Ozar
Track and Room: Database Administration Deployment - GAMMA
Title: Power BI Dataflows? Why you need to implement it!
Abstract: Not so long ago, Power BI Dataflows have been added to the Power BI landscape. It is showing great promise, as they have the potential of becoming key in every (large) implementation of a Power BI or Hybrid BI Architecture.
During this session, the core concepts of Power BI Dataflows will be explained, and we’ll discuss how Power BI Dataflows could alleviate some of the specific problems you might be experiencing in your current architecture.
How this feature ties into some other cool concepts, like Azure Data Lake Storage Gen2 or the Common Data Model, obviously can’t be missing from this speech.
Expect to walk out of this session with a decent grasp on the underlying architecture, and some key takeaways to take home with you.
Speaker(s):
- Benni De Jagere
Track and Room: BI Platform Architecture, Development Administration - BETA
Title: Checking in with Power Apps, Flow and Power BI
Abstract: In this session we will create an Power App that will allow users to check-in their location. We will then create a Flow that will take that location and write to a Power BI data source and refresh it. We will then create a Power BI report that will display the data on a map.
Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the users location when a button is pressed. The Power Automate flow we create in this session will take the location and user information and write it to an Excel file. We will also look at the Power BI connector in Power Automate that will allow us to refresh a Power BI data set. In the Power BI report we will create, we will connect to an Excel file with the location information in it and display it in a report including the location on a map.
The audience will take away useful information about Power Apps, Flow and Power BI including
Speaker(s):
- Asgeir Gunnarsson
Track and Room: Other - DELTA
Title: Azure DevOps duet (60 minutes version)
Abstract: Welcome to Azure DevOps Duet, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for SQL Server related deployments.
This session will cover the process of developing a CI/CD process starting at getting the team on board and ending with making an actual release.
We will discuss
- the challenges of implementing DevOps
- setting up a database solution project
- getting started with source control
- testing your database releases using tSQLt
- setting up your Azure Devops pipelines
After this session you will have the tools and knowledge to get started with DevOps and get your development process to the next level.
Speaker(s):
- Kevin Chant
Track and Room: Application Database Development - DELTA
Title: MS SQL New functions, syntaxes, tips tricks
Abstract: In this session we will see what bring us some newly introduced MS SQL functions and syntax’s like COMPRESS, STRING_SPLIT, STRING_AGG, DROP IF EXISTS (a.k.a. DIE), UTF8 Support and many more. How are they performing compared to some old solutions? Accompanied with multiple examples, this session will show you many interesting topics.
Speaker(s):
- Damir Matesic
Track and Room: Application Database Development - DELTA
Title: Power BI Live Data sets, Monitoring your key metrics
Abstract: In this session we will explore options in PowerBI to stream real-time data to the service. Differences between pushing, streaming and PubNub streaming will be explained and we will dive deep into each of the three methods. Join this session so learn how to get live data into your PowerBI service. The session will be covering basic entry to best practices.
Speaker(s):
- Jens Vestergaard
Track and Room: Advanced Analysis Techniques - BETA
Title: Monitoring SQL Server: from on-premises to Azure
Abstract: Have you ever wonder how can you monitor your SQL Server no matter if it is on-premises or on Azure? In this session we will show you the tools and techniques you could use to monitor your SQL Server environment, nevertheless where it is located on-premises or in Azure. We will go through DMVs, Wait Stats, Performance Counters, Extended Events, Query Data Store, Management Studio, Azure Portal, SQL Azure Diagnostics, SQL Auditing and more… We want to share with you what we have learnt from support cases and how we, Microsoft CSS, use these tools to help customers monitor and improve the performance of their SQL Server environments.
Speaker(s):
- Juan E. Moreno Romo
Track and Room: Database Administration Deployment - GAMMA
Title: Detect Plan Regression with Query Store
Abstract: Microsoft introduced Query Store in SQL Server 2016 and promised that it now becomes easy to analyze the entire query workload and detect plan regressions on a database level. In this session, you will learn how Query Store works internally and to interpret the available reports to detect plan regression caused by parameter sniffing and by the new cardinality estimator.
Speaker(s):
- Torsten Strauss
Track and Room: Database Administration Deployment - GAMMA
Title: Why Synapse Analytics is beyond Azure SQL Datawarehouse
Abstract: Synapse Analytics is being announced as the new name of Azure SQL Datawarehouse, but it’s not only that. There is a broader view in Synapse analytics, beyond Azure SQL Datawarehouse. Let’s see in this session what was improved, what changed, and how synapse analytics fits in the data platform.
Speaker(s):
- Dennes Torres
Track and Room: Advanced Analysis Techniques - BETA
Title: BI in Azure two years live
Abstract: After more than two years live with BI in Azure Alexander Klein would like to give an honest feedback.
Which architecture is the right one? Which tools/services should I use ( Azure Data Factory V1 or V2, Azure Stream Analytics, Logic Apps, Azure Functions, Azure SQL DB, Azure SQL DW, Azure Analysis Service, Azure Data Lake, Power BI, Azure Databricks …) ? What was good and what wasn’t so good? What do you have to pay attention to? What can you possibly do better in the next project?
Alexander Klein will answer all these questions and more in this presentation.
Speaker(s):
- Alexander Klein
Track and Room: BI Platform Architecture, Development Administration - BETA
Title: Creating Scalable Data Pipelines with Azure Data Factory and Data Flows
Abstract: One major challenge that data professionals are faced with in the age of Big Data is ensuring that data is in the proper form at the proper time for downstream analytics. This session will discuss the modern data warehouse architecture, and how Azure Data Factory with Mapping and Wrangling Data Flows can be used to ensure that data pipelines deliver the right data at the right time to data consumers.
This session will be a mix of discussion and demo, and attendees will come away with a solid understanding of how these data pipelines are architected and built.
Speaker(s):
- Ted Malone
Track and Room: BI Platform Architecture, Development Administration - GAMMA
Title: Dynamic Search Conditions
Abstract: A common requirement in database applications is that users want a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintainable and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitations.
Speaker(s):
- Erland Sommarskog
Track and Room: Application Database Development - DELTA
Title: Introduction into Power BI Embedded
Abstract: The session gives an overview about Microsoft Power BI Reporting Platform and how this amazing technology can be a game changer at the information delivery to the customer. The session explains what Power BI Embedded is, how to embed reports into ISV application works. Also, the session clarifies the licensing aspect and gives information about the maintenance of this architecture. After the session, the attendees will be able to create her first Power BI Embedded Application
Speaker(s):
- Philipp Lenz
Track and Room: Application Database Development - DELTA
Title: Best Practices for building a Data Lake with Azure Databricks
Abstract: Databricks is a Unified Analytics Platform making it easier than ever to do big data analytics on cloud. However, there are a lot of things you need to know and take into account before diving head first into a Data Lake. This session is intended for architects and developers who are looking to build a massive scale data storing and processing solution. I will go through the Best Practices for the purpose. In addition, I will demonstrate how to unify real-time and batch processing using Azure Databricks. As a result, you should feel comfortable building your own Data Lake for your big data processing needs.
Speaker(s):
- Oskari Heikkinen
Track and Room: BI Platform Architecture, Development Administration - BETA
Title: My romantic relation with Powershell generally and DBATools especially
Abstract: I was very late to adopt Powershell in my day-to-day work as a DBA. I did some copy/change “programming” with Powershell. But it wasn’t until I got in touch with DBATools that I really understood the power of Powershell. In this session, I will demo some of the reasons I really love Powershell and DBATools. I will cover a brief overview of DBATools and then jump into some scenarios where DBATools really helped me, including:
- Automatic restore testing
- Homecooked log shipping
- Migration work
Speaker(s):
- Magnus Ahlkvist
Track and Room: Database Administration Deployment - GAMMA
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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.
Juan E. Moreno Romo
Twitter: - DarthSicuel
LinkedIn: Juan E. Moreno Romo
I was born in IT as a developer. I worked in Data Modeling, as Consultant, Software Architect and Project Manager in a Consultancy Service Company, what leads me to create my own Consultancy Company. I worked on it for almost 15 years till an awesome company, Microsoft, knock my door.
I have delivered training in Developing Technologies, Programming Methodology, Software development process, ALM, different programming languages, Project Managing, Data Modeling, MySQL and SQL among other subjects
Currently I am happily working in Microsoft, based in Madrid (Spain), focused in SQL Server Business as Support Escalation Engineer for SQL Server Core and SQL Server on IaaS in CSS Western Europe Support Team.
Benni De Jagere
Twitter: - https://twitter.com/BenniDeJagere
LinkedIn: Benni De Jagere
Contact: https://bennidejagere.com
Benni De Jagere is a Senior Data Insights Consultant at Realdolmen, with a strong focus on the Microsoft (BI) Stack.
On a daily basis he turns (large amounts) of coffee into insights for customers, and references witty British comedy way too often. Overly enthusiastic about anything data related, he’s trying hard to keep up with all things new and shiny.
Rumour has it that he’s also involved with a ragtag band of data enthusiasts, enjoying themselves whilst organising cool community things. They go by the name of .. dataMinds!
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).
Torsten Strauss
Torsten Strauß (MVP, MCSE Data Platform, MCSE Data Management and Analytics, MCT) has been working with Microsoft SQL Server since the turn of the millennium. He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as Principal Consultant for Sarpedon Quality Lab. Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups in recent years.
Damir Matesic
Twitter: - matesic_damir
LinkedIn: Damir Matesic
Contact: https://blog.matesic.info/
For many years Damir is a passionate programmer and a Microsoft SQL Server developer (ver. 2000+). He is a certificated Microsoft professional on various technologies. In 2020 Microsoft awarded him with Data Platform MVP. Damir leads the Croatian SQL Server User Group (PASS) and he introduced and organizes SQLSaturday events in Croatia. Founder and organizer of Data Community Weekender. He is working as Senior Database Developer @Span.eu. Damir speaks on various community events and conferences like SQLSaturday, Advanced technology days and user groups. When free he blogs about SQL @ https://blog.matesic.info.
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.
Philipp Lenz
Twitter: - lenz_philipp
Contact: https://www.flip-it.de
Philipp works as a Business Intelligence Senior Consultant at XXXL Digital in Coblenz, Germany. With the advent of Power Pivot for Excel and SQL Server Reporting Services, he has discovered his passion for Microsoft Business Intelligence technologies over 12 years.
Since mid-2016 he has been a founding member of the Power BI Usergroup in Cologne and is Chapter Leader of SQL PASS Mittelrhein, Germany. In 2019 he has also founded the Power Apps and Power Automate Usergroup and he was in the end of 2019 recognized as an Data Platform MVP.
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.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Kevin Chant
Twitter: - kevchant
LinkedIn: Kevin Chant
Contact: https://www.KevinRChant.com/
Senior Database Architect originally from the UK and now living in the Netherlands.
Over 23 years experience in the IT sector, and has supported databases for companies in the top 10 of the fortune 500 list.
In addition to a lot of SQL Server experience also has a fair few Microsoft Certifications. In addition, was probably the last ever person in the world to gain the MCSD Azure Architect certification and has gained the latest Microsoft DevOps Engineer Expert certification.
Has real life experience with SQL Server and Azure Devops. Currently SQL Server Product Owner of around 1,900 instances.
In addition, done various things over the years for the Data Platform Community.
Asgeir Gunnarsson
Twitter: - bidgeir
LinkedIn: Asgeir Gunnarsson
Ásgeir Gunnarsson is a Data Platform MVP and Chief Consultant at Datheos in Denmark. He works on Business Intelligence solutions using the whole of the Microsoft BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI, Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.
Ásgeir speaks regularly at events both domestically and internationally, and is the group leader of the Icelandic PASS Group, as well as the Icelandic Power BI User Group.
Ásgeir is passionate about data and loves solving problems with BI.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: