(Martin LaMonica) Microsoft on Friday announced that it will begin a broad testing program for its SQL Server 2000 database that will enable business reporting. (R)

By Paula Musich – Marimba Inc. this week will launch its first foray into security patch management with a version of its change management software tailored to the deployment of hot fixes and anti-virus patches. And Microsoft Corp. will soon ship its Systems Management Server 2003 change management

The days of the SQL Server DBA’s isolation are passing away as products become more complex and interdependent. This week, Brian Moran gives an overview of upcoming technologies and their important to the SQL Server community.

Many times you’re required to write query to determine if a record exists. Typically you use this to determine whether to insert or update a records. Using the EXISTS keyword is a great way to accomplish this.

LockwoodTech has released version 1.0 of Log Navigator, a SQL Server auditing tool that leverages the SQL Server transaction log to passively audit data changes without triggers. As of 25 Sept 2003, the product is being offered at a special introductory price of $599 per developer. Upgrades and supp

By George V. Hulme – The company says it will reinforce its security efforts with better patch management, improved operating-system firewalls, and a security outreach program.

Oracle unquestionably is the 800-pound gorilla of database companies. But Microsoft’s SQL Server is mounting a serious challenge to the market leader.

By Andrew Novick – This two-part series discusses how to create stored procedures to implement the CRUD operations in SQL Server. This article concentrates on the rational behind using stored procedures and discusses many of the technical issues that are particular to SQL Server.

STFB Inc. is a provider of accounting systems complete with source code and distribution rights for Microsoft Access, VB, VB Dot Net, MSDE 2000, SQL Server and Internet Platforms.

DBGhost is a database change management system. Use to increase developer productivity by insuring code created can be delivered. DB Ghost does this by using the following features: Verify changes made to your database schema and static data. Report on all changes and errors.