(Steve Callan) Oracle Data Guard is a very useful tool to help maintain high availability and to protect your data. It is not uncommon to see “must have experience with RAC and Data Guard” in job postings on Monster and Dice. If you are not using Data Guard at work or do not work in an environment w
Other News
The Importance of Data Modeling as a Foundation for Business Insight
(Larissa Moss and Steve Hoberman) To fully appreciate the inherent potential of business intelligence (BI) and data warehousing, one has to understand the origins and significance of data modeling. The origin of data modeling predates data warehousing by more than a decade and it predates the re
Use reduced XML schemas to trim BizTalk processing overhead
(Scott Robinson) It’s hard to argue against the convenience, robustness and flexibility of XML data transport in extended application systems. The people behind BizTalk Server 2004 have made it BizTalk’s lifeblood and it serves well. It’s possible to do some pretty intricate, even convoluted, de
SQL Server 2005 T-SQL Enhancements
(Jim Duffy) Microsoft has introduced a number of new features and enhancements in the T-SQL language in SQL Server 2005. Some of the new features include the PIVOT and UNPIVOT commands, CTE, DDL (data definition language) triggers, error and exception handling with the TRY/CATCH block, and ranking f
Hotsos Symposium 2005
Hotsos Symposium is the only conference in the Americas devoted to Oracle system performance. The combination of topic focus, small audience size, and large speaker list make the Hotsos Symposium an unsurpassed networking opportunity.
Securing Your Data Warehouse
(Warren Sequeira) A data warehouse is a valuable asset to any organization because it integrates and enhances the organization’s raw data that is stored either in its online transaction processing (OLTP) databases or in external data sources. Users from various locations can access this central
An Introduction to TMAPI
(Robert Barta and Oliver Leimig) There are several software packages for Java developers when they need to develop applications using XML Topic Maps. There are some proprietary software vendors and also open source packages like TM4j, tinyTIM, and a few others.
Mainframe EXTRA: The Resilient DB2
(Jim Porell) Much angst is going through many executive IT teams today. Is the data that ensures the livelihood of their businesses protected against a potential loss? Are they doing enough to protect against a loss? Loss can come in the form of corrupted data, misuse of the data or lack of access d
Understanding SQL Server Full-Text Indexing
(Mike Gunderloy) Microsoft SQL Server supports T-SQL, an implementation of ANSI standard SQL. T-SQL is designed to (among other things) search for matches in your data.
FIX: A call to the GetLiteralInfo function may return an incorrect error message in the Microsoft Host Integration Server 2000 DB2 driver
A call to the GetLiteralInfo function may return an incorrect error message in the Microsoft Host Integration Server 2000 DB2 driver. When SQL Server Distribution Agent cannot synchronize with the IBM DB2/MVS heterogeneous subscriber, the synchronization ends.