So you've heard that automating deployments to your databases are all the rage, not least because you don't have to wake up at 2am to perform them. But how do you get from having a database with no automation to having your DB in code, and deploying changes automatically using Azure DevOps?
The video is not available to view online.
Planning to move your databases to the cloud but seriously doubt if your data is 100% secure? No matter if you are on-prem or in the cloud, making sure your data is protected in every angle possible is the most crucial and important step in building a secure data tier of an application. Let's dedicate this session to knowing the different multi-layer defense-in-depth security techniques and strategies available to armor your Azure SQL database. let's dive deep into each of these layers starting with the network security, Azure role-based access control (RBAC), data security at the row level, auditing, advanced threat protection, different layers of encryption, monitoring, and more. By the end of this session, you will have the knowledge to make the right security decisions for your environments and implement these techniques in securing your data. 
The video is not available to view online.
How can you everage SSDT in order to deploy DB changes as part of your CI/CD pipeline
The video is not available to view online.
Join us for a pure, demo-driven journey of a dozen incredible features for Azure SQL Managed Instance showing you the greatest and latest innovations enabling Database Administrators and Developers to achieve more. Whether you’re a DBA, Azure Administrator, Developer, Business Intelligence developer, or of course any other data professional, these demos will show how you can achieve more with the exciting features that are available to you. Some of the topics we will cover are hybrid scenarios, performance and scale, application compatibility, workload modernization, compliance, data mobility/migration & business continuity/disaster recovery - and several more - in this fast-paced, demo-only session.
The video is not available to view online.
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
The video is not available to view online.
Based on real world experience let’s think about just how far the breadth of our knowledge now needs to reach when starting from nothing and building a complete Microsoft Azure Data Analytics solution.
The video is not available to view online.
With more and more deployments of SQL Server becoming hybrid or cloud native, how do you need to think about availability? This session will give you the foundation on how to approach availability in the new world.
The video is not available to view online.
Join this session if you want to get a guided tour into an example of how you could implement Azure DevOps in your organisation or team. We will be complete the journey from idea to running code
The video is not available to view online.
Power BI has revolutionized the industry by accelerating our ability to deliver Data Analytics solutions. But how do we ensure the code we build is reliable and the data is produced in a timely and trustworthy manner? Enter DataOps, a better way to develop and deliver Data Analytics Solutions. In this session, I’ll cover the concept of DataOps, why it matters to Power BI, and the principles that can drive you to continuously improve.
The video is not available to view online.
Learn the fundamentals of how to work within Git in this 20 minute session.
The video is not available to view online.
Cloud migration projects are often massive projects with sprawling scopes. Don't you want some help sorting through this enormous pile of work? Join an experienced cloud migration consultant for a targeted walkthrough of their cloud migration success checklist so you can make sure your project gets off to a good start and reaches a successful completion.
The video is not available to view online.
Want to avoid downtimes or big blocking operations when managing indexes on busy systems? In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.
The video is not available to view online.
Data integrity is a huge concern for every business, especially when it comes to protecting your company's most valuable information and Azure SQL Ledger can be the way to go.
The video is not available to view online.
Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.
The video is not available to view online.
Microsoft Defender for SQL is part of the Azure Defender family and it protects SQL Server in two main ways. We'll cover the first way, Advanced Threat Protection. This is a feature with advanced security capabilities that detect anomalous activities that might access or exploit sql server, like SQL Injection.
The video is not available to view online.
So you’re the data person in your company and you need to look to the sky. Maybe you've been wanting to do it for a while, maybe it's a mandate coming from the top. What are the steps you need to think about? Where do you even start? What are the risks? How can you begin to wrap your head around all the different things you have to coordinate? Companies don't just need the IDEA that they should move to cloud, but a guide on how-to-do it. This session will not only give you that guide to get you going, but a foundation to take to your bosses to show just how awesome you really are.
The video is not available to view online.
Have you moved to a cloud database like Azure SQL Database and are having performance issues? While the Azure SQL services running in Azure are similar to SQL Server, they are key differences in performance tuning methodologies. In this session, you will learn about monitoring options, changes in cloud DMVs, and additional cloud tuning tools like Azure SQL Analytics and Performance Insights that can allow you quickly get to performance data across a number of instances. You will learn about what you need to keep in mind when choosing between scaling-out to readable secondaries and scaling-up to higher tier solutions. Discuss with Microsoft MVP Monica Rathbun the challenges and benefits of tuning, what to keep in mind, and what to expect in the cloud.
The video is not available to view online.
Want to use Query Store and not sure how to make sure everything is "correct"? Tried Query Store and had issues? In this session we'll cover what you MUST know to successfully use Query Store in a production environment.
The video is not available to view online.
Moving from traditional SQL Server to Azure SQL Database can be a challenge! There's already lots to think about before you make the move, but this session can help you with one of those considerations: What do I do with my old SQL Agent Jobs?
The video is not available to view online.
You should not have to wait for a spefic feauture to be secure. A lot of the security features are not limited to the latest versions. Let's go back in time and match modern day security features in a SQL version from way back when.
The video is not available to view online.
Security is given too little attention in the database environment and many times more rights are given than are necessary. Especially with CROSS DATABASE access, the goal is often overshot. Learn how to securely access data in other databases without breaking the bank.
The video is not available to view online.
How to provision, use, and monitor Synapse Link to SQL in order to bring on-premises SQL instances data into Azure Synapse Analytics
The video is not available to view online.
If you care about your database performance, then make sure you take care of your statistics. Join this session to learn why it is so important, and how to do it right.
The video is not available to view online.
In this session we’ll deep-dive into the link feature, a revolutionary new hybrid capability bridging the SQL Server and Managed Instance that provides the ultimate freedom of movement between the two. The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance. You don’t even need to migrate to the cloud to use it – remain running on your existing SQL Server and use the modern Azure services by offloading R/O workloads and analytics to the cloud. When ready to migrate, use it as the best possible minimum downtime migration option in Azure. Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.
The video is not available to view online.
In just 20 minutes you will see a demo of bidirectional database failover between SQL Server 2022 and Managed Instance, using the link feature. The feature provides never-before possible hybrid connectivity and near real-time database replication between SQL Servers 2016-2022 and Managed Instance, including industry’s first bidirectional data movement and online failover (Disaster Recovery) between SQL Server 2022 and SQL Managed Instance Need to move back from Azure to SQL Server on-premises, or anywhere else? No problem, use it all in reverse and replicate your online and near real-time from Managed Instance back to SQL Server 2022.
The video is not available to view online.
If you're getting started with an implementation using Infrastructure as Code, one of the first things to figure out is which tool to use. In this session will dive into the details of the differences of Bicep and Terraform to help you choose the best option for your scenario. We will begin the session by going through the similarities of Bicep and Terraform, but will then jump straight into the differences of these two tools. We will cover how state is handled, how configuration is scoped and how making changes is evaluated. Then we will go through how existing resources are handled and using preview features. At the end of this session you will be able to choose which tool is the best option for your implementation!
The video is not available to view online.
You know Microsoft handles patches and updates for your OS and SQL but what does that really mean? When does that maintenance occur, what might happen and do I have any control? Let's answer these questions and more in 20 minutes.
The video is not available to view online.
The video is not available to view online.
This session will explain why you should care and know about the checkpoint process and the different checkpoints that SQL Server does. I will show you exactly what happens during a checkpoint, how you can influence the interval of checkpoints, and changes made with checkpoint settings in SQL 2014 and SQL 2016+.
The video is not available to view online.
Azure Functions are great for a wide range of scenarios, including working with data on a transactional or event-driven basis. In this session, we'll look at how you can interact with Azure SQL, Cosmos DB, Event Hubs, and more so you can see how you can take a lightweight but code-first approach to building APIs, integrations, ETL, and maintenance routines.
The video is not available to view online.
. In this session, we will discuss some of the new capabilities introduced to get the most out of your databases, like Configurable Retry Logic to make your applications more resilient out-of-the-box, or various security-related improvements that have been added. We’ll also discuss new specific capabilities, like support for Azure SQL temporal tables in EF 6 and all the performance improvements that have been introduced.
The video is not available to view online.
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.
Welcome to Azure DevOps trio, a tale about how a development team and an operations team have to bond together and start using Azure DevOps for Data Platform deployments.
The video is not available to view online.
In this session we will give you an overview of Azure SQL availability and resiliency capabilities. You'll receive a deep dive on architectures, configurations, and our industry leading SLAs which will help you get the right level of availability and resilience your databases need.
The video is not available to view online.
You will be challenged with a case study to design a solution using Azure SQL Database capabilities. At the end of this session, you will better understand the possibilities to migrate on-premises databases to Azure SQL Database. You will learn how to synchronize data across different environments and get more insights on how to troubleshoot issues in Azure SQL Database. This is a hands-on, open discussions and team work kind of session (not a traditional slideshow).
The video is not available to view online.
In this session we will share how real-world customers are using Azure SQL in their solutions to store and query trillions of IoT events in near real-time.
The video is not available to view online.
An overview of VNets, Service Endpoints & Private Endpoints for Azure SQL DB & Managed Instance
Version control provides benefits beyond DevOps automation.
How to build a data platform in Azure
The video is not available to view online.
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.
<<1234>>