Singleton pits should be applied with caution

The description of the pattern is simple. The class must be guaranteed to have only one object and this object …

Free tools for MS SQL Server

MS SQL Server is not uncommon in a network of organizations because it often goes “in strain” to a business …

DBREPLICATION Technology for replication of information bases

DBReplication is a unique technology for replicating databases and the tasks that the technology solves. First of all this is …

The Importance of Database Maintenance

Often specialists, engineers, programmers forget about the importance of maintaining the database and faced with performance problems. First begin to …

Statistics as a key to solving performance problems

The trend of modern time is the growth of information flows within the company. Due to many factors: increased number …

Basics of T-SKL programming

Transact-SQL (T-SQL) is an extension of the SQL language from Microsoft. It’s used in SQL Server to program databases. SCL …