Backward compatibility is a key function that most users want and expect in today's upgrade products. Is Microsoft listening to its users? Find out what you should expect in terms of backward compatibility if a Vista upgrade is on your 2007 agenda.
Subscribe to SQL Server Magazine and make sure you add sql_express@lists.sqlmag.com to your list of allowed senders and contacts:
https://store.pentontech.com/index.cfm?s=9&cid=51&promotionid=1491
Get $40 off SQL Server Magazine ========== Sponsor: AppDev ====================================
NEW! Free Training Download or CD--SQL Server 2005 Reporting Services
Get 3 FREE hours of award-winning AppDev training from our latest course--"SQL Server 2005 Reporting Services." You'll receive step-by-step instruction by industry expert Paul Litwin, plus printable courseware--a $115 value.
Get your free download or CD now
http://www.appdev.com/promo/RN00488
1. ======= Commentary ==========================================
The Losers in the Race to Vista
by Michael Otey, mikeo@windowsitpro.com
A scenario that seems to be repeating more often these days is that Microsoft isn't providing backward compatibility as a function in some of its new products. Case in point: Windows Vista isn't compatible with Microsoft SQL Server Desktop Engine (MSDE) as well as some other Microsoft applications. MSDE incompatibility will certainly be a problem for customers, but evidently Microsoft didn't consider it a big enough problem to assign resources to work on fixing the incompatibility. From a Microsoft-centric viewpoint, this incompatibility problem might even be a win-win situation. By cutting functionality from a product's design, Microsoft can get that product out the door more quickly and "encourage" customers to upgrade all at the same time.
I think customers will take offense to this tactic because at the very least, it amounts to misrepresentation. Microsoft never fails to say that it has the tightest integration with its own products, and the company supposedly is interested in listening to its customers and its community. Clearly, this incompatibility strategy isn't in the customer's best interest because it really forces customers to upgrade to newer releases. Don’t get me wrong--I'm not a big fan of MSDE, and I would always recommend using SQL Server 2005 Express rather than MSDE for any situation. ISV's will probably be affected by this the most because many third-party applications use MSDE and will need to be changed before Vista is released. However they're probably aware of the situation. The really unfortunate thing is the number of customers who aren't aware that MSDE won't run under Vista and will be caught by surprise when they upgrade to Vista.
MSDE isn't the only loser in the move to Vista. Microsoft's flagship development product, Visual Studio 2005, won't be fully compatible with Vista until after the release of Vista Service Pack 1 (SP1), which is still in beta. Visual Studio 2005 runs under Vista, but you'll discover a few problems with Vista's User Account Control (UAC). Earlier Visual Studio versions, such as Visual Studio 2003 and Visual Studio.NET, won't be supported by Vista at all. Although developers tend to move forward faster than most users, there are still a significant number of organizations that currently use Visual Studio 6, let alone Visual Studio 2003. Upgrading from these products is a bit tougher than the MSDE upgrade. Upgrading from MSDE to SQL Server 2005 Express will require time and effort, but at least this upgrade won't require additional expense because you can download both products from the Microsoft Web site for free. Not so with Visual Studio 2005. Upgrading from Visual Studio 2003 to Visual Studio 2005 Professional will set you back $549. And that's per seat. (Although you can get lower prices from online retailers. For example, Amazon.com sells Visual Studio 2005 for $488.61.)
Even SQL Server 2005 Express, as new as it is, won't be immune to Vista update problems. Before you attempt a Vista upgrade on any system running SQL Server 2005 Express, you'll need to upgrade to SQL Server 2005 Express SP2 (which isn’t available yet).
Backward compatibility--at least with previous versions of Microsoft's products--isn't a nicety but a necessity. Omitting this type of compatibility is essentially a failure both in engineering and customer relations. If you're considering the upgrade to Vista do your homework and make sure that the applications you're using are going to work with Vista. In other words, look before you leap.
********** Double-Take Software ********************************
Enhancing SQL Protection: A Case for Asynchronous Replication
Built-in SQL Server data protection features aren't enough. Learn to use an automated data protection solution that provides 24x7 availability to meet today's critical business demands.
http://www.sqlmag.com/go/whitepapers/doubletake/sqlprotection/?code=SQLExpMid1016
2. ====== Features ============================
Jump Start: Querying Database Tables and Views
by Michael Otey
Sometimes your code needs to do more than just query data from the database. For example, you might want to query the structure and objects in the database. For this type of query, a basic approach is to query the available tables and views in your database. For example, to list the tables in the AdventureWorks database, use SQL Server Query Editor to execute the following code:
USE adventureworks
GO
SELECT * FROM sys.tables
GO
Sys.tables is a system database that stores the names of all the tables in the current database. Likewise, if you want a list of all the views in a database, use the sys.views system table by executing the following code:
USE adventureworks
GO
SELECT * FROM sys.views
GO
********* Watch: Polyserve ***************
How to Build a Superior Windows File Serving Environment
As the number of file servers and associated storage has grown rapidly, IT organizations have faced multiple challenges related to manageability, scalability, fit within existing infrastructure, availability, utilization and cost. In this free white paper, get the tools you need to provide a scalable, highly available CIFS file service using inexpensive, industry-standard servers that can be added incrementally as demands require, while retaining the management simplicity of a single server and a single pool of exported file systems.
http://www.windowsitpro.com/whitepapers/polyserve/fileserving/index.cfm?code=SQLExpWatch1016
*************************************************
Check It Out: MSDE and Vista
by Michael Otey, mikeo@windowsitpro.com
If you're currently running Microsoft SQL Server Desktop Engine (MSDE) for some of your applications and you're considering switching to Windows Vista, an upgrade for MSDE is definitely in your future. But before you upgrade, you should definitely check out the Microsoft white paper "Upgrading from MSDE 2000 to SQL Server 2005 Express Edition" at
https://www.microsoft.com/sql/editions/express/upgrade.mspx
********* HOT SPOT: Intercerve ********************************
sqlSentry’s advanced monitoring and reporting delivers far-reaching insight into schedule-related performance issues, enabling you to optimize even the busiest schedule. Easily track events running across multiple servers--Replication, DTS, etc. Download a free trial now!
http://www.sqlsentry.net/optimizing-sql-server-productivity-try-it-now5.asp?ad=SSMagUp_2006_10_16_B
3. ==== Resources and Events ===========
SQL Server Magazine Connections Conference
Come learn about SQL Server 2005, WinFX, Visual Studio 2005, ASP.NET 2.0 and Atlas, and more November 6-9, 2006, at SQL Server Magazine Connections in Las Vegas. The conference will feature exciting Microsoft announcements that no one should miss! There's no better conference value in the USA this fall.
http://www.devconnections.com
Email Discovery and Compliance
You know you need to manage your email data; how do you do it? What steps are you taking? What additional measures should you implement? What shouldn't you do? Get answers to these questions and get control of your vital messaging data. Download the free eBook today!
http://www.windowsitpro.com/go/ebooks/ilumin/discovery/?code=1018emailannc
Creating the Business Case for Disaster Recovery Planning and Budgeting
Can disaster recovery planning create real value for your business beyond mere survival? Justify your investments in DR planning, and get real answers to your questions about how DR planning and implementation affect the financial performance of your organization. Make cost-effective decisions to positively impact your bottom line! Live Event: Tuesday, November 14.
http://www.windowsitpro.com/go/seminars/xosoft/drplanning/?partnerref=1010emailannc
Managing Your Cross-Platform Data
Join experts Douglas McDowell from Solid Quality Learning and Andrew Sisson from Scalability Experts, as well as Intel insiders and other database professionals, to learn the latest about SQL Server and Oracle database mirroring, BI, 64-bit database computing, and high availability. Coming to cities across the US this fall. Visit
http://www.windowsitpro.com/roadshows/sqloracle/?code=1018emailannc
Get the Most from Your Upgrade
Streamline and automate upgrades to SQL Server 2005 and manage multiple databases in less time. Leverage the data management, business intelligence, and performance improvements that you receive with an upgrade to SQL Server 2005, and unlock the full potential of your servers. Live Event: Thursday, November 2
http://www.sqlmag.com/go/seminars/polyserve/upgrade/?partnerref=1010emailannc
4. ==== Featured White Paper ============
Comparing Approaches for Desktop Software Lockdown
Prevent installation and execution of unauthorized software on the computers on your network. Download this free white paper today for a comparison of different techniques for detecting and preventing unauthorized code. Protect yourself against emerging risks today!
http://www.windowsitpro.com/go/whitepapers/bit9/lockdown/?code=1018emailannc
Special Offer: Download any white paper from Windows IT Pro before October 31 and enter to win a Casio Exilim Card Camera! The more you download, the more chances to win! Visit http://www.windowsitpro.com/whitepapers for a full listing of white papers and contest rules.
===================================
WANTED: Your reviews of products you've tested and used in production. Send your experiences and ratings of products to "whatshot@windowsitpro.com" and get a Best Buy gift certificate.
5. New Books for SQL Server Professionals
by Blake Eno, beno@windowsitpro.com
Addison-Wesley Professional released three new SQL Server books. "Practical Business Intelligence with SQL Server 2005" offers insight into BI systems design and step-by-step best practices for implementing, deploying, and managing BI systems, and is priced at $49.99. "Introduction to SQL: Mastering the Relational Database Language, Fourth Edition" illustrates each aspect of SQL with practical examples and exercises in each chapter to make sure you grasp all the concepts. This book is priced at $49.99. "Inside SQL Server 2005 Tools" covers several components such as Database Engine, Analysis Services, Reporting Services Integration Services, and Notification Services. This book is priced at $59.99.
http://www.awprofessional.com
6. ==== Exclusive Email Offers ====
Monthly Online Pass--only $5.95 per month!
Includes instant online access to every article ever written in SQL Server Magazine, plus the latest digital issue. Sign up now:
https://store.pentontech.com/index.cfm?s=9&promocode=eu216Aum
Get $40 off SQL Server Magazine
Subscribe to SQL Server Magazine today and SAVE up to $40! Along with your 12 issues, you'll get FREE access to the entire SQL Server Magazine online article archive, which houses more than 2,300 helpful SQL Server articles. This is a limited-time offer, so order now:
https://store.pentontech.com/index.cfm?s=9&promocode=eu216Aus
==== Contact Us ====
About the newsletter--letters@sqlmag.com
About the commentary--mikeo@teca.com
About technical questions-- http://sqlforums.windowsitpro.com/web/forum/default.aspx?forumid=10
About product news--products@sqlmag.com
About your subscription--sqlupdate@sqlmag.com
About sponsoring an issue of SQL Server Express UPDATE--Richard Resnick, rresnick@sqlmag.com
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.
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
http://lists.sqlmag.com/u?id=%%SUBSCRIBER_ID_TAG%%
To manage your email account, simply log on to our Email Preference Center.
http://www.sqlmag.com/email
View the SQL Server Magazine Privacy Policy.
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.
End of Article
