(Mike Gunderloy) SQL Server 2000 has hundreds of advances over SQL Server 7.0. Though it’s been out for a few years now, developers can be pardoned if they still haven’t found time to dig into all of the changed areas; there are just so many of them, and we’ve all got work to do. But it’s worth find
Other News
Oracle Tip: Put some magic into your database
(Scott Stephens) The UNIX command file attempts to identify a file type based on bytes in a file rather than on the file extension. For example, every GIF file starts with the letters GIF, and every JPEG file begins with the value 0xffd8 in big-endian order. (R)
Querying XML Data with XQuery
(Scott Mitchell) Let’s face it, one of the primary tasks we, as Web developers, are faced with is querying data from some data store and allowing users to view and/or manipulate the information via a Web interface. Typically, the data stores that we query from are traditional relational databases, l
Reading BLOBs from SQL Server and display it in a Windows Form PictureBox
It’s common for modern databases to contain large binary objects, more commonly referred to as BLOB’s (Binary Large Objects). BLOBs are typically graphical images such as photos contained in .bmp, .jpg or .tif files. Although the database is fully capable of storing BLOB data, the potential size of
An XBRL Tagset for XML
This tagset works with the Output Delivery System (ODS) and PROC PRINT, or with the LIBNAME engine. Using ODS is the simplest way. The prerequisite is that you have two data sets: one with the XML document’s metadata, and one with the all of the items. See the PROC PRINT output of an example.
Visual Basic .NET for Beginners
To this point, I’ve tried hard to stick with examples and code that can be run as a Console Application so you could use a simple and free text editor to create your VB.NET programs and compile them with the free compiler in the .NET Framework SDK. It’s a great way to learn .NET. But after a while,
XML Schema: Understanding Datatypes
(Rahul Srivastava) The W3C XML Schema Datatype Specification defines numerous datatypes for validating the element content and the attribute value. These datatypes can be used to validate only the scalar content of elements, and not the non-scalar or mixed content. The text enclosed between the
MySQL Administrator
(Russell J.T. Dyer) For many MySQL developers, database administration is something that they know little about and, as a result, they avoid. To make MySQL administrative tasks easier, MySQL AB has developed a new graphical user interface to the MySQL server. It’s called simply and appropriately, “M
Understanding Hash Joins
The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so that the smaller of the two inputs is the build input. Hash joins are used for many types of set-matching operations: inner join; left, right, and full outer join; left and right semi-join; i
IBM Opens Up Its Digital Asset Framework
IBM has updated and renamed its Digital Media Factory — software for creating, managing and distributing rich media. Dubbed the Digital Media Framework, the software lets users plug in legacy applications alongside the latest streaming media technology. IBM DB2 Content Manager functions as a con