Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
In this 100% demo session, I will show you kql magic, kql kernel, and the recently released Azure Monitor Logs extension for Azure Data Studio to consume event logs of the Azure SQL database.
I will show you demos for how to implement each layer of defense. This way, if one layer is breached, you aren’t left defenseless. We will start at the outer layer with network access. Next, we will cover the authentication and authorization using Azure RBAC. Finally, we will protect the innermost layer with Data At Rest and Data In Transit encryption. Once these protections are in place, we’ll see how to monitor Azure SQL security ecosystem for intrusions with Advanced threat protection.
This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.
Understand the automatic performance changes in Azure SQL and SQL Server
How to deploy SQL databases, data factories, and tabular data models to Azure using Azure DevOps release pipelines.
An overview of VNets, Service Endpoints & Private Endpoints for Azure SQL DB & Managed Instance
Version control provides benefits beyond DevOps automation.
This data governance session guides you through the organization processes, policies and roles that are required for a successful data governance adoption. In addition to demos showing the possibilities of Azure Purview (the MS data governance service), we will share about experiences from our data governance workshops and adoption projects with our customers.
DBA/Developer Toolset to get you out of that hole and save you some time
Want to have a deep dive into how SQL Server and Azure SQL service maintain high availablity? This is your session.
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
Reality Check on Microsofts Enterprise Scale Analytics Framework
Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.
Only the curious will learn and only the resolute overcome the obstacles to learning.
A tale about how a development team and an operations team must bond together and figure out how to use GitHub and Azure DevOps together for Data Platform deployments.
Auditing options for Azure SQL offerings