SQL Server Magazine UPDATE, July 6, 2006--Supporting the Unified Communications Revolution

SQL Server Magazine UPDATE, July 6, 2006--Supporting the Unified Communications Revolution

In This Issue:
As modern communication technologies push us 10 steps forward and 9 steps back, can Microsoft create a magic pill to manage those technologies? And can we find an effective storage solution to support the coming revolution?

New Instant Poll: SQL Server Everywhere CTP
"Will you download the SQL Server Everywhere CTP?" Go to the SQL Server Magazine home page ( http://www.sqlmag.com ) and submit your vote for:

  • Yes, we support mobile users with SQL Server Mobile and want to upgrade.
  • Yes, we support mobile users, and we are going to start using SQL Server Everywhere.
  • Yes, we want to evaluate SQL Server Everywhere.
  • No, we support mobile users but won't use SQL Server Everywhere.
  • No, we don't support mobile users.

To ensure that future email messages you receive from SQL Server Magazine 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 free email newsletter is supported by the following advertisers. Please take a moment to visit these sites and show your support for SQL Server Magazine UPDATE.





July 6, 2006

1. Perspectives

  • Supporting the Unified Communications Revolution

2. SQL Server Watch

  • Get Guidance for SQL Server Everywhere CTP
  • Product Watch: myLittleTools.net and sqlSentry

3. Hot Articles

  • TIP: Using NewSequentialID Instead of NewID
  • SELECT TOP(X): Query Editor Shortcuts
  • In a Nutshell: It Depends On How You Define "Whining"

4. Events and Resources

  • Secure, Remote Access to Corporate Applications
  • Policies to Protect Your Assets and Data
  • Gain Control of Messaging Data
  • State-of-the-Art Scanning Engine

5. Featured White Paper

  • Achieve Compliance While Managing Threats

6. Announcements

  • Discounted Offer for the SQL Server Magazine Master CD
  • Get $80 Off the Exchange & Outlook Administrator Newsletter

7. Web Community

  • http://www.sqlmag.com

Sponsor: EMC
Get the essential tools you need to manage a SQL Server 2005 system, SQL Server security essentials, and database backup and recovery. Download this exclusive guide today!

1. Perspectives

Supporting the Unified Communications Revolution
by Brian Moran, [email protected]

In this column, I typically present my commentary and opinions about SQL Server and Microsoft data management in general. But lately, I've been spending a bit of time discussing Microsoft Office, spreadmart, and related topics that are clearly connected to data management, but aren't my usual meat-and-potatoes relational database discussions. I promise to get back to my "real" database roots soon, but this week, I can't help but opine about the intriguing ideas and products that are part of Microsoft's recently unveiled Unified Communications road map. As part of my discussion of Unified Communications, I also want to examine Microsoft's revised plans for WinFS, the long-awaited next generation Windows File System, which relies on core aspects of SQL Server. So in way, maybe this week's article really is about SQL Server.

First, let's take a look at the thoughts of Bill Gates, which he released to customers in a recent executive email titled "The Unified Communications Revolution" ( http://www.microsoft.com/mscorp/execmail ).

"The irony is that rather than making it easier to reach people, the proliferation of disconnected communications devices often makes it more difficult and more time consuming. And in an age when business success increasingly depends on how quickly people can share information, this is a critical issue.

In the coming years, unified communications technologies will eliminate the barriers between the communications modes—email, voice, Web conferencing and more—that we use every day. They will enable us to close the gap between the devices we use to contact people when we need information and the applications and business processes where we use that information. The impact on productivity, creativity and collaboration will be profound."

You really should read the entire interesting, thought-provoking message. Of course, your first reaction might be like mine, along the lines of, "Wow, sounds like a great idea. But I'm not sure how easy or practical solving the problem of disparate communications will be." But heck, people used to laugh at the idea of a PC on every desktop. As modern communication technologies push us 10 steps forward and 9 steps back, maybe Microsoft can create a magic pill to manage those technologies. I also suggest you read the Microsoft Press Pass article and product road map at http://www.microsoft.com/presspass/press/2006/jun06/06-25UCGRoadmapPR.mspx .

How does WinFS tie in? Well, it doesn't take a rocket scientist (or a DBA) to figure out that the communications strategy that Microsoft is outlining will create the potential need for vast, almost unimaginable amounts of storage. Much of the metadata could lend itself to traditional database solutions, but much of the unstructured voice and communications data will not. WinFS sure would be a clean way to think about solving the problem.

Alas, the further delays and repositioning of WinFS cause me to wonder whether Microsoft will ever get this technology to market in a timely manner. Microsoft seems to be positioning Microsoft Exchange and new technologies as the core data-storage engines behind the Unified Communications roadmap. WinFS might have been a great solution. But as you might already know, Microsoft recently announced that WinFS would be delayed again and will not ship as a standalone offering. Plans for a Beta 2 of WinFS have been cancelled. Microsoft is positioning this cancellation as "no big thing" and says that the more mature parts of WinFS are simply being added to the Katmai CTP (no announced dates for that yet). But the fact remains that this delay is a major setback for WinFS—and for the entire concept of creating file systems integrated with Windows that rely on core aspects of SQL Server.

For a more detailed Microsoft-based perspective about what the WinFS changes mean now and in the future, see Quentin Clark's blog at http://blogs.msdn.com/winfs/archive/2006/06/23/644706.aspx .

Sponsor: AppDev
FREE SQL 2005 or VS 2005 Training CD-ROM!

Start learning SQL 2005 or VS 2005 today with cutting edge training from AppDev. Get a FREE training CD taken directly from your choice of courses (a $115 value!). Click the link below for your FREE SQL 2005 or VS 2005 training CD.

2. SQL Server Watch

Get Guidance for SQL Server Everywhere CTP
On June 12, Microsoft released the Community Technology Preview (CTP) of SQL Server 2005 Everywhere Edition. SQL Server Everywhere is the new name of SQL Server 2005 Mobile Edition, and the CTP includes enhancements such as the elimination of the desktop restriction that exists in SQL Server Mobile. SQL Server Mobile is supported on devices and Tablet PCs and is partially supported on desktop computers. But on desktop computers, either Visual Studio 2005 or SQL Server 2005 must be installed to use the mobile edition. With SQL Server Everywhere, the restriction is removed so that users can develop and deploy applications independent of SQL Server 2005 and Visual Studio 2005. You can read complete details and download the CTP at

Product Watch
by Blake Eno, [email protected]

Web-Based Administration for SQL Server 2005
myLittleTools.net announced myLittleAdmin for SQL Server 2005, a Web-based management tool that lets you manage most objects of your databases and servers, including new objects such as snapshots, schemas, and credentials. The product's datagrid lets you edit and delete records while browsing your data, which can later be exported to XML or comma-separated value (CSV) formats. MyLittleAdmin also features helpful tools and wizards, including a New Query tool, Backup and Restore wizards, and a Generate INSERT wizard. A live demo is available at myLittleTools.net's Web site. Pricing for myLittleAdmin for SQL Server 2005 starts at $590 for a single-user license. For more information, contact myLittleTools.net at 719-576-0123 or 800-999-2734.

SQL Server Management for SMBs
sqlSentry announced that the core functionality of its Enterprise Edition is now available for small-to-midsized businesses (SMBs) in sqlSentry Standard Edition. The product lets you manage and optimize your SQL Server environments at a lower price point than the enterprise edition. Available features include visual scheduling with drag-and-drop support, comprehensive notifications, and schedule-performance monitoring for managing your schedule events. sqlSentry Standard Edition lets you monitor any number of SQL Servers and Windows Task Schedulers without installing or maintaining agents on each server. For more information, contact sqlSentry at 704-895-6241.

Sponsor: Innovartis
Control Your SQL Server Code with DB Ghost

With DB Ghost Change Management Components—Scripter: Scripts all schema objects AND static data. Builder: Builds DBs from object scripts handling ALL dependencies. You build the rest of your code regularly, why not your database? Schema Compare & Data Compare: Compare and synch schema and data. Builds a delta script that is guaranteed to work with no manual intervention! NEW PRODUCTS: Packager & Packager Plus. Download our 14-day Free Trial:

3. Hot Articles

TIP: Using NewSequentialID Instead of NewID
by Brian Moran, [email protected]

SQL Server 2005 provides a new function called NewSequentialID that's similar to NewID(), a function that originated in SQL Server 2000 and is supported in SQL Server 2005. Both functions return a value of data type uniqueidentifier. Learn the benefits of each function—and when to use which one—by reading the complete tip at

SELECT TOP(X): Query Editor Shortcuts
Query Editor is a new SQL Server 2005 management tool. Although the new tool uses many familiar Query Analyzer keyboard shortcuts, you'll find new ones as well. In his July SELECT TOP(X) column "Query Editor Shortcuts," Michael Otey gives you 10 of his favorite new shortcuts. Read this article today and post your comments at

In a Nutshell: It Depends On How You Define "Whining"
In this week's blog, Kevin Kline notices that many respected voices in the industry feel that Microsoft is trying to get us to drink from a firehose these days. It wasn't very long ago that SQL Server didn't have very many "moving parts" to master. But nowadays it's hard to master all of the new database-related technologies. What's the right balance between looking ahead and staying fresh in your skills versus becoming overloaded? Let Kevin know your strategy and your opinion today at

4. Events and Resources

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. On-demand Web seminar.

Find out what policies help or hurt in protecting your company's assets and data. View this on-demand seminar today!

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.

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 you against. Download your free 30-day trial of CounterSpy Enterprise today!

See the complete Windows IT Pro Network guide to Web and live events.

5. Featured White Paper

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 the white paper today and secure the confidentiality, availability and integrity of your corporate information!

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.

6. Announcements

Discounted Offer for the SQL Server Magazine Master CD
Save 50% 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%!

Get $80 Off 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!


7. Web Community


Hot Threads


New Instant Poll

In a Nutshell Blog:

Contact Us

SQL Server Magazine 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!

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.

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.