(Gavin Powell and Carol McCullough-Dieter) This chapter takes a bird’s-eye view of Oracle SQL changes in both Oracle Database 10g and Oracle Database 9i. Without further ado, let’s get started with Oracle Database 10g. (pdf)
Other News
PRB: SQL Distributed Query with Oracle NUMERIC Column Gives Error
Attempting to use an Oracle linked server using the MSDAORA OLE DB provider, which queries a table with a NUMERIC column, may give an error similar to the following: Server: Msg 7354, Level 16, State 1, Line 1 OLE DB provider ‘MSDAORA’ supplied invalid metadata for column ‘columnname’. The data
Synchronizing on Demand
(Gary Zaika) After the World Trade Center attacks of September 11, 2001, many organizations reconsidered how they manage and protect crucial business data. Having a remote data center with a second set of databases and application servers has become a common practice. Businesses have been willin
Creating a Custom XML Editor in ColdFusion
(Kelly Brown) It’s almost impossible to pick up a trade magazine these days and not find a reference to XML. It’s an important enabling technology for the sophisticated Web applications of the future.
C# to Get Edit-and-Continue in VS 2005
(A. Russell Jones) S. “Soma” Somasegar, Microsoft’s corporate vice president for the developer division, made the unexpected announcement, via his official MSDN-hosted Web log (http://blogs.msdn.com/somasegar/), that C# will get the much-loved edit-and-continue (E&C) feature in Visual Studio 2005. W
Better, Faster XML Processing with VTD-XML
(Jimmy Zhang) VTD-XML is a new, open-source, non-validating, non-extractive XML processing API written in Java. Different from current XML processing technologies, VTD-XML is designed to be random-access capable without incurring excessive resource overhead. One key optimization of VTD-XML is no
Taking on the ACID Test
(Christopher Byrne) In the last article, I talked about the introduction of DB2 as an optional back-end data store in Lotus Notes & Domino 7. This discussion centered on what the new threats and vulnerabilities are that need to be recognized by application developers, what information systems au
Business Intelligence with Microsoft SQL Server Reporting Services – Part 1
(Adnan Masood) Business Intelligence is a thriving discipline in the marvelous era of computing we live in. It’s the process of analyzing and exploring the information, trends and patterns hidden in data. BI escalates the business roadmap and facilitates business users to deliver better strategic so
Review: MyLittleAdmin
(Anthony Wilko) In the web hosting world there’s rarely a “Holy Grail” in software. With all the choices available these days the software starts to blend together and it gets hard to discern which software is really better than the rest. Is MyLittleAdmin the tool that can make a difference in a
SQL 2005 Service Manager
(Jasper Smith) With the lack of an equivalent in SQL2005 for the SQL Server Service Manager that comes with SQL2000, I’ve decided to write one myself using C# and SMO. The download in this article is the first beta of SQL2005 Service Manager. There are a number of known issues with it currently