Make your own free website on

SQL Server newsletter for the month of October 2001
Last updated: October 10th '01 | Best viewed with: All popular browsers | Best viewed at: 1024x768 | Links to external sites will open in a new window

About myself
My technical skills
My favorites
My picture album

Shortcut keys
My code library

VB resources
SQLServer resources
SQLServer books
Replication FAQ
Scripting resources
ASP resources

Search my site
Sign my guestbook
Contact information
NEW!!! Subscribe to my newsletter:
Want to keep in touch with the latest in SQL Server world? Email with 'subscribe' in the subject line

Previous month  Next month

Welcome to the first issue of this monthly SQL Server newsletter brought to you by and thank you for subscribing. This newsletter will familiarize you with all the new and updated content at It will also provide you with tips and links to valuable SQL Server related information that is worth a read. If you are interested in receiving information on a particular aspect of Microsoft SQL Server, feel free to mail us at . We hope you will find this information useful.

Information in this newsletter is divided into the following sections:

What's new at <top>

New questions added to the Administration FAQ:

New questions added to the programming FAQ:

New resources added to the SQL Server resources page:

Enhanced version of the Propercase function is now available:

Added a new stored procedure sp_lock2, which is an enhanced version of Microsoft's sp_lock, for monitoring locking information:

The following new articles were published:

SQL Server Security best practices
This article discusses the security model of SQL Server 7.0, 2000 and the security best practices that a serious DBA must be aware of:

SQL Server administration best practices
This article discusses the administration best practices for SQL Server 7.0 and 2000, with a special focus on backup/restore and disaster recovery:

Third party SQL Server tools, products and solutions
This article has a list of popular third party products that help you manage your databases:

What's new from Microsoft? <top>

Having non-convergence problems with SQL Server 2000 Merge replication? The -ForceConvergenceLevel parameter can help! Learn how to use this undocumented merge agent parameter at:

Here is a support webcast, that teaches you everything about the new INSTEAD OF triggers. It also discusses some of the main applications of INSTEAD OF triggers, including implementing cascading referential integrity and inheritance:

Get to know the enhancements and new features of Merge replication in SQL Server 2000 from SQL Server replication product unit manager Thomas Casey:

When, why and how to use Profiler? Here is a support webcast on "How to effectively use SQL Server Profiler":

Have a lot of performance issues to troubleshoot, but don't know how to proceed? Check out this webcast "How to Collect and analyze Performance Data in Microsoft SQL Server":

Excellent article on troubleshooting stored procedure recompilations:
INF: Troubleshooting Stored Procedure Recompilation

Think your Full-Text search is yielding incorrect results? You could be seeing this bug:
FIX: Full-Text Search Queries with CONTAINS Clause Search Across Columns

Too many servers to take care of? Not sure, whether all your servers are running with the latest security patches? Finally, here is a tool, that lets you centrally assess a computer or group of computers for the presence or absence of security patches (Windows as well as SQL Server):
Microsoft Network Security Hotfix Checker (Hfnetchk.exe) Tool Is Available

Here is a collection of all the articles that talk about disaster recovery with SQL Server 6.5, 7.0 and 2000:
INF: Disaster Recovery Articles for Microsoft SQL Server

Download the updates to SQL Server 2000 Books Online. These updates include corrections, clarifications, and new topics:

Useful information from other SQL Server based websites <top>

Microsoft and MERANT DataDirect announced the release of a beta version of the Microsoft SQL Server 2000 JDBC Driver, to enable users from Java and J2EE platforms to integrate with SQL Server 2000:

Read the chapter "Using XML" from the book SQL Server 2000 Developer's Guide from Osborne McGraw Hill:

Read the chapter "Implementing and Managing a Backup Solution" from the book, SQL Server 2000 Administration from Osborne McGraw Hill:

Read about the new Intel Itanium chip and the upcoming 64-bit Windows and SQL Server software:
Wait on 64-bit Itanium

Tips <top>

Don't have SQL Server 2000, but want to access its documentation? Don't worry; SQL Server 2000 Books Online is a free download. Get it from: or access it online at:

Did you know, you can get formatted XML output with an undocumented trace flag?

Here is an example:

/* Start of code snippet */
PRINT 'Normal output'

SELECT title_id, title FROM pubs..titles FOR XML AUTO


PRINT 'Formatted output'

SELECT title_id, title FROM pubs..titles FOR XML AUTO



/* End of code snippet */

No part of this newsletter may be reproduced in whole or in part without written permission. Feel free to forward this newsletter, in its entirety only, to friends and colleagues.

Disclaimer and terms of use
Copyright 2001 Narayana Vyas Kondreddi. All rights reserved.