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

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

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

C++ Servers Benchmarking Best Practices 78

Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers 130

Servers Best Practices Government Network 130

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 116

Serverless C++ Storage Latency 116

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

Artificial Intelligence Java Strategy Cloud 182

Percona

DECEMBER 15, 2023

The system will generate error codes if they try to delete users which they did not create. 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++ 90

C++ Database Open Source Systems 90

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

C++ Database Cache Storage 98

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 221

Innovation Infrastructure DevOps Azure 221

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 Tuning C++ Database 244

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. Another option is to use imperative iterative code, but such solutions tend to be lengthy. FROM C AS M INNER JOIN dbo. FROM C AS M INNER JOIN dbo. FROM C AS M INNER JOIN dbo.

C++ 143

C++ Code Servers Availability 143

Brendan Gregg

JULY 30, 2017

I recently improved flame graph code coloring. Code-type coloring was a regex hack that took five minutes. org/mozilla/classfile/ClassFileWriter; addLoadConstant. - **C++** JavaCalls::call_helper. JavaThread::thread_main_inner. - **C** tcp_v4_do_rcv. If it contains "::" it's C++, "/" it's Java, else it's C.

Code 40

Code Java C++ Website 40

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

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

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

Tech News Gather

MARCH 30, 2022

It is a combination of programming languages, frameworks, libraries, patterns, servers, UI/UX solutions, software, and tools used by developers. Structure-wise, the tech stack consists of two elements: Front-end or client-side and server-side or back end. In this article, we will see what technology stack to choose for your project?

Technology 96

Technology Technology C++ Java 96

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

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

C++ Monitoring Database Open Source 81

Official Blog - World Web Technology

AUGUST 27, 2023

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. In PHP, code is directly executed on the server and generates HTML to send to the client.

Development 98

Development Ecommerce Open Source Website 98

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. Use the following code to create the Orders table and populate it with a small set of sample data to help you verify the validity of the solutions: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo.

C++ 112

C++ Code Azure Database 112

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

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. You might consider some extra steps, such as verifying the existence of gin/gist indexes, unknown datatypes, or planning the upgrade of any standby server using the rsync approach.

C++ 81

C++ Open Source Database Programming 81

HammerDB

MARCH 25, 2023

Docker build, example CLI scripts were added to build and run the TPROC-C workload in the Tcl language. these were enhanced to also add Python based scripts, and to include scripts for both TPROC-C and TPROC-H and a driver script for Linux environments. Copy Code Copied Use a different Browser ~/HammerDB-4.7$ In HammerDB v4.6

C++ 83

C++ Virtualization Benchmarking Database 83

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

Adrian Cockcroft

MAY 23, 2022

That got me a job at Cambridge Consultants Ltd as a software engineer writing code (mostly in C) for embedded real time signal processing and control systems. I was officially a one-day-a-week sysadmin for about ten workstations and servers. After getting deep into how a compiler worked, I was a much better C programmer!

C++ 98

C++ Software Engineering Education Engineering 98

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 143

Monitoring Performance C++ Infrastructure 143

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

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

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

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

Percona

JUNE 5, 2023

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

Internet 86

Internet Internet C++ Virtualization 86

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

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 85

Database Servers Open Source C++ 85

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

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 166

Monitoring Latency Metrics Azure 166

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

C++ Programming Storage Code 145