Ever wonder what a DBA does? Ever had someone ask you what your job entails? Here’s an overview of what a DBA does. Reader feedback will be used to update this article over time.
Other News
The Practical SQL Handbook
If you are like most visitors to this website, you have a strong interest in SQL Server, and most likely, Transact-SQL. As you probably know, Transact-SQL is a superset of the ANSI SQL standard. Code written in ANSI SQL will run under SQL Server, and on any relational database that also supports ANS
Fundamentals of SQL Server 2000 Architecture
Microsoft® SQL Server™ 2000 is a family of products that meet the data storage requirements of the largest data processing systems and commercial Web sites, yet at the same time can provide easy-to-use data storage services to an individual or small business. The data storage needs of a moder
Achieve greater flexibility and convenience with XSLT
In this detailed tip, Benoit Marchal explains how SAXTransformerFactory — a class that feeds SAX events directly in an XSLT processor — buys you greater flexibility when you save XML files. Several reusable Java code samples demonstrate the techniques, which require TrAX.
A New Old Angle on XML
by Edd Dumbill – One of the things that has made XML famous is the angle bracket; the pleasing symmetry of the opened and the closed. Angle brackets are key to the particular strength of XML, a uniform and universally agreed syntax. It is hardly surprising, then, that the angle bracket
FOP wraps Batik
The latest version of the Apache XML Project's XSL Formatting Objects processor, FOP, incorporates the Batik SVG renderer. This gives FOP much improved support for rendering SVG diagrams. FOP is a print formatter capable of processing XSL-FO and creating PDF files. Other improvements in t
SQL Insider Freeware Software to Become Openware
Robert Vallee has announced that he will release the source code to SQL Insider early to September 15th. On that date, members will be able to download the source code and make modifications to the program.
ALS Microsoft® SQL Server™ 2000 System Administration
Developed for academic courses, MICROSOFT® SQL SERVER™ 2000 SYSTEM ADMINISTRATION helps students build the skills they need on the job and for MCP Exam 70-228—an elective on the Windows® 2000 MCSE track. The textbook delivers Microsoft courseware adaptable for either a full 16-week semester or a 6-w
XQuery/XPath 2.0 Functions, Operators draft
The draft, "produced through the efforts of a joint task force of the W3C XML Query Working Group and the W3C XML Schema Working Group and a second joint task force of the W3C XML Query Working Group and the W3C XSL Working Group", describes how to process type information specified by W3C X
Writing XML Providers for Microsoft .NET
By Aaron Skonnard – In retrospect, it seems obvious that OLE DB would never become a true universal standard for exposing and accessing information because it faced competition from other vendors. Since OLE DB is a COM technology and COM itself never became universally supported across platforms, it