(Thiru Thangarathinam) With the introduction of C# 3.0, Microsoft has released a number of features that greatly enhance the object oriented programming experience of C# developers. These new features enable you to declare and instantiate objects with a new syntax that is not only intuitive but also
Other News
Increase productivity in Java database development with new IBM pureQuery tools, Part 4: Tour Data Studio and pureQuery for Informix databases
(Sonali Surange and Mark Jamison) Take a complete tour of Data Studio and pureQuery using Informix databases. Learn everything you ever wanted to know about working with your database and building applications in Data Studio within 40 minutes. (R)
SQL Server 2008 XML: XQuery Enhancements
(Stephen Forte) Continuing our discussion of XML in SQL Server 2008, SQL Server 2005 alowed us to use XQuery to query XML data in an XML data type. You can use the FLWOR statements of for, where, order by, and retun, but not LET. SQL Server 2008 now has support for LET, which is used to assign valu
7 ways to do Performance Optimization of an ASP.NET 3.5 Web 2.0 portal
(Tanzim Saqib) This article explores some of the key performance issues that can occur while developing a Web 2.0 portal using server side multithreading and caching. It also demonstrates model driven application development using Windows Workflow Foundation.
Cascading in Oracle: Friend or Foe?
(Steve Callan) Cascade is one of those clauses (or keywords) which seems to permeate many areas within the Oracle RDBMS. Generally speaking, when an event or action includes a cascade clause, the intent is that good things will follow. Good things, in this context, means that extra work will be done
Comparing 32-bit/64-bit MySQL on OpenSolaris
(Martin MC Brown) I’ve been working with the folks working on OpenSolaris for a few months now providing advice and input on getting MySQL and the connectors (C/ODBC and C/J) installed as a standard component. Having got the basics in, the team are now looking at adding both 32-bit and 64-bit packag
Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances
(Mike Wachal) I’ve gotten a number of questions recently asking how SQL Express uses resources during idle time, and how that behavior impacts the way SQL Express behaves “on first connection” after being idle for a period of time. While many of these questions have been related to web hosting, the
Index Compression Part III (2+2=5)
(Richard Foote) As previously discussed, compression is only beneficial when the compressed columns have repeated values within an index leaf block. If a compressed column has repeated values, Oracle will basically store the one copy of the compressed column (or columns) as a prefix entry within a l
How to setup linked servers for SQL Server and Oracle 64 bit client
(Tim Ford) We have two SQL 2005 64-bit clusters in our organization: a four-node production cluster and a two-node dev/test cluster. We recently migrated a database from SQL 2000 that relied on an Oracle linked server for some of it’s computations. No big deal, right? Install the Oracle client s
Writing Outer Joins in T-SQL
(Kathi Kellenberger) Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article e