Sergey Smagin

Sergey Smagin

Product manager, CEO and co-founder of Active Database Software
Nov
15
A quick sample: how to customize your database schema view visually?

A quick sample: how to customize your database schema view visually?

When you want to change your database schema tree, Metadata Container Editor lets you do this without coding to experiment with the tree structure faster.
3 min read
Oct
09

Creating a simple SQL query with Active Query Builder

SQL is a powerful weapon to cope with this task, but you will need plenty of time to master it if you don’t have a solid SQL background. Is there a way to get an instant result?
8 min read
Dec
25
SQL for Beginners

SQL for Beginners

Entry-level SQL users sometimes have a hard time learning the language or hesitate to apply their knowledge in the real
2 min read
Dec
25

SQL for Advanced Users

A single SQL query sometimes may take multiple pages and include many subqueries. Such a complex query can be quite
2 min read
Jan
22
Understanding a Complex Database Structure

Understanding a Complex Database Structure

Knowing where to look for the necessary data in a scarily large database schema is vital when you write SQL queries.
5 min read
Sep
17
Do you need a BI tool to make ad-hoc reports?

Do you need a BI tool to make ad-hoc reports?

Is it possible to make users of your database information system (ERP or CRM) self-sufficient in serving their needs for data without the use of complicated and expensive BI tools?
4 min read
Sep
13
How to organize data flow in B2B solutions?

How to organize data flow in B2B solutions?

When you start any B2B business, you probably need partner’s data. The manual approach is like asking the CTO to show you where to get the data. Then repeat the process with every client.
4 min read
Apr
28
Faster visual SQL query building in the upcoming major version!

Faster visual SQL query building in the upcoming major version!

Find out how things will change in Active Query Builder for .NET 4.0.
3 min read
Mar
14
Domain Specific Language: define SQL queries via fluent API

Domain Specific Language: define SQL queries via fluent API

New API makes your queries database server-independent and checked against the current database schema on the compilation stage.
1 min read
Feb
22

Demo projects are available on GitHub now

All demo projects on GitHub refer to Active Query Builder NuGet packages, so they do not require installation of Active Query Builder to run.
1 min read