Forrards Blog

130 cents total
SQL Server issue: switching partitions using the parameter with enabled replication

It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any problems until a need to replicate a few directories...But let’s get into the details step by step:First of all, we create the partition function and a scheme to demonstrate very unexpected behavior of SQL Serverset nocount on;

Forrards
March 30, 2023
Database migration from on-premises Microsoft SQL Server to Azure SQL managed instance via backup/restore

This guide describes the process of database migration from Microsoft SQL Server on-premises to Azure SQL managed instance.

Anna
March 30, 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.