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 […]
Create Visual Studio Project with the correct directory structure
This ones just for me. I have been using TFS and when I read the best practice documentation for how to setup your projects I […]
jQuery – enable / disable (readonly) and how to reference .Net Server side Controls
Ok, I am just starting to play around with jQuery and these are a couple of tips that I have found useful. 1. How to […]