It is the first Friday in July, so I wanted to wish DBAs everywhere a Happy DBA Appreciation Day! Day in and day out your DBAs are working behind the scenes to make sure that your applications have access to the mission-critical data they need to operate correctly and efficiently.
MongoDB and CouchDB both are the types of document-based NoSQL databases. A document database is also called mdocument store, and they are usually used to store the document format of the semi-structured data and detailed description of it.
If you’re in a situation where you need to resolve a gap in a Data Guard environment due to missing/corrupt archive logs, rolling forward the Physical Standby would be your best option vs. having to rebuild your entire physical standby database.
Welcome to this week’s #GraphCast – our series featuring what you might have missed in Neo4j media from the past fortnight. Last time, our Editor-in-Chief, Bryce Merkl Sasaki, showed us how graph-powered drug discovery and pharmaceutical research helps in the fight against COVID-19.
We were in the process of migrating our SQL server environment to an Azure SQL (PaaS) solution. We have built a few Azure SQL Instances for our production environment and migrated our databases to those instances.
RedisInsight is an easy and intuitive GUI for Redis, allowing you to oversee all your databases and manage your data, with built-in support for the most popular Redis modules. It provides tools to analyze your database’s memory usage and profile its performance.
About 75 percent of container orchestration is done in Kubernetes. But the popularity of the k8s platform doesn’t mean it’s easy to use in all scenarios. Kubernetes can have a steep learning curve, especially when it comes to managing state and storage.
With the release of MariaDB Community Server 10.5, we continue what we started with our first divergence from MySQL, adding important features while maintaining key points of compatibility. To reflect our differentiation from MySQL, MariaDB Community Server 10.
I had the opportunity to participate to POUG day 1 and wanted through this blog to share some of my feedback on the interesting sessions I could follow. First of all, I would like to mention the great introduction done by the staff team and the great organization.
SQL Server 2017 was made generally available on Windows, Linux, and Docker on . Download the free Express / Eval / Developer editions. For Windows, the latest CU is always available here. If you're running on Linux, you can navigate through the 1991-esque packages.microsoft.
Galera is based on synchronous (or ‘virtually synchronous’) replication method, which ensures the data applied to other nodes before it is committed. Having the same data on all nodes means that node failures can be easily tolerated, and no data is lost.
There are many ideas and considerations behind graph databases. This includes their use cases, advantages, and the trends behind this database model. There are many ideas and considerations behind graph databases. This includes their use cases, advantages, and the trends behind this database model.
Binary Large OBject storage (BLOB) is a topic that comes up in almost every conversation about Oracle to PostgreSQL migration. I will discuss it here with enough detail to make architectural choices coming from the Oracle perspective. Ready? Ok, let’s continue.
Greetings! This is Eldin reporting from the Solutions Engineering team at Grafana Labs. In previous posts, you might have read about Grafana’s New 7 release or our introduction to Loki. In this week’s post, I am introducing Éamon, who will be covering our Grafana Cloud Agent. – Eldin
In this article, I am going to explain how we can refresh a SQL Database using the Maintenance plan. To demonstrate the process, I have configured two virtual machines. I have installed SQL Server 2016 on both.
In this article, we will introduce SQL queries hint and will analyze the OPTION(Fast ‘N’) hint in detail. Once the user submits any query to SQL Server, it creates an optimized and cost-effective execution plan depending upon the statistics, indexes, and data distribution.
You don’t have to choose between cost management and full observability. With Logz.io features Log Patterns, Drop Filters, and Archive & Restore add to cost efficiency. These features are designed to easily identify and filter out that data before indexing it, and then reingest that data if necessary later.
Fabric is a new feature introduced in Neo4j 4.0 and is a way to store and retrieve data in multiple databases. This feature makes it easy to query the data in the same DBMS or multiple DBMS using a single Cypher query. If you haven’t already, please download Neo4j Desktop.
We are working on an Integration Services project with multiple developers. Some team members work remotely, so it's not always easy to see which package someone is working on. We'd like to use a git repository as a source control repository. This way we can also manage the code using branches.
It’s been 20 years since MySQL Replication was introduced in MySQL 3.23.15 (Released in May 2000). Since then, virtually every MySQL Database deployment in production has been using Replication in order to achieve high availability, disaster recovery, read scale out and various other purposes.