Forrards Blog

Category
130 cents total
Converting Crystal Reports to SSRS: Pitfalls of Automation

First of all, why migrate from Crystal Reports to MS Reporting Services? Does it really bring in some considerable benefits? The short answer is yes, it does. SSRS proves to be much more suitable for scalable tasks, delivers better .NET integration as both technologies share the same manufacturer, Microsoft. SSRS is also free as long as you already have an SQL Server license. In order to determine whether your business is ready to migrate to SSRS from Crystal Reports, please refer to this article.

Forrards
March 17, 2023
Single instance vs. multiple instances of SQL Server on a server

Single instance vs. multiple instances of SQL Server on a server

Forrard
March 8, 2015
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.
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

Let's discuss your project or resource request

                       

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

Contact Us
To let us help you

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