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

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

MariaDB has recently launched its new DBaaS offering, SkySQL.

  • severalnines.com
  • Paul Namuag

Nicolas Hourcard Nicolas is a lifelong technology enthusiast and co-founder of QuestDB. He previously leveraged time-series data for companies like Rothschild and Nasdaq. He splits his time between London and San Francisco and enjoys tennis, skiing and climbing new mountain peaks each year.

  • thenewstack.io
  • Nicolas Hourcard

What this means in practical terms is that a MySQL instance has reached its maximum allowable limit for client connections.  Until connections are closed, no new connection will be accepted by the server.

  • percona.com
  • Tate McDaniel

What happens when you put a SQL database on the internet? It's probably not what you'd expect. And then we posted it to Hacker News.

  • dzone.com
  • David G. Simmons

Postman is one of the most popular REST API clients. Since v7.2, it also supports GraphQL APIs. In this blog post, we will look at how you can use Postman to make GraphQL requests. We will also look at some of the advantages of doing so.

  • dgraph.io
  • Pawan Rawal

With over 300 databases on the market, how do you determine which is right for your specific use case or skill set? We continue to see the common debate of SQL vs. NoSQL and other database comparisons all over social media and platforms like dev.to.

  • dev.to

1st Jul 2020

The DB-Engines Ranking ranks database management systems according to their popularity. The ranking is updated monthly. Read more about the method of calculating the scores.

  • db-engines.com

Skip to content Release Announcement: Telegraf 1.14.5 By / June 30, 2020 June 30, 2020 / Release Notes, Telegraf / 1 minute A new maintenance release for Telegraf is available now. Telegraf 1.14.

  • influxdata.com
  • Samantha Wang

Navigating the turbulent waters of the Azure Data Lake and many of the other offerings within the Azure Data ecosystem can be a challenge for aspiring Azure Data Engineers.

  • mssqltips.com
  • Ron L'Esteve

Most of the projects developed today rely on open source libraries - it is likely that your project does too. While using these libraries accelerates development by relying on proven solution for common needs, it also introduces a potential risk factor.

  • blogs.oracle.com
  • Shay Shmeltzer

The TPCC workload "mystery" exposed in the following post was already clarified the last year, and I've presented explanations about the observed problem during PerconaLIVE-2019.

  • dimitrik.free.fr
  • dimitri

In this article, we detail the results of our performance comparison of popular cloud-based Enterprise Data Warehouses using popular benchmarks.

  • blog.griddynamics.com
  • Dmitry Karachentsev

The 10.5 release of MariaDB Community Server which includes ColumnStore columnar storage engine is now available as an image on Docker hub. Columnar data storage is designed for analytics workloads with large data sets and ad hoc queries. With the MariaDB Community Server 10.

  • mariadb.com
  • Rob Hedgpeth