Contest!

We've run contests from time to time over the past couple years and had a lot of fun doing it. This time we're trying something new, partnering with Red Gate. Lots of good prizes on this one!

Microsoft SQL Server 2000 Analysis Services Performance Guide

Analysis Services is slowly gaining in popularity and many of you might get drawn into setting up a server or developing a system based on this technology. Microsoft has released a performance guide to help you take performance into consideration from the beginning.

SQL Server 2000 Best Practices Analyzer Beta

Microsoft has released a new tool to analyzer your SQL Servers and see how they conform to their list of common best practices. Give it a try and let us know what you think.

Delphi Code Generator

You point this application at a database and it generates a code unti that allows you to easily execute stored procedures and functions from Delphi. (Not Reviewed)

QA Lite - .Net Version of Query Analyzer

A free product from RAC4SQL, if you need something a little different maybe this will help. (Note: We're looking for a review of this, if you're using it drop us a note)

Permissions on System Tables Granted to Logins Due to the Public Role

Many of you know that Brian Kelley is our resident security guy. If you didn't, this might prove it! There is a ton of information in this 63 page document worth reading. Let us know what you think.

New 'Find Duplicates Wizard'

The Wizard enables anyone working with a SQL Server database to identify and review duplicate data with ease. It is an exceptionally powerful tool with the modest price tag of $397 (approximately £230).

The software has a wealth of processing options, which you can read about when visiting www.findduplicates.com or (in even more detail) in the free help file download which is also available on the web site.

Yukon News

This article on CNET has some info about how Yukon affects the MS strategy in other areas.

Superior SQL Builder v1.3 released

Red Earth Technologies announces the release of version 1.3 of Superior SQL Builder, its SQL tool that allows users to visually build complete SQL scripts without typing any code.

Superior SQL Builder introduces new SQL scripting technology, allowing users to quickly and easily transform their database data. In version 1.3 this scripting technology has been extended and enhanced so that complex SQL scripts can be built in less time and with greater ease.

Server side tracing in SQL Server, using system stored procedures

Ever wanted to use the SQL Trace system stored procedures instead of Profiler, but got intimidated by the cryptic system stored procedure calls? Then this article is just for you. It will show you how to use SQL Trace system stored procedures and provide you with wrapper stored procedures, that can be used to quickly get server side traces up and running.