Subscribe to SQL Server Magazine:
To ensure that future email messages you receive from SQL Server 2005 Express UPDATE aren't mistakenly blocked by antispam software, be sure to add [email protected] to your list of allowed senders and contacts.
==== This Issue Sponsored By ====
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for SQL Server Magazine UPDATE.
June 5, 2006
- Using SQL Server Management Studio for Express
2. Jump Start
- Using Views
3. Check It Out
- Microsoft's SQL Server 2005 Express Blog
4. Events and Resources
- Special Offer: Download a White Paper
- Application Packaging and Its Role in Successful OS
- SQL Server High-Availability Options
- Download a Quick-Reference Pocket Guide
5. Featured White Paper
- Building Open iSCSI SAN Storage Systems on
6. New Product
- New Components Enhance Development Experience
- SQL Server Magazine Monthly Online Pass--Only $5.95
- June Special--Save $100 On the Exchange & Outlook
==== Sponsor: Neverfail ====
When disaster strikes your servers, you need a disaster-recovery plan in place to recover quickly. Download this eBook to read about solutions for Windows, SQL Server 2005, and Exchange servers and get started on your recovery plan today!
1. ==== Commentary ====
Using SQL Server Management Studio for Express
by Michael Otey
In this column, I tell you how to get SQL Server Management Studio Express (SSMSE) and how to use it to manage SQL Server 2005 Express. I also point out some of the differences between the standard SSMSE and the full-blown SQL Server Management Studio (SSMS) that comes with SQL Server 2005 Enterprise Edition, Standard Edition, and Workgroup Edition.
SSMSE is the graphical management tool that Microsoft provides for SQL Server 2005 Express. Having SSMSE as a companion product with SQL Server Express is one of the main advantages that SQL Server Express has over its predecessor, Microsoft Data Engine (MSDE). MSDE has no built-in management tools; instead you are limited to managing MSDE by using the not-so-user-friendly osql command-line tool or (if you're an existing SQL Server customer) you can use Enterprise Manager.
SSMSE isn't delivered as part of SQL Server 2005 Express Edition. There are three ways to get it: download SSMSE separately from the Microsoft site, receive SSMSE with the full-featured SQL Server 2005 Express Edition with Advanced Services, or download SSMSE with the SQL Server 2005 Express Edition Toolkit. You'll find links for these options at
After you've downloaded and installed SSMSE, you can begin to manage your SQL Server Express instances. You start SSMSE by selecting Start, All Programs, Microsoft SQL Server 2005, SQL Server Management Studio Express. When SSMSE starts, you'll see a Connect to Server dialog box. By default, the "Server name" drop-down box displays the name of the local SQL Server Express instance. If the display is blank and you used the default instance name during installation, you can connect to the local SQL Server Express instance by typing .\SQLEXPRESS in the "Server name" drop-down box. You can also use SSMSE to connect to SQL Server 2005 by entering the SQL Server 2005 name in the "Server name" drop-down box, but SSMSE lacks some of the capabilities in SQL Server Management Studio--more on that later.
Next, select the authentication method you want to use to connect to the SQL Server Express instance. If you selected the default options during installation, you'll use Windows Authentication. Otherwise, you'll need to select SQL Server Authentication and enter the SQL Server username and password that you specified during the installation process or while you were using the SQLCMD tool. Click Connect to populate SSMSE with the server instance and database objects in the left pane. To explore the database objects, click the plus sign next to each object to expand it. Here are some brief descriptions of the objects:
To enter and run T-SQL statements, open the Query Editor by clicking New Query.
You'll find the look and feel of SSMSE to be similar to the version of SSMS that's included with SQL Server 2005, but there are differences. The full-featured version of SSMS lets you manage SQL Server 2005 features that aren't included in SQL Server Express. For example, SSMS lets you manage SQL Server Agent jobs and SQL Server replication. These features aren't included with SQL Server Express and SSMSE. However, SSMSE and SSMS share important capabilities, such as the ability to browse database objects and use Query Editor to execute T-SQL statements.
****** Sponsor: AMD ******
Learn the key differences in system architecture between 32-bit and 64-bit architecture and the benefits of deploying 64-bit technology with Windows Server 2003 and SQL Server 2005 from industry expert Michael Otey. Live Event: Wednesday, May 10.
2. ==== SQL Server Express Jump Start ====
by Michael Otey
In this column, I drill down a little deeper into the world of SQL Server 2005 Express database objects and show you how to create and use views. First, what is a view? As its name suggests, a view is a customizable "window" that displays the contents of one or more selected tables or other views. The technical definition of a view is a virtual table created by the results of a query. This virtual table represents the data from one or more tables or views in an alternative way. Because a view is a virtual table (i.e., a query result), creating a view doesn't take up disk space.
You use views in a couple of common ways: First, views let you easily create a subset of the data contained in a single table, and second, you can use views to join multiple tables into a single table to simplify data access. In the April 19, 2006 Jump Start column (http://www.sqlmag.com/Article/ArticleID/50035/sql_server_50035.html ) I described how to create a Media table. The following code determines whether the vwMedia view exists, then creates a view called vwMedia that lists a subset of the columns in the Media Table:
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'vwMedia' AND type = 'U')
DROP TABLE Media
CREATE VIEW vwMedia
SELECT MediaID, MediaType, MediaTitle
Now, run the following SELECT * statement to return all the columns (e.g., MediaID, MediaType, MediaTitle) from the view.
SELECT * FROM vwMedia
***** HOT SPOT: Double-Take Software *****
Develop your disaster recovery program before it's too late. Define the right plan for your environment and avoid costly mistakes.
3. ==== Check It Out ====
Microsoft's SQL Server 2005 Express Blog
by Michael Otey
Looking for a place to learn more about SQL Server 2005 Express and keep up with some of the latest SQL Server Express news and events? If so, check out Microsoft's SQL Server Express blog at
4. ==== Events and Resources ====
Special Offer: Download a White Paper Download any white paper from Windows IT Pro before June 20, and you could win a pair of Bose Triport Headphones. View the full selection of papers today at
Application Packaging and Its Role in Successful OS Migrations Cut your Windows XP migration time by 60 percent or more when you learn how to efficiently migrate your applications into the Windows Installer (.msi) format. On-demand Web seminar
SQL Server High-Availability Options Industry expert Michael Otey explains how to design high-availability options for your SQL Server 2005 environment. He also covers Windows clustering, Database Mirroring, and online operations. On-demand Web seminar
Download a Quick-Reference Pocket Guide Get free pocket-reference guides about things you need to know about today's technology, including the top 10 error messages that can ruin your day. Download one or all today!
5. ==== Featured White Paper ====
Building Open iSCSI SAN Storage Systems on Industry-Standard Platforms
Explore how the standardization of storage hardware will change market dynamics, focusing on the growth of iSCSI SANs and "glue software."
Tell Us About a Hot Product and Get a Best Buy Gift Card!
Have you used a product that changed your IT experience by saving you time or easing your daily burden? Tell us about the product, and we'll send you a Best Buy Gift Card if we write about the product in a future Windows IT Pro What's Hot column. Send your product suggestions with information about how the product has helped you to [email protected]
6. ==== New Product ====
New Components Enhance Development Experience
by Blake Eno
7. ==== Announcements ====
SQL Server Magazine Monthly Online Pass--Only $5.95 per month!
Includes instant online access to every article ever written in SQL Server Magazine and the latest digital issue. Order now at
June Special--Save $100 On the Exchange & Outlook Administrator Newsletter
Get endless solutions to help you migrate, optimize, administer, backup, recover, and secure your message system. Subscribe to Exchange & Outlook Administrator today and save $100 at
==== Contact Us ====
About the [email protected]
About the [email protected]
About technical questions-- http://sqlforums.windowsitpro.com/web/forum/default.aspx?forumid=10
About product [email protected]
About your [email protected]
About sponsoring an issue of SQL Server Express UPDATE--
Richard Resnick, [email protected]
SQL Server Express UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.
Manage Your Account You are subscribed as %%$email%%. To unsubscribe from this email newsletter, click here
To manage your email account, simply log on to our Email Preference Center.
SQL Server Magazine is a division of Penton Media, Inc.
221 East 29th Street
Loveland, CO 80538
Attention: Customer Service Department
Copyright 2006, Penton Media, Inc. All Rights Reserved.