article thumbnail

Leveraging Infrastructure as Code for Data Engineering Projects: A Comprehensive Guide

DZone

However, with the emergence of Infrastructure as Code (IaC) practices, data engineers can now automate infrastructure provisioning, deployment, and management, ensuring reliability, scalability, and reproducibility.

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
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

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
article thumbnail

A Gentle Intro to eBPF

DZone

In this short article, we’ll explore eBPF (Extended Berkeley Packet Filter), an exciting new technology that makes programming the kernel flexible, safe, and accessible to developers. TLDR eBPF is a mechanism that makes the kernel dynamically programmable without modifying the source code.

Internet 195
article thumbnail

SQL Server Stored Procedure Recompilation Factors

SQL Shack

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90
article thumbnail

Scalar UDF Inlining in SQL Server 2019

SQL Shack

In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.

Servers 107
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 130