Browsing All Posts filed under »Change Tracking«


February 15, 2010


What is everybody’s thoughts on the NOSQL movement? Where do you see NOSQL databases working best or better than traditional relational databases? Advertisements

Hands off the database

July 9, 2009


No need for a DBA anymore.. lol.. well, maybe sometimes.

Cushy CMS

January 19, 2009


Recently, I have had to update a really old website I did for a client  , it was based on ASP (classic!) but essentially was static pages of content. What I really wanted was a way for them to update the site easily themselves but I didn’t want to spend time re-writing it as this […]

The GUID Guide

July 1, 2008


Excellent article on GUIDs.

Personal Firewall

April 28, 2008


I have just finished watching the Gadget show and wanted to blog about a neat personal, usb, linux-based firewall. You basically have to install the drive and plug in.. it works in XP/Vista (32bit I believe). You can check out the details at the Yoggie site , If you are in the UK, […]

Change Tracking Context

February 12, 2008


This is potentially very useful if you are intending to use Change Tracking. It is possible to set a context (“hey, all these changes were done as part of this process”). This can easily be done by DECLARE @originator_id varbinary(128); SET @originator_id = CAST(‘SSIS’ AS varbinary(128)); WITH CHANGE_TRACKING_CONTEXT (@originator_id) UPDATE MyTable SET MyLocationId = 1100 […]

All Change

January 21, 2008


I will putting together a piece on Change Tracking over the next couple of days. This is a new feature that will be available in all editions of SQL Server 2008.