SQL Server Express UPDATE--June 5, 2006: SSMSE, Using Views, and SQL Server Express Blog

Subscribe to SQL Server Magazine:
&nbsp &nbsp &nbsp https://store.pentontech.com/index.cfm?s=9&cid=51&promotionid=1491


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.

&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/ebooks/neverfail/hasolutions/?code=SQLExpTop0605

&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/seminars/amd/understandingx64/?partnerref=SQLExpMid0605

Double-Take Software
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/whitepapers/doubletake/disasterrecovery/?code=SQLExp0605


June 5, 2006

1. Commentary
&nbsp &nbsp &nbsp - Using SQL Server Management Studio for Express

2. Jump Start
&nbsp &nbsp &nbsp - Using Views

3. Check It Out
&nbsp &nbsp &nbsp - Microsoft's SQL Server 2005 Express Blog

4. Events and Resources
&nbsp &nbsp &nbsp - Special Offer: Download a White Paper
&nbsp &nbsp &nbsp - Application Packaging and Its Role in Successful OS
&nbsp &nbsp &nbsp Migrations
&nbsp &nbsp &nbsp - SQL Server High-Availability Options
&nbsp &nbsp &nbsp - Download a Quick-Reference Pocket Guide

5. Featured White Paper
&nbsp &nbsp &nbsp - Building Open iSCSI SAN Storage Systems on
&nbsp &nbsp &nbsp Industry-Standard Platforms

6. New Product
&nbsp &nbsp &nbsp - New Components Enhance Development Experience

7. Announcements
&nbsp &nbsp &nbsp - SQL Server Magazine Monthly Online Pass--Only $5.95
&nbsp &nbsp &nbsp per month!
&nbsp &nbsp &nbsp - June Special--Save $100 On the Exchange & Outlook
&nbsp &nbsp &nbsp Administrator Newsletter


==== 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!
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/ebooks/neverfail/hasolutions/?code=SQLExpTop0605

1. ==== Commentary ====

Using SQL Server Management Studio for Express
&nbsp &nbsp &nbsp 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
&nbsp &nbsp &nbsp http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx

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:


  • Database object: lists user and system databases
  • Security object: lists SQL Server logins and roles
  • Server Objects: lists backup devices, linked servers (remote database systems) and server triggers
  • Replication node: lists local subscriptions
  • Management node: displays SQL Server logs and the Activity

    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.
    &nbsp &nbsp &nbsp http://www.windowsitpro.com/go/seminars/amd/understandingx64/?partnerref=SQLExpMid0605


    2. ==== SQL Server Express Jump Start ====

    Using Views
    &nbsp &nbsp &nbsp 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
    &nbsp &nbsp &nbsp WHERE name = 'vwMedia' AND type = 'U')
    &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp DROP TABLE Media
    CREATE VIEW vwMedia
    SELECT MediaID, MediaType, MediaTitle
    FROM Media

    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.
    &nbsp &nbsp &nbsp http://www.windowsitpro.com/go/whitepapers/doubletake/disasterrecovery/?code=SQLExp0605


    3. ==== Check It Out ====

    Microsoft's SQL Server 2005 Express Blog
    &nbsp &nbsp &nbsp 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
    &nbsp &nbsp &nbsp http://blogs.msdn.com/sqlexpress/

    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
    &nbsp &nbsp &nbsp http://www.windowsitpro.com/whitepapers

    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
    &nbsp &nbsp &nbsp http://www.windowsitpro.com/go/seminars/WindowsXP?partnerref=0607emailannc

    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
    &nbsp &nbsp &nbsp http://www.windowsitpro.com/go/seminars/xosoft/sqlserver/?partnerref=0607emailannc

    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!
    &nbsp &nbsp &nbsp http://www.windowsitpro.com/needtoknow

    5. ==== Featured White Paper ====

    Building Open iSCSI SAN Storage Systems on Industry-Standard Platforms
    &nbsp &nbsp &nbsp Explore how the standardization of storage hardware will change market dynamics, focusing on the growth of iSCSI SANs and "glue software."
    &nbsp &nbsp &nbsp http://www.windowsitpro.com/go/whitepapers/lefthand/iscsi/?code=0607featwp


    Tell Us About a Hot Product and Get a Best Buy Gift Card!
    &nbsp &nbsp &nbsp 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
    &nbsp &nbsp &nbsp by Blake Eno

    ComponentOne announced ComponentOne Studio Enterprise 2006 2, a component toolset for Windows, Web, and Mobile application development. The product features Asynchronous JavaScript and XML (AJAX)-enabled components including WebGrid, WebReports, WebTreeView, WebTabStrip, and WebTopicBar to help you build Web interfaces. A new productivity technology called SmartDesigners helps you set components' most common properties without leaving the design surface. In addition, Studio Enterprise features new visual elements to WinForm and WebForm charts. For more information, contact ComponentOne at 412-681-4343 or 800-858-2739.
    &nbsp &nbsp &nbsp http://www.componentone.com

    7. ==== Announcements ====

    SQL Server Magazine Monthly Online Pass--Only $5.95 per month!
    &nbsp &nbsp &nbsp Includes instant online access to every article ever written in SQL Server Magazine and the latest digital issue. Order now at
    &nbsp &nbsp &nbsp https://store.pentontech.com/index.cfm?s=1&promocode=eu2166um

    June Special--Save $100 On the Exchange & Outlook Administrator Newsletter
    &nbsp &nbsp &nbsp 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
    &nbsp &nbsp &nbsp https://store.pentontech.com/index.cfm?s=1&promocode=eu2366ue


    ==== 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.
    &nbsp &nbsp &nbsp https://store.pentontech.com/index.cfm?s=9&cid=51&promotionid=1491

    Manage Your Account You are subscribed as %%$email%%. To unsubscribe from this email newsletter, click here
    &nbsp &nbsp &nbsp http://lists.sqlmag.com/u?id=%%SUBSCRIBER_ID_TAG%%

    To manage your email account, simply log on to our Email Preference Center.
    &nbsp &nbsp &nbsp http://www.sqlmag.com/email

    View the SQL Server Magazine Privacy Policy.
    &nbsp &nbsp &nbsp http://www.sqlmag.com/aboutus/index.cfm?action=privacy

    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.



  • TAGS: SQL Server
    Hide comments


    • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

    Plain text

    • No HTML tags allowed.
    • Web page addresses and e-mail addresses turn into links automatically.
    • Lines and paragraphs break automatically.