Azure SQL Database Compatibility with SQL Server

Complete Prometheus Monitoring Tutorial for Beginners 🚀

This complete Prometheus tutorial consists of 3 parts and is a detailed guide to getting started with Prometheus in your Kubernetes cluster. In the second part you will learn how to setup Prometheus Monitoring and Grafana in your Kubernetes cluster.

dev.to

blog.mclaughlinsoftware.com

MySQL File Privilege

While preparing a set of student instructions to create a MySQL 8 (8.0.21) Windows 10 instance I found an error with LOAD command and the --secure-file_priv variable set in the my.ini file. After granting the global FILE permission to the previously provisioned student user:

ArangoML Part 1: Where Graphs and Machine Learning Meet

This post is the first in a series of posts introducing ArangoML and showcasing its benefits to your machine learning pipelines. In this first post, we look at what exactly ArangoML is, with later posts in this series showcasing the different tools and use cases.

arangodb.com

Tips for Running MongoDB in Production Using Change Streams

Modern databases must have the capacity to capture and react to data as they flow in real-time. This explains why MongoDB has a feature called MongoDB Change Streams responsible for capturing and responding to data in real-time.

severalnines.com

The DB2Night Show #227: A look at Graph and REST with Db2

100% of our studio audience learned something!Dan discussed two exciting additions to Db2 11.5.4: Db2 Graph and Db2 Rest. Watch the replay... This informative presentation includes ademo for both technologies. Be sure to download or watch youtube and catch this session.

dbisoftware.com

Best practices for monitoring AWS CloudTrail logs

Engineering teams that build, scale, and manage cloud-based applications on AWS know that at some point in time, their applications and infrastructure will be under attack.

datadoghq.com

Diagnosing and Fixing “MySQL Server Has Gone Away” Messages

We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them.

percona.com

Verify MySQL Backups with TwinDB Backup Tool

If you don’t verify backups you may safely assume you don’t have them. It happens often that MySQL backups can be invalid or broken due to a software bug or some hidden corruption. If you are lucky enough hours and days will be needed to resurrect a database from a bad backup copy.

twindb.com

What’s a Database Health Check?

As a critical component of your business, a healthy database is vital to staff efficiency and customer satisfaction. If you’ve neglected database maintenance and tuning, chances are you’re running into a litany of performance issues. When your database begins to lag, so does your business.

virtual-dba.com

How to migrate High Availability databases on an ODA?

Through this blog, I would like to show, with a real customer case, how I have been migrating databases in High Availability environment on an ODA. High Availability using Data Guard for Oracle Enterprise Edition or dbvisit for Oracle Standard Edition 2.

blog.dbi-services.com

Starting SQL: Fixing Parameter Sniffing

There is a good solution to alleviating parameter sniffing. Ones I commonly use are: There isn’t really a good place to put a temp table in this stored proc, though I did blog about a similar technique before.

erikdarlingdata.com

mahmoudhatem.wordpress.com

Oracle database flashback and clone (COW) using LVM snapshots

As the title of this blog post suggest we will be looking at how to use LVM snapshot to flashback our oracle database to point in time snap or to create a thin clone for what if analysis.

Setting up MySQL Monitoring With New Relic Infrastructure Pro

If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there’s now an easy solution at your fingertips. With the New Relic MySQL integration you can monitor and graph almost any detailed metric you could possibly want.

blog.pythian.com

What are your favorite DB GUI tools?

What DB GUI tools have you tried and which ones do you like best?

dev.to

Parse parameter default values using PowerShell – Part 1

If you have ever tried to determine the default values for stored procedure parameters, you probably have marks on your forehead from hitting it on your desk repeatedly and violently.

sqlperformance.com

patternmatchers.wordpress.com

Calculating moving median in Postgres

Some time ago I’ve stumbled on this interesting question on stackoverflow (as stated in the title). I could not find any satisfactory answer at that time, so I came up with this solution. I think the problem is interesting enough to make it into a blog post.

blog.mclaughlinsoftware.com

Windows MySQL Install

MySQL will be used for our online sections because the VMware instance and Docker configurations where too large to effectively download this term. After you download the MySQL 8 MSI file, you will perform the following 24 steps to install MySQL on Windows 10.

Create a Scale-Out Hive Cluster With a Distributed, MySQL-Compatible Database

This post shows how to deploy a Hive cluster with TiDB to achieve horizontal scalability of Hive Metastore. Hive Metastore supports various backend databases, among which MySQL is the most commonly used.

dzone.com

How to Migrate Data From Neo4j to Nebula Graph

In this article, see how to migrate data from Neo4j to Nebula Graph. This article mainly introduces how to migrate your data from Neo4j to Nebula Graph with Nebula Graph Exchange (or Exchange for short), a data migration tool backed by the Nebula Graph team.

dzone.com

Open sourcing the R and Python language extensions for SQL Server

For the past decade, data science has become integral to many enterprise applications. Languages such as R and Python have left the realm of data scientists and are being used more frequently by data engineers supporting them.

cloudblogs.microsoft.com

Introducing queued purchases for Savings Plans

This blog post is contributed by Idan Maizlits, Sr. Product Manager, Savings Plans AWS now provides the ability for you to queue purchases of Savings Plans by specifying a time, up to 3 years in the future, to carry out those purchases.

aws.amazon.com

MySQL: Deleting data

Completing the data lifecycle is often harder than originally expected: Deleting data can cost sometimes way more than inserting it in the first place. MySQL Partitions can offer a way out. We have an earlier post on the subject.

blog.koehntopp.info

Understanding the HAProxy Statistics for MySQL & PostgreSQL

Having a Load Balancer is always a good option to improve your database environment. It can help you on redirect applications to available database nodes, distribute the traffic across multiple servers to improve performance, or even failover when required.

severalnines.com