article thumbnail

T-SQL Windowing Improvements in SQL Server 2022

SQL Performance

Microsoft recently released the first public preview of SQL Server 2022. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. 10835 1 2022-01-15 17 845.80 10952 1 2022-03-16 18 471.20 11011 1 2022-04-09 60 933.50

Servers 145
article thumbnail

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. 11050 2022-05-05 11055 2022-05-05 11063 2022-05-06 11067 2022-05-06 11069 2022-05-06 (809 rows affected).

Servers 142
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

New critical vulnerability, CVE-2022-42889, in Apache Commons Text discovered (but no need to panic)

Dynatrace

A new critical remote code execution (RCE) vulnerability was disclosed on October 13, 2022. While some view CVE-2022-42889 as the next Log4Shell vulnerability , others see its impact as more limited. CVE-2022-42889 not as critical as Log4Shell. url” to load values from remote servers via URLs. Starting with version 1.5,

Java 246
article thumbnail

Kubernetes in the wild report 2023

Dynatrace

Kubernetes moved to the cloud in 2022. Kubernetes moved to the cloud in 2022. In 2022, Kubernetes became the key platform for moving workloads to the public cloud. Likewise, the share of cloud-hosted clusters increased from 31% in 2021 to 45% in 2022. But in 2022, this picture reverses.

article thumbnail

New Bit Manipulation Functions in SQL Server 2022

SQL Performance

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. Instead, starting with SQL Server 2022 you simply use the SET_BIT function.

Servers 122
article thumbnail

OneAgent release notes version 1.241

Dynatrace

Rollout starts June 8, 2022. The following operating systems will no longer be supported starting 01 July 2022. Windows: Windows Server 2004. The following operating systems will no longer be supported starting 01 August 2022. The following operating systems will no longer be supported starting 01 October 2022.

Java 236
article thumbnail

OneAgent release notes version 1.231

Dynatrace

Rollout starts January 10, 2022. The following operating systems will no longer be supported starting 01 March 2022. The following operating systems will no longer be supported starting 01 April 2022. The following operating systems will no longer be supported starting 01 July 2022. Windows: Windows Server 2004.