Rather than choosing the prevalent cumbersome format of a 1000+ page bible with pointless appendixes, a slim padded envelope revealed a 440 page book, thinner than my ThinkPad. The appendixes are real case studies, not XML references or Javadoc printouts. A first look at the Table of Contents shows
Author: SSWUG Research
Choosing the Right Web Services Management Platform
When you deploy any application, you are expected to have a plan for management and maintenance of that codebase: That’s part of the job. But developers have been so busy learning Web services that management issues have taken a back seat. Use these requirements as a checklist for investigating prod
Browsing OS files from TOAD or SQL*Plus
By Jim Leask – This tip describes the process required to browse operating system (OS) files from a PC application like TOAD or SQL*PLUS. This process will be useful for browsing the Oracle alert log when access via the OS is restricted. It will only work on Oracle version 8.1.6 and above.
External Tables in Oracle 9i
Learn how to run any SQL query against external data without requiring that the external data first be loaded into the database.
Slammer report: More headaches
By Robert Lemos – After a round-the-clock weekend watch for any infection of the so-called SQL Slammer worm–also know as Sapphire and SQL Hell–that hammered other companies’ networks, the software maker apparently had escaped with only minor incidents in its international offices. Until Tue
Past, Present, and Future
Michael Otey revisits SQL Server’s six major releases, then looks to the future and the upcoming Yukon release.
Design a Custom Paging Solution
by Brett Olges and Doug Safford – Turbocharge paging through large datasets in your Web apps’ list screens with ASP.NET’s DataGrid control.
Coding an Owner Prefix to Avoid Recompilation
A sentence in SQL Server Magazine’s June 2001 “Answers from Microsoft” column caught my eye: “Recompilations might be the source of the slower stored procedure speed.” The column recommended coding the owner prefix on all reference tables, views, and procedures. Should I incorporate this step into m
Are PIs deprecated?
Jeni Tennison reopens the debate about Processing Instructions (PIs) on xml-dev by proposing to define guidelines for using them.
The Crux of SOAP Encryption
by Dan Wahlin – You can use .Net classes to create a custom Simple Object Access Protocol (SOAP) encryption application to protect sensitive information sent from a client to a Web service. The application relies on public and private keys for the encryption and decryption of SOAP messages. It also