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, …
SQL Backup using Azure File Share
SQL Backup is more than 12TiB, you can choose to backup using Azure File Share Standard file shares can span up to 100 TiB, however this feature is not enabled by default. If you need a file share that is larger than 5 TiB, you will need to enab …
JDBC Driver 11.2 for SQL Server Released
Version 11.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 11.2.0 brings several added features, changes, and fixed issues over the previous production release. **BREAKING CHANGE** Encrypt = strict There is one breaking …
ODBC Driver 18.1 for SQL Server Released
Version 18.1 of the Microsoft ODBC Driver 18 for SQL Server has been released. Version 18.1 brings several new features and fixes to the driver. Features New IpAddressPreference option: Choose preference between IPv6, IPv4, or OS defaults. …
Announcing Entity Framework 7 Preview 7: Interceptors!
Entity Framework Core 7 (EF7) Preview 7 has shipped with support for several new interceptors, as well as improvements to existing interceptors. This blog post will cover these changes, but Preview 7 also contains several additional enhancements, inclu …
Released: General Availability of Microsoft.Data.SqlClient 5.0
We have released for general availability Microsoft.Data.SqlClient 5.0. This .NET Data Provider for SQL Server provides general connectivity to the database and supports all the latest SQL Server features for applications targeting .NET, .NET Framework …
Establish digital trust in your data with ledger in SQL Server 2022
Part of the SQL Server 2022 blog series.We are pleased to introduce you to ledger, a new technology that uses the power of blockchain to offer a tamper-proof record of data modifications. Currently in Azure SQL, this feature is also part of the SQL Ser …
Azure Active Directory authentication for SQL Server 2022
Part of the SQL Server 2022 blog series.Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.Azure AD Authentication methods The new functionality extends …