SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher.

Servers 145

Servers C++ Code Database 145

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 83

Servers Database Open Source Scalability 83

DZone

JANUARY 16, 2024

You write your code, and the cloud provider handles the rest - provisioning, scaling, and maintenance. When we talk about " serverless ," it doesn't mean servers are absent. Instead, the responsibility of server maintenance shifts from the user to the provider.

Serverless 284

Serverless AWS Architecture Lambda 284

Dynatrace

APRIL 8, 2020

Optimize your code by finding and fixing the root cause of garbage collection problems. These details arm you with the knowledge necessary to find the respective code and remove unnecessary allocations. Any significant reduction in allocations will inevitably speed up your code. You can even look at the source code directly. .

Speed 165

Speed Code Java Lambda 165

Dynatrace

SEPTEMBER 7, 2019

Fully automatic deep code monitoring module injection. One of the unique strengths of Dynatrace OneAgent is the fully automated injection of the deep code monitoring module on Windows and Linux. Fully automated deep code monitoring module injection is available for all customers as of OneAgent version 1.175.

Code 128

Code Monitoring Java Operating System 128

Dynatrace

JANUARY 23, 2024

XML external entity (XXE) exploit The aXMLRPC library allows its users to connect to a server and perform RPC calls using the XML-RPC protocol over HTTP. A possibility to make this exploit successful is a man-in-the-middle attack that intercepts the connection to a legitimate server.

Java 206

Java Servers Code Software 206

SQL Shack

SEPTEMBER 6, 2021

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90

Servers Database Code Performance 90

Dynatrace

JUNE 12, 2020

Besides being the most popular web server back end, PHP is also commonly used for developing microservices, shell applications, high-scale back ends, and for scheduling automated tasks. Dynatrace has long provided automatic code-level performance monitoring for PHP applications with OneAgent. to PHP 7.3.

Code 133

Code Monitoring Database Metrics 133

SQL Shack

SEPTEMBER 28, 2020

In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.

Servers 107

Servers Programming Code Software 107

HammerDB

DECEMBER 14, 2022

In this post, we will do a walk through example of installing and configuring unixODBC and the SQL Server on Linux drivers as well as the HammerDB connection options to enable HammerDB on Linux to be able to connect to SQL Server. We can verify the configuration and drivers as follows: Copy Code. Use a different Browser./configure

Servers 62

Servers Virtualization Code Testing 62

Simform

JULY 28, 2022

A few years ago, servers were the irreplaceable menace that gave developers nightmares. Even if one server experienced downtime, the entire system collapsed and finding out the issue required piecing together every misstep and miscalculation. Let’s not even talk about the business lost during this whole time.

DevOps 59

DevOps Infrastructure Code Servers 59

DZone

FEBRUARY 6, 2024

Its simplicity and efficacy make it the go-to solution for diagnosing and understanding system-level operations, especially when working with servers and containers. If you have friends who are learning to code, I'd appreciate a reference to my Java Basics book.

Java 245

Java Servers Systems Code 245

Dynatrace

MARCH 18, 2024

For example, poorly written code can consume a lot of resources, or an application can make unnecessary calls to cloud services. Are there rogue servers running in the environment where ITOps, CloudOps, or another team can’t assign or identify who’s financially responsible for it? Suboptimal architecture design.

Best Practices 233

Best Practices Strategy Cloud AWS 233

SQL Shack

SEPTEMBER 15, 2021

This article intends to give comprehensive details on how we can use the recompilation options of SQL Server stored procedures and how they behave when we use these recompilation options. A stored procedure is a ready T-SQL code that can be reused again and again. What is a SQL stored procedure?

Servers 80

Servers Code Performance 80

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 72

Servers Database Testing Open Source 72

Smashing Magazine

NOVEMBER 2, 2021

Creating A Magento PWA: Customizing Themes vs. Coding From Scratch. Creating A Magento PWA: Customizing Themes vs. Coding From Scratch. One of the reasons for that is because a PWA has the same code base. So unlike the case with native applications, the progressive web app needs to be coded only once. Alex Husar.

Code 74

Code Cache Retail Mobile 74

DZone

JANUARY 3, 2022

An access log is generated by the web server to log the details about the request that it has processed. It logs status code, response time, URL, protocol, size, client IP address, etc., Most people are aware of the application server log but many of them are not aware of the web server/load balancer access log.

Performance 246

Performance Servers Code Availability 246

Percona

MARCH 13, 2023

Percona Server for MySQL 5.7.41-44 44 On March 2, 2023, Percona Server for MySQL 5.7.41-44 It is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database, and Percona Server for MySQL 5.7.41-44 Download Percona Server for MySQL 5.7.41-44 code base, and starting with version 8.0.32-25,

Servers 78

Servers Open Source Database Software 78

DZone

OCTOBER 25, 2023

TLDR eBPF is a mechanism that makes the kernel dynamically programmable without modifying the source code. eBPF has been running in production for over half a decade at an internet scale on millions of servers. You'll see the term BPF in Linux source code, and you'll see BPF and eBPF used interchangeably in tooling and documentation.

Internet 195

Internet Internet Programming Network 195

The Netflix TechBlog

MAY 4, 2023

These include options where replay traffic generation is orchestrated on the device, on the server, and via a dedicated service. Moreover, allowing the device to execute untested server-side code paths can inadvertently expose an attack surface area for potential misuse.

Traffic 339

Traffic Latency Tuning Systems 339

Dynatrace

NOVEMBER 3, 2023

focused on technology coverage, building on the flexibility of JMX for Java and Python-based coded extensions for everything else. While Python code can address most data acquisition and ingest requirements, it comes at the cost of complexity in implementation and use-case modeling. Dynatrace Extensions 1.0 Extensions 2.0

Technology 247

Technology Technology Scalability Availability 247

DZone

FEBRUARY 7, 2022

It offers all the functionality we need to deploy our application in production, with a hybrid system with static pages and server-side rendered (SSR) pages. Isomorphic: Works on both server and client (browser). Static export: Compile static files to be able to upload to the server. SSR Benefits (Next.js). Performance.

Mobile 246

Mobile Website Servers Code 246

The Netflix TechBlog

FEBRUARY 13, 2024

Conversely, using integration testing tools like Cypress or Playwright provides control over the page, but sacrifices the ability to instrument the bootstrapping code for the app. Inability to make assertions on spies/mocks or execute code within the app. Two-way communication between the browser and test (node) context.

Testing 244

Testing Code Servers Testing Tools 244

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 We recommend checking out our products for Percona Server for MongoDB , Percona Backup for MongoDB , and Percona Operator for MongoDB. PSMDB), the best practice to create an index was doing it in a rolling manner. Starting from PSMDB 4.4, Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function

Servers 79

Servers C++ Storage Best Practices 79

Dynatrace

OCTOBER 25, 2023

Tracked as CVE-2023-34051 (CVSS score: 8.1), the Aria Operations for Logs vulnerability relates to a case of authentication bypass that could lead to remote code execution. In their report , they presented how an attacker could use three different CVEs to achieve remote code execution. Spoof the IP address of the known worker.

Analytics 267

Analytics Operating System Code Servers 267

SQL Performance

OCTOBER 21, 2021

A colleague recently said to me, after expressing a preference to force an empty string instead of allowing NULL: "I don't like dealing with nulls in code.". The post Bad Habits: Avoiding NULL in SQL Server appeared first on SQLPerformance.com. I’m sorry, but that’s not a good reason. Conclusion.

Servers 103

Servers Design Speed Code 103

DZone

FEBRUARY 16, 2023

Both GraphQL and Protocol Buffers (Protobuf) are types of formats for transferring data between client and server. It enables clients to specify the exact data required and makes it simple to evolve APIs over time without breaking existing client code.

Servers 256

Servers Design Code 256

DZone

APRIL 6, 2023

Kubernetes provides many features which are similar to Spring Cloud and Spring Config Server features. It's a great deal when developers have total control over cloud configuration along with business logic source code. Spring framework has been around for many years.

Java 243

Java Cloud Servers Code 243

Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers 130

Servers Best Practices Government Network 130

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. I have SQL Server 2019 CTP 3.2 Now that 2019 CTP 3.2

Servers 95

Servers C++ Testing Systems 95

Scalegrid

JANUARY 25, 2024

You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health. Connected_slaves provides information about replication status while Used_memory tracks utilized amount of server’s total capacity. <code> 127.0.0.1:6379> <code> 127.0.0.1:6379>

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

APRIL 21, 2022

Dynatrace Application Performance Management (APM) has long provided multiple options for database monitoring, including deep insights into code and statements, service level visibility, connection pool monitoring, and more. Easily track the health and performance of database servers with AI support.

Database 241

Database DevOps Analytics Servers 241

SQL Shack

FEBRUARY 3, 2022

Introduction SQL is a non-procedural programing language that means the database users only code what they want to do and they can’t describe how […]. In this article, we will go through the details of the trivial execution plans and we will also tackle some examples about the trivial plans to explore effects on query performance.

Servers 83

Servers Programming Database Code 83

DZone

MARCH 25, 2022

As you may agree, it is important to test your code. The resilience patterns implemented in your application are code (even if they're just a bunch of annotations). Often I saw that this is not tested thoroughly or not at all. With Testcontainers , writing integration tests has become a commodity.

Testing 256

Testing Open Source Engineering Servers 256

Dynatrace

APRIL 14, 2022

With a critical CVSS rating of 9.8 , Spring4Shell leaves affected systems vulnerable to remote code execution (RCE). Further, the report lists Tomcat as the most popular Java application server. Figure 2: Spring Controller that maps the DemoObject to requests received at the server. What is the Spring Framework?

Java 217

Java Servers Code Open Source 217

Dynatrace

OCTOBER 10, 2022

Despite the name, serverless computing still uses servers. This means companies can access the exact resources they need whenever they need them, rather than paying for server space and computing power they only need occasionally. If servers reach maximum load and capacity in-house, something has to give before adding new services.

Serverless 166

Serverless Infrastructure Lambda Latency 166

SQL Server According to Bob

FEBRUARY 5, 2018

SQL Server on Linux uses the GSSAPI and SSSD service for Active Directory (AD) authentication activities. system but not on my Centos 7 system joined to the same domain (realm.) I followed the common guidance for using Active Directory with SQL Server on Linux – no luck. SQL Server (SQLPAL) Logging (/var/opt/mssql/logger.ini).

Servers 40

Servers Code Cache Traffic 40