SQL Server Express UPDATE--July 3, 2006:SQL Server 2005 Everywhere Edition CTP

2. Check It Out

3. From the Community

4. Events and Resources

5. Featured White Paper

6. SQL Server Express Product

7. Announcements

==== Sponsor: AVIcode ====
80 percent of all software released into production will fail because of quality problems, but monitoring applications proactively throughout their lifecycle will improve quality and reliability. Learn about the two fundamental categories of application errors and methods for pinpointing quickly the root cause of functional errors. Download the whitepaper today!
&nbsp &nbsp &nbsp http://www.sqlmag.com/go/whitepapers/avicode/nettroubleshooting/?code=SQLExpTop0703

1. ==== Commentary ====

Introducing SQL Server 2005 Everywhere Edition
&nbsp &nbsp &nbsp by Michael Otey

In June, Microsoft added a new member to the SQL Server family: SQL Server 2005 Everywhere Edition. As with SQL Server 2005 Express, SQL Server Everywhere is a free relational database that's limited to 4GB and designed for small-scale database applications. You can use the ADO.NET programming model to access both databases and use SQL Server Management Studio (SSMS) to manage them. Because SQL Server Express and SQL Server Everywhere are so similar, you might have a difficult time deciding which product to choose. So let's take a look at some of the differences between the products.

The primary difference between SQL Server Express and SQL Server Everywhere is that SQL Server Express is a multiuser database server that runs as a system service--meaning it's not bound to any specific application. SQL Server Express runs outside the application and can provide database services to multiple local or remote applications. In contrast, SQL Server Everywhere is an in-process database that provides relational-database support for the application it's embedded in. In other words, you use SQL Server Everywhere within an application to provide database functionality to only that application.

Another difference lies in the products' heritage. SQL Server Express uses the same core database engine that SQL Server 2005 Enterprise, Workgroup, and Standard Editions use. That's not the case for SQL Server Everywhere; it's based on SQL Server 2005 Mobile Edition. SQL Server Everywhere has a different core database engine, a smaller footprint than SQL Server Express, and is designed to run on mobile devices. It runs as a mobile or desktop application and lacks many of the more powerful database features in SQL Server Express. For example, although SQL Server Everywhere does support referential integrity (by using cascading deletes and updates) and the ability to commit roll-back transactions, it doesn't support more advanced database features such as stored procedures, the XML data type, or CLR integration. For building distributed mobile applications, SQL Server Everywhere, like SQL Server Express, supports data exchange with other members of the SQL Server family by using merge replication.

So, when should you use SQL Server Everywhere and when should you use SQL Server Express? SQL Server Everywhere is the clear choice when you need database support for mobile-device applications, or for single-user applications that require only basic database functionality. SQL Server Express is a better choice for multiuser applications or for applications that need advanced database features such as stored procedures and XML support. You can read more information about the differences between SQL Server Everywhere and SQL Server Express in the Microsoft article "SQL Server 2005 Everywhere Edition" at: http://www.microsoft.com/sql/ctp_sqleverywhere.mspx

Read more background information about SQL Server Everywhere's predecessor, SQL Server Mobile, at
http://www.microsoft.com/sql/editions/sqlmobile/default.mspx.

****** Sponsor: Double-Take Software ******
Learn what every IT Manager should know about protecting SQL Server and identify the costs, risks, and advantages of each. Make sure that your disaster recovery and high-availability solutions match your business needs.
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/whitepapers/doubletake/sqlserver/?code=SQLExpMid0703

******************************

2. ==== Check It Out ====

SQL Server 2005 Everywhere Edition CTP
&nbsp &nbsp &nbsp by Michael Otey

If you're interested in developing mobile and desktop applications that use an embedded database with a very small footprint, you might want to check Microsoft's newest release in the SQL Server family: SQL Server 2005 Everywhere Edition. You can download the Community Technology Preview (CTP) of SQL Server Everywhere free from the Microsoft site at:
&nbsp &nbsp &nbsp http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3

***** HOT SPOT: Neverfail *****

Want the convenience of a server cluster without the expense? Learn about server cluster alternatives that provide high availability, preventative maintenance, and fallover capabilities at pricing that fits your budget.
&nbsp &nbsp &nbsp http://www.sqlmag.com/go//whitepaper/neverfail/sqlclustering/?code=SQLExpHot0703

************************************

3. ==== From the Community ====

One of our readers noticed an error in the code in a recent Jump Start column ("Using Views," June 5, 2006,
http://www.sqlmag.com/Article/ArticleID/50495/sql_server_50495.html ). Here's the reader's note:

Hello Michael. In your Jump Start column titled "Using Views," you included code. When I ran the code, it appears to drop the Media table before trying to create a view on that table. Did you intend to check for the existence of the view rather than the table, then drop the view?
- John Kelso

John, you're absolutely right, and thanks for pointing it out. Here’s the corrected code listing.

IF EXISTS (SELECT name FROM sysobjects
&nbsp &nbsp &nbsp WHERE name = 'vwMedia' AND type = 'V')
&nbsp &nbsp &nbsp &nbsp &nbsp &nbsp DROP VIEW vwMedia
GO

CREATE VIEW vwMedia
AS
SELECT MediaID, MediaType, MediaTitle
FROM Media

First, this code queries the sysobjects system table to check for the existence of the view named vwMedia. If the vwMedia view exists, SQL Server executes the DROP VIEW statement to delete the view. This existence-check and drop-statement combination lets you rerun the code to easily recreate the view. Otherwise, running the CREATE VIEW statement for an existing view would result in an error. Finally, the CREATE VIEW statement creates the vwMedia view by using only the MediaID, MediaType, and MediaTitle columns from the base Media table.
- Michael Otey

4. ==== Events and Resources ====

Is Your Antivirus Effective in Detecting Spyware?
Are you protected company-wide against spyware, keyloggers, adware, and backdoor Trojans? Test the state-of-the-art scanning engine that uses threat signatures from multiple sources to track down the culprits that antivirus solutions alone can’t protect against. Download your free 30-day trial of CounterSpy Enterprise today!
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/download/sunbelt/counterspy/?code=0705emailannc

Simplify Management and Boost Availability
Learn how a database utility for SQL Server can lower operational costs, simplify management, and increase the availability of your SQL Server deployment. Live event: Tuesday, June 20
&nbsp &nbsp &nbsp http://www.sqlmag.com/go/seminar/polyserve/availability/?partnerref=0626emailannc

Keeping Remote and Mobile Users Fully Functional
Take an up-to-date look at secure, remote access to corporate applications and stay ahead of the curve when making decisions about near- and long-term IT infrastructure. Watch this on-demand Web seminar.
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/seminars/whale/vpn/?partnerref=0705emailannc

How to Evaluate and Choose a Message Archiving Solution
Gain control of your messaging data--and make your job easier--with these step-by-step instructions for complying with the law and ensuring your systems are working properly.
&nbsp &nbsp &nbsp http://www.windowsitpro.com/toolkits/ilumin/index.cfm?code=0705emailannc

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

Best Practices for Outward Bound Internet Content Protection Achieve compliance in today's complex regulatory environment while managing threats to the inward- and outward-bound communications vital to your business. Adopt a best-practices approach, such as the one outlined in the international information security standard ISO/IEC 17799:2005. Download this white paper today and secure the confidentiality, availability, and integrity of your corporate information!
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/whitepapers/surfcontrol/securitystandard/?code=0705featwp

===================================

6. ==== SQL Server Express Product ====

SQL Server Express Management Solution
&nbsp &nbsp &nbsp by Blake Eno

Vale Software's SQL Manager is a complete management solution for SQL Server 2005 Express Edition. The product allows you to add, edit, and delete databases, tables, views, roles, rules, stored procedures, functions, and data types. In addition, you can set primary keys, triggers, indexes, and constraints. Additional features include job scheduling management and database backup and restore capabilities. For a list of more features or additional information, contact Vale Software at 866-775-8253, [email protected], or [email protected]
&nbsp &nbsp &nbsp http://www.sqlexpresstools.com

7. ==== Announcements ====

Discounted Offer for the SQL Server Magazine Master CD Save 50 percent on the SQL Server Magazine Master CD! Order now and get portable, high-speed access to the entire SQL Server Magazine article database on CD--a searchable library that includes every issue ever published. The newest issue also includes BONUS SQL Server 2005 Tips. Subscribe now and save 50%:
&nbsp &nbsp &nbsp https://store.pentontech.com/index.cfm?s=9&promocode=eu2867uc

Save $80 On the Exchange & Outlook Administrator Newsletter Get endless solutions to help you migrate, optimize, administer, back up, recover, and secure your messaging environment. Subscribe to the Exchange & Outlook Administrator newsletter today and save $80:
&nbsp &nbsp &nbsp https://store.pentontech.com/index.cfm?s=1&promocode=eu2367ue

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