Sites Microsoft


JDBC Driver 12.2 for SQL Server Released

Publié le 1 février 2023 sur MS Tech Community
 

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

Publié le 30 janvier 2023 sur MS Tech Community
 

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!

Publié le 26 janvier 2023 sur MS Tech Community
 

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

Publié le 26 janvier 2023 sur MS Tech Community
 

 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

Publié le 25 janvier 2023 sur SQL Server Blog
 

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

Publié le 24 janvier 2023 sur devblogs.microsoft.com
 

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?

Publié le 20 janvier 2023 sur devblogs.microsoft.com
 

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

Publié le 20 janvier 2023 sur MS Tech Community
 

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

Publié le 19 janvier 2023 sur MS Tech Community
 

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

Publié le 16 janvier 2023 sur MS Tech Community
 

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更新之网络,是你期待的吗?

Publié le 16 janvier 2023 sur devblogs.microsoft.com
 

最新的.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

Publié le 13 janvier 2023 sur MS Tech Community
 

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

Publié le 13 janvier 2023 sur MS Tech Community
 

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

Publié le 13 janvier 2023 sur devblogs.microsoft.com
 

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

Publié le 12 janvier 2023 sur SQL Server Blog
 

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 …


Pages :