SQL Blogs

SQL and SQL Server database topics. Includes design, issue resolution and tips.

Importing Data into SQL Server – Using the Import Export Wizard

Rudy / March 15, 2010

Today begins the series on importing data into SQL Server 2005/2008 using the various built in tools. With SQL Server, […]

Rudy / March 12, 2010

From time to time you will run into a case where you need to store computed columns in your SQL

Rudy / February 16, 2010

There are times when you need to audit user permissions to ensure that things aren’t getting inserted, over-written, or deleted.

Rudy / February 12, 2010

Several of my DTS jobs require processing a file and then archiving the file. As we all know, you can