(Amit Jain) Typically, as part of the product installation, applications/products are required to create some database tables. It’s a good practice to isolate product installation tables from the application/solution specific tables.
Author: SSWUG Research
Moving domain index to another tablespace
(Pawe³ Barut) It seems to be very easy task that can be accomplished using rebuild option: ALTER INDEX MY_INDEX REBUILD TABLESPACE NEW_TBS;
Intelligent Layering: Leverage Conditional Formatting Logic from Analysis Services
(William Pearson) The reporting / presentation layer of the integrated Microsoft business intelligence solution is often the only point of interaction for organizational information consumers. It is here that we often find it desirable to manifest the effects of conditional formatting. Conditional f
Generate RSA public and private keys, export to XML
(Stefan Prodan) The following method shows how RSA keys can be saved to disk as an XML file. The XML files can then be used to make an RSA secure channel — the public key is used for encryption and the private one for decryption. (R)
SQL Server 2005: Using OVER() with Aggregate Functions
(Jeff Smith) One of new features in SQL 2005 that I haven’t seen much talk about is that you can now add aggregate functions to any SELECT (even without a GROUP BY clause) by specifying an OVER() partition for each function. Unfortunately, it isn’t especially powerful, and you can’t do running total
Using the DOM class in AJAX with the GWT and Java
(Richard G. Baldwin) Historically, the development of Ajax web applications has been a complex process. This is due mainly to the requirement to learn and use a variety of technologies, such as HTML, JavaScript, XML, ASP.NET, Java servlets, various scripting languages, etc.
Extended TreeView
(G. Mohyuddin) It is a TreeView Control that has been extended from the ASP.NET TreeView shipped with .NET Framework 2.0. By extending it from the built in TreeView control, the purpose is to have all basic features of the existing TreeView with some new features, which are highly required but are n
XML Design for Relational Storage
(Solmaz Kolahi and Leonid Libkin) Design principles for XML schemas that eliminate redundancies and avoid update anomalies have been studied recently. Several normal forms, generalizing those for relational databases, have been proposed. All of them, however, are based on the assumption of a native
Redefining Business Intelligence with Operational BI
(Santosh Joshi) Ever since the term business intelligence (BI) was coined, myriad definitions have evolved in trying to fully and clearly define what BI really means. All the definitions point to the simple fact that any system that adds intelligence to business processes can be classified as a BI s
Reduce Costs and Improve Efficiency by Automating Oracle Document Delivery
Companies can extend the business process efficiency gains achieved with Oracle by automating document delivery. See production fax as a powerful tool for automating information distribution while driving efficiency, compliance and cost reduction. (R)