SQL Server 2022 Release Candidate 0 is now available on Linux
Following our release cadence, we are pleased to announce the release of SQL Server 2022 Release Candidate 0 (RC 0) for Linux. To download the latest RC 0 container images, please use the ‘2022-latest’ tags for both RHEL and Ubuntu based c …
Deploy Always On Availability Groups (AG) on SQL Server RHEL based Azure VMs – The Ansible Way!
One common comment I’ve heard at various conferences and customer interactions is, « setting up Always On availability groups (AGs) on pacemaker takes very long, has multiple steps and commands that need to be run, so sometimes it can be error prone, ca …
Get more out of SQL Server Reporting Services 2022 with an improved user experience
Part of the SQL Server 2022 blog series.SQL Server 2022 introduces the new SQL Server 2022 Reporting Services (SSRS).OverviewAt Microsoft, we understand the power of technology, and that is why we continue to innovate, create, and design in a …
Released: Microsoft.Data.SqlClient 2.1.5
We have released an update to Microsoft.Data.SqlClient, version 2.1.5. The update addresses a few issues that are important to our customers. Updates in Microsoft.Data.SqlClient 2.1.5 include: Fixed Added CommandText length validation whe …
HOW IT WORKS: dm_os_ring_buffer vs XEvent *_ring_buffer_reported events
Many of the sys.dm_os_ring_buffer entries support matching XEvent (security_error, resource_monitor)_ring_buffer_reported events. For example: How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me? – Microsoft Tech Community outlines …
Updates to the modern servicing model for SQL Server 2017 and future versions of SQL Server on Linux
We would like to announce the recent change made to the Announcing the Modern Servicing Model for SQL Server – Microsoft Tech Community that applies for SQL Server on Linux/Container releases only. We are moving forward with a …
Azure Data Studio August Release
Thank you to Erin Stellato (Program Manager, SQL Experiences) and Drew Skwiers-Koballa(Program Manager, SQL Experiences) for contributing to this blog.The end of summer in the Northern Hemisphere can be a quiet time for some, but the Azure Da …
SQL Server 2022 Release Candidate 0 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Release Candidate 0. Since the first public preview in May 2022, anyone can download SQL Server 2022 RC0 to try the new features in this release. …
New granular permissions for SQL Server 2022 and Azure SQL to improve adherence with PoLP
In the last 3 years, the SQL Security team has put more emphasis on enabling customers to use SQL Server while adhering to the Principle of least Privilege (PolP). As part of that effort, all new features in the next SQL Server release: SQL Server 2022 …
Register today—Free Azure Data training at Data Platform Summit 2022
Data Platform Virtual Summit 2022 (DPS 2022) is just a few weeks away, running from September 1923. A free global learning event for data professionals, DPS 2022 features a keynote from Bob Ward (Principal Architect, Microsoft) and Buck Woody (Applied …
Query Store is enabled by default in SQL Server 2022
Part of the SQL Server 2022 blog series.Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database workloads.The Query Store feature first became available …
Azure Cosmos DB SQL Studio is a Hidden Gem!
This post was authored by Microsoft MVP and Azure Cosmos DB community champion Hasan Savran. You can reach Hasan (@SavranWeb) on Twitter. Azure Cosmos DB Core (SQL) API has many features that can help you with your cloud projects in Microsoft Azure. …
Released: Microsoft.Data.SqlClient 3.1.1
We have released an update to Microsoft.Data.SqlClient 3.1, version 3.1.1. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 3.1.1 include: Fixed Fixed null SqlBinary as rowversio …
Cumulative Update #17 for SQL Server 2019 RTM
The 17th cumulative update release for SQL Server 2019 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 …
Microsoft Purview access policies for SQL Server 2022
Part of the SQL Server 2022 blog series.OverviewMicrosoft Purview is a family of data governance, risk, and compliance solutions that help organizations:Gain visibility into data assets across your organization. Data assets can be across data centers, …