Les Smith

I am a database developer working with SQL Server and Oracle8i. My focus is on data warehousing, reporting and analysis. The tools I use are Java, Stored Procedures, Visual Basic and commercial applications such as Informatica. I am currently working at an Application Service Provider company in Silicon Valley.

Data Warehouse Version Management

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.

2001-08-27

3,190 reads

Blogs

Snowflake in Azure

By

Being aligned to a global cloud like Microsoft Azure you have choices. Whether that...

Regression Testing SQL Saturday Naming

By

I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Kick starting Extended Events

By VoldemarG

We have no prior experience of using XE. Yes, our DBA group uses server...

Easing Back to the Office

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Easing Back to the Office

Missing Data

By Joe Celko

Comments posted to this topic are about the item Missing Data

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers