By Keith Regan – A mid-size corporation moving from an Oracle database probably would have to rewrite dozens — at least — of proprietary SQL queries in order to ensure that all of its data migrated successfully.

By Mike Weaver – This script will 1) go through all SQL Server databases on a single server and create a device for each database and 2) schedule a single job with a task for each database to be backed up to a local directory of your choice.

By Barbara Darrow – If you don’t like the latest RTM date for Microsoft Windows Server 2003, wait a minute. The latest target date to start duping disks is now March 28, sources close to Microsoft said. A company insider also confirmed that this is the latest proposed release-to-manufacturing

By Michael Otey – One of the most dangerous system attacks–SQL Injection–is code-based, and defending against it falls squarely on the application developer’s shoulders.

By Lisa Vaas – Microsoft Corp. has consolidated the database security tools that shield SQL Server 2000 and MSDE 2000 installations from the Slammer worm. SQL Server 2000 SQL Scan, SQL Check and SQL Critical Update are now available in a single download, the SQL Critical Update Kit, which can be dow

By Alexander Chigrik – Should you have problems installing SQL Server 2000, review this troubleshooting checklist to find potential solutions.

In this article, Steven Heyvaert shares some of the SQL Server CE knowledge he has gained implementing SQL Server CE into his eVB application. In addition to the code snippets covering a variety of routine CE database access scenarios, there is also code to fill a grid with a CE recordset.

I get different results when I use the sp_depends system stored procedure to display my database object dependencies instead of using the Display Dependencies window in SQL Server Enterprise Manager. Why?

By Jeremy Kadlec – This article is the first of a multi-part series detailing the SQL Server upgrade process from the technical, logistical and business perspective.

by D. Britton Johnston – The business application architecture many companies use is as archaic as the decades old centralized mainframe model. Companies would be better served by a decentralized architecture in which their applications and databases are distributed across regional locations and loc