UltraBac Software announces the release with totally new architecture leveraging DCOM technology. This allows for a more distributed application and better manageability. UB7.0 introduces Set-Level Failover for more reliable Active Cluster backup and Client Side Compression for faster backups with reduced network overhead. UB7.0 writes data to any type of local or remote media, including disk, tape, CD-RW and optical. UltraBac's Image-Based Disaster Recovery software is now GUI based and backs up all hidden and active partition types including 'extended' and LIVE OPERATING SYSTEM partitions. To learn more about our Windows 2000 Advanced Server Certified products or download a free live trial visithttp://www.ultrabac.com/default.asp?src=SQLUpdateApr2502&tgt=./

1. COMMENTARY

I'm embarrassed to admit that I own a Pocket PC but rarely use it. I hang my head in shame at conferences when true uber-geeks whip out their expandable keyboards like the gunslingers of yesteryear and start typing away, while I pull out paper and pen to take notes. Oh, the shame! I'm not yet a member of the handheld borg, but I'm smart enough to recognize that resistance is futile. I have no doubt that mobile computing devices will become pervasive in the same way that ATM cards penetrated our lives a decade ago and mobile phones are changing our communication habits today. It's simply a question of when, not if.

I'm not trying to make an evangelical argument about the future of Palm and Pocket PC mobile devices. Microsoft, Palm, and other to-be-announced vendors will all play significant roles in the mobile computing market. But I do want to call your attention to Microsoft's recent announcement of the beta program for SQL Server 2000 Windows CE Edition 2.0 because I think this program will accelerate the use of Pocket PCs and other mobile devices, making them a pervasive part of SQL Server administrators' lives.

I don't use my Pocket PC for several reasons, one of the biggest of which is the lack of a killer application I just can't live without. A killer app will likely arise as more people start writing applications for mobile devices, which would happen if more people used their Pocket PCs, which would happen if they had a killer app—a classic chicken-or-the-egg scenario.

Microsoft representatives told me some exciting news about Microsoft's new .NET Compact Framework and SQL Server CE 2.0 that will encourage the development of killer apps for mobile devices. Visual Studio .NET and the .NET Compact Framework will make building applications for a mobile device easier than ever. The .NET Compact Framework, a subset of the full .NET Framework that's intended for mobile devices, will let developers build .NET applications with Visual Studio .NET and seamlessly deploy the applications on a mobile device.

Almost any application needs a data store, and SQL Server CE 2.0 offers a platform that makes deploying mobile versions of SQL Server easy. SQL Server CE 2.0 will support a new .NET managed provider for SQL Server CE that developers can use to write one code base, then port the application to a mobile device. In addition to the new managed provider, Microsoft representatives say that SQL Server CE 2.0 will offer several engine-level enhancements, including more advanced support for parameterized queries and intrinsic functions, and will increase the number of indexes that a table allows.

Aside from the business productivity benefits it brings, mobile database computing is an interesting option to consider if you're a SQL Server professional looking for a high-growth area to specialize in. If you're interested in using SQL Server CE 2.0 to develop applications, consider nominating yourself for the SQL Server CE 2.0 beta program. Spots in the beta program are limited; you can apply for the program at http://www.microsoft.com/sql/evaluation/betanominations.asp

This program addresses the SQL Server CE 2.0 beta for the eMbedded Visual Tools, which include eMbedded Visual Basic 3.0, eMbedded Visual C++ 3.0, and eMbedded Visual C++ 4.0. The beta program includes the necessary server-side components to do synchronization with both SQL Server 2000 and SQL Server 7.0. Support for Smart Device Extensions and the .NET Compact Framework will be available to beta-program participants from a separate public beta forum at the MSDN Web site.

If you're a technical developer or IT professional dedicated to developing, maintaining, and managing cutting-edge solutions, the hands-on technical training you will get at Microsoft TechEd 2002 Europe is definitely for you. Don't miss out on the early-bird discount for Microsoft's premier technical education event by registering now! For more detailed information, please visit http://www.microsoft.com/europe/teched/win2k

4. RESOURCES

WHAT'S NEW IN SQL SERVER MAGAZINE: "LITTLE" DESIGN MISTAKES

Thorough testing is a prerequisite to a successful database rollout. Michael Otey, senior technical editor of SQL Server Magazine, provides tips for avoiding database application rollout problems in "'Little' Design Mistakes," which appears in the May 2002 issue of SQL Server Magazine and is available online at the following URL: http://www.sqlmag.com/articles/index.cfm?articleid=24561

HOT THREAD: TROUBLESHOOTING ADO BEHAVIOR

Cameron is using ADO and SQLOLEDB to connect to a SQL Server database. He has discovered that ADO is replicating some simple SELECT queries and wrapping them in SETFMTONLY ON and SETFMTONLY OFF statements, resulting in excessive queries to the server, which decreases performance. Offer your advice and read other users' suggestions on the SQL Server Magazine forums at the following URL: http://www.sqlmag.com/forums/messageview.cfm?catid=5&threadid=5806

TIP: PREVENT ESCALATING LOCKS

(contributed by the SQL Server MVPs)

Q. How can I prevent SQL Server from escalating locks?

A. SQL Server uses locks to maintain transactional integrity and consistency within a database. SQL Server supports several types of locks of differing granularities. For example, a row lock is a fine-grained lock; a page lock is a coarser lock. SQL Server escalates locks from a large number of fine-grained locks to fewer coarse-grained locks, which reduces system overhead but might result in unforeseen blocking within an application.

Escalation occurs automatically when the number of locks exceeds the lock-escalation threshold. This threshold is an internal setting designed to protect system resources. No configuration option exists for this threshold, but you can disable lock escalation if you start SQL Server with the undocumented trace flag 1211. Be warned that if you disable lock escalation, the responsibility for managing the system resources is on you. If SQL Server runs out of memory, for example, the system can crash. A better approach is to execute shorter transactions if row-level locks are absolutely needed.

Send your technical questions to questions@sqlmag.com.

5. NEW AND IMPROVED

(contributed by Carolyn Mascarenas, products@sqlmag.com)

COMPRESS AND ENCRYPT DATABASE BACKUPS

DBAssociates released SQLLiteSpeed, a backup and restore utility that can encrypt and compress data during backup. SQLLiteSpeed features 128-bit encryption and full password protection. The product lets you restrict database restores to a specific machine or operator. Contact DBAssociates at info@dbassociates.com.au. http://www.dbassociates.com.au

EDIT AND MANAGE DATA

TheDevShop released DbQwikEdit 2.1, a program that connects to any database through ADO and ODBC to let you edit and manage data. DbQwikEdit performs data editing, data exporting, and data migration. The program lets you move data between tables, merge database tables, and perform table synchronization. DbQwikEdit Pro costs $79, and DbQwikEdit Lite is $39. Contact TheDevShop at sales@thedevshop.com. http://www.dbqwikedit.com

SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine completely devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today.http://www.sqlmag.com/sub.cfm?code=ssei211x1y

Receive the latest information about the Windows and .NET topics of your choice. Subscribe to our other FREE email newsletters.http://www.winnetmag.net/email

From the Blogs

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....More