By Itzik Ben-Gan – When you need to perform calculations that don’t necessarily involve accessing data that’s stored in tables, take the logical path to a solution.
Author: SSWUG Research
Introduction to MSSQL Server 2000 Analysis Services Custom Cubes: Financial Reporting (Part I)
Join author Bill Pearson as he expands our cube building skills to create an integrated Financial Reporting Cube. This two-part lesson will present hands-on practice in building core cube structures from multiple data tables and developing the initial design to focus on the production of financial s
Tip: Basics of bootstrapping with DOM, Part 3
By Brett McLaughlin – This tip explains the changes to DOM Level 3 that relate to bootstrapping, and how they improve upon DOM Levels 1 and 2.
Java Architecture for XML Binding
by Hitesh Seth – Two foundation technologies, Java and XML, represent the marriage of portable code and data. A key ingredient of a successful marriage is compatibility. XML and a number of XML-based vocabularies are being used extensively as the standard data-exchange mechanism (and beyond) by both
Take the Pain Out of Reading XML
by Elliotte Rusty Harold – Reading XML documents isn’t as easy as writing them. Fortunately, you can use an XML parser to do the work for you. Download a sample chapter from Processing XML with Java to get the scoop.
Activebase Disaster Recovery and Performance Enhancement Solutions for Oracle Databases
ActiveBase recently announced disaster recovery and performance enhancement solutions for Oracle databases.
Refresh value of a global variable only after commit
By Ravinder Bhalla – Using the tip below, you can not only reinitialize the value of a variable after COMMIT at the backend or the SQL prompt, you can also execute specific functions or procedures only after COMMIT. It was tested on the Oracle 9i database, but it should be possible to run on 8i also
Real Life DBA: Dealing with a SQL Server Cluster Failover
By Brad McGehee – What’s is really like to experience a SQL Server cluster failover on your most important production server?
Does Sort Order Affect Performance?
I have seen information about how sort order affects performance in SQL Server 6.5, but I can not find similar information about sort-order performance in SQL Server 2000 or SQL Server 7.0. I am trying to decide if using binary sort makes sense for my SQL Server 2000 application. What is the perform
Business at XML 2002
by Alan Kotok – The XML 2002 conference and expo (8-13 December 2002), this year’s IDEAlliance showcase, reflected the impact of the technology recession on XML business applications. With many business customers cutting back on new technology investments, XML vendors now take a greater interest in