Our colleague Michael shared some stunning landscape photos with the team, which he captured during his trip to Iceland. We are proud that our employees are not only skilled professionals, but also people who know how to enjoy life and appreciate its beauty. Thank...
Often in the process of database operation, some of its objects become very large, which negatively affects performance and maintenance time. Sectionalization can be one of the options to solve this problem. In this article, we will tell you about the pros and cons...
In the previous two articles, we described in detail how DB-Service diagnoses infrastructure problems on DBMS servers and problems related to SQL logic. Completing the series of publications about the basic analysis of these problems, it is necessary to say a few...
In the previous publication, we raised the topic of how DB Service diagnoses failures after receiving complaints from customers. We considered the first large group of possible failures – infrastructure problems. In this article, we will discuss the second...
When receiving complaints from a client, such as “everything is slow”, “users are complaining”, “the process is too slow”, etc., «DB Serv» performs a large number of checks to diagnose the problem. In this article, we will describe...
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...
