SQL Server Management Studio (SSMS) 19.0 Released!
The long-awaited release of SQL Server Management Studio (SSMS) 19.0 is finally here! This is the recommended release for SQL Server 2022, and it includes support for combability level 160. You can review the entire list of n …
HPE SGLX – The new Azure VM extension for SQL Server on Linux
Overview Mission critical SQL Server instances have the need to utilize high availability and disaster recovery features to ensure business continuity. SQL Server on Linux supports HPE Serviceguard as one of the supported clusterin …
Azure Data Studio 1.41 release
We are less than one month into 2023 and already have a new release of Azure Data Studio to shareintroducing 1.41! With this release, we migrated to a new authentication library, made improvements based on user requests and feedback, and addressed a sl …
Azure Cosmos DB & Power BI Incremental Refresh
Abstract Data Collection has become a daunting task with the ever-growing amount of data. The growth of data makes reporting tasks an operational challenge due to the processing time requirements imposed by technical limitations in many business intel …
CTEs, Views or Temp Tables?
I’ve just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several comments there was the request to explain what is the difference between Common Table Expressions, Views and Temp Tables. This is qu …
Released: General Availability of Microsoft.Data.SqlClient 5.1
We have released for general availability Microsoft.Data.SqlClient 5.1. 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 …
Best practices assessment -Arc-enabled SQL Server
If you are a Database Administrator (DBA) and responsible for managing, securing, protecting, and governing hundreds of SQL Servers, you are not alone, we are here to help you with the Azure SQL Server built by Microsoft. Learn more. In thi …
SQL Server containers on Kubernetes with S3-compatible object storage – Getting started
One of the new features introduced with SQL Server 2022 is the ability to connect to any S3-compatible object storage and SQL Server supports both Backup/Restore and data lake virtualization with Polybase integration. In this blog, we will demons …
.NET 7更新之网络，是你期待的吗?
最新的.NET 7现已发布，我们想介绍一下其在网络领域所做的一些有趣的更改和添加。这篇博文讨论了 .NET 7 在HTTP 空间、新 QUIC API、网络安全和WebSockets方面的变化。 HTTP 改进了对连接尝试失败的处理 在 .NET 6 之前的版本中，如果连接池中没有立即可用的连接，（处理程序上的设置允许的情况下，例如HTTP /1.1中的MaxConnectionsPerServer，或 HTTP/2中的EnableMultipleHttp2Connections）新的 HTTP 请 …
Hotfix: JDBC Driver 10.2.3 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 10.2.3. The update addresses a few issues on top of the 10.2.2 release. Fixed issues Fixed incorrect update counts when timeout occurs in batch queries 202 …
Hotfix: JDBC Driver 11.2.3 for SQL Server Released
We recently released an update to Microsoft JDBC Driver for SQL Server, version 11.2.3. The update addresses a few issues on top of the 11.2.2 release. Fixed issues Fixed null SQL state and zero error code when database exception is thrown …
Development with SQL in containers on macOS
There are a bunch of tools available for developing with SQL on macOS, including the mssql extension for VS Code and the standalone yet-comfortably-familiar Azure Data Studio. As a developer, you might have heard about the Azure SQL Database emulator a …
Working with time series data in SQL Server 2022 and Azure SQL
Part of the SQL Server 2022 blog series.Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not time-based and may be updated often, time serie …
Released: SCOM Management Packs for Azure SQL Database, SQL Server, RS, AS (7.0.42.0)
Updates to Azure SQL Database, SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.42.0). You can download the MPs from the links below. Majority of the changes are based on your direct feedback. Thank you. …
Microsoft R Application Network retirement
In June 2021, we announced that Microsoft Machine Learning Server & Microsoft R Open will be retired on July 1, 2022. In continuation with the retirement process, the Microsoft R Application Network (MRAN) website and CRAN Time Machine will be reti …