The Issue I wrote a windows form application that deployed via an .msi installer. The application has an App.Config file which contains a single configuration […]
SQL Server 2008 R2 – Intellisense not working – Visual Studio 2010 SP 1
Hi, Recently intellisense in the SQL Server management Studio stopped working. It appears that it was caused by the installation of Visual Studio 2010 SP1. […]
Bootstrapper Manifest Generator (2008) – How To Guide v2
I wrote the original Boostrapper Manifest Generator (BMG) blog post a few years ago. It is one of the most heavily visited pages on my […]
Reconnect all SQL logins after DB restore
Hi, Below is a script that I use to reconnect sql logins after a database restore. It reconnects all users to all databases. Cheers
Restore SQL Server Database – disconnect all users
Hi, Often when you try to restore a database there will be connections to the DB, which will stop the restore from succeeding. What I […]
SQL Server SHRINKFILE not working
As microsoft put in in SQL Server Books online, “A shrink operation is most effective after an operation that creates lots of unused space, such […]
Windows Server 2008 Image thumbnails not showing
I noticed the other day that on one of my servers image thumbnails were not showing. This is easy to fix, do the following: Click […]
SSIS Date conversion error going from Oracle to SQL Server
Hi, The other day I had the task to move a large amount of data from Oracle to SQL Server. I had chosen to import […]
How to Create a linked server connection from SQL Server to Filemaker Pro 6.0
Ok, This one may be a bit obscure but I had to do this for data conversion from a legacy system the other day and […]
StringUtil class – Space Before a Capital Letter
Hi, I often use enumerations in code that I want to display as text on the screen. For example the state of an object recorded […]