SQL Shack

JULY 14, 2020

This article explores the configuration of Windows failover clusters, storage controllers and quorum configurations for SQL Server Always On Availability Groups. Prerequisites In this series of articles, we will configure the SQL Server always on availability groups from end to end for your learning purpose.

Storage 75

Storage Availability Servers 75

Dynatrace

DECEMBER 16, 2021

Since December 10, days after a critical vulnerability known as Log4Shell was discovered in servers supporting the game Minecraft, millions of exploit attempts have been made of the Log4j 2 Java library, according to one team tracking the impact, with potential threat to millions more applications and devices across the globe.

Internet 262

Internet Internet Games Java 262

DZone

JULY 3, 2023

Data engineering projects often require the setup and management of complex infrastructures that support data processing, storage, and analysis. In this article, we will explore the benefits of leveraging IaC for data engineering projects and provide detailed implementation steps to get started.

Data Engineering 150

Data Engineering Infrastructure Code Engineering 150

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. Graphical query planning tool with syntax highlighting.

Open Source 262

Open Source Database Azure Servers 262

Dynatrace

DECEMBER 16, 2020

This article explains what a software supply chain attack is, and how Dynatrace protects its customers against such attacks by applying: Risk management and business continuity planning. Every storage location involving data at rest is encrypted as well. Dynatrace news. Security controls in the software development life cycle (SDL).

Software 240

Software Software Development AWS 240

SQL Shack

OCTOBER 6, 2021

This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances. Introduction The server performance depends on various factors such as CPU, Memory, and Storage configurations. SQL Server works on top of the operating system and works closely with these resources.

Servers 88

Servers Database Operating System Storage 88

SQL Shack

AUGUST 17, 2020

In this article, we will discuss how to resolve I/O problems that is a very important point for the SQL Server troubleshooting. The storage subsystem is one of the significant performance factors for the databases. Detecting and identifying I/O problems in SQL Server can be a tough task for the database administrators (DBAs).

Servers 82

Servers Storage Database Performance 82

Highly Scalable

MARCH 1, 2012

In this article I provide a short comparison of NoSQL system families from the data modeling point of view and digest several common modeling techniques. I would like to thank Daniel Kirkdorffer who reviewed the article and cleaned up the grammar. The rest of this article describes concrete data modeling techniques and patterns.

Database 279

Database Ecommerce Efficiency Engineering 279

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server with Percona XtraBackup. installed REPLICA: mysql8 (192.168.56.113) with Percona Server 8 and xtrabackup 8.0

Servers 111

Servers C++ Storage Systems 111

Scalegrid

MARCH 8, 2024

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. This isn’t merely about taking a full backup or enabling binary logging.

Database 162

Database Strategy Servers Best Practices 162

SQL Performance

JULY 19, 2022

Each log record has a fixed overhead so, sometimes, the Storage Engine breaks this rule by combining multiple changes into a single log record to reduce the total number of log records written to the log. There are between 70 and 100 log record types, depending on the version of SQL Server (there’s no documented list).

Servers 94

Servers Database Storage Engineering 94

SQL Performance

OCTOBER 7, 2020

For more background on these performance spools see my prior article. With those out of the way, this article is exclusively about Sorts and when they can rewind. Sorts use storage (memory and perhaps disk if they spill) so they do have a facility capable of storing rows between loop iterations. Row Count Spool. Remote Query.

Servers 106

Servers Cache Azure Performance 106

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 163

Virtualization Infrastructure Monitoring Cloud 163

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. Basically, you can view this as a PostgreSQL instance but without a storage layer Storage Broker Storage Broker is a coordination component between WAL Service and Pageserver.

Serverless 123

Serverless C++ Storage Servers 123

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice. Data transfer technology.

Cache 130

Cache Storage Architecture Scalability 130

DZone

JULY 19, 2023

This article discusses the profound influence these elements have on IT operations within the utility and energy sector, providing a robust and adaptive infrastructure for the future. Before moving on to the main article, here is a pertinent case study that helps demonstrate the importance of such digital transformation.

Virtualization 130

Virtualization Scalability Cloud Energy 130

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. autovacuum may have trouble keeping up on a busy server.

Strategy 182

Strategy Cloud Java Open Source 182

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. . pg_repack – reorganizes tables online to reclaim storage. What’s causing this massive shift?

Open Source 244

Open Source Tuning C++ Database 244

Dynatrace

JULY 11, 2023

When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. The problem with the IIS server access logs was the headers. This article was developed in conjunction with Robin Wyss. Just ask your Dynatrace account rep.

Database 164

Database Government Servers Games 164

The Netflix TechBlog

SEPTEMBER 10, 2024

By Karthik Yagna , Baskar Odayarkoil , and Alex Ellis Pushy is Netflix’s WebSocket server that maintains persistent WebSocket connections with devices running the Netflix application. KeyValue is an abstraction over the storage engine itself, which allows us to choose the best storage engine that meets our SLO needs.

Latency 235

Latency Cache Tuning Efficiency 235

Scalegrid

JANUARY 12, 2024

This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure. These include popular technologies such as web servers and web applications, along with advanced solutions like distributed data stores and containerized microservices.

Cloud 130

Cloud Virtualization Storage Efficiency 130

SQL Shack

SEPTEMBER 9, 2019

In this article, we will study in detail about the how SQL Server Index Fill factor works. Index Fill factor SQL Server Index Fill Factor is a percentage value to be filled data page with data in SQL Server. This option is available in index properties to manage data storage in the data pages. It […].

Servers 56

Servers Benchmarking Performance Storage 56

Scalegrid

AUGUST 30, 2024

This article provides instructions on how to fortify your RabbitMQ setup. Authentication Mechanisms in RabbitMQ RabbitMQ provides several authentication mechanisms to ensure the security of user-server connections, such as using a combination of username and password or employing X.509 509 certificates, and OAuth 2.0, 509 certificates.

Transportation 130

Transportation Virtualization Strategy Storage 130

Percona

SEPTEMBER 12, 2023

this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. In this article, we will look into this enhancement, compare MySQL 5.7 This counter value is stored in memory and is not persistent across server restarts.

Servers 116

Servers Storage Database Open Source 116

SQL Shack

DECEMBER 5, 2019

This article discusses the Forwarded Records and its performance issues for heap tables in SQL Server. Heap introduction and performance issues A page of 8KB is the smallest unit of storage in SQL Server. In each page of SQL Server, we have a 96-bytes header to store the system information.

Servers 53

Servers Performance Storage Systems 53

CSS - Tricks

SEPTEMBER 21, 2020

There are two images sitting on a server, a large one and a small one. Rather than a file (like an image) needing to travel across the world, it comes from a server much geographically closer on a server designed for that job. Imagine images. Imagine the performance implications of that. The large one. Fair enough.

Website 97

Website Energy Storage Efficiency 97

Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. Client Side Rendering, Server Side Rendering And Jamstack. To run it, you have to make another API call to the server and retrieve any data you want to load. Jump to online workshops ?.

Cache 128

Cache Performance Servers Architecture 128

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. This article is about batch mode bitmaps, which have a very different implementation. Background. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

Smashing Magazine

JUNE 18, 2020

In this article, we’re going to see some of those differences and how to overcome them. More specifically, we’re going to talk about storage and UI differences, which are the ones that most often cause confusion to developers when writing Flutter code that they want to be cross-platform. Example 1: Storage.

Storage 95

Storage Mobile Website Java 95

Scalegrid

JUNE 7, 2024

In this article, we will explore what RabbitMQ is, its mechanisms to facilitate message queueing, its role within software architectures, and the tangible benefits it delivers in real-world scenarios. It plays a critical role by assigning tasks, which trims down the delivery times for web application servers and enhances overall productivity.

IoT 130

IoT Software Architecture Architecture Scalability 130

Scalegrid

JUNE 14, 2024

In this article, we will explore the process of how to connect MySQL to Power BI, a leading business intelligence tool. MySQL Server Credentials To establish a connection between Power BI and MySQL, you’ll need the necessary server credentials, such as server address, port number, username, and password.

Database 130

Database Azure Efficiency Servers 130

Smashing Magazine

OCTOBER 26, 2021

In this article, we will go through how to optimize and build a high-performance Next.js We will go through how to set up an Nx server, how to add a plugin to an existing server, and the concept of a monorepo with a practical visualization. For this article, we will be focusing on how Nx works with Next.js Cloud storage.

Cache 112

Cache Servers Code Testing 112

The Netflix TechBlog

JUNE 25, 2021

It also provides tools to view the storage layout on disk; browse the supported sample queries (to help design efficient point queries); guide you through the process of choosing a compaction strategy, and many other advanced settings. See our integration with Metrics later in this article.) The server is a Node.js

Metrics 157

Metrics Best Practices Strategy Design 157

Scalegrid

JANUARY 8, 2024

Discover key insights and strategic advice in our article, designed to steer you toward the best cloud solution that fits your company’s priorities. This article will focus on the technology behind ScaleGrid’s Database-as-a-Service (DBaaS) solutions and how they align with multi-cloud and hybrid cloud structures.

Cloud 147

Cloud Strategy Scalability Artificial Intelligence 147

SQL Performance

SEPTEMBER 16, 2021

To finish up my short series of articles on latches, this time I’m going to discuss a few other latches in SQL Server you might see occasionally but don’t merit a complete article by themselves. The post SQL Server Latches – Other Latches To Know About appeared first on SQLPerformance.com. The LOG_MANAGER Latch.

Servers 57

Servers Storage Efficiency Database 57

CSS - Tricks

DECEMBER 23, 2020

In this article, we’ll go over how to set up Lighthouse CI and run it locally, then how to get it working as part of a CI workflow through GitHub Actions. Here’s the simplest configuration that will run and collect Lighthouse reports for a static website project, and upload them to temporary public storage. // lighthouserc.js

Performance 79

Performance Storage Servers Virtualization 79