Articles

In three previous articles Andy has done a very basic introduction to the ADO connection, command, and recordset objects. In this wrap up article he talks about how to use the power of ADO client side filtering and disconnected recordsets, then adds some code which shows how to combine all the objects. ADO is not simple, but Andy has done a good job in limiting his dicussion to the things you REALLY need to know about ADO to get started.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2001-12-07

10,286 reads

Discuss

Microsoft SQL Server 2000 Security

by Additional Articles

Microsoft MSDN

Security

This document introduces the new security features of Microsoft SQL Server 2000. New features are outlined, and a detailed discussion is provided about how to best implement security in a Microsoft Windows 2000 domain environment. Source code examples are included for developers who want to implement the security model immediately.

2001-12-06

1,547 reads

Discuss

Service Pack 2 for SQL Server 2000 Released

by Brian Knight

SQLServerCentral.com

Service Packs

Here we go again! Microsoft has released service pack 2 this week, which is much more tame than service pack 1. Read the summary of this service pack here.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-12-05

11,336 reads

Discuss

Worst Practices - Depending on the GUI

by Steve Jones

SQLServerCentral.com

Security

One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2001-12-04

6,236 reads

Discuss

Security Alert : SQL Server Worm Virus Attacking Systems

by Brian Knight

SQLServerCentral.com

Security

This past week, a worm virus began to attack SQL Servers on the internet that hold a blank password. Read some of the details about what this virus can do here.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-12-03

13,224 reads

Discuss

A New Way to View and Analyze Your Data

by Additional Articles

Microsoft SQL Home

With Data Analyzer—the brand-new Office data analysis solution—you can quickly and easily view, analyze, and share business data, giving you the power to make better business decisions.

2001-11-30

4,798 reads

Discuss

Using SQL Server 2000 and XML to Monitor the Usage of your SMTP Server

by Kunal Das

SQLServerCentral.com

Basics

This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-11-29

3,582 reads

Discuss

HOWTO: Run Singleton SELECT Queries in a Visual Basic Client

by Additional Articles

Microsoft MSDN

T-SQL

This article demonstrates how to retrieve a single record from SQL Server by using the IRow interface with a singleton SELECT. The main purpose for this technique is to avoid the overhead of creating a recordset when you are fetching a single record. Because no recordset is actually created, only one read-only ADODB.Record is returned. This is true even if the specified SELECT results in multiple records being returned if a normal ADODB.Recordset is used.

2001-11-26

1,684 reads