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.

Service Pack 1 for SQLCentric v.1.2.3 Now Available

This service pack contains bug fixed, plus enhancements including test email button, sorting, and drill down.

New JDBC Driver for SQL

This is one of the vendors we met at PASS 2003. Their new driver is supposed to be faster than the driver provided by Microsoft AND supports NT authentication. Link takes you to a comparision chart of features. (Not Reviewed)

Lockwood Tech is now ApexSQL!

The name has changed, but the owner and the upgrade policies remain the same! Follow the link to see the press release that explains the name change.

Database Migration Tool

New product designed to help you move from one database platform to another. (Not Reviewed)

Brief Tutorial on Text, Ntext, and Image

Joseph has written a couple articles for us and forwarded this link to an article he wrote recently on text type columns. You can see more of his work at http://www.sqlservercentral.com/columnists/jgama/.