Archives
-
[SQL] Scripting backup and restore all databases on a server (Part 2 - Extra Credit)
In the first post of this series, I discussed scripting database restore statements. It seems simple enough, but there's a complication - the restore statement requires the database logical name. The logical name usually follows the default format (a database named Example would have a data logical name of Example_Data and a log logical name of Example_Log), but it doesn't have to. The logical name could be just about anything.
-
[SQL] Scripting backup and restore all databases on a server (Part 1 - Simple Case)
We just migrated a group of production sites from one hosting environment to another. The new environment has staging and production servers, so we really completed two migrations. There were a lot of databases, and if you've been following my blog at all you probably know that I love to script repetetive tasks - not (only) from laziness, but from a desire to avoid typographical errors due in repetetive manual work.
-
[SQL] Change Logical Filenames
A little while ago, we deployed some really great sites built on the DotNetNuke platform. We started with a base DNN install, worked for several months, and ended up with a really nice suite of sites. Along the way, we renamed the databases, but the logical database names remained DotNetNuke_Data and DotNetNuke_Log. We looked into changing the logical names, but came up empty.
-
IE7 Standalone (Updated for IE7 Release)
I just released a new version of the IE7 Standalone Launcher. Due to changes in this beta release of IE7, a simple batch file alone won't cut it. You can grab a zip package (two batch files, two reg files) on the new tools.veloc-it.com site. -
Lessons from Home Remodeling: One Week Phases
A few times a year, someone will write about how software development is like building construction, and shortly afterwards a bunch of people will write about how software development is very different from building construction, but the two disciplines can inform eachother. I'm squarely in the second camp. I think software development is easier in many ways - our only real raw material is time, and we don't suffer from pesky constraints like gravity. I'm always happy to learn from anyone who will teach me, though, and in this case it's a guy who spent decades remodeling homes.
-
[SQL] Some of my favorite INFORMATION_SCHEMA utility queries
Phil just posted about using INFORMATION_SCHEMA to bulletproof your SQL change scripts. I've been working up a post on using queries against INFORMATION_SCHEMA views to generate SQL scripts, so this seems like a good time to chime in. The INFORMATION_SCHEMA views are views which describe a database's objects and schema. Phil did a great job of explaining what the INFORMATION_SCHEMA views are, so go take a look at his post if you'd like to know more. As the title of his post indicates, he's using INFORMATION_SCHEMA to make SQL change scripts more robust. I'm going to focus on using ad-hoc queries against INFORMATION_SCHEMA to save time.
-
Motorcycle blogging from San Diego to the Arctic Circle
