SQL Saturday Edinburgh is back, begin the year 2020 with interactive learning from the industry professionals and achieve your career goal from the Edinburgh Data Platform community offering.
All attendees, speakers, and sponsors must register with a PASS.org account (free if you don't have one yet) and will need to accept and follow the Anti-Harassment Policy as fully listed at https://www.sqlsaturday.com/AntiHarassmentPolicy.aspx. Harassment in any form, will not be tolerated.
This event will be held on Feb 01, 2020, at Edinburgh Training & Conference Venue, 16 St Mary’s Street, Edinburgh EH1 1SU, United Kingdom.
The venue is located in the city centre situated on St Mary’s Street- 5 minutes walk from Waverley Train Station, here is a list of hotels with fantastic offers on accommodation.
*Thanks to our sponsors and supporters
For more information and news reach to firstname.lastname@example.org and/or event Organisers: Satya Jayanty ( @SQLMASTER) and Thomas Sykes (@SQLTOMATO)
SQLSat927 Pre-con 1
Open Hack: From Ingestion to Consumption - 31st January 2020
This workshop is designed to get hands-on experience with a Modern Data Solution. During this day, the participants will be wrangling data inside the Azure Data Platform, going from ingestion to consumption. At the end of the day, the participants will have the required skillset to build their modern data warehouse using the full power of the Azure stack.
The workshop covers 5 modules.
- Module 1 will take a deeper look into the various Azure storage options that can be used as the landing zone for the data. The architecture needs to fulfill a set of customer requirements. Based on these requirements and the guidance of the experts, the data architecture will be designed to perform in the following modules.
- Module 2 will focus on loading the data to your architecture and again making sure you are compliant with all the customer requirements. There is the opportunity to apply the newest standards when it comes to DevOps, ARM templating and Infrastructure as a Code.
- Module 3 will require data rendering skills where you will cover the consumption part of your data. A report must be created based on the date you've processed in the previous modules. The goal is to create valuable insights to support the customer in their decision making on critical business processes.
- Module 4 will introduce a new data stream to the architecture. In this module, you will combine the batch data with live stream data and make sure this data is persisted and can be queried in real-time. In the modern world, data can't be transformed into insights fast enough. Learn everything about creating a real-time data pipeline.
- Module 5 will cover AI using algorithms to detect and solve a real-world data science challenge. Based on the newest techniques in the azure suite, you will start to analyze the data and apply machine learning models to your data architecture. This is the next level of data maturity where even decision making is automated.
For this workshop, you will be working in small groups of 3 people. There will be experts present during the workshop who can help you with all the questions you might have, and they will also guide you in choosing one of the possible solutions for the scenario. This ensures a high level of interactivity to have an excellent knowledge transfer between both your team and the experts. The winner of the day is determined based on their progress, quality, and team spirit. It's not about winning; participating will already give you the tools to become a modern data expert.
- You will need to bring your laptop with SSMS, Visual Studio and Visual Studio code installed. An Azure access promo code will be provided to you for the duration of the workshop.
Stijn Wynants is a Microsoft Premier Field Engineer Data & AI, a core member for the DataMinds conference in Belgium.
He is a speaker at various international events (SQL Saturday, PASS Summit, Difinity, ...). He spends his days tuning SQL Servers & solving problems with the full data platform. His focus is primarily on SQL server core but has also done various BI & ETL projects. He gets his kicks out of Columnstore indexes & tuning queries but shivers at the sight of an SSAS cube. When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine & local beers or enjoying time with his wife and his dog.
Steve Verschaeve is a professional date with close to 16 years' experience in SQL Server (DBA, DEV, BI).
He works at Microsoft as Data & AI Premier Field Engineer focusing on Power BI, building bots, IoT, cognitive services and HDInsight.
He's a big fan of automating things wherever he can using MS Flow. When not working, you might catch him on his shiny black gravel bike.
After finishing her master degree in Econometrics, she was looking forward to applying her knowledge on statistics and machine learning models in practice.
She is passionate about obtaining valuable insights out of data. As a consultant, she is currently working with Power BI a lot and helping customers on a wide range of data engineering projects. When not at work, you can find her enjoying life in the city of Amsterdam or on the tennis court.
- Click here to pay for precon1 (secure method) and register your place.
SQLSat927 Pre-con 2
Data Life-cycle : From Production to Data Lake - 31st January 2020
If you feel the data platform became an alphabet soup hard to understand? If you struggle with the difference between data warehouse and bi, while words like ETL, OLAP, DAX, give you goose bumps, this training is for you. The number of technologies and architectures to help us organize our company most important asset - our data - only increase every day, creating an alphabet soup difficult to understand.
Explaining both, the concepts and the tools available, this training day will start from the very basic concepts - what's production data and why we need more than that, we will pass by subjects like ETL, Data Warehouse, OLAP, Data Warehouse vs BI, Big Data, Hadoop, HDFS, Big Data Clusters, Lambda and other architectures, dashboards, visual storytelling, self-service BI, Machine Learning and more.
- What's Data Warehouse
- What's the difference between BI and Data Warehouse
- Why do we need a Data Warehouse
- Basic principles of Data Warehouse modeling
- ETL: Concepts, tools, and challenges
- Cubes and Data Marts
- Tools used to create cubes and data marts
- Self-Service BI: Basic concepts on Power BI
- What's Big Data
- Tools used to process Big Data
- Data ingestion architectures
- Data Virtualization
- Data Warehouse vs Data Lake
- Machine Learning: Concepts and Tools
- Data Bricks
- Machine Learning Services in SQL Server:
Speaker: Dennes Torres
Dennes Torres has more than 25 years of experience in the IT area. 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, Microsoft Certified Trainer (MCT) certifications, and being a member of MVP Reconnect, 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.
Twitter - https://twitter.com/dennes?lang=en
- Click here to pay for precon2 (secure method) and register your place.
SQLSat927 Pre-con 3
Database DevOps with SSDT, GitHub and Azure DevOps Services - 31st January 2020
DevOps has fundamentally changed the way we manage IT. Those practicing DevOps well aren't just outpacing their competitors, they are annihilating them. With DevOps comes a whole host of new practices, tools, and buzzwords. Some roles and tasks have been made redundant, while new opportunities have been created.
We all need to learn to survive in this new reality.
In this session, we'll cut through the hype and look at the key concepts and findings from the Puppet State of DevOps Reports, The DevOps Handbook, and Microsoft's work in this space.
Then you will roll up your sleeves and create your repository in GitHub, create and push a new SSDT project, and configure your own Azure DevOps Build and Release Pipeline to deploy your source code to either an on-prem SQL instance or Azure SQL DB.
Don't forget to bring a laptop!
Speaker: Alex Yates
Alex is a Data Platform MVP who loves DevOps.
He's has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He's most proud of helping Skyscanner develop the ability to deploy 95 times a day. Alex has worked with clients on every continent except Antarctica - so he's keen to meet anyone who researches penguins.
A keen community member, he helps organize Data Relay and he created speakingmentors.com. He blogs at workingwithdevs.com, speaks wherever they'll let him and manages the DLM Digest quarterly email: a report on the latest database DevOps news/tutorials. He was awarded his first MVP award in 2017.
He's quite fond of Nutella. And otters. (Not together.)
- Click here to pay for precon3 (secure method) and register your place
(For any issues or escalation, email to email@example.com)