New really great feature appears in SQL Server 2008 – change data capture. In few words: Change data capture records insert, update, and delete activity that is applied to a SQL Server table. This makes the details of the changes available in an easily consumed relational format. Further details can be…
Straight to the point: this week I’ve faced an interesting SQL issue. Few words about environment where it has occurred: Enterprise system with SQL Server 2005 databases. All changes made by users are logged using internal mechanism to history tables. The mechanism looks like Change Data Capture, but this possibility…
Let’s try to have a look at some SQL functions that are not very popular but can be very useful in some cases. Let’s imagine that we have the following task: replace all letters in a varchar column between first and last spaces with symbol ‘*’. The task can be…