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
Other News
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
Satisfy Your Users with Views
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.
SQLXML 3.0 and .Net Leverage Web Services
by Randy Holloway – Learn how to use SQLXML 3.0 and its managed classes in .Net to extend Web services’ functionality with SQL Server.
Debate foams over SOAP 1.2
By Tom Sullivan – AS THE WORLD Wide Web Consortium (W3C) works to add the finishing touches on SOAP (Simple Object Access Protocol) 1.2, debate is heating up over Web services interoperability and SOAP's future in the Web.
Set an XSL style sheet based on XML content
By Nicholas Chase – Using Extensible Stylesheet Language Transformations (XSLT) is often the easiest way to transform your XML data from one form into another, as it allows you a great deal of flexibility without having to change an application. On occasion, however, you may run into a snag because
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
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
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.
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.