Browse by Tags

Related Posts

  • SQL Server 2005 doesn't like numbers less than 50

    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...
    Posted to Plip's Weblog (Weblog) by Plip on 07-30-2006, 12:00 AM
    Filed under: SQL Server, SQL Server 2005
  • SQL Server 2005 doesn't like numbers less than 50

    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...
    Posted to Community Blogs (Weblog) by Anonymous on 07-30-2006, 12:00 AM
    Filed under: SQL Server, SQL Server 2005
  • [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...
    Posted to JonGalloway.ToString() (Weblog) by Jon Galloway on 07-28-2006, 12:00 AM
    Filed under: SQL, SQL Server
  • [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...
    Posted to JonGalloway.ToString() (Weblog) by Jon Galloway on 07-27-2006, 12:00 AM
    Filed under: SQL, SQL Server
  • [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...
    Posted to JonGalloway.ToString() (Weblog) by Jon Galloway on 07-27-2006, 12:00 AM
    Filed under: SQL, SQL Server
  • [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...
    Posted to Community Blogs (Weblog) by Anonymous on 07-28-2006, 12:00 AM
    Filed under: SQL, SQL Server
  • [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...
    Posted to Community Blogs (Weblog) by Anonymous on 07-28-2006, 12:00 AM
    Filed under: SQL, SQL Server
  • [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...
    Posted to Community Blogs (Weblog) by Anonymous on 07-28-2006, 12:00 AM
    Filed under: SQL, SQL Server
  • MSDE not supported on Vista? Yikes!

    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...
    Posted to Community Blogs (Weblog) by Anonymous on 07-13-2006, 12:00 AM
    Filed under: SQL Server
  • Tip/Trick: Online Database Schema Samples Library

    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...
    Posted to ScottGu's Blog (Weblog) by ScottGu on 07-12-2006, 12:00 AM
    Filed under: Data, SQL Server, Tips and Tricks, ASP.NET
Page 1 of 97 (965 items) 1 2 3 4 5 Next > ... Last »
Microsoft Communities