Database Design and Maintenance

Automating SQL Express Backups

SQL Express allows you to distribute a free edition of SQL Server with your applications. There are an enormous amount of 3rd party applications that use it and MSDE (it's...

Read More
SQL Database Development

SSIS 64 Bit Gotchas

I'm at a client engagement this week, which has been extremely fun in learning the more subtle issues isses with 64 bit with SSIS. The first gotcha I alread knew but...

Read More