By Vyas Kondreddi – This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourself, if you want to be a point-and-click DBA or a T-SQ
Other News
Testing Database Options in SQL Server 2000
In addition to testing a SQL Server configuration, it can be helpful to test a database’s settings. This article contains a stored procedure you can use to inspect a database and report whether any of its options differ from the default settings of a new SQL Server 2000 installation.
TOAD Pocket Reference for Oracle
Book by Patrick McGrath, Jim McDaniel – The Tool for Oracle Application Developers (TOAD) is a popular graphical user interface for the Oracle database that allows programmers to build, test, debug, and format their code within an interactive development environment. The only book in print for the c
Oracle Navigates Choppy Seas
Faced with diminished demand for its database software, Oracle CEO Larry Ellison is tacking in several directions: Borrow from Microsoft’s high-volume model, mix well with IBM’s outsourcing approach, and set sail. Literally.
Microsoft Turns On SQL Server Notification Services
By Matt Hicks – Microsoft Corp. released a new feature for its SQL Server 2000 database that can generate personalized notifications to a range of devices, including mobile devices.
XML Web Services: Means to an End
By Darryl K. Taft – For the second day in a row at the XML Web Services One conference here, a keynote speaker got up and signaled the impending end to the Web services era, at least on a standards level. Don Box, an architect in Microsoft Corp.’s developer division told an audience of Web se
XML Matters: Roundup of XML editors, Part 1
By David Mertz, Ph.D. – In this two-part series on XML editors, David looks at the progress of commercial tools in the year-and-a-half since he last looked at this tools category. These tools have progressed from largely cosmetic wrappers around text editors to fleshed-out development environments t
ManekiNeko: RELAX NG meets XNI
Andy Clark has recently updated ManekiNeko, his Xerces Native Interface (XNI)-based ‘parser configuration’ for validating XML documents against RELAX NG grammars and accessing information in those documents using standard APIs such as DOM and SAX.
OASIS Forms Technical Committee To Tackle UDDI
By Richard Karpinski – The OASIS standards group this week launched a new technical committee to oversee the development of UDDI, the registry and lookup technology in the Web services software "stack."
Oracle Guide Aims to Clear up Policies
By Matt Hicks – Oracle Corp. on Tuesday will release a promised pricing and licensing guide that company officials hope will help clear up customer confusion of its policies. The guide, called the Oracle Software Investment Guide, offers about 40 pages of details on licensing and pricing poli