(Brian Peasland) I have read numerous ways of replicating data across different operating systems and different databases. My question is, which of these methods is the most efficient and productive? Oracle mentions it but is not very clear when it comes to non-Oracle databases. Could you shed some
Other News
Oracle reassures Siebel clients
(Martin Veitch) Experts have applauded Oracle’s attempts to “have it all ways” as it develops its customer relationship management (CRM) software after buying Siebel.
Data Mining Tools: Which One is Best for CRM? Part 2
(Robert A. Nisbet) One way to refer to this wider context of data mining is to include data mining as part of the broader process of knowledge discovery (KD). In addition to data mining activities, KD may also contain some elements that define data extraction from source systems, customer householdi
DataStage tip for beginners: developer short cuts
(Vincent McBurney) People who have been using a tool for a long time learn some shortcuts. I’ve done a brain dump of any DataStage short cuts I can remember.
Part I: Understanding the SQL Server 2005 XML Data Type
(Srinivas Sampath) XML has been widely adopted as a platform-independent mechanism for representing data, and is also commonly used to exchange data between disparate and loosely-coupled systems, such as B2B applications and workflow solutions. More recently, XML has been used to represent semi-stru
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 1
(William Pearson) As I have shown in many past articles, the Microsoft Integrated BI Solution, consisting of the MSSQL Server 2005 Database Engine, Analysis Services 2005 and Reporting Services 2005, provides unprecedented flexibility in helping implementers and developers to meet client and employe
Databases Programming in Python: Accessing MySQL
(A.P.Rajshekhar) While data storage for applications is no longer considered complex, it is now simplified to the point that flexibility is sacrificed. There is a good compromise, however. In this article, you will learn how to access a a MySQL database with Python.
Gather Windows system details and store in SQL Server 2005 Express with this VBScript
(Scott Lowe) Monitoring your servers and network can run from cheap to way-too-expensive-to-bother, and it can run from simple to way-too-hard-to-care. Unfortunately, as the profile of Information Technology is raised and systems become more integrated, it’s critical to be able to provide some sembl
Don’t Use Select *
(John Fuex) Something you see in a lot of database access code is a select statement that looks something like this: SELECT * FROM TableName WHERE …
Using Master Pages in ASP.Net 2.0
(Peter Aitken) Many web sites follow a plan in which most of the pages have certain content in common, such as a header and footer. As the user navigates from page to page, only the content in the main part of the page changes.