DataPlatformGeeks successfully executed SEVEN webinars and ONE In-person event in the month of February, 2020.
The Gremlins are attacking the Azure Cosmos DB
Abstract: 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!
How to Troubleshoot a Slow Running Query in SQL Server
Abstract: 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.
Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio
Abstract: 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.
Understanding NULLs in SQL Server
Abstract: 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.
Machine Learning Using Python & R (Part 2 – Classification Techniques)
Data Virtualization in SQL Server 2019 Big Data Cluster
Deep Dives into the Storage and Data Pools in SQL Server 2019 Big Data ClusterDownload Event Resources
Click Here. You must be logged in to download the resources. DataPlatformGeeks organizes F-R-E-E in-person events at Microsoft Offices (Pan-India) & webinars every month. So become a member today and do not miss registering for the events you wish to attend. Registration is mandatory.