(Paul Kimmel) Long time no write, kids. Sometimes life throws you a curve, you get whacked, and you take a base. Standing on first a little dazed and confused, it’s good to be writing about something simple and fun: the My feature.
Author: SSWUG Research
Querying the Web Reconsidered: Design Principles for Versatile Web Query Languages
(François Bry, Christoph Koch, Tim Furche, Sebastian Schaffert, Liviu Badea and Sacha Berger) A decade of experience with research proposals as well as standardized query languages for the conventional Web and the recent emergence of query languages for the Semantic Web call for a reconsideration o
Asynchronous Callbacks and Ajax based UI Experience in Web Applications
(Deepak Raghavan) Web applications work on the underlying Http protocol and Http is stateless by nature. It uses the Request – Response pattern between the client and the server, to process the logic at the server and present the information in HTML to the client browser. In the case of long running
Using UNION to implement loose index scan in MySQL
(Peter Zaitsev) One little known fact about MySQL Indexing, however very important for successfull MySQL Performance Optimization is understanding when exactly MySQL is going to use index and how it is going to do them.
Formatting XML by Using XSLT
(Steve Holzner) Previously you saw that you can use CSS to format XML documents in the major browsers (Internet Explorer and Netscape Navigator). However, there’s a native XML way to format XML documents for display—using Extensible Stylesheet Language Transformations (XSLT), which is what this arti
muSQLe – SQL Server query invocation framework
(Messir) This article shows you an easy and strongly-typed way to invoke queries and stored procedures from your code.
New in SQL 2005 Replication
(Hilary Cotter) It has been over 5 years since the developers at Microsoft started work on the new version of SQL 2005, code named Yukon. Work on Yukon actually began before SQL 2000 was released. There are many changes to Replication in SQL 2005. It is clear that the Replication team at Microsoft h
SQL Server 2005 – DML Usage on an untyped XML column
(Muthusamy Anantha Kumar) DML or Data Manipulation Language is a set of statements used to store, retrieve, modify, and erase data from a database.
Data Warehousing, Part 2: When Worlds Collide
(Andrew K. Burger) As data warehousing continues to take hold as a powerful tool of modern business, developers are hard at work trying to build applications that will move the technology to the next level. Part 1 of this three-part series looks at how some developers are attempting to fuse two see
How does the MIDAW facility improve the performance of FICON channels using DB2 and other workloads?
(Paolo Bruni and Jeffrey Berger) The MIDAW facility was introduced in the IBM z9 processor to improve FICON performance, especially when accessing IBM DB2 databases. This facility is a new method of gathering data into and scattering data from discontinuous storage locations during an I/O operation.