To help you design Microsoft database servers that must achieve the best possible performance, Inside Microsoft SQL Server 2000 has the details you need. For one thing, author Kalen Delaney (who used Ron Soukup’s fantastic first edition as a starting point) explains how SQL Server 2000 works at a le
Author: SSWUG Research
MYdbPAL for SQL Server Offers a Wealth of Tools, Power, and Flexibility
by Brad M. McGehee – SQL Server includes many built-in tools for the DBA, database designer, and database developer. Enterprise Manager, Query Analyzer, DTS, and other tools provide a wide array of functionality. If you are a beginner, you may find these tools a little overwhelming, but as you gain
Database Power Play
By Matt Hicks – A few years ago, Green Mountain Power Corp. found itself in an all-too-common predicament as it examined the state of its database systems. It had multiple systems running on multiple operating systems, spread across the company supporting specific enterprise applications. It
Designing Databases for Extreme Performance
By Brian Moran – Avoid performance-tuning mistakes and design a database that can handle unpredictable future demands for extreme performance and scalability.
Server System Architecture, 2002
by Joe Chang – Learn about the various chipsets, and their pros and cons, available for your SQL Server.
Demand Isn’t High For Database Software
By Rick Whiting – The demand for database software will remain low for the near term, according to a recent survey of more than 600 business-technology professionals conducted by InformationWeek and Morgan Stanley Dean Witter. Nearly three out of four respondents have no immediate plans to buy datab
PyXML 0.8 released
Version 0.8 of the Python/XML supplementary distribution has been released. Major changes include addition of DOM Level 3 (WD) load/store and dropping of Python 1.5 support.
Sybase Retools PowerBuilder for Web Services
By Darryl K. Taft – Sybase Inc. is ramping up the support for XML and Web services in the beta versions of its PowerBuilder rapid application development tool. The beta version of PowerBuilder 9.0, announced Monday at Sybase’s TechWave 2002 user and developer conference in San Diego, includes
Supporting Digital Signatures Within SOAP Messages
by Brenda Coulson – Historically, digital signatures have handled the job of data validation and encryption in Web services. But new developments in XML specifications are improving security in SOAP messaging. Get the details on the specification changes and find out how to use them to enhance Web s
Metadata API in Oracle 9i
By Srinivas Chittimalla – It is quite difficult to get metadata out of Oracle 8i and earlier versions.<br><br>However, in Oracle 9i, a new package was introduced: DBMS_METADATA. It allows users to get metadata information about any object (tables, indexes, procedures, etc) from a data dictionary wit