Mass loading of new data or violations of the existing procedures of data cleaning lead to abnormal database growth. That is why it is important to monitor and analyze the database growth, as well as for competent management of its structure in the course of normal...
Our company has adopted several practices to automate MS SQL Server databases, thanks to which our clients’ databases work smoothly and efficiently. In this article, we will discuss the procedures of maintenance of SQL Server indexes and statistics, backup...
Backup is one of the main ways to protect information. In this article, we will tell you what types of backups exist in PostgreSQL and how they are performed. What is a PostgreSQL backup A backup in PostgreSQL is a copy of the database data that is stored separately...
To work with databases, PostgreSQL provides a hierarchy of users with different access rights. In this article, we will discuss how to create and modify them, and explain how PostgreSQL relates the concepts of users, groups, and roles. How to create a user in...
In general, backup means creating a copy of data that can be stored on a separate device. In this publication, we will describe what data backup is and how it is configured using SQL Server DBMS as an example. What data backup gives you: ● A high-quality SQL...
In this article we will describe the main ways to create and delete users using the example of version 2012: in the Management Studio environment and via Transact-SQL instructions. SQL Server users are created in two steps: 1.The first step is to create a SQL Server...
All modern versions of Microsoft SQL Server are equipped with import and export functionality, which allows you to transfer data between different environments: databases, servers, etc., converting them into the required format. Data formats for exporting and...
Oracle Database is one of the most famous commercial non-relational DBMS in the world. To import and export data and metadata from ADO-compliant sources (MS Access, MS SQL DB, etc.) into a special dump file format, Oracle offers a technology known as Oracle Data Pump....
Companies regularly face the complexity of importing and exporting data to PostgreSQL. As a company expands its business, its branches often need to update local access databases with data coming from the central PostgreSQL server. From time to time, this data needs...
Replication is a technology of copying, distributing, and synchronization data between the main or master server and the slave or replica server. It is a key technology for high-load infrastructures, which enables them to: ● Acquire fault tolerance. Restoring from...
Replication is a technology of copying, distributing, and synchronization data between the main or master server and the slave or replica server. It is a key technology for high-load infrastructures, which enables them to: ➡️ Acquire fault tolerance. Restoring...
A proper SQL Server uninstall is a crucial aspect of database management. In this guide, the experts at DB Serv will walk you through everything you need to know to remove such software. Understanding SQL Server Components To comprehend the process of uninstallation...
