The one and only Brent Ozar where he writes & tests T-SQL scripts in Microsoft SQL Server on a livestream.
Github repo: http://FirstResponderKit.org
Are you prepared if a tornado filled with sharks destroys your primary data center?
Sure, you may have backed up your databases, but what about logins, agent jobs or extended events?
In this episode of Data Exposed, join Chrissy LeMaire as she demos how disaster recovery can be simplified using the SQL Community’s SQL Server PowerShell module, dbatools.
Running SQL Server on Azure Virtual Machines provides a suite of free manageability capabilities that are available only on Azure, and which make it easier to run in a cost-effective, secured, and optimized manner.
As a SQL Server customer, you can migrate your SQL workloads to SQL Server on Azure Virtual Machines while making the most of your current SQL Server license investments and benefit from the manageability benefits that SQL Server virtual machines offer today.
In this episode with Amit Banerjee, learn why running SQL Server on an Azure virtual machine provides the best lift-and-shift experience for workloads where OS-level access is required.
In this episode with Amit Banerjee, review new Software Assurance core benefits for high availability and disaster recovery can make running SQL Server on Azure virtual machine cheaper than before.
Resources:
Azure Data Factory is an amazingly powerful tool that can accomplish just about every ETL/ELT task.
In this video, Frank Liu shows how to use the Get Metadata activity to get a list of file names.
In this episode with Jean-Yes Devant, learn about Azure Arc enabled PostgreSQL Hyperscale and see an overview of its capabilities.
Database backups are an essential part of any business continuity and disaster recovery strategy because they protect your data from corruption or deletion.
In this episode of Data Exposed with Uros Milanovic, he’ll share the two types of backups for restoring databases for Azure SQL customers, why database backups are important, how backups are kept, what options customers have, and much more.
Related Resources:
In this episode of Data Exposed with Sasha Nosov, learn how Azure Arc allows you to leverage Azure Services for your existing database applications hosted on-premises or in other public clouds, without changing or even stopping them.
Content & Time Stamps:
- 0:00 Introduction
- 0:45 What is Azure Arc
- 2:30 About Azure Arc Enabled SQL Server
- 3:03 Architecture of Azure Arc Enabled SQL Server (Public Preview)
- 8:09 Environment Health Demo
- 13:18 Azure Arc Enabled Data Services vs Azure Arc Enabled SQL Server
- 17:00 What versions of SQL Server are supported
- 17:45 Getting started & registering for Azure Arc enabled SQL Server
Learn the differences between the Basic, Standard, and Premium tiers of Azure SQL Single Database.
Provisioning is one component of maximizing the value of your deployment – licensing is another.
In this video with Matt Gordon, take a walk through the differences between licensing by DTU and by vCore and talk about what may be right for you and your needs.
Linked servers enable the SQL Server and Azure SQL Database Managed Instance to read data from remote data sources and execute commands against the remote database servers.
In this video, Anna Thomas and Colin Murphy go over configuring linked servers in Azure SQL Database Managed Instance.
At the end, Anna briefly mentions creating a linked server to the readable secondary replica for read-heavy workloads.