Faster Data Migrations in Postgres

Fellowship of the Data – Dataedo Data Cartoon

We love when you use our cartoons! You can use them for free for private, educational, and commercial purposes as long as you give us proper credit. You can publish them in your website, article, email, presentation, video, book, or any other media. How to do that?

dataedo.com

Monitoring PostgreSQL in a Hybrid Environment

Hybrid Cloud is a recent concept that has been increased for a few years, and now is a common topology in any company for a Disaster Recovery Plan (DRP), or even to have redundancy on your systems.

severalnines.com

CentOS Creator Gregory Kurtzer Discusses His New Distro, Rocky Linux

Rocky Linux is a new distribution based on a 1:1-compatible Red Hat Enterprise Linux binary, one designed as a drop-in replacement for CentOS, which used to be the go-to binary compatible version of RHEL (without the licensing fees) until Red Hat changed the course of CentOS last year to be more of

thenewstack.io

Capturing database table changes using kafka

This tutorial will guide you through how to setup up all that you need to stream changes happening to a postgres database table using kafka.

dev.to

Parameter Sniffing Is Usually A Good Thing

I talk to a lot of people about performance tuning. It seems like once someone is close enough to a database for long enough, they’ll have some impression of parameter sniffing. Usually a bad one. Often, even if it means writing unsafe dynamic SQL, people will be afraid to parameterize things.

erikdarlingdata.com

Sample Questions for AZ-304 Exam Microsoft Azure Architect Design- Expert Certification Exam

Hello Readers, here are sample questions to help you crack the AZ-304 Microsoft Azure Architect Design certification exam. You can answer 10 multiple choice questions, verify the correct answer at the end and grab your certificate quickly.

blog.cloudthat.com

Working with Persistent Volumes in Kubernetes

The main reason behind containerization is to allow microservices to run in a stateless way. A container will receive provisioned cloud resources, perform its tasks, and then be destroyed as soon as the process is over. There are no traces of that container or tied up cloud resources to worry about.

caylent.com

Logz.io Celebrates the Release of OpenTelemetry v.1.0

OpenTelemetry 1.0 (Otel) is finally here (in fact, 1.0.1). The announcement brings the industry closer to a standard for observability. OpenTelemetry v1.0.1 will focus solely on tracing for now, but work continues on integrations for metrics and logs.

logz.io

Using HPKE to Encrypt Request Payloads

The Managed Rules team was recently given the task of allowing Enterprise users to debug Firewall Rules by viewing the part of a request that matched the rule.

blog.cloudflare.com

PostgreSQL on FreeBSD, updating & configuration

In the last post we installed FreeBSD, configured the keyboard, time zone and the first network interface, which gets it’s IP address via DHCP. In this post we’ll look at how we can configure the second interface, which gets a static IP address in the host only network.

blog.dbi-services.com

Query Store in SQL Server 2016

Every environment is configured differently; however, we have all experienced alerts being triggered due to unfavorable performance. Oftentimes, before our root cause analysis begins, the issue has resolved itself and/or someone may have rebooted.

virtual-dba.com

A General Indexing Strategy For Normal Queries

Most queries will have a where clause. I’ve seen plenty that don’t. Some of’em have surprised the people who developed them far more than they surprised me. But let’s start there, because it’s a pretty important factor in how you design your indexes.

erikdarlingdata.com

Sizing Aria Pagecache

I wrote two articles about correctly sizing InnoDB buffer pool: Is InnoDB Buffer Pool big enough? and Can we shrink InnoDB Buffer Pool?. Aria is a MariaDB storage engine that is used for internal temporary tables and, potentially, tables created by the user.

vettabase.com

Cloudbase Solutions

In part 2 of this series about OpenStack on ARM64, we got to the point where our cloud is fully deployed with all the Compute (VMs), Software Defined Networking (SDN) and Software Defined Storage (SDS) up and running.

cloudbase.it

Replicating MongoDB Across a Hybrid Cloud Environment

Relying only on on-premises infrastructure may limit how quickly organizations can develop and launch applications. Extending the infrastructure to utilize public cloud in a hybrid setup is a great way to achieve infrastructure agility.

severalnines.com

Couchbase Support for Node-to-node Encryption

Couchbase supports node-to-node encryption or Cluster encryption by adding TLS based encryption to the connections between the nodes within a Couchbase cluster.

blog.couchbase.com

Capture SQL Server Connectivity Errors in the ERRORLOG

Suppose SQL Server users periodically report they lose connections to the database server. They also note that the connection interruptions are random and can happen several times per day with various intensity. In order to monitor these connectivity issues, you need to record these errors somehow.

mssqltips.com

PWDCOMPARE

En esta entrada, vamos a usar una función de SQL Server PWDCOMPARE para testear la seguridad de las contraseñas de nuestros usuarios SQL. Es muy sencilla, admite dos parámetros, el primero es un nvarchar, es decir un texto plano y el segundo el hash encriptado de una contraseña.

sicuel.es

10 Things Every DBA Needs to Do That Have Nothing to Do With Databases

The average Oracle DBA is very technically focused and up-to-date on the new products and features that arrive every few months and the new patches that come every few days.

dbta.com

DB2 12 for z/OS, DRDA Applications and Application Compatibility Part One

This, the first of two articles on how to manage the Application Compatibility level for DRDA applications, provides an introduction to the subject and considers two of the ways of doing this.

worldofdb2.com

The Most Important Skills for an SRE, DBRE, or DBA

I have talked extensively about the DBA’s evolving role and how many DBA’s and operations professionals are now becoming SRE’s (site reliability engineers) or DBRE’s (database reliability engineers).

percona.com

Reconsidering Missing Index Requests

Part of reviewing any server necessarily includes reviewing indexes. When you’re working through things that matter, like unused indexes, duplicative indexes, heaps, etc. it’s pretty clear cut what you should do to fix them. Missing indexes are a different animal though.

erikdarlingdata.com

On Prem To The Cloud: Getting Started (Ep 1)

Welcome to the first in a series on moving your applications to the cloud. Together, with Abel Wang and the rest of the Cloud Advocacy DevOps team, we’ll embark on a journey to show you the possibilities available to migrate your application to the cloud.

devblogs.microsoft.com

Monitoring MariaDB Performance in a Hybrid Cloud

Performance in our MariaDB database is one of the areas we want to closely monitor and observe in a production environment and its timely running condition. It can be extremely demanding for time, work, and money if the architectural setup uses a Hybrid Cloud.

severalnines.com

Modes of Transactions in SQL Server

In this article, we are going to talk about the modes of transactions in SQL Server. In the following sections, we will tackle these transactions’ features, similarities, and differences.

sqlshack.com

8 databases supporting in-database machine learning

In my August 2020 article, “How to choose a cloud machine learning platform,” my first guideline for choosing a platform was, “Be close to your data.” Keeping the code near the data is necessary to keep the latency low, since the speed of light limits transmission speeds.

infoworld.com