Certification Should Be Required

• by Steve Jones

• SQLServerCentral.com

• Certifications

Steve Jones presents his case for why certifications should be required. Read this and the counter point article by Andy Warren to hear the other side of this argument - then post your comments

Cursor Performance

• by Additional Articles

• SQLTeam.com

• Performance Tuning

An anaysis of performance using cursors in T-SQL.

XML for SQL Server 2000: Optimizing Your Performance

• by Additional Articles

• Microsoft SQL Home

• Basics

The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.

Review of Data Compare v.151

• by Andy Warren

• SQLServerCentral.com

• Replication

In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!

Allowing BULK INSERT for non-SysAdmin Users in SQL 7.0

• by Paul Ibison

• SQLServerCentral.com

• Administration

One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.

SQL Server 6.5: Index Statistic Details

• by Alexander Chigrik

• SQLServerCentral.com

• Administration

This article examines how index statistics are used in SQL Server 6.5

SQLXML 2.0 (XML for SQL Server 2000)

• by Additional Articles

• Microsoft MSDN

• News
• Uncategorized

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.

Easily Create Insert Scripts with AutoInserts

• by Brian Knight

• SQLServerCentral.com

• Product and Book Reviews

One of the most pain-staking tasks a developer and DBA must often accomplish is to create an install procedure for the database. This involves creating the necessary DDL to create the tables, relationships and indexes. Inevitably in this process you forget about the data. AutoInserts to the rescue!

Programming With ADO.Net

• by Additional Articles

• Other

• Miscellaneous

Learn the basics of ADO.Net in this article by Andrew Phillips.

Scrubbing Data With DTS : Part 2

• by Brian Knight

• SQLServerCentral.com

• DTS

Chances are, if you've dealt with any type of data, you know you
rarely receive the data in perfect condition. In this second article in the series on cleaning data, Brian Knight shows you how to scrub data with a more advanced method.