SQLSaturday #789 - Tallinn 2018
SQL Server Management Studio Tips and Tricks
Event Date: 24-11-2018 - Session time: 10:30:00 - Track: SQL
Speaker: David Postlethwaite
Title: SQL Server Management Studio Tips and Tricks
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.
Event Date: 24-11-2018 - Session time: 11:30:00 - Track: SQL
Speaker: Michal Sadowski
Title: Database corruption
Self Service BI Solutions with Analysis Services
Event Date: 24-11-2018 - Session time: 12:30:00 - Track: SQL
Speaker: LEONEL ABREU
Title: Self Service BI Solutions with Analysis Services
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.
New capabilities of Azure Data Factory v2
Event Date: 24-11-2018 - Session time: 14:15:00 - Track: SQL
Speaker: Oskari Heikkinen
Title: New capabilities of Azure Data Factory v2
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.
The Road to The Autonomous Databases
Event Date: 24-11-2018 - Session time: 15:15:00 - Track: SQL
Speaker: Janusz Rokicki
Title: The Road to The Autonomous Databases
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.
Hitchhiker's Guide to the SSAS Tabular
Event Date: 24-11-2018 - Session time: 16:15:00 - Track: SQL
Speaker: Roman Lansky
Title: Hitchhiker's Guide to the SSAS Tabular
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.