Data Virtualization in SQL Server 2019 Big Data Cluster
Machine Learning Using Python & R (Part 2 – Classification Techniques)
SQL Server follows three-valued logic (3VL) (instead of Boolean logic) to evaluate any condition to True or False or Unknown. Unknown value in SQL Server is represented as NULL. NULLs in SQL Server are often misunderstood and causes data inconsistency issues. In this 30 min session, we will try to go through different test cases to understand NULLs properly.
On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks.
You always wanted to troubleshoot a slow running query. But you just don’t know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session.
Have you got some data structures not playing well with the relational concepts? Data, as it appears in the real world, is naturally connected. Traditional data modeling focuses on entities and is not perfectly rendering this highly connected world. For many applications, there's a need to model both entities and relationships naturally. Azure Cosmos DB, with its Gremlin Graph API, supports this property graph model. During this session, you’ll learn the best use-cases and the great benefits of graph models but also how Azure Cosmos DB is supporting this. You’ll receive a good explanation of what’s TinkerPop and why it’s so important in the world of graph databases. The Gremlin language will be explained from the basics to some more advanced concerns in the form of recipes for common use-cases of graph databases!
Tools such as Power Query and Power BI generally require websites to provide information in a defined Table format, which relies on website developers to a) take the time to present their data in that format, and b) be willing to provide their data in a way that is easy to scrape. As tools have become better at automatically collecting data, many websites have started restructuring in order to limit a user’s ability to download information. We will apply some of the newer tools within Power BI to analyse non-tabular datasets, showing you how easy it is to apply cutting-edge analytical tools to “difficult” websites.
Get and overview of Dataflows and how it integrates data lake and ETL technology directly into Power BI to enable anyone with Power Query skills. Before diving into details we will go through the architecture and demonstrate the bigger picture for Dataflows in Power BI. We will go through how you can create, customize and manage data within the Power BI experience in a simpler way. Part of this will also be to go through Common Data Models which contains the business entities across your organisation. This will help your organisation simplifying modeling and is intended to prevent multiple definition for the same data.