Additional Articles

Middle Tier Application Data Caching with SQL Server 2000

by Additional Articles

Microsoft SQL Home

Administration

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.

2002-03-08

2,221 reads

Discuss

Freeware DBEzze 1.0 Released

by Additional Articles

SQLServerCentral.com

Administration

DBEzze is a freeware product that can look into a database and generate XML structural or data output. It can also generate INSERT statements from a table, view or stored procedure. This freeware product is available for download from SQLServerCentral.com members only.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-03-06

99 reads

Discuss

Microsoft Tunes Windows

by Additional Articles

Other

Microsoft Corp. is considering bundling in the next version of Windows a pared-down version of its next-generation SQL Server database and the relational file system that goes with it.

2002-03-04

3,283 reads

Discuss

Performance Comparison: Data Access Techniques

by Additional Articles

Microsoft SQL Home

Performance Tuning

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.

2002-03-01

2,857 reads

Discuss

How to track database file growth over a period of time?

by Additional Articles

Vasyn MVP site

This stored procedure shows you the growth patterns of your SQL Server database files and enables you to plan ahead for your future storage needs!

2002-02-28

105 reads

Discuss

Technical Chat: Inside with Jim Gray--The Search for Petabyte Storage

by Additional Articles

Microsoft MSDN

Please join Jim Gray, Distinguished Engineer at Microsoft Research, for this Q&A Session. Jim, the father of Structured Query Language, has been looking at LARGE databases like Google, Hotmail, BarBar, CERN, EOS/DIS, Internet Archive, and others that are either at a Petabyte or will grow to a petabyte scale in the next year or so.

2002-02-28

3,353 reads

Discuss

AdeptSQL Workshop released

by Additional Articles

Other

Adept SQL Tools has released AdeptSQL Workshop, an IDE for SQL-based database schema creation and management. Includes fast drag'n'drop SQL decompiler, editor, preprocessor, SQL analyzer and difference engine, "revision history" scripts with a separate player utility for remote db deployment, integration with MS Visual SourceSafe. Pricing starts at $130,
$199 with VSS support.

2002-02-25

3,342 reads

Discuss

Compare SQL Server Databases with sp_CompareDB

by Additional Articles

SQL Server Performance

Advanced Querying

Use this free stored procedure to compare two different SQL Server databases in order to discover how they differ. Sp_CompareDB can compare both table structures and the data stored in them. Also learn how the stored procedure was written.

2002-02-22

1,214 reads

Discuss

Mini ASP based SQL Server admin tool

by Additional Articles

Other

myLittleAdmin For SQL Server is a web-based SQL Server Database administration tool. It is intended to handle the administration of SQL Server databases over the WWW using ASP. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.

2002-02-18

3,217 reads