SQLSaturday #735 - Finland 2018
Event Date: 05/12/2018 00:00:00
Event Location:
- Microsoft Mobile Oy (Ltd)
- Keilalahdentie 2-4
- Espoo, , Finland
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: Administrating SQL Server with PowerShell dbatools
Abstract: Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.
Afraid of PowerShell? Worried its too complicated? Don’t want to go through the learning curve?
Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday
Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session
Speaker(s):
- Rob Sewell
Track and Room: Enterprise Database Architecture, Administration Deployment - Room 2 - Karjalainen
Title: Biml for Beginners: Script and Automate SSIS Development
Abstract: Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: BI Platform Architecture, Development Administration - Room 2 - Karjalainen
Title: Responding to Extended Events in near real-time
Abstract: Extended Events provide deep insight into SQL Server’s behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, Extended Events don’t seem to provide a way to react to the events as soon as they happen.
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions. We will also offer a different approach to analyzing captured events, without shredding XML files.
Speaker(s):
- Gianluca Sartori
Track and Room: Enterprise Database Architecture, Administration Deployment - Room 2 - Karjalainen
Title: Implementing a hybrid data warehouse
Abstract: The last couple of years have seen the emergency of “Big Data”, “Cloud” and “Internet of Things”. Subsequently, Gartner at the 2016 Gartner Summit in Barcelona declared the Enterprise data warehouse (EDW) as dead. Which of course is silly. Sensible companies don’t just throw money out of the window. But they need to adapt and change when new opportunities arrive. Enter the hybrid data warehouse. Combining the power of big data and cloud with your trusty EDW.
This session will take a look at a few different approaches to a hybrid data warehouse, with components such as SQLServer 2016, Azure Data Lake, HDInsight, Azure Analysis Services, Azure SQL Data warehouse and Polybase, with some scenarios where the approaches might become relevant. And some pitfalls you need to know about along the way.
Speaker(s):
- Johan Ludvig Brattås
Track and Room: BI Platform Architecture, Development Administration - Room 4 - Berlin Auditorium
Title: Custom maps in Power BI
Abstract: Let’s go beyond the standard visuals available in Power BI for making maps. In this session we won’t talk about Bing or ArcGIS services. We want to explore all the available features for creating custom maps without having to rely on existing ones. Do you know what is a shapefile? Do you know how to create your own choropleth and import it into Power BI? What else? R support into Power BI opened the doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment. Do you want to draw multi-layered interactive maps? Want to geocode your data with direct calls? With R in Power BI, now you can. Last but least, we will able to discover Synoptic Panel, an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map. There are endless possibilities; the only limit is your imagination!
Speaker(s):
- Andrea Martorana Tusa
Track and Room: Analytics and Visualization - Room 3 - Jansson
Title: Python revolution in SQL Server world
Abstract: Python is one of the most popular languages this days and we are very excited to have an ability to use Python inside SQL Server stored procedures starting SQL Server 2017.
Machine learning is not the only usecase for this wonderful feature, it can solve many challenges when dealing with text files, bulk loads and even simplify ETL flows when you need to move data from databases other than SQL Server. Moreover, you can offload the big data querying to nosql database and use Python to get the results into SQL server.
Target Audience: Application and Infrastructure DBAs that want to see various usages for Python language from inside SQL Server stored procedures.
Speaker(s):
- Maria Zakourdaev
Track and Room: Enterprise Database Architecture, Administration Deployment - Room 4 - Berlin Auditorium
Title: Chatbots for Dummies
Abstract: The software development landscape is changing. More and more, there is an increased demand for AI and cloud solutions. As a user buying cinema tickets online, I would like to simply ask “I want to buy two cinema tickets for the movie Dunkirk, tomorrow’s viewing at 1pm” instead of manually following a pre-defined process.
In this session, we will learn how to build, debug and deploy a chatbot using the Azure Bot Service. We will enrich it using the Microsoft Cognitive suite to achieve human like interactions.
Will it pass the Turing test, no, but we can extend the bot service using Machine Learning (LUIS), APIs (Web Apps) and Worflows (Logic Apps).
Speaker(s):
- Jose Mendes
Track and Room: Cloud Application Development Deployment - Room 3 - Jansson
Title: Boring is stable, stable is good - best practices in practice
Abstract: Everybody is talking about best practices, and like standards, most everybody has them. But why do they look like they do, and why would you use a specific set of “best practices” that someone has put together? This session goes through my set of best practices that I’ve accumulated over 20 years of DBA work, disassembles each and every one of them to see how they came about and discusses why I still use them - or don’t. There is no such thing as the ultimate best practices, but I aim to provide the attendee with as much food for thought as possible in order to let each and everyone decide on their own path forward for their own set of best practices. The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 thrown in for good measure.
Speaker(s):
- Alexander Arvidsson
Track and Room: Enterprise Database Architecture, Administration Deployment - Room 4 - Berlin Auditorium
Title: I/O Tuning 101
Abstract: One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but that over time has slowed down substantially.
In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.
First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.
The second part will focus on how to reduce I/O requests.
All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.
Speaker(s):
- Anders Pedersen
Track and Room: Application Database Development - Room 1 - Topelius
Title: What are Azure SQL Database Managed Instances?
Abstract: The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them.
Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server. Including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges to using Azure SQL Databases.
But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology.
Speaker(s):
- John Martin
Track and Room: Cloud Application Development Deployment - Room 1 - Topelius
Title: Enabling Citizen Data Science with Microsoft
Abstract: In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics. Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure. These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data? In this demo heavy session we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Speaker(s):
- Jan Mulkens
Track and Room: Advanced Analysis Techniques Machine Learning - Room 2 - Karjalainen
Title: Lifting the lid on SQL Server on Linux
Abstract: In this session, database expert Martin Wild of Quest Software will lift the lid on SQL Server on Linux. He’ll explore the mechanics of deploying SQL Server on Linux, what is and is not in the current Linux build and discuss quirks, insights and observations on setup and configuration. Once the stage is set, Martin will cover tuning and performance on Linux and bring you through some new DMVs for Linux monitoring. He’ll then compare the plans produced on Linux vs. Windows for consistency… or not!
Speaker: Martin Wild Martin Wild is a principal systems consultant at Quest. He frequently presents at SQL Server events such as SQL Bits and SQLSaturdays, and Oracle user groups. Martin has expertise with Oracle, SQL Server, Sybase, DB2, Windows, UNIX, Linux, VMware and Hyper-V. He has worked in IT for more than 30 years, initially in manufacturing and retail organizations. For the last 17 years he has held various database pre-sales roles and is a member of the British Computer Society
Speaker(s):
- SQLSaturday Finland
Track and Room: Other - Room 3 - Jansson
Title: Automate DWH BI development using TimeXtender Discovery Hub®
Abstract: In this session, we will demonstrate the power of Discovery Hub® by building an end-to-end solution from scratch in just 30min. We automate the majority of the tedious tasks related to a DWH project with high quality auto-generated scripts, documentation, data lineage tracing managed deployment/execution and many other value-adding features. We accelerate BI projects dramatically and allows BI developers to focus their efforts on the tricky modelling tasks, rather than the majority of standard technical steps.
Speaker: Mahmoud Ismail Mahmoud is a Solution Architect in TimeXtenders Customer Service Success team and has significant experience in implementing and utilizing the Discovery Hub in a number of industries and sectors. He also has excellent knowledge in regards to data modelling for both Qlik applications, OLAP Cubes and Tabular models. He takes part in a lot of projects ranging, from presales, training consulting and hands-on DWA developing.
Speaker(s):
- SQLSaturday Finland
Track and Room: Other - Room 3 - Jansson
Title: Experts should work with facts, not guesstimates
Abstract: Experts should work with facts, not guesstimates – how you learn to love large scale SQL Server consolidation projects
Have you ever been struggling with the consolidation or migration planning of a sizable SQL Server platform? Traditional data platform capacity planning contains a lot of time consuming manual work and is often based on rough estimates. It is seen more as a task for the data platform architect than a mathematical challenge. The truth is: It is both. Find out how to achieve highly automatized, perfectly optimized plan, based on facts rather than guesswork!
Speaker: Jani K. Savolainen. Founder CTO @ DB Pro.
Speaker(s):
- SQLSaturday Finland
Track and Room: Other - Room 3 - Jansson
Title: Back to the future - Migrating our SQL Server OnPremise Database to Azure
Abstract: We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise.
This session consists of: -> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse. -> Best Practices and best tools for our migration process depending on the platform chosen. -> After the migration, we have several outstanding questions: Can I keep both environments synchronized? How is the performance of my database?
Speaker(s):
- Jose Manuel Jurado Diaz
Track and Room: Cloud Application Development Deployment - Room 3 - Jansson
Title: SQL Server inside a Docker container
Abstract: Still unthinkable a few years ago, Microsoft’s strategy toward the Open Source world is shaking the computer sphere. Bare metal or virtual machine, SQL Server can now be installed on a Windows OS or… on Linux. In parallel, DevOps culture and micro services seem to be the architecture model for the decade. Docker containers offers IT Pros or Developers interesting scenarios. During this discovery session let’s install Docker, create a first container, install SQL Server and then commit the image for future use. We will also pull an official SQL Server image and walk through some use cases.
Speaker(s):
- Christophe Laporte
Track and Room: Enterprise Database Architecture, Administration Deployment - Room 1 - Topelius
Title: Working smarter, not harder with Azure SQL Database
Abstract: Azure SQL DB brings a lot of benefits for new and existing workloads. In this session we are going to explore the various aspects of an Azure SQL DB. How we can have a self managed, high available and high performing Database. Properly monitoring is also an important part of the job and we will cover several aspects of monitoring an Azure SQL DB. After this session you will feel comfortable in moving your workload to the cloud.
Speaker(s):
- Marcos Freccia
Track and Room: Cloud Application Development Deployment - Room 4 - Berlin Auditorium
Title: Hacking? Mission Possible!
Abstract: Everthing is connected. Everything is accessible. Everything is hackable. This is a security “worst” practices session for developers (yes, yes, the boring “best” practices are also included). As always, should you or any of your colleagues be hacked or exploited, the Demo Gods will disavow any knowledge of the speakers’ actions. This session will self-destruct in 60 minutes. Luck has nothing to do with it, Jim…
Speaker(s):
- André Melancia
Track and Room: Application Database Development - Room 2 - Karjalainen
Title: New Data Visualization Features in Power BI
Abstract: Join this session by Heidi Enho, Power BI consultant, Microsoft Certified Trainer, Data Platform and Excel MVP. Learn how to use Power BI bookmarks, buttons, drill-through filters and for example brand new report tooltips to communicate insights in your data. Heidi will show in this highly demo based session many examples and tips how to use new navigation and storytelling capabilities.
Speaker(s):
- Heidi Enho
Track and Room: Analytics and Visualization - Room 4 - Berlin Auditorium
Title: Introducing Azure SQL DW – Architecture Best Practices
Abstract: Azure SQL Datawarehouse is a petabyte range Massively Parallel Processing Datawarehouse provided as a managed service in Azure. This session will delve into the architecture, new optimized for compute instances, common workload and implementation patterns, performance considerations, loading patterns and strategies and some real-life customer deployment examples.
Speaker(s):
- Arun Justus
Track and Room: Other - Room 1 - Topelius
Title: Dynamic Search Conditions
Abstract: A common requirement in database applications is that users need 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 isboth maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker(s):
- Erland Sommarskog
Track and Room: Application Database Development - Room 1 - Topelius
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 - Room 4 - Berlin Auditorium
Title: Case Transparent Supply Chain using Azure Data Services
Abstract: Welcome to join this session to hear more about data platform that integrates umbarella organization’s all different data touch points to new single source of truth.
- What are the main components of the Enterprise Data Platform in Azure?
- Where to start building?
- How to keep it up and running?
In this webinar Olli Lindroos from Solita will go through how they have developed multiple organisation wide data platforms. See how for example Azure Data Lake and Power BI were leveraged in this solution and hear best practices from the project.
Speaker(s):
- Olli Lindroos
Track and Room: Enterprise Database Architecture, Administration Deployment - Room 1 - Topelius
Title: New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups
Abstract: Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017’s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. We’ll kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well.
Speaker(s):
- Matt Gordon
Track and Room: Enterprise Database Architecture, Administration Deployment - Room 2 - Karjalainen
Title: I know Microsoft Data Platform R but where is the intersection?
Abstract: Ok, I know Microsoft Data Platform and I know R but where is the intersection?? What can I use and where?
In-Database R, Power BI with R, ML Server… there are a lot of tools where we have R included but what can you do with them? In this session we will go through the offering with simple examples and talk openly about what is good and what needs improvements. If you’re data platform specialist that needs to talk with data scientists about possibilities this session is for you! If you’re data scientist and want to know the contact points in Microsoft Data Plat this is very well also for you!
Speaker(s):
- Vesa Tikkanen
Track and Room: BI Platform Architecture, Development Administration - Room 3 - Jansson
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.
Matt Gordon
Twitter: - sqlatspeed
LinkedIn: Matt Gordon
Contact: http://www.sqlatspeed.com
Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He’s an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
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.
Jose Mendes
Twitter: - ZeMiguelMendes
LinkedIn: Jose Mendes
Contact: http://blogs.adatis.co.uk/josemendes/
A Principal Data Analytics Consultant working for Adatis Consulting with experience in delivering Microsoft Azure/ SQL Data Analytics solutions. Presented for the first time in 2017 and since then has been blogging and speaking about the Bot Framework, Power BI, Data Lakes, Databricks and other cool Azure services. Co-organizer of the Surrey Data Platform Group.
Vesa Tikkanen
Twitter: - vesat
LinkedIn: Vesa Tikkanen
Contact: http://www.qumio.com/Blog
Vesa is agile oriented architect from Finland. He is Microsoft Certified Master and MVP. He has passion towards Microsoft Data Platform including both relational and non-relational worlds! Vesa has been working with SQL Server since SQL Server 2000 and counts himself as DBA because he has seen corruption. :) Nowadays he spends his time with advanced analytics related workloads on cloud and on-premise. Vesa Blogs at http://www.qumio.com
Maria Zakourdaev
Twitter: - @Maria_SQL
LinkedIn: Maria Zakourdaev
Contact: http://sqlblog.com/blogs/maria_zakourdaev/default.aspx
I have been working with SQL Server for more about 20 years. I have experience managing enterprise-wide environments, both transactional and data warehouse flavors. This days, also working closely with other database technologies, including Postgresql, Redis, RedShift, CouchBase and ElasticSearch. However, my preferred technology is still an SQL Server.
Anders Pedersen
Twitter: - @arrowdrive
LinkedIn: Anders Pedersen
Contact: http://blog.AndersOnSQL.com
20+ years of experience with SQL Server, from version 6.0 to 2017. Funnily enough, the only certification I have is on SQL 2012, the one version I have never used. Mostly worked at medium sized companies, by choice. Was a consultant for 6+ years, working on anything from facility security systems, background checks, retail PoS systems, to major financial systems. Passion for performance, and teaching people easy ways to better SQL performance.
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
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).
Heidi Enho
Twitter: - @heidienho
Contact: http://HExcelligent.fi
Heidi Enho has been consulting and training Power BI and it’s predecessors Power Pivot Power Query since their release. She has a passion for data and visualizations and has two Finnish Power BI sites HExcelligent.fi and vilahdus.fi.
Senior Consultant, Microsoft Certified Trainer, Data Platform Excel MVP.
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.
Jan Mulkens
Twitter: - https://twitter.com/JanMulkens
LinkedIn: Jan Mulkens
Contact: http://www.janmulkens.be
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
Britton Gray
Twitter: - IDreamInSQL
LinkedIn: Britton Gray
Britton Gray is a veteran of database development, data management, business intelligence, analytics, and data privacy in BI. He has successfully completed projects in a variety of technologies in different technology stacks. Coming from a family full of teachers, he thoroughly enjoys the opportunity to share knowledge and insights; it’s an extension of “getting the right information to the right people at the right time” mantra of BI. He lives near Indianapolis, Indiana, and is the Director of BI for Project Lead The Way, a nonprofit organization providing transformative learning experiences in computer science, engineering, and biomedical sciences.
SQLSaturday Finland
Twitter: - @SQLSatFinland
We proudly present our great sponsors at the event. They have top-notch products, solutions and services to help you with your SQL related work. Get to know their expertise in the special sponsor sessions!
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.
Olli Lindroos
Twitter: - https://twitter.com/ollilind
LinkedIn: Olli Lindroos
I do two things, I design data strategies and I put those into practice by building the best agile team in the market to work on the opportunity.
It’s my 8’th year in analytics coaching organizations to be data driven and implementing advanced analytics solutions. All my years as a developer taught me that technology is the easy part but changing the culture and the mindset to catch and overcome rapidly changing business environment is the hard part.
I appreciate simple quality solutions with polished user experience, love good presentations and enjoy selling. My passion is to help the business to create rapidly something new and valuable for their customers by using modern development methods technologies.
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.
19+ years’ fun developing information and multimedia systems, DBA, project and IT management.
Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.
Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.
Go to http://Andy.PT and you’ll know the same as the NSA…
Arun Justus
I have recently moved into a Global Account Executive role in the Telco Industry. My previous role was as Cloud Architect in Data Platform area working for Microsoft Finland. Prior roles at Microsoft include Big Data Advisor, Data Platform Solution Architect, Dynamics CRM Technical Lead and Business Intelligence Lead at Microsoft Western Europe Area level.
Past work experience is from SAP and Land Transport Authority, Government of Singapore.
Rob Sewell
Twitter: - sqldbawithbeard
LinkedIn: Rob Sewell
Contact: http://sqldbawithabeard.com
Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.
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.
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
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.
SQLSaturday Finland
Twitter: - @SQLSatFinland
We proudly present our great sponsors at the event. They have top-notch products, solutions and services to help you with your SQL related work. Get to know their expertise in the special sponsor sessions!
SQLSaturday Finland
Twitter: - @SQLSatFinland
We proudly present our great sponsors at the event. They have top-notch products, solutions and services to help you with your SQL related work. Get to know their expertise in the special sponsor sessions!
John Martin
Twitter: - SQLDiplomat
LinkedIn: John Martin
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
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.
Sponsors
The following is a list of sponsors that helped fund the event: