Our domain name has changed! To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLUpdate@lists.sqlmag.com to your list of allowed senders and contacts.

This Issue Sponsored By
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for SQL Server Magazine UPDATE.

Free Disaster Recovery Toolkit for the SQL DBA
    http://lists.sqlmag.com/t?ctl=26D5:7B3DB

Breakthrough Solution for SQL Server Consolidation
    http://lists.sqlmag.com/t?ctl=26D2:7B3DB

5.25 floppies * 8-Tracks * SQL Server 2000 JDBC
    http://lists.sqlmag.com/t?ctl=26D9:7B3DB


February 17, 2005

1. Perspectives

  • Microsoft Security Investments
  • 2. News and Views

  • Microsoft Fixes Deallocation Problem in SQL Server 2000
  • Article Describes How to Set Up Application Names
  • Results of Previous Instant Poll: SQL Server Magazine E-Newsletters
  • New Instant Poll: Accessing Data
  • 3. Events and Resources

  • SQL Server Summit in Minneapolis, March 31, 2005
  • New Web Seminar--SQL Server Administration for Oracle DBAs
  • SQL Server Magazine Connections Conference
  • Discover All You Need to Know About 64-bit Computing in the Enterprise
  • 4. Peer to Peer

  • Hot Tip: OSQL Returns Strange Results
  • Hot Article: ADO.NET 2.0
  • Kevin Kline's "In a Nutshell" Blog: Analysis Services 2000 vs. Analysis Services 2005
  • Hot Threads
  • 5. Announcements

  • Nominate Yourself or a Friend in the MCP Hall of Fame
  • Introducing the SQL Server Magazine Monthly Pass
  • 6. New and Improved

  • Give Small Businesses Affordable Data Recovery
  • Create an Encryption Shield to Foil Intruders
  • Track Down File and Directory Differences
  • Sponsor: Free Disaster Recovery Toolkit for the SQL DBA
    Written by SQL Server expert Brian Knight, this handy, "how-to" toolkit contains comprehensive first-hand advice and scripts for SQL Server DBAs that need to build and implement a successful disaster recovery plan. With his tips and quips, Brian walks the DBA through real-world scenarios using an easy, step-by-step approach. And as part of the download, you'll receive four scripts, which will greatly speed your recovery time! Download it today, compliments of Lumigent:
        http://lists.sqlmag.com/t?ctl=26D5:7B3DB

    1. Perspectives


  • Microsoft Security Investments

  •     by Brian Moran, brian@sqlmag.com

    Last week, Microsoft announced that the company will purchase Sybari Software, a company that provides comprehensive anti-virus and malicious-software protection for messaging and collaboration servers, including Microsoft Exchange, Microsoft SharePoint, and Microsoft Live Communications Server, as well as other non-Microsoft products (see "Microsoft to Acquire Enterprise Anti-Virus Security Provider Sybari Software" at http://lists.sqlmag.com/t?ctl=26C9:7B3DB ). Microsoft Corporate Vice President Mike Nash of Security Business and Technology, says that the acquisition will provide Microsoft customers with "a server-level anti-virus solution that delivers advanced file and content-filtering capabilities and the use of multiple scan engines."

    Sybari technology is deeply embedded within the server infrastructure it protects, an architecture that provides high-level security while maintaining reliability and performance. Before the Sybari purchase, Microsoft used Sybari technology extensively on internal systems for several months. An interview with Microsoft CIO Ron Markezich describes some of the company's experiences with the tool and explains why Microsoft decided to purchase Sybari (see "Microsoft's Sybari Experience: How the Antivirus Software Protects Microsoft's Crucial Communication and Collaboration Infrastructure" at http://lists.sqlmag.com/t?ctl=26C7:7B3DB ). At this time, Microsoft hasn't announced how it will sell, price, or integrate Sybari technology into Microsoft products.

    Microsoft's Sybari acquisition and the Giant Company acquisition I wrote about in "Spyware: An Evolving Threat" ( http://lists.sqlmag.com/t?ctl=26CB:7B3DB ) indicate that the company is taking a comprehensive approach to security. That's good news for SQL Server professionals. Sybari doesn't have a SQL Server-specific module, but given Microsoft's recent security purchases, I won't be surprised to see the company build a homegrown SQL Server solution or buy one of the leading providers of threat avoidance for SQL Server.

    I readily admit that I'm not a security expert, so I read the white paper "Helping Customers Secure Messaging and Collaboration Infrastructure" at http://lists.sqlmag.com/t?ctl=26C5:7B3DB . The paper presents an interesting discussion about how Sybari technology adds protection to a collaboration environment by providing layered defenses, native integration with the server infrastructure, and constant protection from the latest threats. I use various security products to protect my home and business computers. It will be nice if in the future Microsoft products ship with native, robust, easy-to-use security and protection mechanisms that do a better job of protecting my systems than I can do on my own. Microsoft's new spyware-protection software will be free. If the company's virus protection is also free, I wonder what will happen to commodity anti-virus tools like Norton Anti-Virus. Remember Netscape? Me neither.


    Breakthrough Solution for SQL Server Consolidation
    With ARMTech for SQL Server workload management technology from Aurema, you can improve system utilization and performance, lower TCO and say goodbye forever to the days of "one app, one server." The only workload management solution specifically designed to enable SQL Server consolidation, ARMTech delivers increased reliability, improved performance, and higher system utilization in Windows server environments. Download your free evaluation copy of ARMTech for SQL Server and start saving today!
        http://lists.sqlmag.com/t?ctl=26D2:7B3DB


    2. News & Views


  • Microsoft Fixes Deallocation Problem in SQL Server 2000

  • Microsoft has released a hotfix for a problem that occurs when you perform large deallocation operations. When a large deallocation occurs in SQL Server 2000, SQL Server might temporarily stop responding to other requests. Operations such as dropping tables, dropping work files, and dropping indexes that are performed on objects that are multiple gigabytes in size might cause 17883 error messages in the error log, timeouts, or slow performance symptoms. To find out more about this problem and the supported hotfix, read the Microsoft article "FIX: SQL Server 2000 may stop responding to other requests when you perform a large deallocation operation" at
        http://lists.sqlmag.com/t?ctl=26CE:7B3DB

  • Article Describes How to Set Up Application Names

  • Microsoft has released an article detailing how to set up application names in SQL Server 2000 Analysis Services. You can set up application names on computers running Analysis Services, then use the application names to connect to Analysis Services by using an alias name. It's useful to set up application names in disaster-recovery situations when a standby server has the same analysis data as the production server. When you promote the standby server to production server, you move the alias name to the standby server in the Domain Name System (DNS). In this scenario, clients are then redirected to the standby server. To find out more about this process, read the Microsoft article, "How to set up application names in SQL Server 2000 Analysis Services" at
        http://lists.sqlmag.com/t?ctl=26CD:7B3DB

  • Results of Previous Instant Poll: SQL Server Magazine E-Newsletters

  • "How often do you want to receive the SQL Server Magazine UPDATE email newsletter?" Here are the results from the 131 votes:

  •  9%   Daily
  •  2%   Three times a week
  • 11%   Twice a week
  • 60%   Once a week
  • 18%   Once a month
  • New Instant Poll: Accessing Data

  • "What's your favorite technique of accessing data from several tables?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=26DB:7B3DB ) and submit your vote for

  • Joins
  • Subqueries
  • Both joins and subqueries where appropriate
  • Cursors
  • 3. Events and Resources


  • SQL Server Summit in Minneapolis, March 31, 2005

  • One full day, three tracks: DBA, Developer-DBA, and Business Intelligence. See the exciting new features of SQL Server 2005 up close. Keynote speakers include filmmaker and mountaineer David Breashears, Microsoft senior vice president of Server Applications Paul Flessner, and Michael Otey of SQL Server magazine. Register online at (use event code 1032268846):
        http://lists.sqlmag.com/t?ctl=26BA:7B3DB

  • New Web Seminar--SQL Server Administration for Oracle DBAs

  • Sign up now for this FREE, one-hour Web seminar and get a quick start in mapping Oracle database-management skills, knowledge, and experience to SQL Server database management. Learn about the varying similarities and differences between Oracle and SQL Server and get a preview of real-world tips and techniques for managing these associated technologies. Register now:
        http://lists.sqlmag.com/t?ctl=26BB:7B3DB

  • SQL Server Magazine Connections Conference

  • March 20-23, Orlando, FL. More than 45 sessions presented by Microsoft and industry gurus. Registration includes an exclusive day of presentations on SQL Server 2005 by the Microsoft SQL Server 2005 product team. All attendees receive the latest SQL Server 2005 and Visual Studio 2005 beta. Call 800-438-6720 or 203-268-3204.
        http://lists.sqlmag.com/t?ctl=26D6:7B3DB

  • Discover All You Need to Know About 64-bit Computing in the Enterprise

  • In this free Web seminar, industry guru Michael Otey explores the need for 64-bit computing and looks at the type of applications that can make the best use of it. He'll explain why the most important factor in the 64-bit platform is increased memory. Discover the best platform for high performance and learn how you can successfully differentiate, migrate, and manage between 32-bit and 64-bit technology. Register now!
         http://lists.sqlmag.com/t?ctl=26C3:7B3DB

    See the complete Windows IT Pro Network guide to Web and live events.
        http://lists.sqlmag.com/t?ctl=26D4:7B3DB

    4. Peer to Peer


  • Hot Tip: OSQL Returns Strange Results

  •     by Brian Moran, savvy@sqlmag.com

    Q. OSQL --L should locate all SQL Servers on the network, but lately I've seen OSQL --L return servers that don't have SQL Server or Microsoft SQL Server Desktop Engine (MSDE) installed. Why does OSQL --L show SQL Server running on machines that don't have SQL Server installed?

    Read the answer today at
        http://lists.sqlmag.com/t?ctl=26C4:7B3DB

  • Hot Article: ADO.NET 2.0

  • News about data-access technology has taken a backseat to server news lately. But that doesn't mean there's no news about ADO.NET. On the contrary, there are several important changes in ADO.NET 2.0. In his February SELECT TOP(X) column, "ADO.NET 2.0," Michael Otey shares six of the most important changes. Read this article today at
        http://lists.sqlmag.com/t?ctl=26C2:7B3DB

  • In a Nutshell: Analysis Services 2000 vs. Analysis Services 2005

  • In this week's blog, "Analysis Services 2000 vs. Analysis Services 2005," Kevin Kline shares a great shortcut for getting up to speed on SQL Server 2005 Analysis Services. If you're active in SQL Server business intelligence (BI), you need to get to know Mosha Pasumansky's Analysis Services blog. Mosha posted a great comparison of Analysis Services 2000 versus analysis Services 2005 by two Microsoft field people, Jamie Basilico and Mark Frawley. Let Kevin know if you're interested in business intelligence today at
        http://lists.sqlmag.com/t?ctl=26CA:7B3DB

    Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.
        http://lists.sqlmag.com/t?ctl=26CF:7B3DB

    Upgrading SQL Server 2000/7.0: Error 8525 After SQL Server 2000 SP3 Install
        http://lists.sqlmag.com/t?ctl=26BC:7B3DB
    T-SQL: Return Rows With Latest Version of an Incident
        http://lists.sqlmag.com/t?ctl=26C1:7B3DB
    DTS: Problem With Batch File Execution
        http://lists.sqlmag.com/t?ctl=26C0:7B3DB
    Data Access: Testing Locally Stored Procedure With Linked Server
        http://lists.sqlmag.com/t?ctl=26BF:7B3DB
    Administration: Login to Enterprise Manager Not Working
        http://lists.sqlmag.com/t?ctl=26BE:7B3DB
    Security: Limiting Rights on New IDs
        http://lists.sqlmag.com/t?ctl=26BD:7B3DB

    Hot Spot


    5.25 floppies * 8-Tracks * SQL Server 2000 JDBC Great once, but unusable today! Microsoft's SQL Server 2000 JDBC driver is built on technology more than 3 years old. DataDirect presents today's JDBC--the SPECjAppServer leader. Get current with DataDirect Connect for JDBC.
        http://lists.sqlmag.com/t?ctl=26D9:7B3DB

    5. Announcements


  • Nominate Yourself or a Friend in the MCP Hall of Fame

  • You're a valuable and active member of the MCP community, so why shouldn't you get the fame you deserve? Nominate yourself or a peer to become a part of the first ever MCP Hall of Fame. You could win a VIP trip to Microsoft and other prizes. Enter now!
        http://lists.sqlmag.com/t?ctl=26C8:7B3DB

  • Introducing the SQL Server Magazine Monthly Pass

  • Sign up now and get the "golden key" to the SQL Server Magazine Web site. Here's your opportunity to get immediate online access to every article ever published in the magazine--that's thousands of how-to articles, expert tips and helpful blogs to use whenever you need it. Sign up today:
         http://lists.sqlmag.com/t?ctl=26C6:7B3DB

    6. New & Improved


        by Dawn Cyr, products@sqlmag.com

    Share Your Product Success Story and Get a T-Shirt! Have you used a product that saved you time or made your job easier? Tell us your product-success story, and if we print your submission in the Hands On department, we'll send you a SQL Server Magazine t-shirt. Send your product suggestion with information about how the product helped you to handson@sqlmag.com.

  • Give Small Businesses Affordable Data Recovery

  • Sonasoft announced SonaSafe Point-Click Recovery Solution for Small Business, a disaster-recovery solution that provides low-cost, efficient disk-to-disk backup and compression of essential business data. The easy-to-use tool is available for SQL Server, Microsoft Exchange, and Windows File Systems and can be purchased as part of the complete SonaSafe Small Business Suite for backup and recovery of all an organization's databases, email messages, files, and applications. The product's Web-based interface lets you access it from anywhere in the world. SonaSafe for SQL Server supports SQL Server 2000 and 7.0, and its features include a template-driven automated backup plan, point-of-failure or point-in-time recovery, intelligent standby functionality, automated policy-based purging functionality, diagnostic capabilities, and the ability to manage multiple servers through a management console. You can request an evaluation copy of the software at the vendor's Web site. For pricing and more information, contact Sonasoft at 408-927-6200 or info@sonasoft.com.
        http://lists.sqlmag.com/t?ctl=26DA:7B3DB

  • Create an Encryption Shield to Foil Intruders

  • ActiveCrypt Software announced SQL Shield 2.0, software that provides a layer of encryption in addition to SQL Server native encryption and renders SQL scripts impenetrable by any known decryptor. The software provides SQL Server 2000 and 7.0 and Microsoft SQL Server Desktop Engine (MSDE) servers with encryption for triggers, views, and procedures. SQL scripts encrypted with SQL Shield remain executable, so you don't have to restore them for execution every time you need to run them. Plus, installing the software doesn't affect settings and doesn't entirely replace default encryption options; users can always choose which encryption settings to apply. The latest release of the product features a new GUI that lets you quickly encrypt a single procedure or a whole database. Pricing for SQL Shield 2.0 starts at $249 for a single SQL Server 2000 license and $199 for a single SQL Server 7.0 license. For more information or a free evaluation copy of the software, contact ActiveCrypt Software at info@activecrypt.com.
         http://lists.sqlmag.com/t?ctl=26D8:7B3DB

  • Track Down File and Directory Differences

  • Altova announced DiffDog 2005, a synchronization tool that facilitates the comparison and merging of files, folders, and directories for application developers and power users. DiffDog 2005 Standard and Professional editions let users quickly compare source code files, HTML files, or any text-based files, then merge changes with one click. Both editions deliver versatile comparison and merging options for all file directories. And the tool also provides advanced XML-aware differencing and editing capabilities. Pricing for DiffDog 2005 starts at $69 for the Standard edition and $129 for the Professional edition, and a free 30-day trial version is available on the vendor's Web site. For more information, contact Altova at 978-816-1600 or sales@altova.com.
        http://lists.sqlmag.com/t?ctl=26DC:7B3DB

    Contact Us


  • About the newsletter—letters@sqlmag.com
  • About technical questions—http://www.sqlmag.com/forums
  • About product news—products@sqlmag.com
  • About your subscription—sqlupdate@sqlmag.com
  • About sponsoring SQL Server Magazine UPDATE—Richard Resnick, rresnick@sqlmag.com
  • 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.
    http://www.sqlmag.com/rd.cfm?code=00ep214xeb

    Manage Your Account You are subscribed as #EmailAddr#. To unsubscribe from this email newsletter, click here /#Mailing:UnsubEmail

    To make other changes to your email account such as changing your email address, updating your profile, and subscribing or unsubscribing to any of our email newsletters, simply log on to our Email Preference Center.
    http://email.winnetmag.com/winnetmag/winnetmag_prefctr.asp

    View the SQL Server Magazine Privacy Policy.
    http://www.winnetmag.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 2004, Penton Media