In this article, we will talk about the benefits of backing up SQL Server databases, different backup types, and backup strategies.
The immediate purpose of...
One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue.
Perhaps, a classic case everyone gets...
In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.
This article explains implementation of the TFS custom check-in policy for pre-commit code review. We developed this policy for Review Assistant - our code review tool.
Idea Behind...
It's incorrect to consider a database as a stable unit, since various kinds of undesirable situations can appear over time — database performance degradation,...