Forrards Blog

130 cents total
How to bulk enable or disable SQL Server agent jobs ?

It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script below is useful when you have dozens or hundreds of jobs. It will help you you to avoid doing this work manually.

Forrards
March 18, 2023
CONTEXT_INFO and efficient mass update on a large table with a trigger

Let`s assume we have following task – make changes to the data in a large table that has consistency checker in a trigger. Let`s look at the ways to do it in a most efficient way.Use test database in a simple recovery mode. Create two tables and fill them by random data.

Forrards
March 18, 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.