Tag Archives: sql server

Password Handling

I thought this article on Best Buy PC setup was amusing. Here’s a company that’s trying to provide a service. They’re offering to set up most of your new machine for you. To make sure that things work right away for you, … Continue reading

Posted in Editorial | Tagged , | Comments Off on Password Handling

Create a Filestream Filegroup for Filetables – SQL Server 2012

Once you’ve enabled filestream, the next step is to add a filegroup to your database to hold the filestream data. This is pretty easy to do, and I’ll show you the SSMS and code versions. If you want to know … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

The Difference Between Change Tracking and Change Data Capture

Change Tracking (CT) and Change Data Capture (CDC) were both added to SQL Server in 2008. At first it seems like these two items ought to be synonyms, but they’re separate features. They are similar, but there are some differences, … Continue reading

Posted in Blog | Tagged , , | 5 Comments

SQL Server on RDS

A database service in the cloud. Imagine being able to connect to SQL Server on a remote machine, without having to administer the underlying OS, and without having to change the database code that you build against your local instance? … Continue reading

Posted in Editorial | Tagged , , | Comments Off on SQL Server on RDS