by Tom O’Neill – You give so much to your database . . . sometimes you just want something back. What do you give your database? Plenty. You give it new records (INSERT). You give it changes to existing records (UPDATE/DELETE). Every now and then, you just look around (SELECT). When you do these th

Microsoft announced on its Web site recently that the new Windows 2003 exams currently under development can be used to fulfill the core networking requirements of the Microsoft Certified Database Administrator (MCDBA) on SQL Server 2000 credential.

By Dan Farber – MySQL AB had just $5 million in revenues last year, but company CEO Marten Mickos gives off the impression that his company could become the next Red Hat or Oracle. Is he serious or just hyping the open source database? I spoke with Mickos about his notion of a “commodity” database a

xCase (RESolution, Ltd.) is a desktop data-modeling software package that has developed into a very useful, yet cost-effective, tool for everyday database design and maintenance in Microsoft SQL Server, Oracle, Sybase, Visual FoxPro, Jet, or many other database platforms. Dan LeClair reviews the rec

To prevent data corruption, SQL Server does not support the rollback of individual transactions. For example, suppose that two transactions, T1 and T2, use a cash balance field. T1 adds $500 U.S., and T2 makes a change by using that new value. If you roll back T1, T2 might be wrong. However, you can

Superior SQL Builder is different from anything you have seen before. It introduces a new way to cleanse, convert and transform data and is unmatched in its ability to build SQL scripts of any size, type or complexity. Once you understand how to use Superior SQL Builder (it is easy) you will

by Randy Dyess – MssqlXpress is a small tool that goes a long way in replacing the old standby that many of us use every day: Query Analyzer. While the developers have not recreated all the functionality of Query Analyzer yet–they still need to create execution plans before mssqlXpress will replace

Download the Microsoft SQL Server 2000 Web Services Toolkit to get tools, code samples, white papers, and SQLXML 3.0—everything you need to build XML Web services and Web applications with SQL Server 2000.

This script the full version of an example script for my article Is a Temporary Table Really Necessary? and will loop through all databases obtain the user tables in the database and perform an action on each of those tables (in this case sp_spaceused) without the use of a cursor or an undocumented

By Brian Moran – Thinking about an unscheduled reboot, just for the heck of it? Forget about it. Microsoft is always looking for ways to improve SQL Server so that customers can achieve higher levels of availabilty.