By Daniel Nehren Connecting client-server applications through a firewall is difficult, because usually the only port you've got is the one you use for the Web. Discover how our framework using HTTP tunneling and XML surmounts this obstacle.
Author: SSWUG Research
Performance Tuning Client Side XML in IE
by Mark House With XML fast becoming the lingua franca of the Internet, its use between clients and servers continues to grow. Microsoft has fully committed to XML with their forthcoming .NET platform, and already offer a comprehensive suite of tools to access and manipulate XML on the client and
Writing Dynamic XML Pages
You know a lot about HTML pages dynamically created on the server and then served up to the browser. This is just what the ASP technology lets you do. A problem with this is that the basic language is still HTML and you still use HTML to describe both your data and the way it should be rendered. You
SQL Server CE
New Version Lets You Store and Update Data on Handheld Devices by Paul Yao and David Durant Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Editio
Tame Those Strings – Using SUBSTRING
by Steve Jones I guess I could have called it "String Manipulation", but that was nowhere near as exciting as the other title. Often I find developers performing string manipulation in stored procedures and queries and chastise them for it. Using T-SQL is, IMHO, in general, a poor use of
Fitting Workflow into B2B Architectures
By NICOLAS FARGES Every exchange that comes into play in a Business-to-Business architecture forms part of a business process that can be highly automated using workflow technology. The Gartner Group leaves little room for doubt when it affirms that "By 2003, more than 90% of e-business will
XML for the Absolute Beginner – A Short Tutorial
By Darshan Singh Welcome to the wonderful world of Extensible Markup Language (XML). This short article is an effort to explain what XML is, what are it's benefits, and briefly describe some of standards evolving around it.
XML: The Big Picture
By Ahmad Abualsamid XML was a rising star in 2000, and that trend is going strong this year. While many high-tech media darlings fall victim to standards wars and overblown expectations, XML is one icon that's living up to the hype.
Eliminate the Use of Temporary Tables For HUGE Performance Gains
by Justin Gunther As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM cla
SQL Server and DMO: Distributed Management Objects
(Francesco Balena) SQL Server can be administered programmatically using system stored procedures, but Distributed Management Objects (DMO) offer a more modern, object-oriented alternative. This article introduces SQL-DMO in SQL Server 7.0 and SQL Server 2000 and describes the SQL-DMO object model,