These complimentary Chat with the Lab programs are brought to you by a combination of the Business Intelligence Best Practices Team and The Toronto and Santa Teresa Labs. Download one or all of the chats at no charge! Chat is a technical program designed for DBAs, system administrators and architect
Other News
Simple Object Persistence with the db4o Object Database
(Jim Paterson) Many Java applications need to deal with persistent data. In most cases, this means interfacing with a relational database, possibly a legacy database or an industry standard Database Management System (DBMS). The JDBC API and drivers for most database systems provide a standard way o
Adding Subqueries to MySQL, or What Does it Take to Have a Decision-Support Engine?
(Antonio Badia, Matt Chanda and Bin Cao) MySQL is an OLTP system without the ability to handle SQL subqueries. As part of our project in query optimization, we add subquery processing to MySQL through rewriting. First, we incorporate the ability to handle subqueries in the FROM clause; then rewr
64-Bit .NET Framework
The 64-bit version of the .NET Framework 2.0 enables the .NET Framework platform, tools and applications to run on 64-bit workstations and servers which provide increased performance and scalability by addressing more memory (16 TB vs. 4G), processing more data (64 vs. 32 bits) per clock cycle and p
Update MSMQ from SQL
(Bruce Johnson) One of the problems that we recently faced was the need to post a message to MSMQ when the data in a SQL table was changed. An extensive search of the various resources that we have led us to this solution. And, although it seems to be complicated, it appears to be the only way, at t
Full Text Search on SQL 2000 Part 1
(Don Schlichting) Full Text Searching is a free, optional component of MS SQL 2000. When installed, it offers a vast array of additional string querying abilities. Full Text Searching allows for string comparisons similar to internet search engines, returning both results and a matching score or wei
Use DIME to send files to Web services
(Phillip Perkins) SOAP makes provisions for sending binary files across the transport protocol by encoding the binary data with base64 and attaching the encoded data to the SOAP message.
Suppress Repeating Groups Using RANK (not ROWNUM)
(Mohammad Anwar) This tip achieves the same output as the Tip for Week of August 23, 2004. In that tip, the author uses ROWNUM and inline views, whereas I use the analytic function RANK() to do the job.
Using XML with XML DB and ODP.NET
(Mark A. Williams) Many developers already realize, and many more are beginning to realize, the powerful duo formed by the Oracle Database in conjunction with .NET applications. One of the many powerful features of the Oracle Database is its ability to work with XML. Using the Oracle Data Provid
Best Kept Secrets in .NET (Chapter excerpts)
(Deborah Kurata) Author Deborah Kurata has spoken to .NET user groups all over America sharing her “Best Kept Secrets in .NET,” and she often hears experienced developers say, “I didn’t know you could do that with .NET!” This book is a collection of Deborah’s insights into .NET secrets that can enha