SQL Server 2022 community technology preview 2.1 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Community Technology Preview 2.1. Since the first public preview in May 2022, anyone can download SQL Server 2022 CTP2.1 to try the new features in …
Azure Data Studio July Release with VS Code Updates
Hello, community! As you may already know, Azure Data Studio (ADS) is and has always been focused on building out its own ecosystem of extensions and customized tabs for handling databases, using the UI framework of Visual Studio (VS) Code. As a result …
Improve scalability with system page latch concurrency enhancements in SQL Server 2022
Part of the SQL Server 2022 blog series.Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database. In SQL Server 2022 we are addressing one of the last areas of contention by introducing co …
Cumulative Update #30 for SQL Server 2017 RTM
The 30th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …
Upcoming updates to SQL Server container images on Microsoft Artifact Registry aka (MCR)
As you may be aware, SQL Server container images are published and available on the Microsoft Artifact Registry (aka MCR or Microsoft Container Registry). To know more, please see Overview of SQL Server on Linux – SQL Server | Microsoft Docs. When …
ODBC Driver 17.10 for SQL Server Released
Version 17.10 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.10 brings a few changes and several fixes to the driver. Changes Support for Ubuntu 22.04 Support for Red Hat 9 TrustedConnection_UseAAD option – …
Announcing Entity Framework Core 7 Preview 6: Performance Edition
Entity Framework 7 (EF7) Preview 6 has shipped and is available on nuget.org. Keep reading for links to individual packages. This blog post will focus on optimizations to update performance; for the full list of EF7 Preview 6 enhancements, see this pag …
Analysis Services and Reporting Services extensions for Visual Studio 2022 are here!
We’re happy to announce the popular and long-awaited Analysis Services, RDLC Report Designer, and Reporting Services extensions are available for Visual Studio 2022! Here’s how these Microsoft extensions for SQL Server can further enhance your busines …
SQL Server 2012 reaches end of support and Microsoft is here to help
Today, July 12, 2022, marks the end of support for SQL Server 2012. This version has had an amazing 10-year run and we want to thank our customers for your investment in learning and using Microsoft SQL Server. Looking forward, there are four great opt …
Difference in handling config file changes between SSRS 2017 and SSRS 2019
This article discusses the differences in handling Config file changes between SSRS 2017 and SSRS 2019. While implementing a Custom Deployment in SSRS using a custom Data Extension and modifying the SSRS config files to add the extension, prior …
拡張セキュリティ更新プログラム (ESU) について
こんにちは、 SQL Server サポートです。 今回は、SQL Server サポート期間とサポート終了後の拡張セキュリティ更新プログラム (ESU)について紹介します。 [SQL Server サポート期間について] SQL Server に関するサポートをご利用いただく際に注意する点として、SQL Server のバージョンごとのサポート期間があります。 １つの製品にはメインストリームサポートの期間と延長サポートの期間があります。 メインストリームサ …
Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022
This blog post is part of the SQL Server 2022 blog series.Buffer Pool Parallel Scan is a new feature in SQL Server 2022 that improves the scalability of several common scenarios in SQL Server and as a result, could significantly improve the performance …
How to enable and run SQL best practices assessments on multiple SQL Servers on Azure VMs
You can evaluate your SQL Server on Azure VM for configuration best practices using SQL best practices assessment feature on Azure portal. GA announcement post explains how to use this feature using Azure portal. In this post, we’ll talk about how to e …