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


As Amazon, Microsoft, and Google fight it out in an epic struggle to dominate the cloud, a lot of companies and analysts are tossing around the term “multi-cloud.” But as Inigo Montoya immortally states in the movie Princess Bride, “You keep using that word.

  • redislabs.com
  • Fredric Paul

More and more Azure VMs are being deployed every day, but one of the issues is the cost. What can be done to reduce the costs of Azure VMs?

  • mssqltips.com
  • Vitor Montalvao

Today, we are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes on the table with a single click.

  • blog.sqlauthority.com

A single point of failure (SPOF)  is a common reason why organizations are working towards distributing the presence of their database environments to another location geographically. It's part of the Disaster Recovery and Business Continuity strategic plans.

  • severalnines.com
  • Paul Namuag

In this article, we will discuss the SQL Server Auto Shrink database property, which allows SQL Server to automatically shrink the database files when the value is configured as True in the database option.

  • sqlshack.com
  • Jignesh Raiyani

SQL Server Log shipping provides a DR (disaster recovery) solution for the SQL Server databases and it can be configured at the database level. In a specific time-gap, SQL Server Transaction Log backup will be taken and copied to the destination site and will be restored.

  • sqlshack.com
  • Jignesh Raiyani

As you know, Oracle Cloud Infrastructure (aka OCI) becomes more and more popular. You can find OCI data centers almost everywhere and the price is very attractive. Oracle provides a lot of modules to deploy your architecture on OCI using Terraform. Those are called oracle-quickstar repos.

  • lefred.be
  • lefred

When you need to query documents using SQL, there are two options available in Couchbase. The Query service and the Analytics service. Our blog, N1QL: To Query or To Analyze? provides a detailed overview of both services. I highly recommend reading it before this one.

  • blog.couchbase.com
  • Evan Pease

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions.

  • scalegrid.io

A pushdown is an optimization to improve the performance of a SQL query by moving its processing as close to the data as possible.

  • blog.yugabyte.com
  • Karthik Ranganathan

Database schema change is becoming more frequent than before, Four out of five application updates(Releases) requires a corresponding database change, For a DBA schema change is a more often a repetitive task, it might be a request from the application team for adding or modifying columns in a table

  • mydbops.wordpress.com
  • Waseem Akram

This article explores the recovery of data removed by SQL Delete and SQL Truncate statements using SQL database backups. Before you go further with this article, go through the following articles to understand how delete and truncate statements work in detail.

  • sqlshack.com
  • Rajendra Gupta

In the previous blog post, we discussed the different Windows build variants that PostgreSQL supports. In this post, we’ll discuss how, as a Unix-based developer, you can check whether your patch might work on Windows. (For simplicity, I’ll say “Unix” to mean Linux, BSD, macOS, and similar.

  • postgr.es
  • Peter Eisentraut

If you are running PostgreSQL in production you might have already noticed that adjusting checkpoints can be a very beneficial thing to tune the server and to improve database performance overall.

  • cybertec-postgresql.com
  • Hans-Jürgen Schönig

In a previous post, we learned about installing Db2. Now I'm installing SQL Server. Therefore, I've downloaded Windows 2019 Standard (Evaluation) from this link. (Evaluation 180 days).

  • blog.dbplatz.com
  • DBplatz Support

Yes, I wrote a loop to find a gap in an identity-value sequence. Sue me. (Or don’t, that’d be cool too.) I’ve done some things I’m not proud of.

  • natethedba.com
  • natethedba

More and more organizations are getting on board with infrastructure as a service and the hybrid cloud and it looks like that trend is only accelerating this year.

  • cyberark.com

Kube-ArangoDB, ArangoDB’s Kubernetes Operator first released two years ago and as of today is operating many ArangoDB production clusters (including ArangoDB’s Managed Service Oasis). With many exciting features we felt kube-arango really deserves to be released as 1.0.

  • arangodb.com
  • Joerg Schad

This month is Women’s History Month, and it’s a chance to stop and think about the impact that women have had in history. After reading Monica Rathbun’s post on being a women in the SQL Server community, I wanted to drop a few notes.

  • sqlservercentral.com
  • Steve Jones

If you have a PostgreSQL cluster up-and-running, and you need to handle data that changes with time (like metrics collected from a system) you should consider using a time-series database that is designed to store this kind of data.

  • severalnines.com
  • Sebastian Insausti

This article walks through different versions of the T-SQL IF EXISTS statement for the SQL database using various examples. Suppose you want to deploy objects such as tables, procedures, functions in the SQL Server database.

  • sqlshack.com
  • Rajendra Gupta

Welcome to the sixth in a series of blog posts covering performance best practices for MongoDB. If you are running MongoDB on Atlas, our fully-managed and global cloud database service, then many of the considerations in this section are taken care of for you.

  • mongodb.com

Have you ever wondered where SQL Server Management Studio (SSMS) gets its information from and how you can retrieve the same data without using SSMS? Well it's not a big secret.

  • mssqltips.com
  • Greg Robidoux

PostgreSQL Streaming Replication is a great way of scaling PostgreSQL clusters and doing it adds high availability to them.

  • severalnines.com
  • Krzysztof Ksiazek

Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article, Shel Burkow walks through four modelling examples in Cassandra involving constraints.

  • red-gate.com
  • Shel Burkow

In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.

  • sqlshack.com
  • Ahmad Yaseen

If you’re looking to turn your passion for Yugabyte into your profession, then we have great news for you! Yugabyte is currently looking for talented people to join our team and help us keep the momentum going.

  • blog.yugabyte.com
  • Michelle Brinich

I deliberately didn’t set any goals at the start of 2020 since I was taking six weeks off for a sabbatical. That’s done, and it’s time to look forward. I know I have a few things that will be important for work.

  • sqlservercentral.com
  • Steve Jones

As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an IaaS solution (SQL Server in a VM) or a PaaS solution (SQL Database).

  • sqlservercentral.com
  • James-Serra

I learned an interesting thing about ALTER VIEW behavior in SQL Server when applied to indexed views.

  • littlekendra.com
  • Kendra Little