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. You probably need an in-house Developer Experience Platform Team that knows the languages, supports the libraries, and manages the web service and database vendors.

Engineering 137

Engineering Serverless Lambda AWS 137

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. This process can have both negative and positive implications.

C++ 113

C++ Code Testing Processing 113

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

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. L0 AS ( SELECT 1 AS c. Sometimes, you need to solve a T-SQL querying task, and you know the natural tool to solve it is a feature that’s part of the SQL standard but isn’t available in T-SQL.

C++ 112

C++ Code Azure Database 112

SQL Performance

MAY 13, 2020

In my examples I'll use a sample database called TSQLV5. 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). C is what's known as a range variable.

C++ 143

C++ Code Design Servers 143

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. In my examples, I’ll use the sample database PerformanceV5. You can download the source code to create and populate this database here. Environment for Demos. I’ll remind you at the end.

C++ 133

C++ Database Servers Code 133

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency. Msg 230, Level 14, State 1.

C++ 109

C++ Database Servers Code 109

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency. Msg 230, Level 14, State 1.

C++ 93

C++ Database Servers Code 93

CSS Wizardry

JULY 21, 2018

le|c|sa|sc)ss$/{print}' | nl. These tags allow definitions to be quickly and easily located by a text editor or other utility. Basically, ctags will create a kind of of database of all of the function, variable, mixin, ID, and class definitions for your project. This output will not be listed chronologically.

Programming 142

Programming C++ Database Code 142

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

DECEMBER 9, 2020

You can create supporting tables in the user database if needed. Requirements: Implement your solution as an inline table-valued function (iTVF) named dbo.GetNumsYourName with parameters @low AS BIGINT and @high AS BIGINT. As an example, see the ones I submit at the end of this article. You can add hints as needed.

C++ 61

C++ Servers Testing Processing 61

SQL Performance

APRIL 13, 2022

It’s based on a question from a public database forum. 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. The CTE called C is based on a query that computes two row numbers.

C++ 136

C++ Strategy Testing Servers 136

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

MARCH 7, 2019

There could be more, but this particular query was definitely hurting the performance of the server. c) From there you can divert into the areas that are related to that resource and start to narrow down the issue. Talking with the customer, this turned out to be a query that was introduced as part of a new software release.

C++ 98

C++ Traffic Servers Monitoring 98

SQL Performance

APRIL 10, 2019

You can also find it as part of the document ISO/IEC 9075-2:2016, Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) (available for purchase). price ) AS bottomprice , LAST ( C. LAST ( C. price ) , C AS C. price > PREV ( C.

C++ 73

C++ Virtualization Servers Code 73

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors.

C++ 140

C++ Code Design Database 140

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

SQL Performance

JANUARY 8, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. The conflict occurred in database "TSQLV5", table "dbo.Contacts", column 'hourlyrate'. 3 C NULL 4 D 150.00 NULL treatment inconsistencies.

Design 65

Design C++ Code Database 65

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

Database 99

Database Servers Open Source Tuning 99

Percona

JULY 5, 2023

Long database service downtime Some queries become slow Applications stop working due to incompatibilities Data loss This is what can happen if MySQL’s major upgrade to 8.0 You cannot load a dump of the MySQL system database from MySQL 8.0 Default database: 'test'. EOL is set for the end of October 2023. and restore to 5.7

C++ 114

C++ Database Servers Testing 114

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. The dynamic allocation might have flaws, but it’s definitely a good addition.

Metrics 98

Metrics C++ Storage Database 98

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. Consider the following code as an example: USE TSQLV5 ; WITH C AS. ( FROM C AS C1 INNER JOIN C AS C2 ON C1.

C++ 122

C++ Code Storage Processing 122

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 73

Database Best Practices Open Source C++ 73

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

SQL Performance

APRIL 8, 2020

It occurred to me that both the naming confusion, and the confusion around whether there's a persistency aspect to table expressions, can be cleared with a better understanding of the fundamentals of our field of relational database management systems. When I read C. In my examples I'll use a sample database called TSQLV5.

C++ 143

C++ Azure Database Servers 143

Percona

SEPTEMBER 27, 2023

First, we will need to install the OS with the necessary control files for the appropriate PostgreSQL version for installing pg_partman on the database. Installation of pg_partman on the database I recommend creating the schema before creating the extension to install the extension’s objects. pg_partman_bgw.dbname : Required.

Storage 97

Storage Open Source Database Efficiency 97

Percona

DECEMBER 14, 2022

In the database world there are essentially two types of database operations: Online Transaction Processing , OLTP : Online transaction processing applications have high throughput and are insert- or update-intensive in database management. And if the query processes 100 million rows, that’s definitely not trivial!

Database 92

Database Analytics Storage Processing 92

SQL Performance

MARCH 11, 2020

The standard unique constraint definition is a bit different than the T-SQL version. Here's the unique constraint definition from the standard: "A unique constraint on T is satisfied if and only if there do not exist two rows R1 and R2 of T such that R1 and R2 have the same non-NULL values in the unique columns.".

C++ 135

C++ Code Servers Database 135

SQL Performance

MAY 12, 2021

I’ll do my testing in a database called testdb. Use the following code to create the database if it doesn’t exist, and to enable I/O and time statistics: -- DB and stats. IF DB_ID ( 'testdb' ) IS NULL CREATE DATABASE testdb ; GO. And here’s the code with the function’s definition: CREATE OR ALTER FUNCTION dbo.

C++ 111

C++ Servers Database Code 111

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. Benefits of using BDD.

Development 96

Development Programming Testing Java 96

SQL Performance

MAY 8, 2019

GetNums ( 1 , 100 ) AS C WHERE C. If you haven’t figured it out yet, look closely at the definitions of both tables—specifically the column names—and at the column names used in the query. GetNums ( 1 , 100 ) AS C WHERE C. CREATE TABLE dbo. Customers. ( ( custid INT NOT NULL.

Best Practices 68

Best Practices C++ Code Servers 68

Testsigma

FEBRUARY 3, 2021

This includes- database, memory, CPU usage etc. During the manual review, we can take help of the IDE’s, or manually check the API and database calls. Definitely writing the automation code covering all of these differences is quite challenging. This can be considered similar to load testing, endurance testing. Recovery Testing.

Mobile 82

Mobile Testing Hardware C++ 82

The Netflix TechBlog

MARCH 25, 2019

In the rest of this blog, we will a) touch on the complexity of Netflix cloud landscape, b) discuss lineage design goals, ingestion architecture and the corresponding data model, c) share the challenges we faced and the learnings we picked up along the way, and d) close it out with “what’s next” on this journey.

Infrastructure 219

Infrastructure Big Data Transportation Architecture 219

SQL Performance

NOVEMBER 13, 2019

Here's the definition of the POC that supports our query: CREATE INDEX idx_grp_data_i_id ON dbo. Consider the following UDF definition as an example: DROP FUNCTION IF EXISTS dbo. ) SELECT id , grp , datacol FROM C WHERE n = 1 ; No one shall pass this way without my permission. YouWillRegretThis ; GO. CREATE FUNCTION dbo.

Servers 104

Servers C++ Storage Performance 104

ScaleOut Software

JULY 14, 2021

The Microsoft Azure IoT ecosystem offers a rich set of capabilities for processing IoT telemetry, from its arrival in the cloud through its storage in databases and data lakes. Acting as a switchboard for incoming and outgoing messages, Azure IoT Hub forms the core of these capabilities.

IoT 52

IoT Azure Analytics Serverless 52

SQL Performance

SEPTEMBER 25, 2020

This is because, except for the raw text stored in the object’s definition, the information is not anywhere in the catalog views. a AS /* comment here because -- chaos */ int = 5 , @b AS varchar ( 64 ) = 'AS = /* BEGIN @a, int = 7 */ ' 'blat' '' , @c AS int = -- 12. Really hard. now we need to try parsing.

Code 42

Code C++ Database Servers 42