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
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: 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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:
- Red pill or blue pill SQL Server on Azure VM (IaaS) vs SQL Azure DB (PaaS) Which one?
- Always available. High availability in Azure
- Now what … Best practices and configuration connectivity.
Speaker(s):
- 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?
Speaker(s):
- Alexander Klein
Track and Room: Cloud Application Development Deployment - Room B
Speakers
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.
Sponsors
The following is a list of sponsors that helped fund the event: