DBplatz - Database News. Read our handpicked database-related articles. Where all databases are welcome. SQL and NoSQL. Windows, Linux and MacOS. #useThemAll

A new wave of attacks is targeting unsecured MongoDB database servers and wiping their content attempting to extort a ransom to the victims.

  • securityaffairs.co
  • Pierluigi Paganini

In this article, I am going to explain in detail about SSIS memory usage and how can we optimize out tasks and the data flow to leverage maximum benefits from the in-memory operating tool.

  • sqlshack.com
  • Aveek Das

. This is a demo about Oracle ACFS snapshots, and how to understand the used and free space, as displayed by “df”, when there are modifications in the base parent or the snapshot children.

  • blog.dbi-services.com
  • Franck Pachot

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.

  • datatechnologytoday.wordpress.com
  • Craig

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.

  • severalnines.com
  • Mani Yangkatisal

In this article, we will take a step forward and integrate Git installed locally on the GitHub. First, it is essential to understand the difference between Git and GitHub terminology.

  • sqlshack.com
  • Rajendra Gupta

Partitioning is an integral data management strategy for high-performance and high-volume database applications. PostgreSQL provides excellent partitioning support that is constantly evolving. 

  • 2ndquadrant.com
  • Bilal Ibrar

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.

  • virtual-dba.com
  • Marvin Lapid

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.

  • neo4j.com
  • Zaw Win Htet

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.

  • mssqltips.com
  • Atul Gaikwad

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. 

  • redislabs.com
  • Stévan Le Meur

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.

  • cockroachlabs.com
  • Charlotte Dillon

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.

  • mariadb.com
  • Max Mether

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.

  • blog.dbi-services.com
  • Marc Wagner

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.

  • sqlblog.org

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.

  • severalnines.com
  • Agus Syafaat

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.

  • dzone.com
  • Jamie Liu

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.

  • 2ndquadrant.com
  • Kirk Roybal

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

  • grafana.com

Recently, Microsoft announced our acquisition of CyberX, a comprehensive network-based security platform with continuous threat monitoring and analytics.

  • microsoft.com

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.

  • sqlshack.com
  • Nisarg Upadhyay

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.

  • sqlshack.com
  • Rajendra Gupta

Have you left a cloud database exposed online?

  • nakedsecurity.sophos.com
  • Paul Ducklin

I recently discovered an interesting (and frustrating) issue while running PostgreSQL in Kubernetes.

  • datageek.blog
  • Jonathan Gnagy

A brief overview of Logz.io Infrastructure Monitoring - a Grafana-based monitoring solution that correlates between logs and metrics for easier investigative workflows.

  • logz.io

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.

  • logz.io

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.

  • neo4j.com
  • Soham Dhodapkar

“Running MySQL on selected NUMA node(s)” looks pretty straightforward but unfortunately it isn’t. Recently, I was faced with a situation that demanded running MySQL on 2 (out of 4) NUMA nodes.

  • mysqlonarm.github.io
  • MySQL On ARM

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.

  • mssqltips.com
  • Koen Verbeeck

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.

  • mysqlhighavailability.com
  • Kenny Gryp