Video : JSON Data Type in Oracle Database 21c

Working With MyISAM in MySQL

MyISAM is one of the most popular storage engines in MySQL. MyISAM frequently is the second choice after InnoDB - in this blog post we will try to find out how best to work with this engine. MyISAM is one of MySQL’s storage engines.

severalnines.com

Data-Driven Enterprise – 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

The DB2Night Show #231: Db2 V11.5 Overview & Latest From the Lab

100% of our studio audience learned something!Keri presented a Db2 V11.5 Overview. Watch the replay... Keri did her usual thorough job including information on Db2 11.5.5 and beyond. Be sure to download or watch youtube and catch this session. Search #DB2Night to learn more.

dbisoftware.com

pspg 4.0.0 released

I finished and released new version of pspg pager. New release has possibility to export content in CSV, TCVS, formatted text or INSERT format to file or clipboard.

okbob.blogspot.com

Unit Testing Helidon Like A Pro using Mockito

Writing JUnit5 unit tests in Helidon is easy with the usage of helidon-microprofile-tests-junit5 dependency. It starts a separate Helidon microprofile server for you to run your tests using @HelidonTest annotation.

blogs.oracle.com

How to monitor Azure Data Factory

In the previous articles of this series, we discussed how to perform different types of activities using Azure Data Factory. These tasks include copying data between different data stores, running SSIS packages and transforming data before writing it to a new data store.

sqlshack.com

MySQL 8.0.22: SHOW PROCESSLIST Version 2 – Now Available From PERFORMANCE_SCHEMA

The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and it needs the global mutex.

percona.com

Performance Measures And Factors

When I’m working with clients, we look at a lot of stuff together to make sure things are in good working order. If we’re tuning a single query, the goal is pretty easy to define. We want it to finish as fast as possible.

erikdarlingdata.com

How to Audit a PostgreSQL Database

Auditing is a good way to keep your data as safe as possible, and to know what is happening in your databases. It is also required for many security regulations or standards, like PCI - Payment Card Industry. This is not an exception for your PostgreSQL database.

severalnines.com

Synchronizing Files on your Raspberry Pi with Syncthing

In this tutorial, we will show you how you can use the Syncthing software on your Raspberry Pi. Syncthing is a software designed to synchronize files between multiple devices such as the Raspberry Pi in real-time.

pimylifeup.com

What's the Quarantine state in Windows Failover Clusters

Due to the Coronavirus pandemic, Quarantine and Lockdown are two prominent words from the year 2020. The word Quarantine means isolating things such as a COVID-19 positive patient to prevent the spread of the disease.

mssqltips.com

2021 Cybersecurity Trends to Prepare For

While few people foresaw the dramatic developments of the past year, CIS experts interviewed in 2020 identified several cybersecurity trends that persisted or even accelerated in the midst of the COVID-19 pandemic.

cisecurity.org

Auditing PostgreSQL Using pgAudit

Auditing in information technology (IT) is a process of examining an organization’s IT infrastructure to ensure compliance with the requirements imposed by recognized standards or established policies.

scalegrid.io

The modern Droplet: How to choose the “right” VM for business and personal use

DigitalOcean Droplets are on-demand, Linux virtual machines suitable for production business applications and personal passion projects. We’ve recently introduced Storage-Optimized Droplets with NVMe SSD, and have also made other adjustments to our Droplet portfolio.

digitalocean.com

Trigger Warning! Guide to SQL Triggers - Setting up Database Tracking and Auditing in PostgreSQL

I was 12 years old when I first heard about SQL triggers. My brother, Jonathan, had just begun his software career at a startup. Jonathan came home one day frustrated by a database full of convoluted SQL triggers.

blog.arctype.com

Installing Grafana on Raspberry OS.

In a previous post we’ve installed Prometheus on Raspberry, and this time we are installing Grafana on a Raspberry Pi as part of our homelab monitoring server. The Raspberry Pi we’ve chosen is this one.Model 3B -1GB.

blog.dbplatz.com

Tips for Monitoring MySQL for Moodle

Database monitoring is a critical part of any application’s maintenance. Finding database issues on time can help the application remain healthy and accessible. Without monitoring in place, database outages can be prolonged, resulting in increased downtime for users.

severalnines.com

Preparing on-premises and AWS environments for external Kerberos authentication for Amazon RDS

As database security becomes more and more essential to the success of a business, managing user access to databases effectively has always been a challenge to database administrators (DBAs) and security officers. Traditional database authentication is based on a username-password mechanism.

aws.amazon.com

How to Scale Your Services With Docker During Development

In this article, we're going to see how we can leverage Docker to scale and spin up multiple instances of a service on our machine. Hi all! Today we’re going to see how we can leverage Docker to scale and spin up multiple instances of a service on our machine.

dzone.com

Vulnerability Management Has a Data Problem

Security teams have an abundance of data, but most of it lacks the context necessary to improve remediation outcomes. Today, vulnerability management teams have so much data on hand that processing and analyzing it takes as much time as remediation efforts.

darkreading.com

Benchmarking AWS, Azure, & GCP in the 2021 Cloud Report. Who came out on top?

The 2021 Cloud Report stands on benchmarks.

cockroachlabs.com

Webinar January 28: Tuning PostgreSQL for High Performance and Optimization

PostgreSQL is one of the leading open-source databases, but, out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it.

percona.com

jonathanlewis.wordpress.com

Between

Reading Richard Foote’s latest blog note about automatic indexing and “non-equality” predicates I was struck by a whimsical thought about how the optimizer handles “between” predicates.