Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. 2019-04-29T18:34:58+00:00. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. The Server Timing Header. Drew McLellan.

Servers 87

Servers Performance Metrics Database 87

Dynatrace

SEPTEMBER 7, 2019

TL9 SP9 as well as massive improvements in OneAgent deployment and automatic instrumentation of technologies with deep code monitoring modules. For complete details, see Fully automatic code level monitoring and extended version support for AIX. in November 2019 as it reached end-of-life on June, 27th 2019. with Java 6.

Java 102

Java Traffic AWS Monitoring 102

Scalegrid

NOVEMBER 29, 2023

Data Center Dynamics highlights a significant uptick in DBaaS adoption, growing from 40% to 45% between 2019 and 2020. This blog post will explore some of the major challenges in database management that businesses can expect, especially when transitioning from traditional database servers. Your data will always be intact.

Healthcare 130

Healthcare Hardware Database Scalability 130

Dynatrace

JANUARY 19, 2020

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. No ABAP code instrumentation or injection is performed.

Monitoring 155

Monitoring Best Practices Infrastructure Servers 155

Dynatrace

MAY 31, 2023

Uptime Institute’s 2022 Outage Analysis report found that over 60% of system outages resulted in at least $100,000 in total losses, up from 39% in 2019. Automation also enables tools to move into developers’ hands so they can make decisions about deploying code without needing to involve operations teams.

Best Practices 228

Best Practices DevOps Latency Metrics 228

Dynatrace

JANUARY 20, 2020

Having released this functionality in a Preview Release back in October 2019, we’re now happy to announce the General Availability of our SAP ABAP real user monitoring. Aggregated T-code scorecards give you immediate insights (for example, the slowest performing T-code) so you always know where to look first. Dynatrace news.

Monitoring 153

Monitoring Performance Infrastructure Network 153

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. It would be nice if SQL Server could push the aggregation down into the scan and just return distinct values from the column store directly.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

AUGUST 14, 2019

Run the following code to create the Transactions table and populate it with sample data: SET NOCOUNT ON ; USE TSQLV5 ; -- [link]. SQL Server 2019 introduces batch mode on rowstore support, so you can get batch-mode processing even if there's no columnstore indexes present on the data. DROP TABLE IF EXISTS dbo. Transactions. (

Best Practices 108

Best Practices Servers Database Azure 108

Dynatrace

JULY 9, 2019

Support for tracing of asynchronous code execution within Spring integrations.NET. support has been extended and will reach end-of-life in November 2019. x (Pivotal support for this version ended in April 2019. x (Pivotal support for this version ends in June 2019. Dynatrace news. OneAgent SDK for.NET (version 1.5.0)

Java 104

Java AWS Cloud Infrastructure 104

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. Reference software serves as the basis for standard development, a framework, in which the performance of video coding tools is evaluated. New Netflix Buildings in Los Gatos. What is SVT-AV1?

Open Source 166

Open Source Scalability Speed Efficiency 166

Dynatrace

JULY 31, 2020

The vendor has de-supported this technology and version with 2019-09-30. The vendor has de-supported this technology and version with 2019-09-30. Windows: Windows Server 2008. Windows: Windows Server 1809. Improved OneAgent.NET code module handling on read-only file systems. Oracle Hotspot JVM 12. OpenJDK 12.

Operating System 120

Operating System Java Infrastructure Monitoring 120

SQL Server According to Bob

JULY 31, 2018

Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. I changed the code to call unlink after open completes preventing new access to the file. Bob Dorr – Principal Software Engineer SQL Server. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

SQL Performance

SEPTEMBER 12, 2019

The main benefit of the PIVOT operator is that it tends to result in shorter code. However, this operator has a few shortcomings, among them an inherent design trap that can result in bugs in your code. You can find a clue that will help you figure out the bug in the code by looking at the query plan shown in Figure 1.

Best Practices 103

Best Practices C++ Code Design 103

SQL Performance

DECEMBER 11, 2019

Like them or not, as a database practitioner you often have to deal with them, and given that NULLs do add complexity to your SQL code writing, it's a good idea to make it a priority to understand them well. This query generates the following output: orderid shippeddate -- -- 10771 2019-01-02 10794 2019-01-02 10802 2019-01-02.

Best Practices 117

Best Practices C++ Database Code 117

The Netflix TechBlog

MARCH 21, 2019

A researcher found an application that ran on an older Windows server that was deployed in a non-standard way making it difficult for our automated visibility services to detect it. After further testing, the researcher found a remote code execution that we then rewarded and remediated with a higher priority.

Entertainment 166

Entertainment Programming Internet Internet 166

SQL Performance

AUGUST 11, 2021

Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. SQL Server Management Studio already has IntelliSense support, as shown in Figure 1: Figure 1: Intellisence support for DATE_BUCKET in SSMS. DATE_BUCKET.

Azure 139

Azure Code Database Servers 139

Particular Software

JANUARY 27, 2020

Microsoft Message Queuing, better known by its nickname MSMQ, passed away peacefully in its hometown of Redmond, Washington on October 14, 2019, at the age of 22. Since it exists in Windows 10 and Windows Server 2019, MSMQ will continue to live on until at least 2029—and much longer assuming it isn't removed from future versions of Windows.

Transportation 98

Transportation Azure Open Source Systems 98

Dynatrace

MAY 6, 2019

We recently introduced several code modules that provide out-of-the-box code-level insight for each mainframe transaction. Here’s what you can do with our GA code modules for z/OS: Gain insight into the CICS Transaction Server on z/OS with our CICS code module. In-depth analysis at the source-code level.

Java 117

Java Programming Technology Technology 117

SQL Performance

JANUARY 12, 2022

Use the following code to create the table and populate it with a small set of sample data: DROP TABLE IF EXISTS dbo. ( ID INT NOT NULL IDENTITY ( 1 , 1 ) CONSTRAINT pk_Auctions PRIMARY KEY CLUSTERED , Code CHAR ( 1 ) NOT NULL. Auctions ( ID , Code , Quantity ) VALUES. ( Auctions. (

Code 116

Code Servers Performance Azure 116

SQL Performance

FEBRUARY 12, 2020

According to the standard, you would use the following code with the DISTINCT predicate to handle this need: SELECT orderid , shippeddate FROM Sales. According to the standard, you would use the following code to handle such a join: SELECT T1. INNER JOIN dbo. k1 IS NOT DISTINCT FROM T2. k2 IS NOT DISTINCT FROM T2. CREATE TABLE dbo.

C++ 120

C++ Code Servers Database 120

Percona

MARCH 7, 2019

The server is a small instance: Models | 6xIntel(R) Xeon(R) CPU E5-2430 0 @ 2.20GHz 10GB RAM This symptom can be caused by various different reasons. In other words, the time the CPU was executing user code, such as MySQL. There could be more, but this particular query was definitely hurting the performance of the server.

C++ 100

C++ Traffic Servers Monitoring 100

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. 2019-04-29T18:34:58+00:00. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1.

AWS 44

AWS Servers Storage Cloud 44

KeyCDN

MARCH 22, 2023

Some attackers will try to deface your website and inject malware into it, steal your or your customer's data, and delete important content from your server. Why a website security check is so important In 2019, it was found that over 60% of websites were vulnerable at the time of infection.

Website 60

Website Servers Ecommerce Google 60

Scalegrid

MAY 2, 2019

In this post, we show you how to connect to an SSL-enabled MongoDB replica set configured with self-signed certificates using PyMongo, and how to test MongoDB failover behavior in your code. 1305:12 @(shell):1:1 2019-04-18T19:44:42.261+0530 I NETWORK [thread1] trying reconnect to SG-example-1.servers.mongodirector.com:27017

Testing 55

Testing Network Database Servers 55

Smashing Magazine

AUGUST 23, 2019

2019-08-23T13:30:59+02:00. 2019-08-23T13:06:42+00:00. The idea presented here is now to load only so many bytes of a progressive JPEG from the server that you can quickly get an impression of the image content. With Ajax, however, this is possible, provided that the server delivering the image supports HTTP Range Requests.

Network 103

Network Servers Programming Code 103

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. I tested my solutions in SQL Server 2019 Enterprise edition. SQL Server chose row mode processing for all previously shown solutions by default.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

APRIL 10, 2019

I posted a suggestion to improve SQL Server by adding support for RPR in T-SQL , but I was quite limited in the space that I had to provide the feedback. Use the following code to create the table, populate it with some sample data, and query it: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. STOCK1 2019-02-12 150.00

C++ 73

C++ Servers Virtualization Code 73

Scalegrid

SEPTEMBER 16, 2019

You can remotely access and navigate another database server. The dashboard lets you monitor server activities such as database locks, connected sessions, and prepared transaction. Since pgAdmin is a web application, you can deploy it on any server and access it remotely. 2019 Comparison Click To Tweet.

Open Source 262

Open Source Database Azure Cloud 262

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. My test machine has four logical CPUs, running SQL Server ® 2019 Enterprise.

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

MARCH 29, 2022

When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. The bigint type isn’t used for server-side parameterization.

Cache 90

Cache Servers Database Testing 90

SQL Performance

MAY 11, 2022

You can download the source code to create and populate this database here. I ran all the examples on SQL Server ® 2019 Developer, where batch-mode on rowstore is available. SQL Server doesn't currently support an efficient combination of a parallel order-preserving input prior to a parallel batch-mode Window Aggregate operator.

C++ 133

C++ Database Servers Code 133

Percona

AUGUST 17, 2023

StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. That community spans expertise and industries, putting diverse skill sets and fresh perspectives into the review and improvement of code. Bugs and security vulnerabilities are identified more quickly.

Open Source 78

Open Source Healthcare Social Media Database 78

Smashing Magazine

MAY 25, 2021

A number of sites moved to font-display: swap when this first came out, and Google Fonts even made it the default in 2019. The amount of code isn’t huge, but it still feels like a little bit more effort than it should be. However, beyond that it didn’t really solve the problem.

Operating System 143

Operating System Google Website Cache 143

Smashing Magazine

APRIL 17, 2019

2019-04-17T12:30:16+02:00. 2019-04-29T18:34:58+00:00. Every time you type a URL in the browser address bar, follow a link in a page or even load a resource like an image from a different domain, the browser needs to do a DNS lookup to find the server that holds the resource we’ve requested. Drew McLellan. Preconnecting.

Performance 106

Performance Games Servers Cache 106

Smashing Magazine

JANUARY 15, 2019

2019-01-15T13:30:32+01:00. 2019-04-29T18:34:58+00:00. So, apart from powering servers with renewable energy, what else can web developers do about climate change? This includes the work done by the server, the client and the intermediary communications networks that transmit data between the two. Jack Lenox.

Website Performance 73

Website Performance Website Energy Performance 73

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. 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.

C++ 111

C++ Database Servers Code 111

The Morning Paper

JUNE 6, 2019

SysML 2019. FL is one instance of the more general approach of “bringing the code to the data, instead of the data to the code” and addresses the fundamental problems of privacy, ownership, and locality of data. Devices upload cryptographically masked updates and the server computes a sum over those updates.

Systems 71

Systems Design Google Servers 71