(Matt Nicholson) Despite the strength of Visual Studio and the .NET Framework, Microsoft’s attempts to move into the wider market of software design and process control, namely Visio and Visual SourceSafe, have not had much impact, allowing other companies such as IBM Rational, Compuware and Borland
Other News
Step-by-Step Guide: Ensuring data integrity in SQL Server
(Serdar Yegulalp) Data integrity in SQL Server is one of those things that doesn’t seem like an obvious topic for an administrator to address directly. After all, doesn’t SQL Server automatically ensure the integrity of your data? Well, yes, but only up to a point. SQL Server itself won’t protect yo
Dispelling the Myths of Java and WebSphere on the iSeries
(Chris Wilson) Much has been made of IBM’s apparent shift in marketing strategy for the iSeries. To many, it’s seen as some form of capitulation, given the fact that WebSphere has a low adoption rate in the iSeries community. The flip side of that is that you need to qualify what “WebSphere” really
MSSQL Server Reporting Services : Mastering OLAP Reporting: Ad Hoc TopCount and BottomCount Parameters
(William Pearson) In this article, I will present a “combined approach” for the support of a top- or bottom- count picklist in the reporting environment. This option will enable an information consumer to decide, on the fly, whether a “top” or “bottom” query is more appropriate, as well as to input
Managing XML data: XML catalogs
(Elliotte Harold) An old programmer’s adage states that any problem can be solved with an additional layer of indirection — an adage that is as true in XML as in any other field. Many problems that arise when loading schemas, DTDs, and stylesheets can be elegantly solved by introducing XML catalogs
Overview of SQL Server 2000 Database Clustering using MSCS
(Pankaj A. Chitriv) When I started working on database clustering, there were lots of questions in my mind like – “Do I need to have multiple databases?”, “How and who will take care of data synchronization between different databases?”, “How will the client communicate with the DB server in a clust
The BizTalk Server 2004 Configuration Framework Wizard changes the Parallelism setting for the instance of SQL Server 2000
The Microsoft BizTalk Server 2004 Configuration Framework Wizard changes the Parallelism setting for the instance of Microsoft SQL Server 2000 that houses the BizTalk Server 2004 databases. This behavior occurs if this instance of SQL Server has multiple processors available. By default, Use all ava
Working with Data
(Steve Muench) My last column explored the basic organization of a J2EE application and considered some simple examples of validation rules you might write for your Oracle ADF entity objects. This column explores how to query and manipulate data by using Oracle ADF view objects and how to expose tha
FIX: You receive an ODBC error message when you run a pass-through query in Office Access to import data from an Oracle database into Office Excel
When you try to use a pass-through query to import data from Microsoft Office Access into Microsoft Office Excel, you may receive an error message that is similar to the following: [Microsoft][ODBC Microsoft Access Driver] Reserved error (|); there is no message for this error
Graceful Failover and Failback Procedures in Non-Data Guard Environments
(Brian Keating) This paper describes the procedures to perform “graceful” failovers and failbacks of hot standby databases in Oracle environments that are not using Data Guard. A “graceful” failover is one that does not require databases to be opened with the RESETLOGS option—and as a result, gracef