Event Location:
Tallinna Polütehnikum
Pärnu mnt. 57
Tallinn, Harju maakond, Estonia
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/abreulj/
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.
LinkedIn: https://www.linkedin.com/in/oskariheikkinen/
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.
LinkedIn: https://pl.linkedin.com/pub/michal-sadowski/4/b33/717
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.
LinkedIn: https://www.linkedin.com/in/jrokicki/
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 Sql Saturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.
LinkedIn: https://www.linkedin.com/in/romanlansky/
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.
LinkedIn: http://www.linkedin.com/in/davidpostlethwaite
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 SQL Saturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL