I’m in SQL just about every day of the week. Supporting multiple clients with multiple SQL servers in operation, we’re regularly working on databases. Part of that process is to backup and restore databases on our local machines for development.

One of the annoying items about SQL for me is that it wants to bury your database files deep within the Windows program folder for your SQL install. I really don’t want to dig down 7 levels of folder structure to get to my files. I can see how that might be handy and serve as a layer of protection, but …read more

This may not be a tip that’s too outstanding for everyone, but I’ve recently started employing the tweak to help me in my web development tasks. One of the challenges for me in development is that the data source for my web pages may change depending on my location on specific testing need. This tip shows you how to easily manage those changes on the fly.

Depending on the situation, I could be working on the development of a website while working completely off a local copy of the database. Later I may need to point the web pages to a …read more