O'Reilly

OCTOBER 12, 2021

Kevlin Henney and I were riffing on some ideas about GitHub Copilot , the tool for automatically generating code base on GPT-3’s language model, trained on the body of code that’s in GitHub. This article poses some questions and (perhaps) some answers, without trying to present any conclusions. Things like that.

Code 130

Code Programming C++ Testing 130

Scalegrid

JULY 13, 2020

In this article, we compare Oracle vs. PostgreSQL, outlining the differences in these SQL database costs, features, and ease of use for both developers and database administrators (DBA’s) alike. 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

DZone

NOVEMBER 9, 2021

It sits at the very beginning of the process before the code is written and can save an immense amount of time down the road (of somebody spending tons of time just to get to a dead-end). I really like what one of the smartest people with whom I worked said: “A good design is a design where you can see the code”. Important note.

Software 245

Software Software Code Design 245

Dynatrace

APRIL 11, 2023

For example, the open source Java library at the heart of the Log4Shell crisis in 2021 was patched within days given the pervasiveness of the code. How vulnerabilities are evaluated – platform module Learn the mechanism that Dynatrace Application Security uses to generate third-party vulnerabilities and code-level vulnerabilities.

Cloud 246

Cloud DevOps Open Source Retail 246

SQL Performance

AUGUST 12, 2020

This article is the fifth part in a series about table expressions. The source of the term aside, common table expression , or CTE , is the commonly used term by T-SQL practitioners for the structure that is the focus of this article. Of course, I’ll demonstrate this design aspect in this article.

C++ 140

C++ Code Design Database 140

O'Reilly

FEBRUARY 11, 2025

Submit a proposal for a talk at our new virtual conference, Coding with AI: The End of Software Development as We Know It.Proposals must be submitted by March 5; the conference will take place April 24, 2025, from 11AM to 3PM EDT. AI writes buggy code? So do humansand AI seems to be getting better at writing correct code.

Programming 89

Programming Code Software Software 89

CSS Wizardry

NOVEMBER 3, 2020

my about page ), and article pages, like this one you’re reading right now; an ecommerce site would have a homepage, a product listings page (PLP), a product details page (PDP), and a search results page (SRP). I want to be able to form hypotheses and draw conclusions without viewing a single URL or a line of source code. Final Word.

Speed 337

Speed Ecommerce Metrics Analytics 337

Dynatrace

AUGUST 7, 2023

Developers use generative AI to find errors in code and automatically document their code. They can also use generative AI for cybersecurity, write prototype code, and implement complex software systems. Visit our booth, number #2608, at Black Hat and c heck out our guide below. Here’s what you need to know.

DevOps 246

DevOps Analytics Best Practices Java 246

SQL Performance

MAY 13, 2020

For example, the expression can be a table value constructor, as I will explain later in this article. 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. I'll get to this one later in the article.

C++ 143

C++ Code Design Servers 143

Scalegrid

OCTOBER 7, 2019

The supported programming languages for PostgreSQL include.Net, C, C++, Delphi, Java, JavaScript (Node.js), Perl, PHP, Python and Tcl, but PostgreSQL can support many server-side procedural languages through its available extensions. The programming language C came in third place, averaging 20.0% Java #Python #C Click To Tweet.

Strategy 182

Strategy Cloud Java Open Source 182

SQL Performance

MAY 24, 2022

In this article I focus on windowing and NULL-related improvements. I’ll be using the sample database TSQLV6 in the examples in this article. This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications. This release has a number of T-SQL improvements. The WINDOW Clause.

Servers 145

Servers C++ Code Database 145

The Polyglot Developer

JUNE 24, 2019

One of my favorite blogs is this one and I saw a great article on Sorting vectors in C++ by Nic Raboy. As it happens, C++ is one of my first commercial languages and I still make some moderate use of it for various mobile projects. The post Moving to Dart from C++ appeared first on The Polyglot Developer.

C++ 64

C++ Mobile Programming Code 64

Percona

MARCH 13, 2023

In this article, we’ll explore the benefits of using Docker images for experimenting with serverless PostgreSQL and show you how to get started with them. 6400'" -c "listen_http_addr='0.0.0.0:9898'" 9898'" -c "pg_distrib_dir='/opt/neondatabase-neon/pg_install'" 4.

Serverless 144

Serverless C++ Storage Servers 144

High Scalability

SEPTEMBER 28, 2018

MrTonyD : I was writing production code over 30 years ago (C, OS, database). There is a reason why I'm not a practicing programmer anymore - even though I love to code. billion increase in pure-play foundry market; Quotable Quotes: WhatsApp cofounder : I am a sellout. I acknowledge that. I could go on and on. There more.

Internet 35

Internet Internet Scalability Blockchain 35

SQL Performance

OCTOBER 13, 2021

This article is the twelfth part in a series about named table expressions. The former is an inlinable named table expression based on a single query similar to a view and is the focus of this article. Before implementing the function itself, here’s code to create a supporting index on the Sales.Orders table: USE TSQLV5 ; GO.

Cache 144

Cache Strategy C++ Code 144

SQL Performance

MARCH 9, 2022

In this article, I continue exploring solutions to the matching supply with demand challenge. The solutions in this article were created by Brian Walker, Peter Larsson, Paul White, and me. Auctions ( Code , ID ) INCLUDE ( Quantity ) ; -- Enable batch-mode Window Aggregate. Code = 'D'. ) Code = 'S'. )

C++ 138

C++ Code Efficiency Performance 138

SQL Performance

DECEMBER 9, 2020

In a comment to my article, Marcos Kirchner mentioned that he tested my solution with varying table value constructor cardinalities, and got different execution times for the different cardinalities. If so, share yours as a comment to this article, and feel free to improve any solution posted by others.

C++ 114

C++ Servers Testing Processing 114

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. This article is dedicated to such a case—specifically, a standard SQL feature related to window functions called the GROUPS window frame option. L0 AS ( SELECT 1 AS c. Sample Data.

C++ 112

C++ Code Azure Database 112

SQL Performance

NOVEMBER 11, 2020

This article is the eighth part in a series about table expressions. 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.

C++ 122

C++ Code Storage Processing 122

Dynatrace

JULY 2, 2019

Automatic failure detection works well in most cases especially for web services and when developers follow good coding practices. It is basically an exception which the code doesn’t expect to occur and therefore doesn’t deal with. For instance, if I expect a “dataValidationException”, the code would look like this: Try. {.

Tuning 147

Tuning Artificial Intelligence Code Java 147

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

SQL Performance

OCTOBER 14, 2020

This article is the 7th part of a series about named table expressions. Then, you will probably want to continue reading this section and test the code that I use as I revisit key unnesting examples that I previously demonstrated with derived tables and convert them to use CTEs. Here’s the attempted solution using a CTE: WITH C AS. (

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

DECEMBER 8, 2021

In subsequent articles, I'll present set-based solutions—including the ones Peter and I worked on. The challenge involves querying a table called Auctions, which you create using the following code: DROP TABLE IF EXISTS dbo. Demand entries are marked with the code D and supply entries with S. L0 AS ( SELECT 1 AS c.

C++ 133

C++ Code Benchmarking Performance 133

SQL Performance

OCTOBER 9, 2019

My good friend Aaron Bertrand inspired me to write this article. In this article I cover a number of T-SQL features that are either often entirely overlooked, or that support parameters or capabilities that are often overlooked. databases ; OPEN C ; FETCH NEXT FROM C INTO @dbname ; WHILE @@FETCH_STATUS = 0.

C++ 111

C++ Database Servers Code 111

Smashing Magazine

DECEMBER 2, 2021

As you’ll see, each and every one of these calendars are sure to cater for a daily dose of web design and development goodness with stellar articles, inspiring experiments, and even puzzles to solve. To make the advent season even sweeter for JVM enthusiasts, there will be a new article about JVM-related topic everyday. Advent of Code.

Design 120

Design Development Programming Website 120

Dynatrace

JULY 13, 2020

refers to cloud-based, containerized, distributed systems, made up of cooperating microservices, dynamically managed by automated infrastructure as code. . ? C ontainers cannot be used at their full potential when only on their own. Containers and Microservices: R evolution in the architecture of distributed systems . ?

Google 173

Google DevOps Ecommerce Cloud 173

SQL Performance

JANUARY 13, 2021

Initially I thought of writing just one article to summarize the ideas people submitted, but there were too many. So I’ll split the coverage to several articles. Here’s the code to create the dummy table: CREATE TABLE dbo. L0 AS ( SELECT 1 AS c. L0 AS ( SELECT 1 AS c. BatchMe ON 1 = 0.

C++ 113

C++ Code Testing Processing 113

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. and dbo.T3

C++ 134

C++ Testing Code Servers 134

Smashing Magazine

NOVEMBER 26, 2021

However, there are a few ways in which you can make a large code-base easy to maintain. In this article, we will discuss a few of those techniques as well as some of the things I wish I had known earlier to help manage large Next.js In certain cases, the build will fail if there are type mismatches in your code as Next.js

Cache 145

Cache Code Testing Design 145

Highly Scalable

JANUARY 31, 2012

In this article I digested a number of MapReduce patterns and algorithms to give a systematic view of the different techniques that can be found on the web or scientific articles. All descriptions and code snippets use the standard Hadoop’s MapReduce model with Mappers, Reduces, Combiners, Partitioners, and sorting.

C++ 144

C++ Network Ecommerce Processing 144

SQL Performance

SEPTEMBER 21, 2022

In this article, I want to focus more on how these functions improve and simplify tasks that were harder to achieve in the past. For example, the following code counts the number of session options set in the current session: SELECT BIT_COUNT ( @@OPTIONS ) ; This code generates the following output in my session: -- 7.

Servers 122

Servers C++ Code Cache 122

SQL Performance

MARCH 11, 2020

This article is Part 4 in a series about NULL complexities. In the previous articles ( Part 1 , Part 2 , and Part 3 ), I covered the meaning of the NULL as a marker for a missing value, how NULLs behave in comparisons and in other query elements, and standard NULL handling features that are not yet available in T-SQL.

C++ 135

C++ Code Servers Database 135

HammerDB

JULY 6, 2024

Firstly, it is worth noting that both HammerDB TPROC-C and sysbench-tpcc run workloads based on the TPC-C specification, however as described here HammerDB is called TPROC-C to correctly comply with the TPC fair use rules. Copy Code Copied Use a different Browser./tpcc.lua Copy Code Copied Use a different Browser #!/bin/tclsh

C++ 52

C++ Hardware Benchmarking Virtualization 52

Smashing Magazine

JULY 18, 2022

If you think that static rendering is limited to generic, public content that is the same for every user of your website, you should definitely read this article. The witty jokes in each article are only visible to paid users. There was something he wanted to C."; Eric Burel. 2022-07-18T11:00:00+00:00. 2022-07-18T18:32:57+00:00.

Cache 127

Cache Website Servers Energy 127

CSS Wizardry

APRIL 25, 2019

I don’t think this article is definitive or gospel. The Head of Tech likely reports into C-level staff, so they’ll sit pretty close to the business, but might not have as much hands-on technical knowledge as a day-to-day engineer. Research the team’s stack, and prepare to shoot the sh*t about coding from the trenches.

Code 203

Code Engineering Design C++ 203

SQL Performance

AUGUST 1, 2022

In this article, I focus on the distinct predicate and the approximate percentile functions. I’ll cover the other improvements in future articles since there’s a lot to say about those. I’ll be using the sample database TSQLV6 in the examples in this article. 75 Test XYZ Student C 55 Test XYZ 77.5 The DATETRUNC function.

Servers 142

Servers Testing C++ Code 142

SQL Performance

MAY 11, 2022

You can download the source code to create and populate this database here. In this article, I want to focus on tips having to do with the potential of the window function’s calculation in the plan to rely on ordered input data without requiring an extra explicit sort activity in the plan. Environment for Demos. Tips 1 and 2.

C++ 133

C++ Database Servers Code 133