ETL

Today we have an editorial that was originally published on Aug 31, 2006 as Steve is traveling at DevConnections. It still seems relevant, so answer the poll this week.

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.

Laptop Boy Scouts

This editorial was originally published on Jan 10, 2007. Steve is at DevConnections, so it is being republished. This piece talks about laptop security when you are working in a public place.

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.

New Spatial Features in SQL Server Code-Named 'Denali'

SQL Server 2008 introduced spatial data support into the database server. This paper describes and discusses the new spatial features in SQL Server Code-Named “Denali” CTP1 and CTP3 that augment existing SQL Server 2008 and SQL Server 2008 R2 spatial functionality.

Password Help

Today we have an editorial that was originally published on Oct 9, 2006. Steve Jones talks about the issues of turnover, passwords, and security.

Database recovery model change notification report for SQL Server

The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at our company to alert the DBAs if a database recovery model is different than what it is expected.