Forrards Blog

130 cents total
How to close all active database connections in one shot?

While trying to restore SQL Server database or do any other actions which require exclusive database access you may face with the following error:Exclusive access could not be obtained because the database is in use.

Forrards
March 31, 2023
Consequences of wrong database autogrowth settings

In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re going to talk about database files settings and their autogrowth settings. From the first glance this seems to be an easy question. But in reality it may cause serious issues in mission critical data systems and even downtime. The goal of the article is to decide whether to set the growth in percents or megabytes and what should be the size of the file growth.

Forrards
March 31, 2023
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Subscribe to our blog

                             

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Database consultancy: Hierarchy in MS SQL Server

In our time of greatest prevalence of databases were relational databases, which are the main targets of the tables and the relationships between them. Tables can solve most problems for data storage and manipulation. But in the real world entity requiring storage is not always presented in a tabular form. One of these very common types of data structures other than the table is a tree structure, where each data element is the parent and the offspring. An example of such a structure may be the structure of state enterprises, which is headed by the director (the root of the tree), his deputies, heads of departments from which are subject to certain deputies, employees of departments, which are subject to the rulers.

Forrards
March 31, 2023
Database consultancy: Reports generator for MySQL

No matter how much you've worked with MySQL, from time to time a modern and reliable report generator is needed. The up to date reports generator should have the following capabilities:

Forrards
March 31, 2023

Let's discuss your project or resource request

                       

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.