October 16, 2006

Commentary

NEW! Free Training Download or CD--SQL Server 2005 Reporting Services
&nbsp &nbsp &nbsp 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.
&nbsp &nbsp &nbsp Get your free download or CD now
&nbsp &nbsp &nbsp http://www.appdev.com/promo/RN00488

The Losers in the Race to Vista
&nbsp &nbsp &nbsp 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
&nbsp &nbsp &nbsp 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.
&nbsp &nbsp &nbsp http://www.sqlmag.com/go/whitepapers/doubletake/sqlprotection/?code=SQLExpMid1016

Jump Start: Querying Database Tables and Views
&nbsp &nbsp &nbsp 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
&nbsp &nbsp &nbsp 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.
&nbsp &nbsp &nbsp http://www.windowsitpro.com/whitepapers/polyserve/fileserving/index.cfm?code=SQLExpWatch1016

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

Check It Out: MSDE and Vista
&nbsp &nbsp &nbsp 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
&nbsp &nbsp &nbsp 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!
&nbsp &nbsp &nbsp http://www.sqlsentry.net/optimizing-sql-server-productivity-try-it-now5.asp?ad=SSMagUp_2006_10_16_B

SQL Server Magazine Connections Conference
&nbsp &nbsp &nbsp 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.
&nbsp &nbsp &nbsp http://www.devconnections.com

Email Discovery and Compliance
&nbsp &nbsp &nbsp 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!
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/ebooks/ilumin/discovery/?code=1018emailannc

Creating the Business Case for Disaster Recovery Planning and Budgeting
&nbsp &nbsp &nbsp 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.
&nbsp &nbsp &nbsp http://www.windowsitpro.com/go/seminars/xosoft/drplanning/?partnerref=1010emailannc

Managing Your Cross-Platform Data
&nbsp &nbsp &nbsp 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
&nbsp &nbsp &nbsp http://www.windowsitpro.com/roadshows/sqloracle/?code=1018emailannc

Get the Most from Your Upgrade
&nbsp &nbsp &nbsp 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
&nbsp &nbsp &nbsp http://www.sqlmag.com/go/seminars/polyserve/upgrade/?partnerref=1010emailannc

Comparing Approaches for Desktop Software Lockdown
&nbsp &nbsp &nbsp 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!
&nbsp &nbsp &nbsp 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.