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.
Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you? Let's jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work!
The video is not available to view online.
After this session, you will be able to conceptualize and implement different Power BI refresh scheduling patterns in ADF/Synapse. You’ll learn what limitations in Power BI you can overcome with an “external” orchestration tool as well as the different building blocks available. Finally, we will go through an example implementation as well as a step-by-step demo of how you can set this up yourself.
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.
Misconfigurations and default settings in your virtual machine base SQL Server environment can be causing you the performance issues you are having. Learn what you need to build to design and build a high performance virtual machine environment for your SQL Server.
The video is not available to view online.
Why do you need subnets? What addresses can we use? And what is the difference between a /16 and a /24 subnet anyway? Virtual Networks and subnets can be daunting in Azure, yet they are fundamental to so many resource types. In this session we'll cover everything you need to know to get started with creating your own virtual network are carving it up into subnets of various sizes to meet your needs. So next time you need to create a subnet to join your Azure SQL VM to, you'll know exactly how to plan for this and implement accordingly.
The video is not available to view online.
An overview of the performance enhancing Intelligent Query Processing features in SQL Server 2019 as well as including some new SQL Server 2022 items,
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.
In this session, I will discuss five common myths about SQL Server backup and demo each to show you the correct answer.
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.
How can we test potential weaknesses in SQL Server? In this session we will explore the concept of Chaos Engineering, its core concepts, and the methodologies behind it.
The video is not available to view online.
Improve analytic queries by unlocking the secrets of columnstore compression!
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.
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.
Database refactoring could be tricky sometimes. To learn more about it come to my session, where I will tell you about different situations and scenarios I've came across during the last 10 years. I will share my experience; traps, you easily can get into, and what solutions did I choose to come over it.
The video is not available to view online.
We cloud solutions architects from Microsoft, will be demonstrating all the use cases with demos of the newly available (currently in public preview) Azure SQL Managed Instance Link. We will talk about all the available migration tools like DMA, DMS, Azure Migrate, ADS and why you may want to use MI Link to migrate on-prem SQL Server to Azure SQL Managed Instance as compared to other available migration tools.
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.
Let's take a look at Synapse Link - it's capabilities and restrictions! Synapse Link is Microsoft's new solution to push your OLTP data in near-real time to Azure Synapse for analytical purposes.
The video is not available to view online.
Panel Discussion moderated by Richard Campbell of RunAs Radio!
The video is not available to view online.
We'll provide a balance perspective of the benefits and limitations of the new Parameter Sensitive Plan Optimization feature in SQL 2022 to help you decide if it's right for your environment.
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.
Using dbatools we'll migrate our databases to a shiny new SQL Server 2022 instance.
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.
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.
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.
In this expert session we unveil the magic of CI/CD for SQL Server updates using GitHub Actions.
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.
The CIS Benchmarks, from the Centre of Internet Security (CIS), are a set of globally recognized and consensus-driven best practices to help us implement and manage our cybersecurity defences. In this 20-minute session, listen to David and Gethyn discussing these best practices, see if you agree with them, and see how many you have implemented.
The video is not available to view online.
In this session, we'll be looking at all the various places within the application stack that data can be encrypted or hashed, so that as an application/database administrator/developer/architect you can make the best decision as to where in the application stack to do this work.
The video is not available to view online.
Join me on a journey through the different offerings in Azure Arc and how they can benefit you as a data professional!
Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
Come get your questions answered live on stage by members of the Microsoft engineering team. This will be a fun and interactive session hosted by Bob Ward. We will take questions live from the audience plus those who are connected virtually.
Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming next in this new intelligent database world with SQL Serevr 2022 and Azure SQL!
The video is not available to view online.
Version control provides benefits beyond DevOps automation.
Are you trying to increase uptime locally or for disaster recovery but your network is terrible? Join the club. This session will discuss different techniques, their pros and cons, as well as considerations for availability when your network is flaky at best.
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.
Automate checking your database security model
Join us for the session where we discuss the best approaches to database monitoring including how organizations can better collaborate to isolate issues & optimize experiences by centralizing and correlating metrics across your entire database stack.
The video is not available to view online.
Learn how to and why you should protect your data with Row Level Security in SQL Server and Power BI.
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.
Learn how enhancements to the SQL Server optimizer improve performance without code changes.
SQL Server 2022 is here! In this session, I’ll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability including SQL Server Ledger and Intelligent Query Processing.
In this Session MVP Frank Geisler and first time speaker Timur Dudhasch will give an introduction to Bicep for the Cloud DBA. As more and more systems are migrated to the cloud and as the sheer number of systems rises continuously Frank and Timur will demonstrate how to ease the process of creating and maintaining resources in the cloud via bicep
One of the best ways to learn is through visualizations. In this session I'll teach you how to learn various aspects of SQL, ground to cloud, through architectures. We will cover scenarios including HADR, security, and scale using architecture design patterns across SQL Server, Azure SQL, and Azure Arc including new ways to attach SQL Server 2022 to Azure.
The video is not available to view online.
The video is not available to view online.
In this session, you will learn where data lives in a computer system, and the key performance metrics used to understand the health and performance of your storage subsystem.
Come learn about all the latest innovations for SQL Server 2022 and Azure SQL directly from the Microsoft engineering team. This 2-part session will go into some detail for some of the new scenarios planned for Microsoft's flagship RDBMS.
The video is not available to view online.
<<12>>