Field Level Auditing using Change Data Capture – Part 2

Second part of two part article on Change Data Capture for field level auditing and marting that data using SSIS for reports. I uploaded the entire Word document that includes the images.

Raw Materials - Recurses!

An argument goes as far as it can and no further.

Script to calculate the Median value for SQL Server data

The standard SQL language has a number of aggregate functions like: SUM, MIN, MAX, AVG, but a common statistics function that SQL Server does not have is a built-in aggregate function for median. The median is the value that falls in the middle of a sorted resultset with equal parts that are smaller and equal parts that are greater. Since there is no built-in implementation for the median, the following is a simple solution I put together to find the median.

Quick and Dirty DR Solution Using Robocopy

This article covers how to use robocopy with SQL Server Agent to copy database backup files to another server.

Extracting and Loading SharePoint Data in SQL Server Integration Services

The SharePoint List Source and Destination Sample available on Codeplex provides an optimized solution with an easy-to-use interface for getting data out of or into a SharePoint list. The sample also includes an API for accomplishing these tasks efficiently outside of SQL Server Integration Services.

Five Things (We Bet) You Didn't Know About Subversion Webinar - Rescheduled for November 8th

Rescheduled for November 8th, 2011 9:00 AM - 10:00 AM PST
Come and learn The Truth about Migration to and Administration for Apache Subversion. CollabNet, Subversion founder and corporate sponsor, and Red Gate Software, number one in SQL source management using any SCM system, want to share five powerful truths about Subversion that will fortify your decision to leave VSS behind.

If you were registered for the original event, please re-register for the new date.

Options to not replicate SQL Server DELETE commands

I have transactional replication configured in my production environment. The business team has requested that I do not replicate delete operations on certain articles. In this tip we look at a couple of options to not replicate DELETE commands.

Raw Materials - Performance Acceleration

Sometimes it's best to keep your secrets to yourself.

Removing TDE

Enabling TDE is simple to do, but it can be more complex when you look to remove the feature from SQL Server. Steve Perry brings you a procedure you can use to help you.

Do you test your SQL?

Red Gate is doing some research into SQL testing tools. If you can spare a moment to complete a short survey, or if you're interested in being part of the early access program, please click here.