dbcc dumptrigger: Capture a dump for specific error and state
I had an inquiry about dbcc dumptrigger today and realized that state filtering was added to dbcc dumptrigger but not well known. You can collect a process dump (SQL Dumper) when a specific error occurs using XEvent (error_reported/ex_raise2 eve …
Microsoft SQL Server on Ubuntu pro-The preferred choice for deploying SQL Server on Ubuntu in Azure!
Today, you can deploy SQL Server on Ubuntu based Azure virtual machines (VMs) in one of the three ways: Option 1: Use the pre-configured Microsoft SQL Server on Ubuntu Pro Azure marketplace image for the Azure virtual machine(VM) creation. Optio …
Revamped SQL Permission system for Principle of Least Privilege and external policies – internals
The article is published here on the Azure SQL Blog: Revamped SQL Permission system for Principle of Least Privilege and external policies – internals Hierarchical SQL permissions
Ledger – Automatic digest upload for SQL Server without Azure connectivity
Ledger is a new feature that offers the power of blockchain in Azure SQL Database and SQL Server 2022. We’re making the data in the SQL database verifiable using the same cryptographic patterns seen in blockchain technology, while keeping the flexibili …
Azure Synapse Link for SQL
Near-real-time analytics for transactional workloadsPart of the SQL Server 2022 blog series.Traditionally, data to serve analytical systems have been extracted from operational data stores using custom-built extract, transform, and load (ETL) proc …
Cumulative Update #31 for SQL Server 2017 RTM
The 31st cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that Cumulative Update 31 is the last cumulative update for Microsoft SQL Server 2017. SQL Server 2017 is transitioned …
Antipatterns on Azure Cosmos DB
This post was authored by Microsoft MVP and Azure Cosmos DB community champion Blaize Stewart. You can reach Blaize (@theonemule) on Twitter. Software developers of all kinds love patterns. They give us reusable ideas that can be applied in many diffe …
Intelligent Query Processing: feature family additions
Part of the SQL Server 2022 blog series.SQL Server 2022 introduces a handful of new members to the growing Intelligent Query Processing (IQP) family. These additions range from expanding and improving various query performance feedback mechanisms …
Released: Microsoft.Data.SqlClient 4.0.2
We have released an update to Microsoft.Data.SqlClient, version 4.0.2. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 4.0.2 include: Fixed Fixed connection failure by not requi …
Announcing Entity Framework 7 Release Candidate 1
Entity Framework Core 7 (EF7) Release Candidate 1 has shipped! The team focused on addressing defects, minor enhancements, and putting the finishing touches on features. See the full list of EF7 RC1 changes on GitHub. For a detailed look at what’s new …
Released: Microsoft.Data.SqlClient 4.1.1
We have released an update to Microsoft.Data.SqlClient, version 4.1.1. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 4.1.1 include: Fixed Fixed connection failure by not requi …
Released: Microsoft.Data.SqlClient 4.1.1
We have released an update to Microsoft.Data.SqlClient, version 4.1.1. The update addresses several issues that are important to our customers. Updates in Microsoft.Data.SqlClient 4.1.1 include: Fixed Fixed connection failure by not requi …
Hotfix: JDBC Driver 11.2.1 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.1. The update addresses a couple issues in the 11.2.0 release. Fixed issues Made com.microsoft.azure:msal4j an optional dependency again 1893 Fixed qu …
Query Store hints 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, and we have continued to make investments in …
Load and visualize Covid-19 case data with the integrated Power BI experience
How have major cities like London and New York been affected by Covid-19 and how can we use historical data to explore how these effects might impact us in a post-Covid world? This was the question posed at a Microsoft Data + AI Hackathon held in part …