I've been creating a database for a client and it requires the creation of some fields which are of type varchar(10). Nothing weird there I'm sure you'll agree. In creating these tables I'm using SQL Server Management Studio and I've found a little bug. If you create a column, enter...

I've been creating a database for a client and it requires the creation of some fields which are of type varchar(10). Nothing weird there I'm sure you'll agree. In creating these tables I'm using SQL Server Management Studio and I've found a little bug. If you create a column, enter...

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...

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...

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...

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...

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...

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...

Whoah. According to this post, MSDE won’t be supported on Windows Vista. This is the first I’ve heard of this, and I have to say it’s pretty surprising. One of my company’s products depends on MSDE – it’s disappointing to think that it won’t be Vista compatible...

Problem: You are building a web application, and are trying to figure out how to best model the particular database schema you need for the application. Solution: One great resource I found recently on the web that I recommend checking out is a really nice library of free database models . You can browse...