(Rick Sherman) It’s been 20 years since the term “data warehousing” was first coined. Since then, it has evolved into a mainstream activity for Fortune 1000 companies, with many undertaking one or more data warehousing projects over the last decade. However, even after 20 years in the marketplace, i
Other News
Unit Tests in Visual Studio 2005
(Satheesh Kumar) VSTS comes with many tools integrated in it for the developers & testers and also for architects and managers. The unit testing tool that comes with the Visual Studio 2005 enables the developers to generate the test classes and methods. Team Test does not provide tools only for deve
Oracle RAC Administration – Controlling the Cluster with CRS command
(Tarry Singh) Starting with this article, we will begin a discussion on administering our RAC database. Administration can mean many things; think of all that you do as an Oracle DBA–backup, restore, export, import, tuning, benchmark and even some PL/SQL work (It is not just for programmers you kno
Understanding error handling in SQL Server 2000
(Tim Chapman) Most iterative language compilers have built-in error handling routines (e.g., TRY…CATCH statements) that developers can leverage when designing their code. Although SQL Server 2000 developers don’t enjoy the luxury that iterative language developers do when it comes to built-in tools,
Caching for XMLPerformance
(Tom Yohe) Highly scalable implementations of service-oriented architectures (SOAs) always include heavy doses of caching. A guided tour through the SOA tiers, describing the caching and XML acceleration techniques employed along the way, provides the SOA enterprise architect with an awareness of op
Reliably making a web-request from the database
(Rushi Desai) One of the prime use cases of the CLR integration in SQL Server 2005 is to make outbound HTTP requests to web applications or web services. But how do you do that reliably given the large number of failures that need to be handled ranging from network unavailability, server timeouts,
Referential Integrity Is Important For Databases
(Michael Blaha) Referential integrity is a database constraint that ensures that references between data are indeed valid and intact. Referential integrity is a fundamental principle of database theory and arises from the notion that a database should not only store data, but should actively seek to
Table Partitioning comparison to Oracle and Microsoft
(Chris Eaton) No doubt this will be a controversial posting but I will give you my perspective on how DB2 Viper Table Partitioning compares to Oracle 10gR2 and Microsoft SQL Server 2005.
SQL Server backup utility
(Shabdar Ghata) Whenever we want to backup or move SQL Server database, most of us prefer to use regular backup utility which is available through Enterprise Manager in SQL Server 2000 or Management Studio in SQL Server 2005. Limitation of using Enterprise Manager or Management Studio is we have to
Ingres Wants Partners To Push Open-Source Database Into Big Biz
(Barbara Darrow) Ingres wants solution providers to know there’s a new channel program in town.