Mapping Database File Objects and Fragmentation

Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?

You have a SQL Server stored procedure named...

Terminal Services - A Couple Tips

We agree with Andy that Terminal Services is definitely a tool to have in the DBA toolbox. Like most tools, everyone uses them differently. Andy starts the discussion with some comments on how he uses TS - what about you? Do you use TS at all? Use it differently than Andy does? Prefer a different solution? Read the article and post a comment.

You are an unfortunate DBA who works for...

Review of SQLDiff by Lockwood

Chris was kind enough to take some time to put this product through it's paces and ends up giving it a very good rating. Read the article to see a nice graphical walkthrough of how to use the product.

You have SQL Server 7.0 merge replication installed...

xSQL Object Public Beta

xSQL Object for Microsoft SQL Server has been designed with the DataBase Administrator in mind. Scripting, Comparing and even Synchronizing different objects like tables, views, stored procedures etc. is fast and easy.

You create a new linked server to Analysis...

New Table Structure Compare Tool in Beta

Aladdin is an "alter table" script generation tool for SQL Server 7/2000.
Aladdin is currently in BETA. They are currently looking for for 25 people willing to use the beta product and report their experiences. Users who fully participate in the beta will get a free, single user license when the product is released. To participate in the Aladdin BETA program, please download the software and send an email to Ken Otto: ottosoft@hotmail.com - Subject: Aladdin Beta Test.

Worst Practice - Spaces in Object Names

We can only guess that someone somewhere put spaces in an object name that Andy works with and gave him the idea for this worst practice. Funny as the topic may sound, we agree - why make your lifer harder?