(Ben Nadel) A long time ago, I took the jQuery documentation XML off of www.visualjquery.com and converted it into a PDF using a lot of ColdFusion XmlSearch() calls and a ton of ArrayLen() logic. It ended up being a lot of code. Well, now that I have been doing a lot of learning about XSLT in ColdFu
Other News
Programming with XML for DB2, Part 4: Integrate data from different data sources in your Web-based DB2 application
(Hardeep Singh) Walk through the steps for creating a sample IBM DB2 application that uses the XML model to integrate data from different data sources. Learn how to expose your database stored procedures as Web services so that they can be accessed through SOAP calls. Follow a Web-oriented architect
The C# ?? null coalescing operator (and using it with LINQ)
(Scott Guthrie) One of the subtle (but cool) language features of C# is the ?? “null coalescing” operator. This provides a nice, terse way to check whether a value is null, and if so return an alternate value.
Oracle 11g New Features DBMS_ADDM for RAC
(Virag Sharma) In “OCP Oracle Database 10g Exam Guide“ chapter 3 “Automatic Database Management” there is question <!–[endif]–> <!–[if !supportEmptyParas]–> 5. To retrieve the ADDM reports using SQL, what do you need to do? A. Run the addmrpt.sql SQL script B. Use the DBA_ADDM view C. U
ORA-04030 doesn’t always mean you’re running out of RAM
(Rex Baldazo) I maintain an ancient Oracle Reports system, which does a peculiar FTP gyration that recently started giving us errors.
How MySQL Treats Security Vulnerabilities
(Kaj Arnö) The phrase “security vulnerability” gives most of us the creeps. We are afraid of them. Looking at them rationally, they share a trait with other bugs: All are a pain, but some are a bigger pain than others. And instead of trying to avoid the evil by not talking about it, let’s take a loo
SQL Server 2005 Express Edition – Part 6 – Post Installation Configuration Tasks (Encryption)
(Marcin Policht) In the previous installment of our series dedicated to SQL Server 2005 Express Edition, we have reviewed a number of network-based configuration tasks that are typically introduced following the initial setup process. In our new article, we will continue coverage of this topic by de
Moving SQL Server 2005 Databases to SQL Server 2000
(Frank Kerrigan) Moving databases from SQL Server 2005 to SQL Server 2000 is not impossible and can really be quite easy once you come to grips with the basics. Microsoft has made it very easy to move databases from 2000 to 2005 by using backup and restore built into the admin tools, but this is not
Pivots with Dynamic Columns in SQL Server 2005
(Andras) Pivots in SQL Server 2005 can rotate a table, i.e. they can turn rows into columns. PIVOTs are frequently used in reports, and they are reasonably simple to work with. However, I’ve seen quite a few questions about this operator. Most questions were about the column list in the PIVOT statem
SQL Server 2005 Performance Audit : SQL Server Hardware Configuration Checklist
(Brad McGehee) We have to start somewhere and server hardware is as good a place to start as any other audit area. In addition, when many DBAs, or database users, think about poor database performance, often the first thing that pops in their minds is whether the hardware and/or hardware configurati