SQL Server Archives | Argon Systems

Power what’s next with limitless relational databases from Azure

At Microsoft, we’re seeing firsthand how data is powering incredible innovation and accelerating more than just a platform shift, it is changing the way we do everything. AI and generative AI are not futuristic abstract concepts, they are being deployed by millions every day, transforming every industry. Tapping into the full potential of that opportunity requires …

Power what’s next with limitless relational databases from Azure Continue Reading

Protect SQL Server 2014 workloads with Azure flexibility

SQL Server has brought reliability and security to mission-critical workloads for 30 years. SQL Server 2022, released November 2022, delivers performance enhancements as well as Azure connectivity for disaster recovery, analytics, and governance. Now customers like Mediterranean Shipping Company (MSC) are using SQL Server 2022 to expand their capabilities to better support a truly worldwide …

Protect SQL Server 2014 workloads with Azure flexibility Continue Reading

Capitalize on your investments with the new centrally managed Azure Hybrid Benefit for SQL Server

Introducing the new centrally managed Azure Hybrid Benefit for SQL Server. Today, Microsoft is pleased to announce the release of centrally managed Azure Hybrid Benefit for SQL Server, a new Azure portal feature that helps you improve SQL Server license management at multiple levels, including at account(s) and subscription levels, so you can ensure you …

Capitalize on your investments with the new centrally managed Azure Hybrid Benefit for SQL Server Continue Reading

Accelerated Database Recovery enhancements in SQL Server 2022

Part of the SQL Server 2022 blog series. We are excited to share that there are several Accelerated Database Recovery (ADR) enhancements in SQL Server 2022 that further improve the overall availability and scalability of the database, primarily around persistent version store (PVS) cleanup and management. Overview of Accelerated Database Recovery (ADR) ADR improves database availability, …

Accelerated Database Recovery enhancements in SQL Server 2022 Continue Reading

SQL Server 2022: Intel® QuickAssist Technology overview

Part of the SQL Server 2022 blog series. In SQL Server 2008 Enterprise Edition, backup compression was introduced addingWITH COMPRESSION as an option in the T-SQL backup command. SQL Server backup compression provides the compressed backup option for all streaming SQL Server backup typesfull, differential, and transaction log. Using the metadata in the backup file …

SQL Server 2022: Intel® QuickAssist Technology overview Continue Reading

Easily migrate SQL Server applications to the cloud with Azure

Microsoft Azure knows SQL Server best and will support your cloud migration at no cost for qualifying scenarios. The SQL Server platform has been successfully driving transformative business results with Microsoft customers across industries for over 25 years, enabling breakthrough innovation through unique capabilities like industry-leading performance1 and security built-in. Microsoft’s continuous investments in SQL …

Easily migrate SQL Server applications to the cloud with Azure Continue Reading

Azure Data Studio 1.41 release

We are less than one month into 2023 and already have a new release of Azure Data Studio to shareintroducing 1.41! With this release, we migrated to a new authentication library, made improvements based on user requests and feedback, and addressed a slew of existing issues that had been logged by usersincluding some that were …

Azure Data Studio 1.41 release Continue Reading

Working with time series data in SQL Server 2022 and Azure SQL

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not time-based and may be updated often, time series data is typically written once and rarely, if ever, updated. Some …

Working with time series data in SQL Server 2022 and Azure SQL Continue Reading

Cardinality Estimation Feedback in SQL Server 2022

Part of theSQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptionsknown as the model. The model determines …

Cardinality Estimation Feedback in SQL Server 2022 Continue Reading

New SQL Server on Azure Virtual Machines and Azure SQL Managed Instance DR benefits

Customers who are running their SQL Server workloads using SQL Server on Azure Virtual Machines and Azure SQL Managed Instance are now eligible for new high availability (HA) and disaster recovery (DR) benefits. These are in addition to existing HA/DR benefits that are explained in detail in the SQL Server licensing materials and this previously …

New SQL Server on Azure Virtual Machines and Azure SQL Managed Instance DR benefits Continue Reading