DoEvents with SQL Server 2000 and Extended Procedures

In this article, we will leverage Extended Stored Procedures to extend the functionality of SQL Server and give a starting point to experiment with Extended Stored Procedures.

Review of Micrsoft ADO.Net Step by Step

Andy takes a look at another entry level book, this one on ADO.Net.

SQL-UP! version 1.3 now available

Incepto Ltd. announced the availability of SQL-UP! version 1.3, distributed SQL Server Cluster. SQL-UP! clusters SQL Server databases over LAN or WAN, with no shared storage device.

The software provides business continuity and complete disaster protection for business-critical databases. The new version adds support for online database schema changes, inter-domain clusters and high transaction load.

VBScript Classes to Query SQL Server for Backup Information

A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.

Proc-Blaster Updated

Proc-Blaster 2.32 has been released with much faster loading time, improved help file, new templates and more. Proc-Blaster is a RAD Code Generator for SQL Server.

VB TV

What's VB.NET? Microsoft has launched a new learning platform called VBTV. Check it out if you are interested in VB at all.

Review: MSSQLCrack

A new SQL Authentication password cracker you should be aware of. It can crack your SQL passwords and give you an idea of how secure you are.

The Case for SQL Logins - Part Two

In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.

Upcoming SQL Server SP3 Beta Program

It’s almost time for the newest Service Pack for SQL Server 2000, and you don’t want to be caught unprepared for this one. In addition to the normal QFE fixes, the top service pack requests from our PSS organization and the latest security fixes, this service pack will be shipping with MDAC version 2.7 SP1. You’re going to want to be involved in this service pack beta! This beta is scheduled to start in mid to late September.

Beware to the System Generated Constraint Name

New columnist Gregory Larsen used to not care what his objects were called until recently when he began to become concerned with the system generated constraint names. This short article tells you why.