Excellent posts on moving files to an archive directory with SSIS

http://sqlserversolutions.blogspot.nl/2009/04/copyrename-file-using-file-system-task.html http://stackoverflow.com/questions/6698075/how-do-i-move-files-to-an-archive-folder-after-the-files-have-been-processed

Ambition IT sponsort SQL Zaterdag

Ambition IT sponsort SQL Zaterdag op 2 april 2011! Zie www.sqlzaterdag.nl.

SQL Server 2008 R2 Express: Send email with CLR

In the Express edition of SQL Server the Database Mail functionality does not exist. Therefor you need an alternative way to send emails with T-SQL. One solution is to use a CLR stored procedure. In this post I explain how to do this.

Key management services (KMS) host could not be located ...

We installed a new Windows Server 2008 server and were not able to activate online. Thanks to Code-Journey we found the easiest way to fix this: just retype your key.

Wij zoeken een .Net developer

Ambition IT is op zoek naar een .Net developer! Zie http://ambitionit.heeft-vacatures.nl/.

5 oktober 2010: Donald Farmer bij PASS Nederland

Op 5 oktober 2010 is Donald Farmer gastspreker bij onze maandelijkse PASS - bijeenkomst! Zie www.sqlpass.nl voor meer details.

SQL Zaterdag 23 oktober 2010: Inschrijving geopend

De inschrijving voor SQL Zaterdag op 23 oktober 2010 is geopend! Zie http://sqlzaterdag.eventbrite.com.

Making a query faster

While preparing for the 70-451 exam I took a look at a stored procedure at a client's server that was performing poorly. This client is in the process of upgrading from SQL Server 2000 to SQL Server 2008 and they now also wanted to improve this stored procedure.

Error when changing the collation of a database

Recently I had to change the collation of a database. That resulted in an error message: The database could not be exclusively locked to perform the operation.

SQL Zaterdag 2010 / SQL Saturday in the Netherlands

Aimed at a Dutch audience: The second SQL Saturday in The Netherlands is on it's way! Be there on October 23. Read more information at www.sqlzaterdag.nl.