In some cases, you can avoid repeating identical data fields by using internal references from one field to another. Uche Ogbuji demonstrates how in this tip.
Author: SSWUG Research
JCP Watch: Business Processes, More XML Support and Enhanced Java Platform Support on Small Devices
By Apu Shah – This week, new specifications providing Java with business process integration and workflow API’s were proposed along with a proposal for the next generation of the Java API’s for XML Processing. In addition, the Executive committee for the Java Mobile Edition platform approved the fin
SQL Server Security Audit and Performance Review
ClearData Consulting offers a one-day audit of your Microsoft SQL Servers to ensure secure, efficient systems. Our consultants will come on-site to monitor your system, perform system tests and interview your staff to look for possible ways to improve in the following areas:
Getting the last row from a table
by Sunil Bhola – Everyone knows that how to get the first row from a table but what if you want to get the last row and don’t know how many rows are in the table? This query will solve it!
Microsoft Gets Serious About Systems Management
By Barbara Darrow – The upcoming Microsoft System Center will meld capabilities to be offered by the company’s upcoming Systems Management Server 2003 and Microsoft Operations Manager 2004 into an enterprise-ready systems management suite, executives said Monday.<Br><br>MOM 2004 will also provide ne
Why Use SOAP?
by Frank Sommers – SOAP (Simple Object Access Protocol) has become synonymous with XML- based Web services. However, many real-world response-request-type Web services don’t use SOAP; instead, they pass XML messages directly over HTTP. This article discusses these two Web service design approaches.
XML and Integration
By Hitesh Seth – To appreciate the value that XML brings to integration, I decided to talk with leading integration software providers who have used XML in various incarnations (a.k.a. markups) within their products and have extensively leveraged the benefits of XML.
Return Prewritten WSDL
by Kevin Jones – Writing Web Services Description Language (WSDL) can be a chore because of its complexity and tediousness—not to mention the error-prone tools for writing it. See how to return dynamic WSDL automatically.
How to Acquire Lock without Handling Exceptions
by T.R. Bharath Rajkumar – Normally I use FOR UPDATE NOWAIT to acquire a lock on rows. This statement either locks all the selected rows or the control is returned without acquiring any lock (i.e. even on rows which are available for locking) after throwing an exception.But there is an featu
Extend the reach of SQL Server with SQLXML Classes in .NET
by S. Vikram – The term SQLXML is used to denote the XML features supported in SQL Server 2000 in .NET. These new XML features extend the reach of SQL Server, and their effects on the database developer are minimal. The classes in the Microsoft.Data.SqlXml namespace are referred to as the SQLXML-man