SQL Server 2017 で導入された日本語照合順序を利用する環境での注意点
＊この記事は、SQL Server で日本語の照合順序を利用している方に向けた情報となりますので、日本語でのみ公開しております。 ＊This article is for the user using japanese collation of SQL Server.Hence we publish the article in japanese only. こんにちは、SQL Server サポートチームです。 今回は SQL Server 2017 で導入された以下の …
Data Virtualization with PolyBase for SQL Server 2022
Part of the SQL Server 2022 blog series.Microsoft SQL Server 2022 introduces the newest version of PolyBase, and with it the capability to query data where it lives, virtualize data, and use REST APIs. REST APIs enable SQL Server to be both more f …
Azure Synapse Link support for Azure Cosmos DB Gremlin API now in preview
Azure Cosmos DB’s Gremlin API combines the power of graph database algorithms with highly scalable, managed infrastructure to provide a unique, flexible solution to most common data problems associated with lack of flexibility and relational approaches …
SQL Server 2022 Release Candidate 1 is now available on Linux
Continuing with our release cadence, we are pleased to announce the release of SQL Server 2022 Release Candidate 1 (RC 1) for Linux. To download the latest RC 1 container images, please use the ‘2022-latest’ tags for both RHEL and Ubu …
HADR_SYNC_COMMIT Wait Updates (In Progress)
A HADR_SYNC_COMMIT wait occurs when the session is waiting for a transaction to commit or rollback when the database is part of a Database Availability Group (High Availability.) A transaction is considered committed when hardened (written) to t …
SQL Server 2022 Release Candidate 1 is now available
Continuing with our release cadence, we’re excited to announce the release of SQL Server 2022 Release Candidate 1. Since the first public preview in May 2022, anyone can download SQL Server 2022 RC1 to try the new features in this releas …
Backup and restore to URL for S3-compatible object storage
Part of the SQL Server 2022 blog series.Backup and restore to simple storage service (S3)compatible object storage is a new feature introduced in SQL Server 2022 that grants the user the capability to back up or restore their databases using S3-co …
Cumulative Update #18 for SQL Server 2019 RTM
The 18th 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 …
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 …