Ambition IT sponsort SQL Zaterdag op 2 april 2011! Zie www.sqlzaterdag.nl.
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.
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.
Ambition IT is op zoek naar een .Net developer! Zie http://ambitionit.heeft-vacatures.nl/.
Op 5 oktober 2010 is Donald Farmer gastspreker bij onze maandelijkse PASS - bijeenkomst! Zie www.sqlpass.nl voor meer details.
De inschrijving voor SQL Zaterdag op 23 oktober 2010 is geopend! Zie http://sqlzaterdag.eventbrite.com.
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.
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.
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.