Subscribe to SQL Server Magazine:
To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@list.windowsitpro.com to your list of allowed senders and contacts.
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.
This Issue Sponsored By
Clustering Alternative for Your SQL Server
Free SQL Server 2000 Training CD!
Want a Perfect Release? Every Time?
January 13, 2005
2. News and Views
3. Reader Challenge
5. Peer to Peer
6. New and Improved
Sponsor: Clustering Alternative for Your SQL Server
Today, every company recognizes the downsides of downtime: significant productivity and profitability losses. But until now, businesses had limited choices among solutions that protect against downtime, either because of their cost or their complexity. Neverfail's "cluster-class" solution ensures server reliability, application availability and data protection--at a fraction of the cost and complexity of traditional alternatives. Learn how to keep your users connected to your SQL Server, no matter whether a failure occurs in the operating system, a hardware component, a software application, or somewhere within the network. To view a demo or access a free whitepaper:
by Brian Moran, firstname.lastname@example.org
The Microsoft Windows AntiSpyware beta is now available from Microsoft. You might not think that's SQL Server news, but it's an important event in the security world, and security is a major concern for all SQL Server professionals. Is spyware a big problem? In November 2004, the analyst firm IDC reported that 67 percent of all consumer PCs are infected with some form of spyware. The study didn't comment directly on business-related computers, but I think it's safe to assume that the number is comparable.
In the beginning, spyware was a minor inconvenience, but over time, spyware has evolved into a problem that affects a machine's performance and undermines consumer and business trust in data security and privacy. One day, spyware could become a dangerous tool for corporate espionage so we must all be concerned now.
You can download the AntiSpyware beta and get more information about its features and benefits at http://www.microsoft.com/athome/security/spyware/software/default.mspx. The following Microsoft newsgroups provide support for the AntiSpyware beta:
You can access the newsgroups by using NNTP or HTTP. To access the newsgroups through HTTP, go to http://communities.microsoft.com/newsgroups/default.asp?ICP=spyware&sLCID=us. To access the newsgroups using NNTP, use the following information for your NNTP client:
Several spyware solutions are on the market today; however, many people run multiple products because no single product is effective. Using multiple products isn't a scalable solution. It's too early to tell whether Microsoft's solution will effectively address the spyware problem, but I believe the company will provide a better, more comprehensive solution than those that are currently available. To form your own preliminary opinion, read the press release "Microsoft Acquires Anti-Spyware Leader GIANT Company" at http://www.microsoft.com/presspass/press/2004/dec04/12-16GIANTPR.asp .
Microsoft also provides a set of tools that clear computers of malicious software, which solves another problem for many consumers and business customers. Most anti-virus tools do a good job of preventing infections, but in many cases, there's little help for getting rid of the disease once you're infected. Microsoft's tools are new versions of virus- and worm-removal tools that Microsoft released in 2004. Each of the tools released in 2004 is specific to a single virus and some of its variants. The new removal tools are more convenient for customers because one tool tackles all viruses and variants. The tools will be available to customers through the Microsoft Download Center, as a critical update through Windows Update and Auto Update, and as an ActiveX control, Malicious Software Removal Tool, available at http://www.microsoft.com/malwareremove . The press release I mentioned explains that the new tools' technology is based on technology from Giant Company, a leading provider of anti-spyware and other Internet security tools that Microsoft recently acquired.
I believe that time will prove these tools useful. Until then however, the tools' release is further evidence that Microsoft finally understands the importance of security and that the company treats security as an important design consideration. If security permeates every product that Microsoft ships, that's a good thing for all of us.
Free SQL Server 2000 Training CD!
See why AppDev was voted THE BEST by readers of SQL Server Magazine...get a FREE SQL Server 2000 Training CD-ROM--a $95 value! Click the link below for your free SQL Server training CD.
2. News & Views
Microsoft WINS and SQL Server Targeted
The Internet Storm Center (ISC) reports that attempts to penetrate systems through WINS and SQL Server have been detected. Read this article to learn how to ensure that your systems aren't vulnerable.
"When do you plan to migrate to SQL Server 2005?" Here are the results from the 147 votes:
"Do you use multiple tools to handle your spyware problems?" Go to the SQL Server Magazine home page ( http://www.sqlmag.com ) and submit your vote for
3. Reader Challenge
by Umachandar Jayachandran, email@example.com
Congratulations to Narasimhan Jayachandran, a senior DBA for First Data Resources in Omaha, Nebraska and Chris Watson, a senior developer for the Auckland University of Technology in Auckland, New Zealand. Narasimhan won first prize of $100 for the best solution to the January Reader Challenge, "Eliminating Recompilation." Chris won second prize of $50. You can read a recap of the problem and the solution to the January Reader Challenge at
Now, test your SQL Server savvy in the February Reader Challenge, "Avoiding Application Failure" (below). Submit your solution in an email message to firstname.lastname@example.org by January 20. Umachandar Jayachandran, a SQL Server Magazine technical editor, will evaluate the responses. We'll announce the winner in an upcoming SQL Server Magazine UPDATE. The first-place winner will receive $100, and the second-place winner will receive $50.
Here's the challenge: David, a developer for a company that sells firewall and ad-blocking applications, develops applications that use Microsoft SQL Server 2000 Desktop Engine (MSDE) for storing various configuration metadata and activity logs. David notices that the application startup can fail if the MSDE service hasn't recovered the application database completely even though the SQL Server service has started successfully. How can David avoid application failure if the database isn't recovered completely? What can David do in the application code to start the application gracefully?
Hundreds of free tips and articles on SQL Server performance tuning and clustering. And get quick and accurate answers to your performance- and cluster-related questions in our forum. All from the SQL Server performance authority: SQL-Server-Performance.com.
Learn how to improve business continuity and information lifecycle management with this analyst white paper, compliments of BMC Software. Discover the backup and recovery management strategies needed to keep mission-critical systems running. Download now!
5. Peer to Peer
Hot Tip: Choosing a Secure Authentication System
by Brian Moran, email@example.com
Q. My company is deciding between SQL Server Authentication and Windows Authentication for future applications. Which authentication method provides better security?
Read the answer to this question today at
Sir Arthur Conan Doyle once said, "Crime is common. Logic is rare. Therefore it is upon the logic rather than upon the crime that you should dwell." In his January T-SQL Black Belt column, "Grouping Ranges" Itzik Ben-Gan shows you how to find groups of dates in a sample retail-activity application, then challenges you with a purely logical exercise to strengthen your mental muscles. Read this article today at
General Discussion: Server Rejecting Stored Procedure sql_variant Types
DTS: DTS Losing Records but not Reporting Errors
Performance: Seeking Feedback About Clustered IDX
T-SQL: Populating a Table With Random Passwords
Replication: Add Column in Publisher Article
Administration: Database Size Unaffected By Table Drop
DB Ghost builds directly from your source control system, validating your code as it builds, so the hassles of working with broken databases become a distant memory. DB Ghost can then compare and synchronize a target database, giving you a perfect release. Every time. See for yourself:
6. New & Improved
by Dawn Cyr, firstname.lastname@example.org
UltraBac Software announced UltraBac 8.0, backup and disaster-recovery software that lets you create incremental backups so that you can restore damaged or lost data to the point before the loss occurred. The latest release of the solution includes advanced features that make the product even better for datacenters or large, distributed databases. The first improvement users will notice is a feature called UltraCopy, which lets you duplicate tape- or disk-based backups to offsite storage media. In addition, UltraCopy lets you consolidate multiple tape or disk backups to any other removable storage medium. Also new in UltraBac 8.0 is support for Intel and AMD 64-bit processors. Native support for both 64-bit and 32-bit systems allows for seamless backup and recovery in mixed-processor environments. Other new features in this release include differential image-backup functionality, support for media pools and barcodes, a centralized SQL-based database indexing option, direct backup and restore support of CD and DVD writer devices, remote autoloader support, firewire device support, throughput throttling, and reporting of bad blocks for worn tapes. Pricing for UltraBac 8.0 starts at $495 per server and includes the ability to back up an unlimited number of workstations. For more information, contact UltraBac Software at 425-644-6000 or email@example.com.
Extreme Technologies announced dbMaestro Freeware Edition, software that lets you automate migration of structural changes from your SQL Server development environment to production. The software tracks changes to development database objects such as tables, indexes, views, and stored code, then lets you select the required changes and apply them to your production system. The product automatically generates the SQL code necessary for the deployment. You can also use the product to compare, synchronize, and migrate lookup and reference data associated with an application. dbMaestro Freeware Edition is available at no charge at the company's Web site or http://www.download.com (keyword dbMaestro). For large enterprises requiring additional capabilities, including comprehensive database versioning, Extreme Technologies offers dbMaestro Professional Edition. For more information, contact Extreme Technologies at 972-03-9248558 or firstname.lastname@example.org.
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.
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.
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, Inc. All Rights Reserved.