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

Open Dashboard and Visualization Workshop: Introduction and Installing Perses

DZone

Back in December of 2022, I started a series taking you on a tour of the Perses project. Monitoring applications goes way beyond just writing and deploying code, especially in the cloud-native world. These articles covered this fairly new open dashboard and visualization project targeting cloud-native environments.

Cloud 296
article thumbnail

New Bit Manipulation Functions in SQL Server 2022

SQL Performance

Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. But the available manipulation was limited and often resulted in complicated logic. But the available manipulation was limited and often resulted in complicated logic. The new functions and operators are as follows: GET_BIT function. SET_BIT function.

Servers 122
article thumbnail

Research in Action names Dynatrace the overall AIOps leader in 2022 Vendor Selection Matrix™

Dynatrace

Research in Action (RIA), a leading independent research and consulting company, named Dynatrace the overall leader in its 2022 Vendor Selection Matrix™ for AIOps Platforms. PurePath automatically analyzes transactions from browsers all the way down to the code and database levels. AIOps is a capability within observability.

Strategy 130
article thumbnail

The Ultimate Guide to Database High Availability

Percona

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. This guide provides an overview of what high availability means, the components involved, how to measure high availability, and how to achieve it. How does high availability work?

article thumbnail

Site reliability done right: 5 SRE best practices that deliver on business objectives

Dynatrace

Keeping pace with modern digital transformation requires ensuring that applications are responsive, resilient, and always available amid increased complexity. surpassed $387 billion in 2022, more than double the figure of three years earlier. As a result, site reliability has emerged as a critical success metric for many organizations.