Forrards Blog

130 cents total
Pros and Cons of Switching to Database Managed Services

The term is widely used and covers so many things simultaneously, so it is hard to figure out what it means exactly. Do managed services include database administration only or do they also cover installation, upgrades and migration to other servers? Are database managed services always 24/7 or are there any other options? Do DBMS involve routine maintenance procedures or can they also handle critical issues? There are literally dozens of questions! Reporting? Custom service? Performance tuning and bottle-neck analysis? Too bad, each database managed service provider answers these questions differently, in its own way.

Forrards
March 18, 2023
SQL Server SSIS: ReplaceNull

One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have the operator similar to ISNULL () in T-SQL. To be more exact, there was such an operator, but it works in a slightly different way.

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.
Database consultancy: Hierarchy in MS SQL Server

In our time of greatest prevalence of databases were relational databases, which are the main targets of the tables and the relationships between them. Tables can solve most problems for data storage and manipulation. But in the real world entity requiring storage is not always presented in a tabular form. One of these very common types of data structures other than the table is a tree structure, where each data element is the parent and the offspring. An example of such a structure may be the structure of state enterprises, which is headed by the director (the root of the tree), his deputies, heads of departments from which are subject to certain deputies, employees of departments, which are subject to the rulers.

Forrards
March 31, 2023
Database consultancy: Reports generator for MySQL

No matter how much you've worked with MySQL, from time to time a modern and reliable report generator is needed. The up to date reports generator should have the following capabilities:

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.