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.
Learn When It’s Time for You to Migrate from Crystal Reports to SSRS

It would be a huge stretch to say Crystal Reports became an old dog hardly taught new tricks, but since Microsoft released its SQL Server Reporting Services developers faced with the need to choose between the default Crystal Reports and potentially more productive SSRS. Is there a real need to change horses in the midstream provided Crystal Reports has its own advantages too?

Forrards
March 17, 2023
Step by step guide to setting up MS SQL Server AlwaysOn

AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it is another step toward the fail-safe system. For the 1st time it appeared in MS SQL Server 2012 and was going to replace mirroring in future. But now we see both technologies in MS SQL Server 2014, which, of course, pleases.

Forrads
March 17, 2023

Let's discuss your project or resource request

                       

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