SQL Server

News and technical articles about Microsoft’s SQL Server

How SQL developers can maximize savings

Whether you build applications for SQL Server on-premises or in Azure, there are several options for you to develop or test for free, or with substantial cost savings. Some of these options you may be familiar with, but this post will help explain details and answer some questions Microsoft often gets to provide you a […]

How SQL developers can maximize savings Continue Reading

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

5 reasons to join us at Securely Migrate and Optimize with Azure

Did you know you can lower operating costs by 40 percent1 when you migrate Windows Server and SQL Server to Azure versus on-premises? Furthermore, you can improve IT efficiency and operating costs by 53 percent by automating management of your virtual machines in cloud and hybrid environments2. To maximize the value of your existing cloud investments,

5 reasons to join us at Securely Migrate and Optimize with Azure 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