by Roger Jennings – Replace disconnected recordsets with XML updategrams for secure Internet and wireless transactions.
Other News
BMC boosts SQL Server database management
By Paul Krill – The SmartDBA tools have a single look and feel across different platforms, thus eliminating the need to employ experts for each database, according to BMC.
Automatic coalesce of all tablespaces
By Max Mangoni – Coalescing tablespace extents is fundamental when the database contains a lot of fragmentated tablespaces. This happens when database objets are often truncated or droppend and re-created. This simple korn shell script helps to automate cleaning of tablespaces.
MSDE and SQL Server
A lot of people are confused about the differences between MSDE 2000 and SQL Server 2000, especially about how MSDE differs from SQL Server 2000 Personal Edition. Michael Otey counts seven important ways that MSDE differs from SQL Server 2000.
Oracle Has SQL Server Beat in Stored Procedure Programming
Oracle9i and SQL Server 2000 add enhancements to the standard SQL language that enable you to use the database to implement your business rules and processes SQL Server with Transact-SQL and Oracle with PL/SQL. Find out why the Oracle database engine is better suited for this role.
Early Adopter VoiceXML Sample Chapter
This book from Wrox Press aims to give the reader an in-depth analysis of the current state of VoiceXML technology. This sample chapter covers VoiceXML with XSLT (HTML and WML).
Using the WSE to Authenticate SOAP Messages with a User Name and Password
This sample application demonstrates one way of authenticating Web Service consumers via username and password. It includes a sample web.config file with the necessary WSE entries, a sample class that implements the IPasswordProvider interface, a test proxy, and other code to show you this SOAP auth
Browser
by John E. Simpson – It’s been a slow month on the O’Reilly Network XML Forum: it’s not easy to write a column answering questions when none have been asked. So, it’s time to dig into the archives, pulling out — this time — a couple of queries about processing XML.
Upgrade to Books Online SP3
Many people don’t realize that a new version of SQL Server 2000 Books Online (BOL) ships with SP3. Here Brian Moran talks about some of the crucial changes that the updates in BOL include.
EXECUTE IMMEDIATE option for Dynamic SQL and PL/SQL
Amar Kumar Padhi shares usage tips and examples of EXECUTE IMMEDIATE, which replaced DBMS_SQL package in Oracle 8i and above.