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


As a MySQL database administrator, we all using the MySQL client program for communicate to MySQL Server . Maximum the client program is used to execute the SQL’s, monitor the traffic and modify the variables . MySQL client program has some good features which can helps to make our work easier .

  • sakthismysqlblog.wordpress.com
  • HERCULES

SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why. SQL Monitor is designed for the busy DBA who has many servers to look after.

  • red-gate.com

This post is part of several blog posts (at least two!) about Troubleshooting Postgres. Last time, we found out if Postgres was running and how to start it. Please find here all the troubleshooting posts. To start Postgres, please refer to Is Postgres running.

  • mydbanotebook.org

Hi! I'm Helen, one of your friendly mods looking after the #sql, #postgres, #mysql and #database tags. At the end of each month, I'll be showcasing some of the great posts, projects and insights from the data community.

  • dev.to
  • Helen Anderson

100% of our studio audience learned something!Julian described how DevOps is changing the role of the DBA. Watch the replay... As the acceptance of DevOps continues, DBAs can be seen as helping the enterprise or a barrier to success. Search #DB2Night to learn more.

  • dbisoftware.com
  • martin

Yesterday I wrote a blog post about COVID-19, Working From Home and Performance Tuning and I have received a lot of email responses to this blog post. Also on twitter, lots of people also reached out to me for further conversation.

  • blog.sqlauthority.com

Microsoft Access is still used in many places, but sometimes it is necessary to port the data to SQL Server instead. One reason is that the database can be a lot larger in SQL Server compared to Access.

  • mssqltips.com
  • Mircea Dragan

Previously, we wrote about Setting Up a Geo-Distributed Database Cluster Using MySQL Replication. This time, it's about PostgreSQL. Setting up a geo-distributed cluster for PostgreSQL is not a new concept and the topology is quite common. 

  • severalnines.com
  • Paul Namuag

In the last part of this series, I covered the steps to install OpenEBS on the Amazon Elastic Kubernetes Service (Amazon EKS). In this tutorial, we will deploy a highly available instance of PostgreSQL.

  • thenewstack.io
  • Janakiram MSV

Last week we asked you what you thought the optimum duration for a virtual event would be, and for our next blog poll question, we have a follow-up. What would be a motivator for you to attend such events? We look forward to seeing your responses!

  • percona.com
  • David Quilty

21st Mar 2020

SQL Triggers are another powerful database object we have at our disposal. In previous articles, we’ve covered user-defined functions, user-defined procedures, and SQL Views. Today we’ll talk about SQL triggers and how to use them to achieve the desired behavior.

  • sqlshack.com
  • Emil Drkusic

21st Mar 2020

Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change your production setup. However, I guarantee, you’re very likely to see them radically change your development process.

  • scarydba.com
  • Grant Fritchey

The term DevOps was coined in the early 2000s to improve the speed and resiliency of the delivery of features and applications and providing more value to customers.

  • red-gate.com

Microsoft Access is still used in many places, but sometimes it is necessary to port the data to SQL Server instead. One reason is that the database can be a lot larger in SQL Server compared to Access.

  • mssqltips.com
  • Mircea Dragan

Hello MongoDB Developers! We are excited to announce the launch of our new Developer Hub: https://developer.mongodb.com. The Developer Hub will serve as the central location for all MongoDB developer content, programs, and resources.

  • mongodb.com

We had a table which has the data in Japanise language. But after cutover, we were not able to get the exact data. Actual Data From the application, change the default client connection to latin1. But please make sure the character server character set before the migration.

  • thedataguy.in
  • Bhuvanesh

Keeping backups of your database is one of the most important tasks in any production environment. It is the process of copying your data to some other place to keep it safe. This can be useful in recovery from emergency situations like database corruption or a database crashing beyond repair.

  • severalnines.com
  • Agus Syafaat

Part 1 of this blog series demonstrated the advantages of using a relational database to store and perform data exploration of images using simple SQL statements.

  • mariadb.com
  • Alejandro Infanzon

Keeping backups of your database is one of the most important tasks in any production environment. It is the process of copying your data to some other place to keep it safe. This can be useful in recovery from emergency situations like database corruption or a database crashing beyond repair.

  • severalnines.com
  • Agus Syafaat

In this article, take a look at how to get started with OpenEBS and cloud-native distributed SQL. OpenEBS is a CNCF project that provides cloud-native, open source container attached storage (CAS).

  • dzone.com
  • Jimmy Guerrero

Hello! I’m Wesley Faulkner, Technical Community Manager and part of the Community Team at MongoDB. The coronavirus (COVID-19) is one of the most pressing global health threats in decades.

  • mongodb.com

PostgreSQL supports many secure ways to authenticate users, and one typical way is to use GSSAPI with Kerberos. However, when I was trying to investigate one issue which is related with GSSAPI in PostgreSQL, I couldn’t find a tutorial that I can follow to setup the environment easily.

  • highgo.ca
  • David Zhang

You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered.

  • cloudblogs.microsoft.com
  • SQL Server Team

We’re thrilled to announce Redgate Streamed: a 3 day online virtual community conference, to be held April 1-3, 2020. Register at Redgate.com/RedgateStreamed In this livestream, I give you a …

  • littlekendra.com

Lots of people don’t believe it, but it’s true. However, I really do love getting to see my #SQLFamily all over the world in my travels with Redgate Software. Unfortunately, our current situation is such that almost no one is travelling and all the events are cancelled or postponed.

  • scarydba.com
  • Grant Fritchey

Percona has been investing in building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion.

  • percona.com
  • Tyler Duzan

In this article, we discuss how to use foreign keys and indexes in order to increase the efficiency of a relational database. Indexes and foreign keys are great tools when confronted with large databases. They can be the answer to a good design and great performance.

  • dzone.com
  • Rafaelo Condret

ArangoDB has supported two storage engines for a while: RocksDB and MMFiles. While ArangoDB started out with just the MMFiles storage engine in its early days, RocksDB became the default storage engine in the 3.4 release. Due to its drawbacks ArangoDB 3.

  • arangodb.com
  • Joerg Schad

This article serves as a complete guide to Azure Databricks for the beginners. Here, you will walk through the basics of Databricks in Azure, how to create it on the Azure portal and various components & internals related to it.

  • sqlshack.com
  • Gauri Mahajan

Chaos Engineering is a way to test a production software system's robustness by simulating unusual or disruptive conditions. For many people, however, the transition from learning Chaos Engineering to practicing it on their own systems is daunting.

  • pingcap.com