Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL ground to cloud to fabric. Bob has worked for Microsoft for 31+ years on every version ...

With all these configurations made sucessfully, the final part is running the script that gets the SQL Server Linked Servers passwords. I won't be going into detail at all in this final part, since ...

To ensure uptime, SQL Server 2022 is fully integrated with the new link feature in Azure SQL Managed Instance. With the new link feature for Azure SQL Managed Instance, you now get all the benefits of ...

So SQL Server on Linux is still a pretty significant undertaking. And, given the caveats I've outlined here, it's not clear that undertaking will pay off for Redmond. But let's not get too granular.

You can also use distributed transactions whenever there's SQL Server to SQL Server communication and changes will be made to data during the course of the transaction, often done via a linked server.

Using a connection to Azure Arc, which is part of the SQL Server 2022 setup process, on-premises users can now also opt for cloud-enabled billing to manage consumption spikes or for ad hoc use ...