n0derunner

APRIL 1, 2024

Running iperf with parallel threads TL;DR – When running iperf with parallel threads/workers the -P option must be specified after the -c <target-IP> option.

C++ 40

C++ Network 40

Sutter's Mill

SEPTEMBER 28, 2023

file compilation looks like when compiled on the command line on my laptop: But note you can still build cppfront as all-today’s-C++ using any fairly recent C++20 compiler because I distribute the sources also as C++ (just as Bjarne distributed the cfront sources also as C). Here’s what that reflect.h2

C++ 89

C++ Cache Code Design 89

SQL Performance

AUGUST 12, 2020

Customers WITH ( SERIALIZABLE ) ; The potential for ambiguity is when you have an unterminated statement preceding a CTE definition, in which case the parser might not be able to tell whether the WITH clause belongs to the first or second statement. Here’s an example demonstrating this: SELECT custid , country FROM Sales.

C++ 140

C++ Code Design Database 140

SQL Performance

MAY 24, 2022

WHERE custid IN ( 1 , 2 ) WINDOW P AS ( PARTITION BY custid ) , PO AS ( P ORDER BY orderdate , orderid ) , POF AS ( PO ROWS UNBOUNDED PRECEDING ) ORDER BY custid , orderdate , orderid ; The order of the window name definitions in the WINDOW clause is insignificant. OrderValues. OrderValues.

Servers 145

Servers C++ Code Database 145

Sutter's Mill

MAY 1, 2023

Simple, mathematically safe, and efficient chained comparisons ( commit ) P0515 “Consistent comparison” (aka “spaceship”) was the first feature derived from this Cpp2 work to be adopted into the ISO Standard for C++, in C++20. Thank you again to everyone who helped land this Cpp2 feature in the ISO C++ Standard.

C++ 97

C++ Virtualization Lambda Code 97

Percona

DECEMBER 29, 2022

for lib in $(psql -qtA pgbench -c"select extname||'.so' for lib in $(psql -qtA pgbench -c"select extname||'.so' Also, you will see a section with the explicit creation of the C language functions for the extensions. A custom C function is using it. For example, with the following bash snippet.

C++ 82

C++ Open Source Database Programming 82

Percona

APRIL 10, 2023

Then, each key-value entry will keep in the key the column name surrounded by backticks, and the value will be the masking function definition. mydumper -o data -B test --defaults-file=mydumper.cnf -r 100000 -c real 0m19.964s user 0m48.396s sys 0m7.885s It took near 19.9 sbtest1`] `k`=random_int The backup took 20.7

Testing 108

Testing C++ Open Source Database 108

SQL Performance

JANUARY 13, 2021

L0 AS ( SELECT 1 AS c. Here’s the function’s definition: CREATE OR ALTER FUNCTION dbo. L0 AS ( SELECT 1 AS c. For this reason, compile times should definitely be taken into account—especially when using the function very frequently with small ranges. L0 AS ( SELECT 1 AS c.

C++ 113

C++ Code Testing Processing 113

SQL Performance

MAY 13, 2020

Here's the standard's definition for derived tables in the general sense: 4.15.3 There are three main parts to identify in a statement involving a derived table definition: The table expression (the inner query). However, from relational theory's standpoint, there's a deeper meaning to what C represents. Derived tables.

C++ 143

C++ Code Design Servers 143

SQL Performance

MARCH 10, 2021

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. Here’s the function’s definition: CREATE OR ALTER FUNCTION dbo.

C++ 134

C++ Testing Code Servers 134

Sutter's Mill

APRIL 30, 2012

I’m seeing many younger programmers picking up C++. The average age at C++ events over the past year has been declining rapidly as the audience sizes grow with more and younger people in addition to the C++ veterans. Having that computer was definitely worth a year of predawn paper delivery in the rain, sleet, and snow.

C++ 40

C++ Programming Media Games 40

SQL Performance

JULY 13, 2022

L0 AS ( SELECT 1 AS c. But what if you require a deterministic definition of the frame with guaranteed repeatable results? To test the performance of the solutions, you’ll need a larger set of sample data. Orders WITH ( TABLOCK ) ( orderid , orderdate , empid , custid , qty ) SELECT N.

C++ 112

C++ Code Azure Database 112

SQL Performance

FEBRUARY 10, 2021

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. L0 AS ( SELECT 1 AS c. SET NOCOUNT ON ; DECLARE @c INT = 0 ; WHILE @c < 128. MySYSDATETIME ( ) AS dontinline.

C++ 124

C++ Servers Testing Code 124

Percona

OCTOBER 17, 2023

The dynamic allocation might have flaws, but it’s definitely a good addition. Shard Key Analyzer helper – analyzeShardKey() The shard key is a critical component of your cluster, as it dictates the distribution of your data through the shards, and that’s where the problem lies.

Metrics 104

Metrics C++ Storage Database 104

SQL Performance

DECEMBER 9, 2020

L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.

C++ 114

C++ Servers Testing Processing 114

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. ) SELECT C1. orderid , C1.

C++ 122

C++ Code Storage Processing 122

Dynatrace

AUGUST 7, 2023

Visit our booth, number #2608, at Black Hat and c heck out our guide below. By definition, zero-day attacks take organizations by surprise. These are just some of the themes we will explore in our guide for Black Hat 2023, which takes place August 5-10 in Las Vegas.

DevOps 187

DevOps Analytics Best Practices Java 187

Percona

JULY 5, 2023

For example, you can’t dump and restore user definition: mysql 80 > show create user msandbox_ro@localhostG 1. source manually, as, again, this is not supported action: # orchestrator-client -c relocate -i 127.0.0.1:5749 Any changes in system tables made since the 8.0 version source will break the 5.7 replica under the 8.0

C++ 120

C++ Database Servers Testing 120

Scalegrid

FEBRUARY 15, 2024

MongoDB® SSL with Self-Signed Certificates in C# Configuring MongoDB Server for SSL/TLS Encryption Once your certificates are ready, the next step is configuring the MongoDB server for SSL/TLS encryption, allowing you to securely connect to MongoDB. While we’re yet to run comprehensive tests, there is definite overhead due to using SSL.

Servers 130

Servers Best Practices Government Network 130

The Netflix TechBlog

MARCH 2, 2021

David Cameron (Studio Production) [David C.] My academic credentials definitely helped on the technical side. What best prepared you for your current role at Netflix? Are there any experiences that particularly helped you bring a unique voice/point of view to Netflix? Aliki Mavromoustaki (Content & Marketing) [Aliki M.]

Analytics 207

Analytics C++ Innovation Engineering 207

SQL Performance

JULY 27, 2021

As well as the nonclustered index correctness checks, if there’s a persisted computed column in the definition of a table, then for each data record in the table, DBCC CHECKDB has to check that the persisted value is correct, regardless of whether that column is part of a nonclustered index or not. columns [ c ] JOIN sys.

C++ 54

C++ Servers Database Code 54

SQL Performance

APRIL 13, 2022

Note the definition of the primary key constraint based on the composite key (grp, ord), which results in a clustered index based on the same key. L0 AS ( SELECT 1 AS c. Following is the first solution to our challenge, which is based on a technique that has been known for a while: WITH C AS. (

C++ 136

C++ Strategy Testing Servers 136

Adrian Cockcroft

FEBRUARY 9, 2023

The third is that the Team Topologies book defined how to create and manage Platform Teams so there’s interest in the terminology and definition. The second is that some companies with tools to sell are marketing the term. Talking through the map, we start with an end user who can choose a web app or a mobile app.

Engineering 137

Engineering Serverless Lambda AWS 137

Tasktop

SEPTEMBER 3, 2020

The corresponding key results could be (a) 60% mobile usage OR (b) Improve the % of product NPS score OR (c) The number of new users increase by 30%. Clear definitions and boundaries around resources and skill sets needed. It’s definitely possible to set some or all of your key results as outputs. Easy to track and manage.

C++ 59

C++ Innovation Strategy Mobile 59

Sutter's Mill

JUNE 3, 2021

Briefly, what is the difference among: (a) undefined behavior Undefined behavior is what happens when your program tries to do something whose meaning is not defined at all in the C++ standard language or library (illegal code and/or data). By definition, if a function’s preconditions are violated, then the results are not specified.

C++ 54

C++ Programming Lambda Code 54

Dynatrace

NOVEMBER 8, 2021

G2 Research includes a clear definition of APM in its Grid Report for Application Performance Monitoring for Spring 2021. ” — Christopher C, Platform Manager at an enterprise. APM solutions track key software application performance metrics using monitoring software and telemetry data.

Artificial Intelligence 234

Artificial Intelligence Monitoring Infrastructure Cloud 234

SQL Performance

APRIL 14, 2021

Here’s the function’s definition: -- Helper dummy table. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; GO. -- Function definition. b FROM L1 AS A CROSS JOIN L1 AS B CROSS JOIN L1 AS C ) INSERT INTO dbo. Here’s the function’s definition: CREATE OR ALTER FUNCTION dbo. BatchMe ; GO.

C++ 112

C++ Servers Testing Code 112

SQL Server According to Bob

JANUARY 11, 2020

Native (-n) or Format (-f) Files The data file storage is binary allowing character strings to be stored as single or multi-byte strings on a per column definition. If you use -c the data file storage would be SQLCHAR instead, regardless of the table definition in SQL Server. bcp.exe" BCPTest.

C++ 40

C++ Storage Servers Retail 40

Percona

AUGUST 30, 2023

psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8) So, the setting goes as part of the function definition. Here is an example of the function definition to test the function-level settings. If, at all, there is any crash in between, I am OK to perform the ETL again. Type "help" for help.

Database 105

Database Servers Open Source Tuning 105

Sutter's Mill

JANUARY 11, 2021

C++20 supports two main assertion facilities… For each one, briefly summarize how it works, when it is evaluated, and whether it is possible for the programmer to specify a message to be displayed if the assertion fails. C++ Coding Standards (Addison-Wesley, 2004). 5] For conditions, it’s up to us to make sure it’s true.) Dos Reis, J.

C++ 58

C++ Programming Code Testing 58

Percona

OCTOBER 10, 2023

Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement. Your MySQL connection id is 256 Server version: 8.0.32-24.2 Type 'help;' or 'h' for help. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 98

Database Performance C++ Engineering 98

Tasktop

JANUARY 26, 2021

I recently had the benefit of participating in the inaugural Turn Product Speak into Financial C-Suite Speak Bootcamp. And, I’ll be honest, as a CPO, I definitely felt that I was going to be a fish out of water. CFO-land, as I like to refer to it, definitely feels daunting and full of spreadsheets.

Education 52

Education Metrics C++ Innovation 52

Testsigma

APRIL 8, 2020

Hands on with one of the programming languages (like JAVA (prefered), Python, Ruby, C#) that will be needed for automation of a test case in the backend. BDD is ineffective without a proper definition of business requirements since it does not cope well with poorly written user stories. Read more about step definitions here.

Development 96

Development Programming Testing Java 96

SQL Performance

AUGUST 2, 2019

I restored a copy of WideWorldImporters and then created three stored procedures (definitions below). OrderID , c. Customers c ON o. CustomerID = c. OrderID , c. OrderID , c. Customers c ON o. CustomerID = c. OrderID , c. OrderID , c. Customers c ON o. CustomerID c.

Servers 95

Servers C++ Testing Systems 95

Percona

SEPTEMBER 27, 2023

DEFAULT ‘on’::text Because we specified ‘2’ for premake in the create_parent function, you can observe that two partitions ahead have been created, as shown in the table definition below. schema.tablename p_control text You should partition the column, either integer or time-based.

Storage 102

Storage Open Source Database Efficiency 102

SQL Performance

OCTOBER 1, 2020

In my last post , I showed how to use TSqlParser and TSqlFragmentVisitor to extract important information from a T-SQL script containing stored procedure definitions. a AS /* comment here because -- chaos */ int = 5 , @b AS varchar ( 64 ) = 'AS = /* BEGIN @a, int = 7 */ ' 'blat' '' , @c AS int = -- 12. Param name: @c.

C++ 57

C++ Code Database Systems 57

SQL Performance

MAY 11, 2022

Naturally, if a partitioning or ordering element doesn’t appear in the window function, you omit that part from the index definition. The following query, which I’ll refer to as Query 5, illustrates this technique: WITH C AS. ( Consider the following query, which I’ll refer to as Query 6: WITH C AS. ( max3: orderid.

C++ 133

C++ Database Servers Code 133