(Russell Butek) Gain a thorough understanding of how WSDL maps to SOAP. Under normal circumstances, you don’t have to worry about namespaces in the SOAP message. But there are times when you must. This tip prepares you for those times when you have to create your SOAP message by hand and deal wi
Other News
FIX: An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000
In Microsoft SQL Server 2000, an access violation may occur that may cause the SQL Server process to exit. You experience this problem when you run a SELECT query and all the following conditions are true: • The NO_BROWSETABLE option is set to ON. • You use a SELECT statement that includes an i
Microsoft’s Lineup of SQL Server Related Webcasts
Thirty-six new webcasts are Scheduled for June, covering such topics as Advanced Report Authoring, Analysis Services, Data Warehousing Enhancements in SQL Server 2005 and more.
Inferring Schemas from Well-Formed XML Documents with Whidbey Beta 2
(Radhakrishnan Srikanth) This article explains how to infer and tune schemas starting from XML documents. The Microsoft Visual Studio 2005 Beta 2 release of the System.XML Schema Inference API is used to illustrate how to automatically infer a schema from an XML instance document.
Maintain federated data using WebSphere Information Integrator autonomic monitoring tools
(Farnaz Erfan) Learn how IBM WebSphere Information Integrator’s automatic health monitoring capabilities can help you meet the challenges of maintaining semantic consistency in the federated database environment. This article introduces federated concepts and then describes how the health monitoring
Modernizing Legacy Systems: It’s Easier than You Think
(Jack Stellrecht) That noble goal of software engineering, software reuse, proves elusive when it comes to legacy business systems. To achieve this modern characteristic, legacy systems typically require redesign and reimplementation. But that need not be the case.
Replacing an MSMQ queue with a SQL Server 2005 queue
(Rushi Desai) Today, we did a short presentation on Service Broker for a customer who is interested in using the Service Broker technology. Their current application uses a large backend SQL Server database that is accessed from several mid-tier servers. In one of their scenarios, requests are queue
BUG: You receive a ‘Failed to find property in cache: InstalledInstances. failed to perform discovery on machine’ error message when you try to install SQL Server 2000 Reporting Services
When you try to install Microsoft SQL Server 2000 Reporting Services, you receive an error message that is similar to the following: Failed to find property in cache: InstalledInstances. failed to perform discovery on machine:ComputerName.
Report on Redo Log Contention
(Jeffrey Hunter) This script is used to report on overall redo log contention for the instance since the instance was last started. (script)
XPath Querying Over DataSets with the DataSetNavigator
(Arpan Desai) The XmlDataDocument was originally envisioned as a component which allowed users to have an editable, hierarchical view of Microsoft ADO.NET DataSet data. The main use case has been the ability to perform an XSLT transformation over a DataSet in order to generate HTML for presentation