Check out Part 2 of this interview, where we focus more on on-premises SQL Server.We discuss how these processes have improved the engineering process, and how Microsoft is focusing on the ...

SQL Server 2022 also features integration with Azure Purview, which assures that the cloud-based data governance platform encompasses SQL Server data, bringing data stored on-premises into its ...

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 cases.

Pairing your on-prem SQL Server with a cloud-based instance for high availability has its challenges, but they can be overcome. Here’s how.

The SQL Server technology family's innovations extend beyond the "box product" (i.e. on-premises SQL Server), though. For example, Microsoft is bringing Azure SQL Database Managed Instance to ...

Azure SQL Managed Instance General Purpose is "a tier of Microsoft's relational database service, based on SQL Server, that operates like an on-premises SQL Server instance," Snodgrass explained ...

These tools have been supplanted entirely by other tools on the Azure data platform. But they are still useful for on-prem SQL Server databases from version 2000 to 2012. They are deprecated for ...

In early November 2021, Microsoft announced the private preview of its flagship database product, SQL Server 2022. At some point in 2022, we will see SQL Server 2022 released as a general availability ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.