(Ken Henderson) SQLXML provides managed code classes that allow you to retrieve XML data from SQL Server (you can translate the data to XML on the server or at the client). These classes have analogues in the .NET Framework itself but are more geared toward SQLXML and exposing its unique functionali
Other News
How to add an icon to your component
(Darren Green) When developing your own custom components for that more professional, and also practical, finish you may want to use your own icon rather than relying on the default system icon. You set this through the IconResource property of the appropriate component attribute; DtsTask for a cont
Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Segregating DISTINCT COUNT
(William E. Pearson, III) In this article, we will continue the examination of distinct counts we began in our previous article, Considering DISTINCT COUNT. Having discussed why distinct counts are useful, and often required, within the design of robust analysis and reporting applications, we descri
ASP.NET 2.0 Databinding
(Jesse Liberty) In ASP.NET 2.0, a great deal of the ADO.NET object model has been incorporated into controls that let you interact with data declaratively, and that spare you from writing boilerplate code to create data sets, extract tables, bind tables or views to controls, and so forth. In this ar
IBM puts some thought into DB2
(Sean McCown) With the latest release of DB2, IBM is poised to reshape the database landscape. Big Blue speaks very proudly and boldly about its new adaptive technology. In Version 8.2, IBM has realized some of the promise adaptive technology has to offer, but the company still has a way to go befor
Fast Tracking Continuous Data Protection and Recovery
(John Wernke) Busy corporate IT managers invented or inherited backup practices that are now well established. Pressure grows, however, with every application failure or even full-scale disaster teaching us the real value of protecting data resources is totally strategic. Managers face hours of work
Oracle Prepared to Drop PeopleSoft Bid
(Roy Mark) Oracle will drop its efforts to block PeopleSoft’s defense to Oracle’s hostile takeover bid if PeopleSoft’s shareholders fail to tender a majority of their shares by Nov. 19, according to an Oracle letter sent to a Delaware court. The development could lead to Oracle abandoning its ho
Handling CLOBs – Made easy with Oracle JDBC 10g
JDBC (Java Database Connectivity) is a standard Java interface for connecting from Java to relational databases. The JDBC standard was defined by Sun Microsystems, allowing independent providers to implement and extend the standard with their own. In addition to supporting the standard JDBC API,
Recording every change made in a database
(Craig Mullins) We are building a new database (UDB v8) and our users have asked us, the DBAs, if it is possible to record every change made in the database in a logging table. This logging table would contain the following fields : an identity column, the table creator, the table name, the column n
Writing Managed Code for SQL Server 2005 Using Visual Studio 2005
SQL Server 2005 allows users to write managed code that runs on the server. Visual Studio 2005 makes it easy to build stored procedures, functions, triggers, data types and aggregates in managed code. Milind Lele shows how to create, deploy, and debug a user defined data type (UDT) in Visual Basic.