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

In 2017 we introduced YugabyteDB, an open source, high performance, cloud native database for mission-critical applications. As a team, we have worked first hand on a number of databases such as Apache HBase, Apache Cassandra (from even before it was open sourced), Oracle, and RocksDB.

  • blog.yugabyte.com
  • Michelle Brinich

The adoption and market share of PostgreSQL is growing at a rapid rate. And it’s not just new installations or applications  – there are huge levels of migrations happening from other database systems as well.

  • percona.com
  • David Quilty

During the quarantines, I’m trying to find as many ways as possible to get y’all free training.

  • brentozar.com
  • Brent Ozar

Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query sys.dm_os_wait_stats or sys.dm_db_wait_stats. Combining them is hard.

  • scarydba.com
  • Grant Fritchey

In this article, we will discuss the SQL Server @@ROWCOUNT and ROWCOUNT system objects by going through practical examples that cover most of these system objects usage.

  • sqlshack.com
  • Ahmad Yaseen

Microsoft provides a number of different deployment options for its Azure SQL Database offerings. We have reviewed a number of them on this forum, including the recently introduced Azure SQL Database Serverless.

  • databasejournal.com
  • Marcin Policht

Criminals are constantly finding new and more sophisticated ways to commit fraud. Every technological development presents new opportunities for illicit activities, and few more so than the evolution of digital currencies.

  • neo4j.com
  • Christian Miles

In my organization we have hundreds of SQL Agent jobs running daily. Our jobs have many steps, sometimes as many as 50! We would like to implement a solution where we can split our large jobs into multiple smaller ones while respecting the dependencies between the jobs.

  • mssqltips.com
  • Ray Barley

MySQL have the nice feature, which helps to write the error log with JSON format . This can be achieved through the MySQL components . In this blog, I am going to show the complete walkthrough involved in this process .

  • sakthismysqlblog.wordpress.com

Data security plays a major role in current age. Privacy matters a lot. Data masking is one of the Key Features when comes to security.

  • mydbops.wordpress.com
  • pon suresh pandian

We are pleased to announce that IBM’s Operational Database Management Systems (OPDBMS) was recognized as a 2020 Gartner Peer Insights Customers’ Choice.

  • ibmbigdatahub.com
  • Kip Yego

Time to renew downloads.mariadb.org! We are embarking on a long project. A large part of our user base mainly interacts with us through downloading new versions. Renewing MariaDB Downloads is the biggest-impact project of all of 2020, for that part of our user base.

  • mariadb.org
  • Kaj Arnö

In this blog post, we answer some common questions from YugabyteDB users to help you in your own application development and deployment. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post.

  • blog.yugabyte.com
  • Andrew Nelson

29th Mar 2020

I haven’t been a big fan of dark mode in many tools, but I’ve been giving it a try in some applications as my eyes age. I decided to try it in SSMS, which wasn’t as easy as I’d hoped.

  • sqlservercentral.com
  • Contributors

In our previous blog, we have discussed ClusterControl CMON HA for Distributed Database High Availability written by Krzysztof Ksiazek in two separate posts. In this blog, we'll cover the distribution of nodes via on-prem and on a public cloud (using Google Cloud Platform (GCP)).

  • severalnines.com
  • Paul Namuag

Oracle Cloud Marketplace (https://cloudmarketplace.oracle.com) is an online store selling a wide variety of business applications and services which can complement an existing Oracle Cloud implementation.

  • gavinsoorma.com
  • Gavin Soorma

When I started this, I thought it was be straight forward and take only a few hours at most. It turned into multiple hours over two days. This is part two of a two-part post. The first part dealt with changing a database column from time to timestamp.

  • news.freshports.org
  • Dan Langille

With the provisioned IOPS (io1) disk, the user can define the IOPS of the disk. The user needs to pay an extra amount for the IOPS of the ioI disk, whereas this is included in the cost of the disk for gp2 disks. Io1 disk supports a maximum of 64000(16Kib I/O) IOPS and 1000MiB/s throughput.

  • sqlservercentral.com
  • Contributors

Essentially, SQL language allows us to retrieve and manipulate data on the data tables. In this article, we will understand and gain the ability to write fundamental SQL queries. At first, we will take a glance at the main notions that we need to know about in order to write database queries.

  • sqlshack.com
  • Esat Erkec

29th Mar 2020

In the last few months, our solution engineers have had many discussions with security and operation teams about how to implement MySQL auditing.

  • medium.com
  • Lee Stigile

A few years ago, Brent Ozar wrote a post called, "Blog For Your Resume, Not For Your Readers," and he's totally right. I wanted to share my thoughts on why blogging is a win-win scenario in multiple ways, sometimes for the author, sometimes for the reader, and often both.

  • sqlblog.org

As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types of each column explicitly before you load the data or write queries.

  • blog.couchbase.com
  • Keshav Murthy

DotNet developers, if you’re using the System.Data.SqlClient, stop. Move over to Microsoft.Data.SqlClient now. It’s easy to do, well, it’s relatively easy to say that. The actual work isn’t that hard, but it can be a challenge to move assemblies.

  • voiceofthedba.com

In this post, we'll introduce how we reduced the read latency and network traffic by half for a multi-region architecture. In data-critical industries like the financial industry, data storage and access need a high availability architecture.

  • dzone.com
  • Peng Qu

Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is for demonstrative purposes only.

  • percona.com
  • Carlos Tutte

It is extremely important to install and configure a production MySQL server with the necessary packages and tools to smooth-out the operations in the long run.

  • severalnines.com
  • Ashraf Sharif

In previous blog, we have setup Kerberos, added all required principals and verified each principal. This blog will explain all the necessary configuration, i.e. postgresql.conf, pg_hba.conf and pg_ident.conf, in PostgreSQL for user authentication using GSSAPI with Kerberos.

  • highgo.ca
  • David Zhang

26th Mar 2020

The reason being, he’s right. I’m spending time rewriting some of my own sample code to use DBATools. I’ll try to post some of it here when I get it together. I’ve been screaming about the importance of containers in general and Docker in particular for quite a while now. Finally, I use Git.

  • scarydba.com
  • Grant Fritchey

One problem I have experienced during logical exporting and importing databases is the tools don’t output any progress indicator (or anything at all really) and using the -v (verbose) switch outputs every single MySQL command being run from the import file.

  • mydbops.wordpress.com
  • shahbaz Gavasekar

I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do is keep up with the changing business and IT environment, which means, deployments. Lots of deployments.

  • sqlservercentral.com