Additional Articles

SQL Server 2000: New XML Features Streamline Webcast

by Additional Articles

Microsoft MSDN

With XML support in SQL Server 2000, you can query SQL over HTTP with a URL, bring the data down to the browser, and manipulate it on the client machine. By adding Internet Explorer 5.0 to the mix and using XSL to convert the XML to HTML, you can lighten the load on your database server. Going still one step further, by using Vector Markup Language you can even create drawings on the fly using the data from your SQL queries.

2001-06-26

4,110 reads

Automate Writing Stored Procedures

by Additional Articles

DevX

Stored Procedures

This article by David Rabb from the June 2001 issue of VBPJ shows you how to build a tool that will build a select, insert, update, and delete stored procedure for each table in a database. It's a great example of how to use DMO and a great tool as well!

2001-06-25

2,561 reads

Job to Monitor SQL Server 7.0 Performance and Activity

by Additional Articles

Microsoft MSDN

Performance Tuning

This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.

2001-06-19

2,670 reads

Implementing Data Quality Through Meta Data

by Additional Articles

Embarkadero

Design and Theory

Data Quality is as important as data integrity for most every application. This article examines how data quality can be improved in a data warehouse through the use of Meta Data.

2001-06-14

1,671 reads

Clonation and the Case of Table Dolly, Part 1

by Additional Articles

Microsoft MSDN

.Net

In software, clonation can sometimes turn out to be an extremely helpful technique. More often than not, in fact, you catch yourself duplicating instances of running objects to produce nearly identical objects to be managed codewise in a fairly independent way.

2001-06-13

1,123 reads

Using SET to Tune Your Queries

by Additional Articles

SQL Server Performance

Performance Tuning

On the surface, the goal of performance tuning a query seems simple enough. Essentially, we want our queries to run faster. This article looks at how the STATISTICS IO and STATISTICS TIME options can help us tune queries.

2001-06-12

2,431 reads

How to Use the Windows Synchronize Manager with Pull Subscribers

by Additional Articles

Microsoft MSDN

Replication

If you have Microsoft Windows 2000 or Microsoft Internet Explorer 5.0, Pull subscribers can use the Windows Synchronization Manager (WSM) to synchronize with the publisher.

2001-06-11

1,664 reads

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

All authors

Additional Articles

SQL Server 2000: New XML Features Streamline Webcast

Automate Writing Stored Procedures

Job to Monitor SQL Server 7.0 Performance and Activity

Implementing Data Quality Through Meta Data

Clonation and the Case of Table Dolly, Part 1

Using SET to Tune Your Queries

How to Use the Windows Synchronize Manager with Pull Subscribers

Creating SQL Objects on the fly with VB and XML

SQL Server 7.0 and OLE DB Heterogeneous Queries

Microsoft SQL Server 2000 Reliability

Blogs

Flyway Tips: AI Generating Migration Script Names

The Book of Redgate: Get the right stuff done

Runing tSQLt Tests with Claude

Forums

No Defaults Passwords Ever

Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

The Long Name

Question of the Day

The Long Name