SQLSaturday #789 - Tallinn 2018
Event Date: 11/24/2018 00:00:00
Event Location:
- Tallinna Polütehnikum
- Pärnu mnt. 57
- Tallinn, Harju maakond, Estonia
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: Self Service BI Solutions with Analysis Services
Abstract: This session covers the aspects to be considered to deploy a Self Service BI Solution, also will be made a comparison between two Analysis Services modes, Tabular and Multidimensional, exploring advantages, features and capabilites, explaining when and why use each model.
Speaker(s):
- LEONEL ABREU
Track and Room: SQL - 400
Title: Hitchhiker’s Guide to the SSAS Tabular
Abstract: If you flirt with SSAS Tabular or you are forced by circumstances to start you journey as SSAS Tabular developer. If you work with Power BI and wand to understand the engine better. Or if you just want to understand basics of SSAS Tabular technology and its traps. Join me for a short ride around SSAS Tabular galaxy. We will look into basic concepts, architecture and development process of SSAS Tabular.
Speaker(s):
- Roman Lansky
Track and Room: SQL - 400
Title: Database corruption
Abstract: In this session, you will learn how to detect and avoid common problems related to database corruption. There will be a description of the data structures in SQL Server and how it can affect the availability of SQL Server during corruption. On the session, there will be not only theoretical knowledge but many real life examples with demos.
Speaker(s):
- Michal Sadowski
Track and Room: SQL - 400
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: SQL - 400
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: SQL - 400
Title: SQL Server Management Studio Tips and Tricks
Abstract: SQL Server Management Studio is still at the heart of most DBA and developer’s day. We take it for granted but have you ever taken a deeper look at the features and shortcuts inside SSMS that can make your day to day work much easier and more productive? Join me in this demo intensive session, where I will show you many of the tricks and handy shortcuts, including some new features in SSMS 2017, that I have learnt over the years that have helped me to make my day easier and more productive At the end of this session you will have learnt many new tricks that you can use to make SSMS more useful and fun to use.
Speaker(s):
- David Postlethwaite
Track and Room: SQL - 400
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LEONEL ABREU
Twitter: - leonel_abreu
LinkedIn: LEONEL ABREU
An IT Pro who likes to play chess and baseball.
System Engineer degree since 2007, formerly Data Warehousing teacher at university levels from 2008 to 2009. Microsoft Student Partner during the years 2006 - 2007, Second Place in Microsoft Andean Imagine Cup (2006), MCTS, MCITP and MCP with over a decade of experience with SQL Server, working in BI, DBA, Database Development, .net Development, SharePoint and other several areas.
Since 2014 based in Barcelona, Spain. Learning enthusiast and always with passion for new technologies and new challenges.
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.
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.
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.
Roman Lansky
Twitter: - @rlany
LinkedIn: Roman Lansky
Contact: http://joyfulcraftsmen.com/blog/
Roman Lansky is MSBI consultant with over a decade of experience with SQL Server, SSAS, SSIS and data warehouse design and architecture. He likes to understand how thinks works and is passionate in performance tuning. He is author of the SSAS Tabular performance blogs and works in MSBI consultation focused company - Joyful Craftsmen.
David Postlethwaite
Twitter: - @postledm
LinkedIn: David Postlethwaite
Contact: http://www.gethynellis.com/
David Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England since 2008 He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services. In 2015 David built and deployed the company’s first cloud solution using Microsoft Azure SQL Database and web services
Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator.
He is an occasional blogger on www.gethynellis.com
David is a regular speaker for SQLSaturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL
Sponsors
The following is a list of sponsors that helped fund the event: