Generating Flexible Random data in MySQL

5 Key Postgres Advantages Over MySQL

Both systems provide frequent updates and have a thriving community supporting them, but Postgres has some key advantages over MySQL. Not all relational database management systems (RDBMS) are created equal.

dzone.com

Top 5 Reasons to Use an Oracle Database

Whether you’re already using Oracle or currently considering database solutions for your business needs, Markus Michalewicz, senior director of product management at Oracle, recently identified five reasons why Oracle Database is the best option. They are:

dbta.com

cloudsecurityalliance.org

Tokenization vs. Encryption: Which is Better for Your Business?

Finding the right security technology for your company's data can be difficult. There are myriad options and a lot of industry terms and jargon thrown around without much reliable information with which to make a smart business decision.

Deduplicating Missing Index Requests Part 1

I often find myself reviewing missing index requests during consulting engagements. Not because they’re so awesome, but because they’re often just good enough to provide some quick relief before more fine-tuned efforts are explored.

erikdarlingdata.com

A Need for Monitoring without Administration

There was a report recently that a number of US government agencies were hacked through a network management system. Apparently Solarwinds had their code hacked, and this resulted in a backdoor being distributed to customers via software updates.

voiceofthedba.com

Want to Avoid Deployment Downtime? Replication Probably Isn’t the Answer.

You’re tired of taking outages to deploy changes to your database schema. Presto! All your servers are up to date and in sync, right? Well, no, not in SQL Server at least.

brentozar.com

Building a Machine Learning Application With Cloudera Data Science Workbench And Operational Database, Part 1: The Set-Up & Basics

Python is used extensively among Data Engineers and Data Scientists to solve all sorts of problems from ETL/ELT pipelines to building machine learning models. Apache HBase is an effective data storage system for many workflows but accessing this data specifically through Python can be a struggle.

blog.cloudera.com

Database version control: Getting started with Flyway

Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works. “Database migrations made easy” and “Version control for your database” are a couple of headlines you will find on Flyway’s official website.

red-gate.com

How to set up command-line access to Amazon Keyspaces (for Apache Cassandra) by using the new developer toolkit Docker image

Amazon Keyspaces (for Apache Cassandra) is a scalable, highly available, and fully managed Cassandra-compatible database service.

aws.amazon.com

How to manage background processes in Linux

If you are new to Linux operating system and you start a command or process using terminal/session, you must have noticed that you need to wait till a process or command get finished before starting another command.

dev.to

How to Make a Chart in Excel from a SQL Server Database

Data loading into a SQL Server table and extracting data from a SQL Server table is something that is done every day.

mssqltips.com

Installing ClusterControl to Deploy a Database Cluster Using Vagrant

If you are dealing with a bunch of virtual machines, using Vagrant is probably the best tool to build, automate and manage the virtual machines to increase efficiency and productivity, especially in a development environment.

severalnines.com

MongoDB 101: 5 Configuration Options That Impact Performance and How to Set Them

As with any database platform, MongoDB performance is of paramount importance to keeping your application running quickly.

percona.com

How to quickly download the new bunch of 21c Oracle Database documentation?

Last month, Oracle released its new 21c version of the database documentation. At that time, I was looking for a quick mean to get all the books of this so-called 21c Innovation Release. I could remember I used a script to get them all in one run.

blog.dbi-services.com

Don’t Be Afraid Of tempdb

When tuning queries, one pattern I see over and over again is people running crazy-long queries. Maybe they worked well-enough at some point, but over the years they just kept getting slower and slower.

erikdarlingdata.com

Video: PostgresSQL Security Features - Password Profiles

Marc Linster, Ph.D., is EDB’s Chief Technology Officer and leads EDB’s engineering divisions and product development groups. Marc is committed to EDB being an accelerator to providing architectural “know how” to help customers take advantage of Postgres without significant risk and cost.

enterprisedb.com

Upgrading from Amazon RDS for PostgreSQL version 9.5

The PostgreSQL – community releases a new major version yearly, with a defined end of life (EOL) policy of older major versions. This allows you to make version and upgrade decisions well into the future. The community EOL policy is to support a major version for 5 years after its initial release.

aws.amazon.com

How to migrate from self-managed Elasticsearch to Elastic Cloud on AWS

Increasingly, we are seeing on-prem workloads being moved onto the cloud. Elasticsearch has been around for many years with our users and customers typically managing it themselves on-prem.

elastic.co

elephantdolphin.blogspot.com

MySQL 5.6 End of Line in ONE MONTH!!!

For the past year or so I have been reminding folks that MySQL 5.6 reaches End of Life Status in ONE MONTH!! No more updates or security fixes! Nostalgia is a fine things and I like antiques but not for my database!

SQL Server ORDER BY performance tips

In this article, we will explore how the ORDER BY statement affects the query performance and we will also learn some performance tips related to sorting operations in SQL Server.

sqlshack.com

Jumping into Azure Arc Data Services

Microsoft may have promised multiple future releases of on-premises Windows Server, but that doesn’t mean you continue to manage and use those servers the way you always have.

infoworld.com

Google Spanner – SQL compatibility

. I have posted, a long time ago, about Google Spanner (inserting data and no decimal numeric data types) but many things have changed in this area. There is now a NUMERIC data type and many things have improved in this distributed SQL database, improving a bit the SQL compatibility.

blog.dbi-services.com

Heaps in SQL Server: Part 4 PFS contention

When inserting rows into a heap, SQL Server must sometimes update the PFS page which can affect performance. In this article, Uwe Ricken demonstrates how to measure PFS contention.

red-gate.com

PASS is Dead – Long Life to SQLFamily

This new year start with the death of PASS, the professional association that for so many years supported the SQLFamily around the world and helped so many to achieve their professional goals.

red-gate.com

Importing or Changing Your SSL Certificate in ClusterControl

SSL encryption is clearly one of the must-haves for database deployments. It is required by all security standards and even if your organization does not have to comply with PCI DSS, HIPPA or other similar standards, you probably still want to have your traffic secured properly.

severalnines.com

Percona Monthly Bug Report: December 2020

Here at Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support.

percona.com