How to configure DTC on Windows 2003
Back in the Windows 2000 days, getting DTC to work was easy. It was setup by default to work. There wasn’t a whole lot of configuration which needed to be done to get it setup correctly. When Windows 2003 was released things got a bit different. All of a sudden DTC wasn’t working by default, […]
Microsoft SQL Server 2008 goes RTM
Microsoft has just announced that SQL Server 2008 has been released to the public. You can download the Eval edition as of today from the Evaluate Microsoft SQL Server 2008 webpage. It’s has been released in a variety of languages including English, French, German, Spanish and Chinese. Technet Plus subscribers can download it today, while retail packaging […]
I need a secure transfer of data between SQL Servers. What are my options?
You’ve got a few options, none of which are all that easy to setup. 1. Export the data, then encrypt the file, then transfer the file, then decrypt the file, then import the file. 2. Setup IPSec between the two SQL Servers and then transfer the data as normal. 3. Setup a Secure FTP Server […]
SQL Server Experts: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost
I was asked to be interviewed for an article on Microsoft SQL Server by OdenJobs.com. They have just posted the interview of myself and Christian Lefter, Andew Fyer, Namwar Rizvi, Brent Ozar, Brian Kelly, Chris Shaw, and Pinal Dave. Part 1: MS SQL beats the “ACID” test for Database Technology in Features, Ease & Cost […]