Europe: +358 9 2316 4047 North America: +1 646 583 1147 Skype: Forrards Don’t have time to talk? Simply fill out the form with your request here instead

Remote DBA experts: knowledge base

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 ...

Database consultancy: tree-like structure

Subject recursion is well covered in the literature, but, nevertheless, the problem of output "tree" does not mean the client and SQL Server many baffled. So, put the problem: there is a table with t...

Database consultancy: SaaS database considerations

There are three well-known types of SaaS database architectures. 1)Separate Databases; 2)Shared Database, Separate Schemas; 3)Shared Database, Shared Schema.Some more details below.Separate DatabasesU...

Database consultancy: ROW_NUMBER() function

ROW_NUMBER function numbers the rows returned by the query. You can use it to perform more complex ordering of rows in the report than the one given by the ORDER BY clause. Using the ROW_NUMBER you ca...

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 knowled...