Forrards Blog

Category
130 cents total
Database Consultancy: SQL for economist

If you’ve ever tried to find a job with economist position, you’ve definitely faced with sql knowledge requirement. Statistics show that over 75% of economist jobs require database and sql knowledge. Unfortunately, while studying at economical college or university we don’t pay enough attention to databases, which cause many problems afterwards.

Forrars
March 5, 2015
How to Easily Migrate SSRS Reports Between Two Servers

Situation: you have an existing installation of MS SQL Server with Reporting Services and now would like to transfer all the content from it to another instance of MS SQL Server Reporting Services. Of course, you could simply delegate this task to a third-party and enjoy fast and accurate migration of SSRS reports to another instance on the same or another server.

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