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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.
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.
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.
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).
