(Nagraj Alur, Steffen Herold, Huey Kim, Makiko Tsuchida and Mark Wiman) This redbook provides detailed instructions and scripts on managing failover and switchback in a bidirectional Q replication environment for the AIX platform. A typical business scenario is used to showcase the bidirectional fai
Author: SSWUG Research
Select Based on List of Random Values — Dynamic SQL or CSV Parsing UDF?
(Mirko Marovic) Two frequently asked related questions in Microsoft SQL Server discussion groups are: –How to pass an array to a stored procedure? –How to select data based on a list of values?
Get the XML out of your database, via HTTP
(Lewis R Cunningham) I recently wrote about getting the XML out of your database using a less preferred method (UTL_FILE). Today, I am going to show you how to do it via one of my preferred methods. Of course the easiest method is just to return an XMLType from a stored procedure and let the calling
Prepare yourself for developing in Windows Vista by mastering the power of XAML
(Lori A. MacVittie) When Microsoft releases Windows Vista, the new operating system will support more dynamic and active graphics. The cornerstone for building these new user interfaces is XAML (“Zammel”), an XML-based markup language that works with Windows Presentation Foundation (WPF), Vista’s ne
Mastering Enterprise BI: Introduction to Key Performance Indicators
(William Pearson) A Key Performance Indicator (“KPI”) is a performance measure that specifies an emphasis intended to produce a desired result. As quantifiable measurements that gauge business success, KPIs can be diverse in nature, but they typically represent values, statuses, trends, or goals. KP
How to add ‘AJAX’ drag-and-drop functionality to your web sites
(edmon) I like the richness and liveliness of the Google personal home page, Live.com and My Yahoo. All the drag-and-drop functionality, live bookmarks and interactivity brings boring HTML pages to life.
Dashboard: Oracle Speaks — But Can It Lead In Business Intelligence?
(Penny Lunt Crosman) Calling business intelligence "a new leg of our business," Oracle president Charles Phillips announced the Oracle BI Suite in March and claimed Oracle would be able to leapfrog other longtime players in the BI space.
Custom Scheduler – SQL Server Reporting Services
(Soshan Fernandes) I was currently working for a company name Hermz Software which needed to create reports using SQL Server Reporting Services as it’s reporting tool. As far as creation of reports is concerned, I didnt have much problems!! However, the delivery of the reports were to be done based
The On-Demand, Open Source Business Software Transformation
(Sarah Lacy) Key to its appeal is the try-it-before-you-buy-it nature of the open source movement. When the software works and it’s easy, it catches on fast within companies and quickly builds a grassroots following. Increasingly, open source designers understand that their audience is counting on t
Querying XML Data Based on Nested Relational Sequence Model
(Lau Ho Lam and Wilfred Ng) We present an XML query language based on the Nested Relational Sequence Model (the NRSM), which is an extension of the Nested Relational Data Model in order to handle XML data. The query language provides the users with a set of formal algebraic operations for manipulat