(Jagadish Chaterjee) This article is the second one in a series focusing on developing a simple DAL (Data Access Layer) for any database using ADO.NET. In this series, we consider Sybase as the database of choice for developing the DAL.
Author: SSWUG Research
SQL Server 2005 Application Performance Management
Want to optimize your applications that run on SQL Server? Then take advantage of Symantec’s offer for free SQL Server 2005 Application Performance Management whitepapers in eBook format, and get an in-depth education. (R)
MySQL Tables
A MySQL table is completely different than the normal table that you eat dinner on. In MySQL and other database systems, the goal is to store information in an orderly fashion. The table gets this done by making the table up of columns and rows.
Thinking XML: State of the Art in XML Modeling
(Uche Ogbuji) The running theme of the column has been semantic transparency: the ability to correctly interpret the contents of XML documents. Semantic transparency might be the most important aspect of XML modeling. This is first in a series of articles that review the many different approaches to
The Move to Store Images In the Database
(Marcel Kratochvil) As the business imperative grows for companies to start managing and then publishing their digital image assets. the issue about where those image assets are stored is raised. The initial choice is to store them in a disk file system. This can be seen as the quickest and simplest
Recommended reading list: DB2 UDB for Linux, UNIX, and Windows application development
(Cindy Wong and Samuel Poon) This article provides a list of DB2 UDB for Linux, UNIX, and Windows application development materials available on the Internet. The DB2 UDB Information Center is also a good source of information. Many of the items listed below are published as articles on IBM develope
Server-Side Asynchronous Methods for ASP.NET and WinFX
(Karl M. Hulme) The purpose of this article is to demonstrate how to expose a method from an ASP.NET Web Service or WinFX Service that uses the asynchronous pattern internally, to increase the scalability of the service. Specifically, how to prevent the threads that are being used to service request
Undocumented DBCC: Report on settings with DBCC RESOURCE
(Serdar Yegulalp) Among undocumented DBCC commands in SQL Server, DBCC RESOURCE is one of the few that can be used to report back on SQL Server’s own internal settings rather than reports on detailed information about data structures within SQL Server (such as tables, databases, indexes, etc.) (R)
Closed World Assumptions, Conjunctive Querying, and Oracle 10g
(chimezie) I promised myself I would write at least one entry related to my experience at the 2006 Semantic Technology Conference here in San Jose, which has been an incredibly well attended and organized conference. I’ve found myself wanting to do less talking and more problem solving lately, but I
PostgreSQL and XML
(Tom Dyson) I’m been feeling mildly guilty about not publishing the work I did with John Gray last year on XPath support in PostgreSQL, but the interest in Jon Udell’s ‘SQL and XPath’ post has goaded me into action: here’s a brief outline of the four production-ready XPath functions which represent