Jump To : GoDaddy-Specific Articles

General Articles on SQL Server and Express

Deleting Users from Membership using SQL

During early phases of your Membership Web Site you will probably create many test users to verify your new application. This article looks at removing users by logging into the database and running SQL directly.

The Salmon Training Users Kit: Approving Members and Assigning Roles

Salmon Training has created a set of database programs (known as "stored procedures") that simplify the process of approving users and adding them to the Administrators and Friends roles. Once they're installed on the live database approving users and adding them to roles simply involves logging into the database and running simple SQL commands.

E-Book Excerpt: Developing Stored Procedures for SQL Server (and SQL Express)

This full chapter from our e-book provides an excellent introduction to developing stored procedures. We take the process from requirements analysis, to table design, to creating and executing stored procedures using input parameters, default parameters, error processing and output parameters. The link takes you to the e-book offer page, which allows you to register for your free chapter.

Why your Development Web.Config File Won't Work on the Live Site

This article looks at the details of a web.config file that was created during developing a local website on a PC with SQL Express. It explains why every attribute of the database connection string needs to change when going live on a shared hosting site using Microsoft SQL Server.

Relaxing Password Restrictions for Membership and Logins

By default, ASP.NET 2.0 applies rather strict rules to passwords: they must be at least eight characters long, contain a mix of upper and lower-case, and contain a non-alphanumeric character. This article shows how to relax the restrictions.

How to Connect to SQL Express Instances from SQL Server Management Studio

SQL Server Management Studio is the new GUI from Microsoft for managing your databases. There are a few tricky steps to take when working for the first time with SQL Express databases within Visual Studio or Visual Web Developer Express. This article provides a step-by-step walkthrough.

SQL Server Compact Edition or SQL Express for your desktop application?

This article compares SQL Server Compact Edition and SQL Express for a particular purpose: the single-user desktop application. The author focuses on two areas of contrast between these two database options: the footprint or resources that an installation consumes on the desktop, and the level of complexity in the features offered by each platform.

Articles on SQL Server and Go Daddy

Go Daddy : Deleting a SQL Server Database on Shared Hosting Plans

Deleting a SQL Server database is straightforward using the Go Daddy Control Panel. However, you should be aware of some implications if you intend to recreate the database at a later point.

Go Daddy: Backing Up SQL Server on Shared Hosting Plans

The backup tool is a relatively recent addition to the Go Daddy control panel (July 2007). This article provides a step-by-step walkthrough to show you how to back up your SQL Server database.

Go Daddy : Restoring a SQL Server Database on Shared Hosting Plans

This article provides a step-by-step walkthrough to show you how to restore your SQL Server database.

Go Daddy: Upgrading to SQL Server 2005 on Shared Hosting Plans

At the time of writing, Go Daddy does not provide an automated upgrade to SQL Server 2005. This two-part article walks through the manual steps.

Go Daddy : Direct Deployment with the Database Publishing Wizard on Shared Hosting Plans

This article shows you how to use the Database Publishing Wizard to deploy directly to a Go Daddy Shared Host.