SQL Server According to Bob

SEPTEMBER 9, 2019

Previous posts have discussed partitioning, for example, a partitioned memory object [link] and how a latch maintains the desired access (exclusive, shared, …) [link]. For example: When ‘use database’ takes place the session acquires a shared lock on database. Bob Dorr – Principal Software Engineer SQL Server.

Servers 103

Servers Database Scalability Tuning 103

Percona

APRIL 20, 2023

In this blog post, you will learn: how to leverage FDE on Kubernetes with Percona Operator for PostgreSQL how to start using encrypted storage for already running cluster Prepare In most public clouds, block storage is not encrypted by default. The configuration of the storage class depends on your storage plugin.

Storage 123

Storage AWS Cloud Database 123

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. with MySQL 8, and provide practical examples to demonstrate the differences. This counter value is stored in memory and is not persistent across server restarts.

Servers 115

Servers Storage Database Open Source 115

The Netflix TechBlog

JUNE 12, 2023

Relatively few authorization plugins are broadly used within the Mac admin community, but one popular example is the Crypt agent. In its typical configuration the Crypt agent enforces FileVault upon login and escrows the resulting recovery key to a corresponding Crypt server.

Open Source 194

Open Source Database Servers Storage 194

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. We will examine these alternatives in the upcoming sections.

Traffic 339

Traffic Latency Tuning Systems 339

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 Compress the audit log files to reduce the storage space occupied with log files. A server restart is not required to add or adjust existing filtering rules. See the recommended documentation for more information about its capacity and usage examples.

Open Source 110

Open Source Database Servers Storage 110

All Things Distributed

JANUARY 23, 2012

Expanding the Cloud - The AWS Storage Gateway. Today Amazon Web Services has launched the AWS Storage Gateway, making the power of secure and reliable cloud storage accessible from customersâ?? With the launch of the AWS Storage Gateway our customers can now integrate their on-premises IT environment with AWSâ??s

Storage 115

Storage AWS Virtualization Cloud 115

Dynatrace

OCTOBER 17, 2023

How IT operations teams can de-silo monitoring data According to the Gartner report, “IT operations practitioners may be in specific silos, such as the network team, server team, virtualization team, application support team or other cross-functional teams (such as a generalized monitoring team).

Monitoring 225

Monitoring Artificial Intelligence Performance Analytics 225

Scalegrid

NOVEMBER 23, 2023

Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security. It represents either an IP address or domain name of the server, where one can find those databases located. Do check your configuration accordingly, however.

Database 130

Database Servers Storage Network 130

The Polyglot Developer

APRIL 6, 2017

When building a mobile application, there are often scenarios where you need to storage files remotely and when I say files, I don’t mean database data. For example, maybe you want to develop an image manager or photo storage solution like what Facebook and Instagram offer?

Storage 59

Storage Cloud Open Source Mobile 59

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. Examples of things that could cause a plan to change to a parallel scan include: Out-of-date statistics. The LOG_MANAGER Latch.

Servers 57

Servers Storage Efficiency Database 57

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. Configuring storage in Kubernetes is more complex than using a file system on your host. The Kubernetes experience.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Dynatrace

DECEMBER 15, 2022

As with all other log ingestion configurations, these examples work seamlessly with the new Log Management and Analytics powered by Grail that provides answers with any analysis at any time. Typically, these are streamed to a central syslog server. Let’s take this example of AWS Fargate. Log ingestion strategy no.

Strategy 180

Strategy AWS Open Source Transportation 180

Dynatrace

JUNE 16, 2020

With our new TIBCO EMS extension you can further enrich this information and see, for example, how many messages are getting stuck or how many messages went through the system. Apply Davis AI to your TIBCO EMS servers. For example, you can create your own dashboard in minutes: What you get. Synchronous storage size.

Storage 133

Storage Metrics Java Architecture 133

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. However, simply deploying a monitoring tool is not enough; you need to know which Key Performance Indicators (KPIs) to monitor to gain insights into your MySQL server’s health and performance.

Performance 108

Performance Monitoring Traffic Database 108

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. You can pick a smart selection of relevant metrics from these.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

SEPTEMBER 19, 2023

This issue most often occurs when there is significant MySQL server activity during the backup operation, and the redo log file storage media operates faster than the backup storage media. Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable.

C++ 110

C++ Servers Storage Speed 110

Percona

FEBRUARY 10, 2023

Percona XtraBackup is an open source hot backup utility for MySQL-based servers. To take consistent and hot backup, it uses various locking methods, especially for non-transactional storage engine tables. This feature is available in Percona Server for MySQL 5.6+. So for Percona Server for MySQL 5.7

Storage 106

Storage Engineering Open Source Servers 106

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward. Integer Example.

Servers 63

Servers Database Testing Efficiency 63

Percona

MAY 9, 2023

Many MongoDB clusters use storage-level snapshots to provide fast and reliable backups. Background story I recently worked with a company running a large four-shard MongoDB Enterprise Server database cluster on VMs on premises that decided to migrate to the Google Cloud Platform.

Storage 110

Storage Cloud Servers Google 110

The Polyglot Developer

SEPTEMBER 17, 2018

I’ve been slowly trying to cut down on my online file storage footprint by switching to software and tools that I’m in full control over. We’re going to see how to install and configure Resilio Sync on a Raspberry Pi to act as a synchronization node on your network for file storage and fast transfers.

Storage 40

Storage Network Cloud Servers 40

SQL Server According to Bob

DECEMBER 3, 2019

I have previously tested and blogged about the NTFS, sparse, file system limitation error 665: [link] when running DBCC or using Snapshot databases with SQL Server. This paper details XFS storage format and structures: [link] – Specifically the theoretical limits table section. filefrag -v test.dat. – Bob Dorr.

Servers 45

Servers Systems Storage Database 45

Dynatrace

JULY 29, 2021

Examples of specific domain knowledge where extended topology is used include the representation of concepts like Kubernetes or serverless functions in Dynatrace. For example, you may need to model physical locations of shops or branch offices due to reporting requirements.

Analytics 246

Analytics Open Source Serverless Architecture 246

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. Dynatrace news.

Internet 260

Internet Internet Games Java 260

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. The changes done by an uncommitted transaction can be flushed or written to the redo log by the server. They are then applied (for example, writing old values back again) to the pages again and written to disk.

Cache 88

Cache Benchmarking Servers Design 88

Dynatrace

APRIL 26, 2022

STM generates traffic that replicates the typical path or behavior of a user on a network to measure performance for example, response times, availability, packet loss, latency, jitter, and other variables). PC, smartphone, server) or virtual (virtual machines, cloud gateways). Endpoints can be physical (i.e.,

Monitoring 203

Monitoring Social Media IoT Metrics 203

Percona

MARCH 17, 2023

PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. Planning for resources of a PMM Server host instance can be tricky because the numbers can change depending on the DB instances being monitored by PMM. 25 Bytes, or you should plan storage roughly between 500 GB – one TB for a default 30 day retention period.

Monitoring 104

Monitoring Scalability Cache Database 104

Percona

JANUARY 19, 2023

Example (using the employee sample DB ): Suppose we have the following schema: db1 employees> show create table employeesG 1. Example: Creating four simple tables to store strings but using different data types: db1 test> CREATE TABLE tb1 (id int auto_increment primary key, test_text char(200)); Query OK, 0 rows affected (0.11

Open Source 93

Open Source Storage Database Big Data 93

All Things Distributed

AUGUST 17, 2011

No Server Required - Jekyll & Amazon S3. As some of you may remember I was pretty excited when Amazon Simple Storage Service (S3) released its website feature such that I could serve this weblog completely from S3. I took my time to figure out what weblog CMS I was going to use to free me from having to run a server.

Servers 126

Servers Social Media AWS Website 126

Percona

JANUARY 24, 2023

Our Operators provide built-in backup and restore capabilities, but some users are still looking for old-fashioned ways, like storage-level snapshots (i.e., Both your storage and Container Storage Interface (CSI) must support snapshots. For example, for GKE, you must create a VolumeSnapshotClass resource first.

Database 69

Database Storage Open Source AWS 69

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 ?.

Performance 125

Performance Cache Servers Social Media 125

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

Scalegrid

JANUARY 9, 2024

Defining Enterprise Cloud Security In today’s business landscape, the reliance on cloud services for data storage and processing has made enterprise cloud security a crucial factor. Tackling the Challenges of Cloud Security Enterprises face a unique array of challenges related to cloud security.

Strategy 130

Strategy Cloud Best Practices Government 130

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

Dynatrace

JUNE 15, 2020

If you work with a client/server setup, some crashes will have their root cause on the server-side. This means that you get full visibility, all the way from individual user actions down to the specific server-side database statements that contribute to mobile crashes. Symbol files for faster analysis.

Mobile 163

Mobile Servers Operating System Storage 163

Scalegrid

APRIL 28, 2020

Since database hosting is more dependent on memory (RAM) than storage, we are going to compare various instance sizes ranging from just 1GB of RAM up to 64GB of RAM so you can see how costs vary across different application workloads. For example, in the US, we distribute nodes across New York 3, New York 2 and New York 1. Learn more.

Azure 344

Azure AWS Database Latency 344

Dynatrace

DECEMBER 16, 2020

Every storage location involving data at rest is encrypted as well. These certificates are stored on physical devices which are plugged into specifically hardened build servers. If a verification fails (for example, due to installation package manipulation by an attacker), the update process is stopped.

Software 233

Software Software Development AWS 233