Featured White Paper(s) VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more) Distributed Databases – Jeremiah Responds Be careful what you ask for, you just might get it. Well, today I have a real treasure to share. […]
Other News
It’s All About Parallel
Featured White Paper(s) Free Poster – SQL Server Perfmon Counters of Interest When you’re looking for a reliable tool to diagnose SQL Server issues, Perfmon is often the answer. No more wasting time trac… (read more) Featured Script sp__backup.sql Generic script to dump all databases on a server… (read more) It’s All About Parallel You’d have to be away from […]
Stripping (HTML) tags in XSLT
(Joachim Selke) As there doesn’t seem to be any built-in function in XLST for stripping tags from strings (e.g., to remove all markup from a piece of HTML-formatted text), people came up with a recursive template-based solution, which has been posted several times on the web (e.g., here).
Get the XML from Dynamicweb
(Nicky Christensen) If you are using XSLT templates in Dynamicweb, then you need to know the XML output from Dynamicweb.
Tip: The zen of XSLT
(Doug Domeny) To start coding an XSLT can be intimidating, but if you can answer two simple questions, you are well on your way. With the simple approach this tip presents and about 10 minutes, you can have a much clearer understanding of the fundamentals of transformations.
New book: Getting Started with IBM FileNet P8 Content Manager
(Susan Visser) Install, customize, and administer the powerful FileNet enterprise content management platform.
Writing SQL Server Service Broker Applications Across Databases
(Arshad Ali) SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and SQL Server 2008 R2), which allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message based applic
DB2 on SPARC T3 Tuning Tips
(cherry.shu) With the new self tuning feature in DB2 V9.x, a lot of database parameters are set to automatic in DB2 v9.7 by default so that DB2 can adjust the values as needed.
SQL: selecting top N records per group
(Shlomi Noach) A while back I presented(*) an SQL trick to present with non-aggregated column on a GROUP BY query, without use of subquery or derived tables.
Encryption enhancements: Field procedure support in DB2 for i 7.1
(Xing Xing Shen, Jia Tian Zhong, Shu Pang and Carol L Ramler) Column-level encryption support is one of the major headline DB2 features in the IBM i 7.1 release. The DB2 for i 7.1 support enables transparent column-level encryption implementations with a field-level exit routine known as a field pro