For years I have been relying upon the Web for quick answers about how to do things in SQL Server and ASP.NET (among other things), and it has saved me a huge amount of time not having to reinvent the wheel. This is my attempt to return the favor: I will be writing articles about unique or otherwise interesting problems (to someone facing them) that I have had to solve.
If you find any of this helpful, please let me know.
Last week I began to prepare to migrate from SQL Server 2005 to 2008 (x64) by clearing off my staging server and installing SQL Server 2008. I didn’t get far. Based on what I saw, and what I have been reading on the MSDN forums, this is what happened:
This last week I wrote two SSIS packages (SQL Server 2005) that read data that was originally published using Excel .xls format and populated a staging table. The data is only published once a year, with perhaps one or two corrections following, but I thought I would save a little …Continue reading →