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

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

SQL Server Enterprise Edition Advanced Scanning

It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in comparison with Standard...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let's review another useful operation - ONLINE rebuilding some partitions of partitioned objects (tables or indexe...

Define SQL Server database permissions for development team

The dba routine includes developer's accounts management. Such as creating sql logins for new developers. There is usually a  standard permissions list and database environment for code writing and t...

SQL Server 2014: protection against Database Administrator

Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like "How can I protect my data against the DBA?" appeared on forums regularly. Unti...