Deleting Rows in Incremental Loads – Level 5 of the Stairway to Integration Services

In this installment of the Stairway to Integration Services, MVP Andy Leonard completes the incremental load section with a look at how deletes at the source are handled when loading data into SQL Server.

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.