by Alexander Chigrik – In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 and 2000 for administering and monitoring. DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to ch

Quest Software, Inc., a leading provider of application management solutions, announced its acquisition of RevealNet, Inc., the industry leader in knowledge-based solutions for Oracle and DB2. This acquisition allows Quest Software to significantly enhance its database development and management sol

What skills do you need to be a DBA? Lots of different ones, but people often forget there are non-technical skills that matter. This article by David Poole examines some of the softer skills that can help your career.

If you have a large quantity of data in your back-end Microsoft SQL Server database, it can be resource-intensive to have every Microsoft Windows CE device download all of the data by using a replication synchronization process. You can “prebuild” a Microsoft SQL Server CE copy of the database, and

Microsoft® SQL Server™ 2000 was named the overall winner in the database software category in this year’s VARBusiness Annual Report Card (ARC). The VARBusiness ARC is the most significant annual benchmark of the industry’s solution provider and vendor relationship. It measures the overall lev

New Riders released “XML and SQL Server 2000” in july. Now you can download chapter 4 “Accessing SQL 2000 via HTTP” for free.

By Kalen Delaney – The SQL Server Trace tool lets you keep track of all the operations that SQL Server performs. For SQL Server 7.0, Microsoft completely rewrote the Trace tool. Microsoft dubbed the new incarnation SQL Server Profiler. However, the SQL Server 7.0 documentation never made it complete

Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management capabilities to devices. SQL Server CE has the familiar feel of SQL Server, with tools, application programming interfaces (APIs), and Tran

by Brad M. McGehee – Writing complex client/server or n-tier applications, using SQL Server as the backend database, can be very difficult, very frustrating, and very expensive. In fact, have you ever seen such a project be completed on time and on budget? Those projects are rare indeed. Ther

By Itzik Ben-Gan – SQL Server 2000 Profiler is an invaluable investigative tool that lets you measure query performance, debug applications, diagnose problems, and replay saved traces. Profiler provides the client-side functionality—the GUI—that lets you define and run traces from the client against