SQL Server on Azure VMs – the best price-performance gets even better!
I know it’s February, but it’s our first blog post of the year and we’re still feeling festive so Happy New Year from the SQL Server on Azure VM team!!! As we reflect on the past year and look toward what’s to come in 2023, we thought it would be a gre …
JDBC Driver 12.2 for SQL Server Released
Version 12.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 12.2.0 brings several added features, changes, and fixed issues over the previous production release. Added Added connection property datetimeParameterType to sp …
Microsoft Drivers 5.11.0 Beta 1 for PHP for SQL Server Released
We recently released the next beta of the Microsoft Drivers for PHP for SQL Server, version 5.11.0-beta1. This beta release has been built with PHP 8.0+ and tested on all supported platforms. Notable items about this release over 5.10.0 include: …
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 …