By Joe Lax – In this 10-Minute Solution I will cover some of the basics of views and show you how to use them to solve thee two issues I raised above. My examples are based on the sample pubs database that works with SQL Server 7 and SQL Server 2000.
Author: SSWUG Research
Auditing Your SQL Server Environment Part II
(Randy Dyess) Roles should be in foremost in your mind when planning the security of your SQL Server environments. Auditing inherited SQL Server installations is a relatively easy thing to accomplish and all DBAs should audit their environment and create documentation if they have not already done s
Best-Practices Road Map for Installing Oracle9i Database
By Ankit Patel – Oracle Support Services (OSS) performs detailed root-cause analysis on the install issues reported by customers and documents the results in a knowledgebase to ensure that the information is shared. This article provides installation best practices to help you quickly and easily ins
Eric van der Vlist on W3C XML Schema
Eric van der Vlist, a regular contributor to XML.com, has just completed writing XML Schema: The W3C's Object-Oriented Descriptions for XML for O'Reilly, to be published in June 2002. In this interview he explains the importance of XML schema languages, and his motivations for writing the bo
Specializing domains in DITA
By Erik Hennum – In current approaches, DTDs are static. As a result, DTD designers try to cover every contingency and, when this effort fails, users have to force their information to fit existing types. The Darwin Information Typing Architecture (DITA) changes this situation by giving information
IBM Web Services Guru Predicts WSDL Future
By Gavin Clarke – If you think the alphabet soup of web services acronyms is bad – with SOAP, WSDL, UDDI, WS-Security and WS-Routing to name but a few – then hold on to your spoon. Things are going to get much, much worse.IBM's director of e-business standards Bob Sutor, predicts between
Generate Custom Crosstab Reports
by Roger Jennings – Filling elements in a crosstab array solves the missing value problem with SQL Server aggregate queries and executes muy pronto.
Charting your certification course
By Jonathan Lurie – Certification demands a great deal of time and money, so you want to be careful about the accreditations you pursue. Before you register for one of those costly immersion courses, let me tell you which certification investments have worked for me.
RBS monitor to catch ORA-1555 errors
By Ofer Harel – One of the most vexing errors in Oracle is this one:ORA-1555: snapshot too old: rollback segment number 9 with name “R07” too small.What causes this error? Oracle fails to return a consistent set of results (often called a snapshot) for a long-running query. This occu
Filling in the DTD Gaps with Schematron
by Bob DuCharme – One nice thing about Schematron is its ability to work as an adjunct to the others, including DTDs, so you don't have to leave DTDs behind to take advantage of Schematron. To use Schematron in combination with RELAX NG, Sun's msv validator has an add-on library that lets yo