Articles

myLittleTools.net is pleased to announce the release of myLittleAdmin, the most advanced and robuste web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager.

2003-06-17

1,164 reads

Discuss

In the Real World - Lost Data Chains

by Steve Jones

SQLServerCentral.com

How do you deal with problems in the real world? What steps should you follow? A new series looking at actual experiences at work. This one looks at a weeklong adventure in troubleshooting SQL Server applications.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-16

4,959 reads

Discuss

SQL Database Audit Tool released to beta

by Additional Articles

Other

LockwoodTech has released a new sql tool that analyzes the SQL Server transaction log to passively audit a SQL Server database. You can track inserts, updates, deletes and full row level detail of past transactions (even before the tool was installed). Client supports powerful filtering, grouping and sorting of audit data.

2003-06-16

37 reads

Discuss

Who Are You? (as a DBA)

by Steve Jones

SQLServerCentral.com

Are you a 228 or a 229? Read on and think about how well you fit your job.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-12

4,993 reads

Discuss

Precise/Indepth for SQL Server

by Additional Articles

Other

Performance Tuning

This is a performance analysis and tuning application. Visit the site to get to more info, they also have a free book on performance tuning (registration required). (Not reviewed)

2003-06-12

786 reads

Discuss

Automatic Deployment of Scripts from your Frontend

by Additional Articles

Other

Bundle SQL Deploy when you distribute a new version of your application to clients and all your database changes will happen automatically. Simply save database changes from Enterprise Manager, SQL Analyser or Visual Studio .NET as scripts (as most developers already do) and this utility enables automatic data version upgrades. Designed for Winforms, Webforms, VB, ASP and Access applications (and more), SSW SQL Deploy means you never have to worry when deploying applications again!

2003-06-11

45 reads

Discuss

Is Windows 2003 Really Faster?

by Brian Knight

SQLServerCentral.com

Installation

Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-06-10

12,879 reads

Discuss

IMP Index Manager

by Additional Articles

ASPToday

Miscellaneous

Integrate high performance index- and search functionality in your SQL database.
Essentially, IMP Index Manager is a set of tools (search engine, administrative interface, etc.) to make it very easy to add search engine capabilities to SQL Server 2000. Easy to implement, and lightening fast performance. (Not Reviewed)

2003-06-10

1,529 reads

Discuss

Monitoring Performance

by Viktor Gorodnichenko

SQLServerCentral.com

Performance Tuning

Vicktor has a bunch of scripts he uses to monitor performance, he explains why he built them and how to use them. Good coverage of the different reasons for slow performance.