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 allows you to shorten your code by avoiding the repetition of identical parts of your window specifications. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher.

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.

Trending Sources

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. Querying the current session’s state of session options with the @@OPTIONS function.

Servers 122
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. A remote code execution vulnerability is a cyberattack an attacker can remotely execute commands on a user’s computing device.

Java 229
article thumbnail

Digesting 2022

O'Reilly

In reality, 2022 has been a fantastic year for AI. GitHub CoPilot also wasn’t new in 2022, but in the last year we’ve heard of more and more programmers who are using ChatGPT to write production code. Nobody owns it; nobody controls it, though individuals control specific servers. It isn’t just people “kicking the tires.”

article thumbnail

OneAgent release notes version 1.231

Dynatrace

Rollout starts January 10, 2022. Impact : This issue affects only those extensions that use native libraries called from Python code distributed with the extension. The following operating systems will no longer be supported starting 01 March 2022. Windows: Windows Server 2004. Windows: Windows Server 1903.

article thumbnail

Mega List of Updates, Bug Fixes, New Features! Release Roundup December 12, 2022

Percona

Today’s post includes those releases and updates that have come out since November 28, 2022. On December 1, 2022, we released Percona Distribution for PostgreSQL 12.13. was released on December 8, 2022. Percona Distribution for MySQL 8.0.30 (PS-based variant) was released on November 29, 2022. Take a look!