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

Sutter's Mill

AUGUST 13, 2023

Thanks again to C++ Now for inviting me to speak this year in glorious Aspen, Colorado, USA! The talk I gave there was just posted on YouTube, you can find it here: At CppCon 2022, I argued for why we should try to make C++ 10x simpler and safer , and I presented my own incomplete experimental compiler, cppfront.

C++ 83

C++ Efficiency Design Virtualization 83

Sutter's Mill

JULY 13, 2019

More about that in the post-meeting trip report after the meeting is over… FAQs (As of pre-Cologne, July 2019) There are bugs in the standard, so should we delay C++20? If we had just another meeting or two, we could add <feature> which is almost ready, so should we delay C++20? Of course, and no.

C++ 98

C++ Entertainment Education Azure 98

SQL Performance

OCTOBER 14, 2020

Here’s the attempted solution using a CTE: WITH C AS. ( Using our trick with the TOP filter in the inner query, you prevent the unnesting of the table expression, like so: WITH C AS. ( The following code returns only shippers with a maximum order date that is on or after January 1 st , 2018: USE PerformanceV5 ; WITH C AS. (

C++ 140

C++ Servers Code Efficiency 140

Sutter's Mill

SEPTEMBER 26, 2019

My CppCon 2019 talk is now available on YouTube, and the slides will soon be available here. I hope you enjoy it.

Availability 98

Availability C++ 98

Dynatrace

APRIL 4, 2023

“In 2019, we actually recognized a few gaps in our previous monitoring solution.” But a simple status update can be hard to provide for a non-IT pro, like many folks in C-level positions who aren’t familiar with the details of application resilience. ” One major gap was application health.

Education 227

Education Monitoring C++ Design 227

SQL Performance

AUGUST 12, 2020

For example, you can use a query that is based on derived tables as the inner query of a CTE definition, as in the following example: WITH C AS. ( ) SELECT orderyear , numcusts FROM C ; However, the same does not hold true for a query that is based on CTEs. CROSS JOIN. ( CROSS JOIN. (

C++ 140

C++ Code Design Database 140

O'Reilly

FEBRUARY 18, 2020

Growth is still strong for such a large topic, but usage slowed in 2018 (+13%) and cooled significantly in 2019, growing by just 7%. But sustained interest in cloud migrations—usage was up almost 10% in 2019, on top of 30% in 2018—gets at another important emerging trend. Still cloud-y, but with a possibility of migration.

Software Architecture 136

Software Architecture DevOps Data Engineering Architecture 136

DZone

JANUARY 22, 2021

In our earlier blog under the xUnit testing tutorial series, we had a look at setting up the xUnit.net framework (further referred to as xUnit) in Visual Studio 2019 (VS 2019). Today our core focus is on Selenium test automation with C#. So, we would also need to install the Selenium WebDriver.

Testing 113

Testing C++ Cloud 113

SQL Performance

JUNE 14, 2019

However, a typical bug when converting the existing solution to one that applies the join is to leave the computation of the order count as COUNT(*), as shown in the following query (call it Query 1): SELECT C. Customers AS C LEFT OUTER JOIN Sales. Orders AS O ON C. GROUP BY C. ORDER BY C. Orders AS O ON C.

Best Practices 93

Best Practices C++ Database Processing 93

Sutter's Mill

NOVEMBER 24, 2024

On Saturday, the ISO C++ committee completed the third-last design meeting of C++26, held in Wrocaw, Poland. There are just two meetings left before the C++26 feature freeze in June 2025, and C++26 is on track to be completed two more meetings after that in early 2026. is the nutshell synopsis. Thank you, Hana!

C++ 61

C++ Code Education Design 61

SQL Performance

SEPTEMBER 12, 2019

As an example with our task, suppose that you don't realize that the grouping element is determined implicitly, and you come up with the following query: SELECT shipperid , [ 2017 ] , [ 2018 ] , [ 2019 ] FROM Sales. So you're expecting to see only three rows in the result. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

O'Reilly

JANUARY 13, 2020

” Despite the slow rate of adoption, Java’s six-month release cadence has been trucking along—Java 12 dropped in March 2019, with Java 13 following in September. 2019 brought another surprise when Oracle moved Java SE to a subscription-based model. Or do people just not know about the benefits of 11 in containers?”

Programming 132

Programming Java Google C++ 132

Scalegrid

JUNE 18, 2019

The easiest way to induce failover is to run the rs.stepDown() command: RS-example-0:PRIMARY> rs.stepDown() 2019-04-18T19:44:42.257+0530 E QUERY [thread1] Error: error doing query: failed: network error while attempting to run command 'replSetStepDown' on host 'SG-example-1.servers.mongodirector.com:27017' 27017 (sg-example-17026.servers.mongodirector.com:27017,

C++ 100

C++ Servers Database Testing 100

The Netflix TechBlog

APRIL 17, 2019

Intel and Netflix announced their collaboration on a software video encoder implementation called SVT-AV1 on April 8, 2019. However, rav1e is written in Rust programming language, whereas an encoder written in C has a much broader base of potential developers. New Netflix Buildings in Los Gatos. What is SVT-AV1?

Open Source 167

Open Source Scalability Speed Efficiency 167

SQL Performance

DECEMBER 11, 2019

As an example, suppose that you need to query the Sales.Orders table in the TSQLV5 sample database, and return orders that were shipped on January 2 nd , 2019. WHERE shippeddate = '20190102' ; It's clear that the filter predicate evaluates to TRUE for rows where the shipped date is January 2 nd , 2019, and that those rows should be returned.

Best Practices 117

Best Practices C++ Database Code 117

The Morning Paper

SEPTEMBER 20, 2020

For example, think of the classic diamond pattern where A depends on B and C, and B and C both in turn depend on D, but there is no version of D that satisfies the constraints of both B and C. Of the 156 conflicts that Watchman predicted were likely to arise, 143 did so!

Monitoring 137

Monitoring Java C++ Strategy 137

SQL Performance

OCTOBER 13, 2021

Combining the APPLY operator with an iTVF call, you can achieve the task nicely and cleanly, like so: SELECT C. Customers AS C CROSS APPLY Sales. GetTopCustOrders ( C. custid , O. orderid , O. orderdate , O. FROM Sales. 263 rows affected).

Cache 144

Cache Strategy C++ Code 144

SQL Performance

FEBRUARY 12, 2020

Here's the complete solution code: WITH C AS. ( ) SELECT id , col1 , MAX ( col1 ) OVER ( PARTITION BY grp ORDER BY id ROWS UNBOUNDED PRECEDING ) AS lastval FROM C ; Clearly, that's a lot more code and work compared to just saying IGNORE_NULLS. 11063 2019-05-06 11067 2019-05-06 11069 2019-05-06.

C++ 120

C++ Code Servers Database 120

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

APRIL 10, 2019

STOCK1 2019-02-12 150.00 STOCK1 2019-02-13 151.00 STOCK1 2019-02-14 148.00 STOCK1 2019-02-15 146.00 STOCK1 2019-02-18 142.00 STOCK1 2019-02-19 144.00 STOCK1 2019-02-20 152.00 STOCK1 2019-02-21 152.00 STOCK1 2019-02-22 153.00 STOCK1 2019-02-25 154.00 STOCK1 2019-02-26 154.00

C++ 73

C++ Servers Virtualization Code 73

Smashing Magazine

DECEMBER 2, 2021

Back in October of 2019, “Perl 6” was renamed to “Raku”. C# Advent Calendar. It’s time for the fifth annual C# advent calendar that will feature two pieces of content every day. Anyone can contribute by sharing their blog posts, videos, articles or podcast episodes dedicated to C# development. 24 Accessibility (2019).

Design 110

Design Development Programming Website 110

SQL Performance

APRIL 13, 2022

L0 AS ( SELECT 1 AS c. My test machine has four logical CPUs, running SQL Server ® 2019 Enterprise. I’ll assume you’re using an environment designed to support batch mode on row store either directly, e.g., using SQL Server 2019 Enterprise edition like mine, or indirectly, by creating a dummy columnstore index on the table.

C++ 136

C++ Strategy Testing Servers 136

Smashing Magazine

JULY 16, 2019

2019-07-16T14:30:59+02:00. 2019-07-16T14:35:52+00:00. Note: Windows users will also need Microsoft Visual C++ 14.0, which you can grab from “Microsoft Visual C++ Build Tools” over here. First you’ll need to make sure you have a c-compiler on your system. First of all, to start off, let’s install Scrapy.

Scalability 87

Scalability Website C++ Servers 87

SQL Performance

MAY 6, 2021

Part 3 started the query scan, performed some early phase processing, and started the first additional parallel tasks in branch C. Branch C execution details. Branch C (additional parallel tasks). At DOP 2, there are two new tasks, two worker threads, and two execution contexts for branch C. Branch C Parallel Execution.

C++ 95

C++ Azure Servers Processing 95

Brendan Gregg

DECEMBER 22, 2019

Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. This is the culmination of five years of work: the BPF kernel runtime, C support, LLVM and Clang support, the BCC front-end, and finally the bpftrace language. This is not my best code, since I hacked it in a hurry, but here it is: #!/usr/bin/python

C++ 85

C++ Education Java AWS 85

SQL Performance

OCTOBER 9, 2019

WHERE orderdate = EOMONTH ( DATEADD ( month , - 1 , SYSDATETIME ( ) ) ) ; Note that if you actually run this query in the TSQLV5 sample database you will get an empty result since the last order date recorded in the table is May 6 th , 2019. SELECT name FROM sys. do your thing here. */. SELECT name FROM sys.

C++ 111

C++ Database Servers Code 111

Brendan Gregg

OCTOBER 15, 2019

Ctrl-C to end. ^C C FUNC COUNT aa_af_perm 1 [.truncated.] Fortunately, he just gave an updated version at Kernel Recipes in Paris, 2019, titled ftrace: Where modifying a running kernel all started. That's at the start of _every_ kernel function on Linux. What the heck! Tracing "*". Unfortunately, it wasn't videoed.

C++ 76

C++ Engineering Technology Technology 76

Dynatrace

JULY 13, 2020

C ontainers cannot be used at their full potential when only on their own. According to the CNCF Survey 2019 , conducted from organizations of all sizes, 8 out of the top 10 most used container management tools were a distribution of Kubernetes. But how will you set up the communication? Who manage s the networking aspects?

Google 133

Google DevOps Ecommerce Cloud 133

Dynatrace

APRIL 5, 2021

In 2019, the US Department of Defense chose Azure for its $10 billion cloud computing project, JEDI. Azure Functions also enables teams to run custom-written code to connect multiple services in JavaScript, C#, Python, or PHP in a containerized environment on an as-needed basis. Making the best use of Azure Functions.

Azure 139

Azure Serverless IoT Lambda 139

Dynatrace

JULY 13, 2020

C ontainers cannot be used at their full potential when only on their own. According to the CNCF Survey 2019 , conducted from organizations of all sizes, 8 out of the top 10 most used container management tools were a distribution of Kubernetes. But how will you set up the communication? Who manage s the networking aspects?

Google 130

Google DevOps Ecommerce Cloud 130

Sutter's Mill

SEPTEMBER 4, 2019

I just can’t get enough of this short video, combining interviews shot at last year’s CppCon with shots of our new “home” location that we’ll be enjoying for the first time two weeks from now. Please enjoy it — this is an excellent representation of what CppCon is like.

C++ 74

C++ 74

Sutter's Mill

SEPTEMBER 3, 2024

We can hopefully do it even more simply and elegantly in C++26/29. Pre-C++11 answer I recently received this question in email from my friend Christopher Nelson. Perhaps you can relate, if you’ve ever said, “I’m pretty sure the answer is X, but this part of C++ is so complex that I’m not sure of myself.”

C++ 76

C++ Code Programming AWS 76

SQL Performance

FEBRUARY 10, 2021

But this option is available only starting with SQL Server 2019, which introduced scalar UDF inlining. L0 AS ( SELECT 1 AS c. SET NOCOUNT ON ; DECLARE @c INT = 0 ; WHILE @c < 128. SELECT TOP ( 1048576 ) @c * 1048576 - 1 + ROW_NUMBER ( ) OVER ( ORDER BY ( SELECT NULL ) ) FROM master.

C++ 124

C++ Servers Testing Code 124

O'Reilly

MARCH 2, 2020

I don’t care what you call it, but large projects (a) are rarely successful, regardless of the methodology, because they (b) get overloaded with a lot of features that nobody needs but that sound good, and (c) forget what the customer or user really needs or wants. Key survey results: The C-suite is engaged with data quality.

Artificial Intelligence 21

Artificial Intelligence Software Architecture Programming C++ 21

SQL Performance

MAY 11, 2022

I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. 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. ( Figure 5: Plan for Query 5. max3: orderid.

C++ 133

C++ Database Servers Code 133

Brendan Gregg

AUGUST 29, 2021

Hit Ctrl-C to end. ^C C msecs : count distribution 0 -> 1 : 83 | | 2 -> 3 : 20 | | 4 -> 7 : 0 | | 8 -> 15 : 41 | | 16 -> 31 : 1620 | * | 32 -> 63 : 8139 | *| 64 -> 127 : 176 | | 128 -> 255 : 95 | | 256 -> 511 : 61 | | 512 -> 1023 : 93 | |. Hit Ctrl-C to end. ^C 41 33681 ^C. Tracing block device I/O.

Cache 78

Cache C++ AWS Java 78