Creating SQL Objects on the fly with VB and XML

• by Additional Articles

• ASPToday

• Miscellaneous

A method for creating databases and other objects on the fly and distribute these objects to multiple servers.

2001-06-08

1,944 reads

SQL Server 7.0 and OLE DB Heterogeneous Queries

• by Additional Articles

• Microsoft MSDN

• Distributed Queries

This article discusses queries that involve more than one database server. For example, you can run a query that returns a joined recordset where some records come from a SQL Server™ database and others come from an AS/400 machine.

2001-06-06

1,416 reads

Microsoft SQL Server 2000 Reliability

• by Additional Articles

• Microsoft MSDN

• Performance Tuning

Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.

2001-06-05

1,660 reads

Put Advanced SQL Server Features To Work

• by Additional Articles

• Microsoft MSDN

• Miscellaneous

SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.

2001-06-04

1,107 reads

A Windows 2000 Service Pack 2 Update

• by Additional Articles

• SQL Server Magazine

• Service Packs

Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.

2001-06-01

1,069 reads

A Look at SQL Server CE

• by Additional Articles

• Microsoft SQL Home

• Replication

An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.

2001-05-30

1,721 reads

SQL Server 7.0 and 2000 Clustering Resources

• by Additional Articles

• SQL Server Performance

• Performance Tuning

A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.

2001-05-29

1,816 reads

The Data Mining Cluster Analysis Algorithm

• by Additional Articles

• PASS

• Data Mining

Provides audience with information on cluster analysis algorithm.

2001-05-07

1,594 reads

Analyze Databases Using Coefficient

• by Additional Articles

• SQL Server Performance

• Performance Tuning

In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.

2001-05-02

1,543 reads

Creating Merge Replication Conflict Resolvers

• by Additional Articles

• Microsoft MSDN

• Replication

This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables.

2001-05-01

2,075 reads