Browsing All Posts filed under »Change Tracking«

NOSQL

February 15, 2010

0

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

0

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

Cushy CMS

January 19, 2009

0

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

2

Excellent article on GUIDs. http://blogs.msdn.com/oldnewthing/archive/2008/06/27/8659071.aspx

Personal Firewall

April 28, 2008

1

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 , http://www.yoggie.com/node/40. If you are in the UK, Play.com […]

Change Tracking Context

February 12, 2008

0

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

0

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.