Brendan Gregg

JANUARY 1, 2019

Programming in eBPF directly is incredibly hard, the same as coding in v8 bytecode. But no one codes in v8: they code in JavaScript, or often a framework on top of JavaScript (jQuery, Angular, React, etc). People will use it and code in it via frameworks. What is an example of eBPF tracing? It's the same with eBPF.

C++ 111

C++ Virtualization Programming Code 111

CSS Wizardry

OCTOBER 16, 2023

Concatenating our files on the server: Are we going to send many smaller files, or are we going to send one monolithic file? Concatenate Concatenation is probably the trickiest bit to get right because, even though the three C s happen in order, decisions we make later will influence decisions we make back here. Back in the HTTP/1.1

Cache 291

Cache Latency Strategy Speed 291

Testsigma

FEBRUARY 3, 2021

Example: Let’s take an example of an e-commerce mobile app. Unit Testing – Developers execute unit tests for the smallest unit of code, whenever they commit new code in the code repository. Example: Here, we test the integration of two or more modules like- from cart to make a payment module.

Mobile 82

Mobile Testing Hardware C++ 82

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

C++ Servers Benchmarking Best Practices 82

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

Percona

DECEMBER 15, 2023

The system will generate error codes if they try to delete users which they did not create. Let me try to explain this with the help of an example. postgres=# CREATE ROLE dev_admin CREATEROLE LOGIN; CREATE ROLE postgres=# c postgres dev_admin You are now connected to database "postgres" as user "dev_admin".

C++ 97

C++ Database Open Source Systems 97

Brendan Gregg

DECEMBER 31, 2018

Programming in eBPF directly is incredibly hard, the same as coding in v8 bytecode. But no one codes in v8: they code in JavaScript, or often a framework on top of JavaScript (jQuery, Angular, React, etc). People will use it and code in it via frameworks. What is an example of eBPF tracing? It's the same with eBPF.

C++ 52

C++ Virtualization Programming Code 52

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. X Linux, with the following example from Red Hat Linux. The build has been tested on x64 Red Hat 8.X X and Ubuntu 20.04.X

C++ 113

C++ Database Open Source Servers 113

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 180

Artificial Intelligence Java Strategy Cloud 180

Dynatrace

JUNE 7, 2023

Our example dashboard below visualizes OpenAI token consumption. How Dynatrace traces OpenAI model requests Let’s use a simple NodeJS example service to show how Dynatrace OneAgent automatically traces OpenAI model requests. OneAgent can automatically monitor all C#,NET, Java, Go, and NodeJS bindings.

Monitoring 164

Monitoring Latency Metrics Azure 164

Dynatrace

JULY 12, 2022

The platform might identify, for example, that a SQL database “leverages [a particular] node when we do our Tlog [transaction log] backups,” he says. “We We are going to pull this server out of our load-balancer pool while Tlog subset jobs are running. IT automation speeds code development.

Innovation 219

Innovation Infrastructure DevOps Azure 219

SQL Performance

SEPTEMBER 9, 2020

Use the following code to create and populate the Employees table in the tempdb database: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. For example, given the employee ID of some manager, return the input employee, as well as all subordinates of the input employee in all levels; i.e., direct and indirect subordinates.

C++ 143

C++ Code Servers Availability 143

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. 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.

C++ 140

C++ Code Design Database 140

Percona

APRIL 3, 2023

In this blog, we will upgrade PG10, which has tables with OID columns and some extensions to PG13, as an example, using the native pg_upgrade utility. Using Logical Method: We can refer to Replication Between PostgreSQL Versions Using Logical Replication on upgrading using a logical replication method.

C++ 106

C++ Database Cache Storage 106

Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. for this example. The Ruby version used in both the examples below is 2.6.3. to learn more about this offer. ssl_verify.

C++ 100

C++ Servers Database Network 100

Percona

DECEMBER 29, 2022

The last is a good option when you can afford some downtime and desire to reuse the same server where your current instance is running. In this blog post, I will show you a particular example I faced when working with an upgrade exercise using pg_upgrade. These are not in this blog’s scope to keep this example simple.

C++ 84

C++ Open Source Database Programming 84

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. At the time of writing, T-SQL doesn’t support it, but PostgreSQL—for example—does. In my examples, I’ll use a table called Orders. L0 AS ( SELECT 1 AS c. Sample Data.

C++ 112

C++ Code Azure Database 112

Official Blog - World Web Technology

AUGUST 27, 2023

For example, website design is very crucial to impress your website visitors. It is a server-side scripting language that is highly secure, open-source, and versatile. Mostly, web servers are created with PHP. In PHP, code is directly executed on the server and generates HTML to send to the client. What is PHP?

Development 98

Development Ecommerce Open Source Website 98

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

C++ Benchmarking Hardware Architecture 108

HammerDB

OCTOBER 23, 2023

HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. Additionally, reviewing official TPC-C full disclosure reports highlighted that all vendors also use stored procedures.

Benchmarking 62

Benchmarking Database Network C++ 62

SQL Performance

MAY 11, 2022

In my examples, I’ll use the sample database PerformanceV5. You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. For simplicity’s sake, you can prevent parallelism in all examples shown in this article.

C++ 133

C++ Database Servers Code 133

Brendan Gregg

JULY 30, 2017

I recently improved flame graph code coloring. Code-type coloring was a regex hack that took five minutes. In late 2014 I was modifying the JDK to preserve the frame pointer so that traditional stack walkers and profilers would work (an example of the problem is here , where Java methods lack ancestry). And that's what I coded.

Code 40

Code Java C++ Website 40

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. 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.

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

OCTOBER 13, 2021

In my examples I’ll use a sample database called TSQLV5. An Example. As an example for an iTVF, suppose you need to create a reusable named table expression that accepts as inputs a customer ID (@custid) and a number (@n) and returns the requested number of most recent orders from the Sales.Orders table for the input customer.

Cache 144

Cache Strategy C++ Code 144

Percona

APRIL 21, 2023

Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 So let’s jump into generating and fixing an errant transaction. On 192.168.56.20:3306,

C++ 87

C++ Monitoring Database Open Source 87

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

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 91

Database Servers Open Source C++ 91

SQL Performance

DECEMBER 9, 2020

As an example, see the ones I submit at the end of this article. 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. You can create supporting tables in the user database if needed. You can add hints as needed.

C++ 114

C++ Servers Testing Processing 114

Brendan Gregg

NOVEMBER 4, 2020

As an example, I ported over my opensnoop(8) tool: #./opensnoop. 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. linux-vdso.so.1

C++ 145

C++ Programming Storage Code 145

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 Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61

IoT Servers Development Cache 61

Smashing Magazine

JULY 18, 2022

Segmented Rendering is a new pattern for the Jamstack that lets you personalize content statically, without any sort of client-side rendering or per-request Server-Side Rendering. Like other similar UI libraries, React provides two ways of rendering content: client-side and server-side. There was something he wanted to C.";

Cache 114

Cache Website Energy Servers 114

SQL Performance

MARCH 10, 2021

As an example, I’ll use dbo.GetNumsAlanCharlieItzikBatch as the baseline solution with the vertical elimination logic. Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. As a reminder, this solution uses a join with a dummy table that has a columnstore index to get batch processing. BatchMe ; GO. BatchMe ON 1 = 0.

C++ 134

C++ Testing Code Servers 134

SQL Performance

MAY 13, 2020

For example, the expression can be a table value constructor, as I will explain later in this article. Here are just a few examples for use cases that come to mind: Create a modular solution by breaking down complex tasks into steps, each represented by a different table expression. C is what's known as a range variable.

C++ 143

C++ Code Design Servers 143

SQL Performance

OCTOBER 9, 2019

If you have examples of your own of T-SQL gems that are often overlooked, please do share those in the comments section of this article. In my examples I'll use a sample database called TSQLV5. The EOMONTH function was introduced in SQL Server 2012. SQL Server 2017 introduced support for the function TRIM.

C++ 111

C++ Database Servers Code 111

SQL Performance

NOVEMBER 11, 2020

In my examples I’ll continue using the sample database TSQLV5. WITH C AS ( SELECT SYSDATETIME ( ) AS dt ) SELECT @i += 1 FROM C WHERE dt = dt ; PRINT @i ; GO. -- Batch 3. How many iterations did the code report? Try running the code and see that it stops at some point. dt and the other with C2.dt.

C++ 122

C++ Code Storage Processing 122

SQL Performance

JANUARY 13, 2021

Here’s the code to create the dummy table: CREATE TABLE dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code defining the dbo.GetNumsItzikBatch function: CREATE OR ALTER FUNCTION dbo. L0 AS ( SELECT 1 AS c. L0 AS ( SELECT 1 AS c. BatchMe ON 1 = 0.

C++ 113

C++ Code Testing Processing 113