Remove Article Remove Availability Remove Code Remove Servers
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. In this article, I focus on the distinct predicate and the approximate percentile functions. The DATETRUNC function. So far so good.

Servers 142
article thumbnail

T-SQL Windowing Improvements in SQL Server 2022

SQL Performance

Microsoft recently released the first public preview of SQL Server 2022. In this article I focus on windowing and NULL-related improvements. I’ll be using the sample database TSQLV6 in the examples in this article. This release has a number of T-SQL improvements. You can download this sample database here.

Servers 145
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. But the available manipulation was limited and often resulted in complicated logic.

Servers 122
article thumbnail

In Defence of DOM­Content­Loaded

CSS Wizardry

Honestly, I started writing this article, for no real reason and somewhat without context, in December 2022—over half a year ago! TTFB is a good measure of your server response times and general back-end health, and issues here may have knock-on effects later down the line (namely with Largest Contentful Paint).

Metrics 326
article thumbnail

High Availability vs. Fault Tolerance: Is FT’s 00.001% Edge in Uptime Worth the Headache?

Percona

With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

article thumbnail

Fully automatic code level monitoring and extended version support for AIX

Dynatrace

Fully automatic deep code monitoring module injection. One of the unique strengths of Dynatrace OneAgent is the fully automated injection of the deep code monitoring module on Windows and Linux. Fully automated deep code monitoring module injection is available for all customers as of OneAgent version 1.175.

Code 129
article thumbnail

Detect VMware Aria Operations for Logs exploitation with Dynatrace and DQL

Dynatrace

Tracked as CVE-2023-34051 (CVSS score: 8.1), the Aria Operations for Logs vulnerability relates to a case of authentication bypass that could lead to remote code execution. They have made a PoC for the vulnerability available and published the relevant indicators of compromise (IoC). Spoof the IP address of the known worker.

Analytics 267