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


I’ve talked a lot about Docker and containers over the last few years. With respect to the Oracle database on Docker, I’ve given my opinions in this article. Over the weekend Sean Scott tweeted the following.

  • oracle-base.com
  • Tim...

Recently, while troubleshooting PostgreSQL performance problems, I ran into problems with subtransactions twice. So I thought this was a nice topic for another blog post. Everybody knows database transactions.

  • cybertec-postgresql.com
  • Laurenz Albe

Editor’s Note: This presentation was given by Alex Babeanu at GraphConnect New York in September 2018.

  • neo4j.com
  • Alex Babeanu

Recently, I had a very interesting situation while working with my client on the Comprehensive Database Performance Health Check. Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan.

  • blog.sqlauthority.com

In this article, we compare distributed SQL databases against NewSQL databases so that we can better understand their differences.

  • dzone.com
  • Sid Choudhury

This book will make you a better programmer by teaching you how to write efficient code to access Db2 databases.

  • db2portal.blogspot.com
  • Craig S. Mullins

10th Mar 2020

Please consider monitoring your productive ArangoDB installation as part of the best practices strategy. It is effortlessly done using established services Prometheus for data collection and Grafana for visualisation and alerting.

  • arangodb.com
  • Kaveh Vahedipour

One of the indicators to see if our database is experiencing performance issues is by looking at the CPU utilization. High CPU usage is directly proportional to disk I/O (where data is either read or written to the disk).

  • severalnines.com
  • Agus Syafaat

You’re done setting up your first graph panels. You want to do more, look around the visualization settings, and discover the settings for the X and Y axes. You stumble over the configuration for a “Right Y” axis. You ask yourself, “Why on earth would I need another Y axis?”

  • grafana.com
  • Marcus Olsson

I got a lot of follow-up questions on what Query Block names are and how to find them, after my recent post about using SQL Patches to influence execution plans. Rather than burying my responses in the comment section under that post, I thought it would be more useful to do a quick post on it.

  • sqlmaria.com
  • Maria Colgan

Tags provide critical context for troubleshooting issues across any dimension of your environment. By applying best practices for tagging your systems, you can efficiently organize and analyze all your monitoring data, and set up automated multi alerts to streamline alerting workflows.

  • datadoghq.com

One of the things I love about SQL Server is that during query plan compilation, it takes a moment to consider whether an index would help the query you’re running.

  • brentozar.com
  • Brent Ozar

Welcome to the final part in our series of blog posts covering performance best practices for MongoDB. Last up is benchmarking.

  • mongodb.com

Azure’s Cosmos DB is one of its best features. A multimodel distributed database, it gives you a foundation for building truly cloud-native applications with a series of consistency models that can be mapped to how your application works.

  • infoworld.com
  • Simon Bisson

Avoid data loss and achieve high availability with cloud databases. One of the most common arguments I hear around cloud adoption is the lack of faith in the safety of online data stores.

  • dzone.com
  • Grant Fritchey

Falco is an incubating CNCF project that provides cloud native, open source runtime security for applications running in Kubernetes environments. Falco monitors process behaviors to detect anomalous activity and help administrators gain deeper insights into process execution.

  • blog.yugabyte.com
  • Jimmy Guerrero

In this article, we will discuss the actual database file size and free space in the database file size with the help of monitoring script and shrink solutions.

  • sqlshack.com
  • Jignesh Raiyani

Scylla Open Source Release 3.2.3 is a maintenance release that fixes a number of issues for product stability, and fixes a bug upgrading on Debian/Ubuntu.

  • scylladb.com
  • Tzach Livyatan

MySQL slaves may become inconsistent. You can try to avoid it, but it’s really hard. Setting super_read_only and using row-based replication can help a lot, but no matter what you do, it is still possible that your slave will become inconsistent. 

  • severalnines.com
  • Krzysztof Ksiazek

Roundup Cosmos DB has rolled out a free tier, staffers get their mitts on stable Edge, and Azure DevOps Services steps back from axing TLS 1.0. For now. Yes, it's the weekly roundup of all things Microsoft we haven't already covered.

  • theregister.co.uk
  • Richard Speed

In this talk, we’ll walk through RocksDB technology and look into situations where MyRocks is a good fit versus other engines such as InnoDB. We will go over internals, benchmarks, and the tuning of MyRocks engine. We will also explore the benefits of using MyRocks within the MySQL ecosystem.

  • percona.com
  • David Quilty

As you've probably seen, a lot of companies are moving towards remote work in the midst of coronavirus. There are many articles out there that give great tips like taking breaks, getting outside, etc.

  • dev.to
  • Laurie

Firebase is a Cloud-hosted, NoSQL database that uses a document-model. It can be horizontally scaled while letting you store and synchronize data in real-time among users. This is great for applications that are used across multiple devices such as mobile applications.

  • databasejournal.com
  • Bradley L. Jones

Recently I was looking at SQL Server ERRORLOG of one of my instances on my Azure VM. It was interesting to see and research the message mentioned in the subject. In this blog, I would share my understanding of the message “This instance of SQL Server has been using a process ID of”.

  • blog.sqlauthority.com

The storage solutions used by today’s organizations contain hard disk drives (HDDs), solid-state drives (SSDs), or a combination of both to support their various workloads.

  • red-gate.com

Phil Factor explains the factors that determine whether a column will allow null values, if you don't specify it explicitly in the column definition. If you rely on the default behavior established by your connection settings, you could be in for some nasty surprises.

  • red-gate.com

100% of our studio audience learned something! Toby discussed the new features in pureScale, many of which were developed in response to customer feedback. Watch the replay...

  • dbisoftware.com
  • martin

Database security requires careful planning, but it is important to remember that security is not a state, it is a process. Once the database is in place, monitoring, alerting and reporting on changes are an integral part of the ongoing management.

  • severalnines.com
  • Bart Oles

Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query  to access the data.

  • blog.couchbase.com
  • Binh Le

By default, mysql package installation creates SSL file in the data directory at the time of installation. If you would like to use different self-signed certificates then create them as described here. Restart mysql server and verify the settings.

  • lalitvc.wordpress.com
  • lalit