Our database's regulatory processes

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 copying, and checking database integrity. 

Read more

How to create a PostgreSQL backup and restore from it

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. 

Read more

Work with users in PostgreSQL

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.  

Read more

Importance of data backup and methods of its implementation

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. 

Read more

Adding and deleting users in Microsoft SQL Server

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. 

Read more
Загрузить еще
Quick Links: Blog Contacts Prices
© 2008-2024. Sitemap