| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:30:00 | Manohar Punna | Cloud Application Development Deployment | Deploy Azure SQL with Cloud IaC using Terraform |
| 09:30:00 | Edwin M Sarmiento | Enterprise Database Administration Deployment | The Transaction Log and How It Affects HA/DR |
| 09:30:00 | Gilbert Quevauvilliers | BI Information Delivery | What is Tabular Editor and how can it help me with Power BI? |
| 10:30:00 | Denny Cherry | Cloud Application Development Deployment | How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Sca |
| 10:30:00 | Eduardo Pivaral | Application Database Development | T-SQL Basics: Coding for performance |
| 10:30:00 | Martin Catherall | Application Database Development | Exploring Window Functions |
| 11:30:00 | Julie Koesmarno | Analytics and Visualization | Kusto Query Language (KQL) in Azure Data Studio |
| 11:30:00 | Dinesh Priyankara | Advanced Analysis Techniques | Machine Learning Like Never Before - Azure Machine Learning Service |
| 11:30:00 | Aroh Shukla | Application Database Development | SharePoint Data and Power Apps – Better Together |
| 12:30:00 | Javier Villegas | Enterprise Database Administration Deployment | Monitoring SQL Server using Community solutions (Free) |
| 12:30:00 | Mohammad Asif Waquar | Cloud Application Development Deployment | Blockchain It's all about Data !! |
| 12:30:00 | Greg Low | Application Database Development | Tips and Tricks for Using SQL Server Management Studio Effectively |
| 13:30:00 | Naginder Singh Virdi | Enterprise Database Administration Deployment | Whats new with OSS Databases on Azure |
| 13:30:00 | Nisal Mihiranga | BI Platform Architecture, Development Administration | Let's Make Semantic Models Simpler using Calculation Groups in SSAS Tabular |
| 13:30:00 | Dharmendra Keshari | Advanced Analysis Techniques | Sneak Peek at SQL Server 2019 |
| 14:30:00 | Stefano Tempesta | Application Database Development | Secure multiparty Machine Learning with SQL Server Always Encrypted with Secure Enclaves |
| 14:30:00 | M A A Mehedi Hasan | Other | Introduction to SQL SERVER 2019 ML Services |
| 14:30:00 | Murilo Miranda | Strategy and Architecture | Automating the deployment of Linux VMs with SQL Server through Ansible |
| 15:30:00 | Uwe Ricken | Application Database Development | Daily indexing problems and its - possible - solution |
| 15:30:00 | Alexander Arvidsson | Information Delivery | The Untruthful Art - Five Ways of Misrepresenting Data |
| 15:30:00 | Marco Russo | BI Platform Architecture, Development Administration | My Power BI Report is Slow: What Should I Do? |
Event Date: 28-11-2020 - Session time: 09:30:00 - Track: Cloud Application Development Deployment
DevOps and deployability of resources as needed have become even more critical with the cloud. Infrastructure as code is a necessity than a luxury. Terraform offer great IaC solution across multiple cloud vendors. In this session, I will explain the importance of infrastructure as code for cloud resources and introduce how Terraform can be used for building your multi-cloud IaC solutions for you SQL environments.
Event Date: 28-11-2020 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 28-11-2020 - Session time: 09:30:00 - Track: BI Information Delivery
Tabular Editor provides an intuitive hierarchical view of every object in your Tabular Model metadata in an offline mode. This includes displaying everything in your data model (Columns, Measures, Hierarchies) Tabular Editor is another tool you should have in your Power BI Toolkit.
In this session I will cover the following items
• The basics of Tabular Editor and its features.
• Creation of Measures
• Deployment to AAS
• Special preview of Tabular Editor being used with Power BI Desktop
• Automation options (Formatting All DAX Measures, Putting DAX Measures into Description fields)
• Calc Groups
○ Multiple measures
○ Currency format strings
• Other tips and tricks
○ Copy and paste also between pbix
○ Move to new folders
○ Best Practice Analyzer
• Questions
Event Date: 28-11-2020 - Session time: 10:30:00 - Track: Cloud Application Development Deployment
Event Date: 28-11-2020 - Session time: 10:30:00 - Track: Application Database Development
In this session, we will learn some basic tips to improve our code and improve database performance from early application planning stages to existing production applications that require performance tuning.
Event Date: 28-11-2020 - Session time: 10:30:00 - Track: Application Database Development
They provide a window over the result set and the ability to access data other than the current row. This means that somethings that may - at first - seem like they need row-by-row processing can be done in one single set-based query. The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis. Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient – and cleaner – queries.
Event Date: 28-11-2020 - Session time: 11:30:00 - Track: Analytics and Visualization
Event Date: 28-11-2020 - Session time: 11:30:00 - Track: Advanced Analysis Techniques
Event Date: 28-11-2020 - Session time: 11:30:00 - Track: Application Database Development
Event Date: 28-11-2020 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 28-11-2020 - Session time: 12:30:00 - Track: Cloud Application Development Deployment
Event Date: 28-11-2020 - Session time: 12:30:00 - Track: Application Database Development
Event Date: 28-11-2020 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 28-11-2020 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 28-11-2020 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Event Date: 28-11-2020 - Session time: 14:30:00 - Track: Application Database Development
challenge. Organizations want to perform collaborative data analytics while guaranteeing the privacy of their individual datasets. Combining multiple data sources to support a better outcome improves accuracy of prediction, but it may come at cost of confidentiality, if sensitive information is not accurately protected. SQL Server 2019 adds new data security capabilities with Always Encrypted with Secure Enclaves. By using trusted execution environments (TEEs) to protect your data while in use, you can use machine learning algorithms across different organizations to better train models, without revealing the processed data. This session presents the benefits of Confidential Computing in an ML scenario, where separate health institutes collaborate on data analysis and prediction using Azure ML.
Event Date: 28-11-2020 - Session time: 14:30:00 - Track: Other
Event Date: 28-11-2020 - Session time: 14:30:00 - Track: Strategy and Architecture
In an environment with high-scale needs and agility in the processes, it became imperative to use some kind of automation, in order to meet the demand in an intelligent and standardized way. In this session, I will show you how Ansible can help us create VMs on Azure, adjust their settings and install a SQL Server instance. All of this in a scalable and consistent way. With the automation, you will be moved from lead actor to a mere spectator, but you will still be the protagonist :)
Event Date: 28-11-2020 - Session time: 15:30:00 - Track: Application Database Development
Event Date: 28-11-2020 - Session time: 15:30:00 - Track: Information Delivery
Right at the intersection of journalism and statistics lies visual communication - the art of using data, charts and maps to convey information. This has been called "the truthful art" as it is an extremely powerful tool that must be wielded with the utmost care. Just like any other tools, however, it can be used for sinister purposes. This session is all about exploring ways that data can be misrepresented to further a goal - while still seem perfectly reasonable. It is intended as an eye opener for anyone interested in the how and why of data deception. We will walk through five stories and explore where the trickery is hidden, discuss a more honest way to communicate the information as well as look at ways to spot potential foul play with data.
Event Date: 28-11-2020 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response.
At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.