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.
10 Things a Database Design Company Should Do

Database design is a complex industry involving many technologies, software and specialists. The term “design” is a little bit misleading as it merely implies the creation process of a database. But in fact database design companies should do much more than mere “construction” of tables, indices and stored procedures. Creating an entity-relationship model, building the body of the database and filling it with data is just the beginning of the long road called “database design

Forrards
March 31, 2023
SQL Azure pricing

Form the first glance it may seem to be complicated to calculate price of hosting your database on Azure SQL. We`re simplifying this in below article.

Forrards
March 31, 2023

Let's discuss your project or resource request

                       

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