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

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

During my parameter sniffing classes, people get a little exasperated with the complexity of the problem. Parameter sniffing is totally hard. I get it. At some level, it’d be great to just hit a magic button and make the whole thing go away.

  • brentozar.com
  • Brent Ozar

30th Jun 2020

Last month IBM announced that Db2 v11.5.4 is planned to be generally available on June 30, 2020. As in prior releases, each of the Db2 v11.5.4 editions have the same capabilities including BLU Columnar tables, Adaptive Compression, Encryption, and many more. Db2 v11.5.

  • medium.com
  • Kay Groski

After a fresh introduction of community bonding, On June 1st, coding of GSoC had started officially with phase 1. At this point, every GSoC student should be expected to have a rigid plan with their entire project.

  • jenkins.io
  • Loghi Perinpanayagam

Whoo! It’s been six months since my last post. There are reasons for this, none of which are probably valid, but it’s the way it is. I’ve been a full-time DBA for just over a year now, and Kevin thought it would be a good time to review how far I’ve come thus far.

  • sqlservercentral.com
  • Contributors

In this article, I am going to explain how we can install and configure the iSCSI Target Server Role on Windows Server 2016.

  • sqlshack.com
  • Nisarg Upadhyay

While there is no magic bullet for MySQL tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation.

  • percona.com
  • Brian Sumpter

A typical database-oriented application setup only must work with single operation SQL or RESTful execution. Your customers might only be sending the INSERT or UPDATE queries one at a time.

  • 2ndquadrant.com
  • Muhammad Haroon

A DBA Overview of Zowe CLI and the IBM Db2 Database Plugin for Zowe CLI{Ecosystem} In 2018, when The Linux Foundation’s Open Mainframe Project (OMP) introduced Zowe to the Mainframe world, the contributors not only introduced Open Source and the power of the open source community to mainframers

  • medium.com
  • Rose Sakach

In this article, we will discuss and understand a method to migrate an on-premises SQL Server database to the Azure SQL database.

  • sqlshack.com
  • Prashanth Jayaram

IBM’s World Community Grid is working with scientists at Scripps Research on computational experiments to help find potential COVID-19 treatments. Anyone with a Raspberry Pi and an internet connection can help.

  • raspberrypi.org
  • Alex Bate

In the late 70s and early 80s, a team was assembled at IBM’s lab in San Jose to create Db2, the world’s first enterprise-level relational database, based upon Edgar Codd’s seminal paper and subsequent IBM research.

  • ibm.com

So you running MySQL with the validate_password plugin. What about existing users and their passwords? How do you check that those passwords are ok and aren’t bad like ‘123456’ or easily guessable like ‘Tuesday2020!’? and how do you fix them.

  • dbadojo.com
  • paulmoen

Version of the Oracle JDBC drivers and related binaries have been recently posted to Maven Central.

  • blogs.oracle.com
  • Andres Almiray

In a factory environment, collecting data to gain useful insights from various sources is challenging because it requires connecting to many different types of automation systems, plcs and devices that often speak different languages.

  • influxdata.com
  • Chris Churilo

This is tutorial to setup 2 innodb clusters and create Replication using REPLICATION FILTER to define replication channel across 2 InnoDB Cluster. Background InnoDB Cluster setup is commonly found within a Data Center (DC1) where the network is good and reliable.

  • mysqlhk.blogspot.com
  • Ivan Ma

In a previous tip on Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1, I have seen how to install a SQL Server 2016 on a Windows Server 2016 failover cluster (WSFC). We are deploying SQL Server 2017 failover clusters running on Windows Server 2016.

  • mssqltips.com
  • Edwin Sarmiento

MariaDB Server 10.5 is a fresh, new, and stable version from MariaDB that was released on June, 24th 2020. Let’s take a look at the features that it will bring us. With MariaDB 10.5 some changes regarding the privileges are coming.

  • severalnines.com
  • Krzysztof Ksiazek