SQL Performance

AUGUST 1, 2022

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. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. You can download this sample database here.

Servers 142

Servers Testing C++ Code 142

O'Reilly

FEBRUARY 25, 2025

On April 24, OReilly Media will be hosting Coding with AI: The End of Software Development as We Know It a live virtual tech conference spotlighting how AI is already supercharging developers, boosting productivity, and providing real value to their organizations. You can find more information and our call for presentations here.

Code 84

Code Programming Servers Cloud 84

Scalegrid

JULY 13, 2020

The $47,500 licensing costs for Oracle Enterprise Edition is only for one CPU core, that ultimately has to be multiplied with the actual number of cores on the physical server. Oracle requires more complex ongoing administration, as all database configurations must evolve in conjunction with the data schemas and custom code.

Open Source 244

Open Source C++ Tuning Database 244

Dynatrace

JANUARY 25, 2020

Monitor, analyze, and boost customer experience on SAP C/4HANA and SAP Cloud Platform. Dynatrace is available for SAP Commerce Cloud (C/4HANA ) and for SAP Cloud Platform (SCP). Dynatrace infrastructure monitoring works for dozens of SAP customers in the monitoring of servers, networks, and cloud platforms.

Monitoring 219

Monitoring Performance C++ Infrastructure 219

Dynatrace

JUNE 1, 2022

As a result, C-level executives say that cloud environments have bolstered cybersecurity challenges. Further, software development in multicloud environments introduces multiple coding languages and third-party libraries. According to the Dynatrace CISO report, organizations still lack the insight they need to monitor this code.

Artificial Intelligence 245

Artificial Intelligence Java Cloud Strategy 245

Dynatrace

JULY 12, 2022

We are going to pull this server out of our load-balancer pool while Tlog subset jobs are running. IT automation speeds code development. To do so, organizations often succumb to a “hamster wheel” of having to release code more quickly to innovate effectively. We want to make sure we are evolving our code and fixing issues.”.

Innovation 246

Innovation Infrastructure DevOps Azure 246

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. The programming language C came in third place, averaging 20.0%

Strategy 182

Strategy Cloud Java Open Source 182

Dynatrace

AUGUST 29, 2024

While web technologies use the internet and HTTP for data transfer, enabling communication between web clients and servers, ADS-B relies on radio frequency broadcasts for direct, real-time communication. The ADS-B protocol differs significantly from web technologies.

IoT 264

IoT Analytics Transportation Metrics 264

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 OrderID , c. OrderID , c.

Servers 95

Servers C++ Testing Systems 95

Dynatrace

MAY 23, 2022

IDC predicted, by 2022, 90% of all applications will feature microservices architectures that improve the ability to design, debug, update, and use third-party code. Monolithic architecture is development where an application is built on a single codebase, and the code is unilateral. Server-side application. Easier to develop.

Architecture 263

Architecture DevOps Monitoring Programming 263

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 PSMDB), the best practice to create an index was doing it in a rolling manner. Many folks used to create directly on Primary, resulting in the first index being created successfully on Primary and then replicated to Secondary nodes. Starting from PSMDB 4.4, internal", "port" : 27017, "version" : "4.4.22-21",

Servers 98

Servers C++ Storage Best Practices 98

Percona

MARCH 13, 2023

There is a section in our Documentation ( Introduction to Serverless PostgreSQL ) and a short overview of the primary components: Page Server The storage server with the primary goal of storing all data pages and WAL records Safe Keeper A component to store WAL records in memory (to reduce latency). 6400'" -c "listen_http_addr='0.0.0.0:9898'"

Serverless 144

Serverless C++ Storage Servers 144

SQL Performance

AUGUST 12, 2020

You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. T-SQL supports it starting with SQL Server 2005. What’s different about the design of CTEs compared to derived tables is where in the code these three elements are located. It uses the term with list element to represent what T-SQL calls a CTE.

C++ 140

C++ Code Design Database 140

Dynatrace

JUNE 7, 2023

OneAgent automatic injection of monitoring and tracing code works not only for the NodeJS language binding but also when using the raw HTTPS request in NodeJS. OneAgent can automatically monitor all C#,NET, Java, Go, and NodeJS bindings. However, we recommend following the OpenTelemetry approach to monitoring Python with Dynatrace.

Monitoring 241

Monitoring Latency Metrics Azure 241

Dynatrace

APRIL 5, 2021

Similar to AWS Lambda , Azure Functions is a serverless compute service by Microsoft that can run code in response to predetermined events or conditions (triggers), such as an order arriving on an IoT system, or a specific queue receiving a new message. Dynatrace news. What is Azure Functions? The growth of Azure cloud computing.

Azure 204

Azure Serverless IoT Lambda 204

SQL Performance

OCTOBER 14, 2020

I explained that when SQL Server optimizes a query involving derived tables, it applies transformation rules to the initial tree of logical operators produced by the parser, possibly shifting things around across what were originally table expression boundaries. Here’s the attempted solution using a CTE: WITH C AS. ( FROM Sales.

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

FEBRUARY 10, 2021

Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code with the definition of the dbo.GetNumsAlanCharlieItzikBatch function: CREATE OR ALTER FUNCTION dbo. BatchMe ; GO. CREATE TABLE dbo. BatchMe ON 1 = 0.

C++ 124

C++ Servers Testing Code 124

Brendan Gregg

NOVEMBER 4, 2020

PID COMM FD ERR PATH 27974 opensnoop 28 0 /etc/localtime 1482 redis-server 7 0 /proc/1482/stat 1657 atlas-system-ag 3 0 /proc/stat […]. The BCC tools should eventually be switched from Python to libbpf C under the hood, but will work the same. However, **Appendix C's Python programming examples are now considered deprecated.**

C++ 143

C++ Programming Storage Code 143

Dynatrace

JULY 2, 2019

For instance, alert me when an error 999 is detected in application server logs or any HTTP 500 error from the web server access log. Automatic failure detection works well in most cases especially for web services and when developers follow good coding practices. Code. …. }. Code. …. }. Uncaught exceptions.

Tuning 147

Tuning Artificial Intelligence Code Java 147

SQL Performance

DECEMBER 9, 2020

Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH. Make sure that you enable Discard results after execution in your SSMS Query Options dialog under Grid, Results.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

MAY 13, 2020

I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well. However, from relational theory's standpoint, there's a deeper meaning to what C represents. C is what's known as a range variable.

C++ 143

C++ Code Design Servers 143

SQL Performance

MARCH 10, 2021

Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code with the definition of the dbo.GetNumsAlanCharlieItzikBatch function: CREATE OR ALTER FUNCTION dbo. BatchMe ; GO. CREATE TABLE dbo. BatchMe ON 1 = 0.

C++ 134

C++ Testing Code Servers 134

HammerDB

MAY 26, 2022

You may want to become familiar with all the underlying source code in C or wish to build a distribution where you can verify every single line of source code that goes into HammerDB. However, the client or server must be installed for all of Db2, MariaDB, PostgreSQL and MySQL for the HammerDB build to be successful.

C++ 115

C++ Database Servers Open Source 115

Percona

APRIL 3, 2023

oid_test" SET WITHOUT OIDS; ALTER TABLE postgres=# c abs_test You are now connected to database "abs_test" as user "postgres". craft" SET WITHOUT OIDS; ALTER TABLE "public"."ports" ALTER TABLE "public"."oid_test" oid_test" SET WITHOUT OIDS; (1 row) Now we can execute the DDL to ALTER these tables. postgres=# ALTER TABLE "public"."oid_test"

C++ 124

C++ Database Cache Storage 124

All Things Distributed

NOVEMBER 22, 2016

AWS will contribute code and improved documentation as well as invest in the ecosystem around MXNet. In addition to scalability, MXNet offers the ability to both mix programming models (imperative and declarative), and code in a wide number of programming languages, including Python, C++, R, Scala, Julia, Matlab, and JavaScript.

AWS 163

AWS Open Source Scalability Programming 163

SQL Performance

OCTOBER 13, 2021

Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO. Orders ( custid , orderdate DESC , orderid DESC ) INCLUDE ( empid ) ; And here’s the code to create the function, named Sales.GetTopCustOrders: CREATE OR ALTER FUNCTION Sales.

Cache 144

Cache Strategy C++ Code 144

ACM Sigarch

OCTOBER 12, 2020

These, let’s call them metal languages , include FORTRAN (introduced in 1957), C (1972), and C++ (1985). Programmers continue to write applications in them, and they continue to evolve: the just approved C++20 standard is the latest example. Despite their age, these languages are far from dead! As Leiserson et al.

C++ 109

C++ Benchmarking Hardware Architecture 109

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT. That's pretty neat!

C++ 111

C++ Database Servers Code 111

Percona

JULY 19, 2023

Well, “easy” if you know just a tiny bit of C++. Our function will implement a ULID generator using a C++ library from ChrisBove/ulid. Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $

C++ 98

C++ Servers Benchmarking Best Practices 98

Percona

JUNE 5, 2023

To do so, create a Bash script with the code from this script on GitHub.

Internet 114

Internet Internet C++ Virtualization 114

O'Reilly

APRIL 8, 2025

The computer doesnt know C++ and doesnt care if the software was written in Java, Haskell, or BASIC; no matter how the software is written, its going to execute binary machine code. Perhaps its a myth, but seasoned developers appear to have the ability to look at some buggy code and say, That looks fishy.

Programming 52

Programming Code Software Software 52

SQL Performance

JUNE 10, 2020

In my coverage of the physical treatment of named table expressions in the series I focus on the treatment in Microsoft SQL Server and Azure SQL Database. Recall that what triggered this series is some confusion that exists in the SQL Server community around named table expressions.

C++ 109

C++ Database Servers Code 109

SQL Performance

NOVEMBER 11, 2020

WITH C AS ( SELECT SYSDATETIME ( ) AS dt ) SELECT @i += 1 FROM C WHERE dt = dt ; PRINT @i ; GO. -- Batch 3. WITH C AS ( SELECT SYSDATETIME ( ) AS dt ) SELECT @i += 1 WHERE ( SELECT dt FROM C ) = ( SELECT dt FROM C ) ; PRINT @i ; GO. dt and the other with C2.dt.

C++ 122

C++ Code Storage Processing 122

Scalegrid

AUGUST 15, 2019

Should have an excellent way to measure server and query performance. It’s further enhanced by an in-place code editor which is also available in all three views. Query Code for converting queries to five target language: Java, Python, C#, PHP, and JavaScript (Node.js). NoSQLBooster.

Database 40

Database Servers Availability Monitoring 40

SQL Performance

MARCH 11, 2020

SQL Server handles NULLs just like non-NULL values for the purpose of enforcing a unique constraint. To demonstrate the T-SQL implementation of a unique constraint, run the following code, which creates a table called T3 with a unique constraint defined on the NULLable INT column col1, and populates it with a few sample rows: USE tempdb ; GO.

C++ 135

C++ Code Servers Database 135

SQL Performance

APRIL 13, 2022

Use the following code to create a table called T1 and populate it with a small set of sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Use the following code to create the helper function GetNums: CREATE FUNCTION dbo. L0 AS ( SELECT 1 AS c. I recommend you try to find a solution before implementing mine.

C++ 136

C++ Strategy Testing Servers 136

The Netflix TechBlog

MARCH 13, 2020

SVT-AV1 codebase status The SVT-AV1 repository includes both an AV1 encoder and decoder, which share a significant amount of the code. SVT-AV1 is written in C and can be compiled on major platforms, such as Windows, Linux, and macOS. The SVT-AV1 encoder supports all AV1 tools which contribute to compression efficiency.

Open Source 159

Open Source Efficiency C++ Speed 159