(Cindy Maurer) Data warehousing holds much promise to provide competitive advantage through derived business intelligence, but the promise cannot be realized unless you ensure the integrity of your data. To ensure data integrity you must have end-to-end controls and the ability to identify data anom
Other News
Building a data warehouse: Eight tips for getting started
(Baya Pavliashvili) When building a data warehouse using SQL Server technologies, there are some challenges you might face. I’ll offer you some suggestions for overcoming them. Naturally, each environment is likely to add its own twist to the challenges of building a data warehouse, but most of thes
DBMS_PROFILER Report for SQL Developer
(Alex Nuijten) Oracle SQL Developer offers the ability to create reports with graphs in it. A number of reports are included with the tool, unfortunately a report which shows information based on DBMS_PROFILER built in package isn’t there. DBMS_PROFILER allows developers to profile the run-time beha
Writing Data Driven Applications with Python
(Raja Kishore) Python programming language has moved from the days when it used to be a plumbing tool for web programmers and system administrators. Today it is ubiquitous and is used in practically every application area one can think of! The fact that it is free and Open Source, coupled with the s
The basics of MathML 3.0
(Ed Tittel) In late April, 2007, the World Wide Web Consortium (W3C) released a working draft of a new 3.0 version of its Mathematical Markup Language, aka MathML. Given that MathML 2.0 became a recommendation in 2003, it’s interesting to consider the reasons why a new, next effort for math markup i
Transforming UML «Activity» Diagrams to WebSphere Business Modeler processes
(Catherine Griffen, Ruo Bo Huang, Zhang Sen and Marc Fiammante) This article shows how to automatically transform UML activity diagrams into WebSphere® Business Modeler processes. Requirements analysis is frequently performed using UML, creating activity diagrams to describe business processes. Howe
Displaying Images in ASP.NET Using HttpHandlers
(Electronic Screw) Most of the time when developing web applications/projects we find the need to display images on the ASP.NET pages. This can include customer pictures, avatars, location maps or other binary data. One good way of doing this is to have a dummy page called, which writes out the bina
SQL Server The Truth – Rebuilding a clustered index does not rebuild the non clustered indexes
(Simon Sabin) It used to be fact that the leaf page of a non-clustered index pointed to the row for the page, because it pointed to the file, page and row if the file or page of the row changed the nonclustered index had to be updated.
Oracle Applications Schema Password Change Utility – (FNDCPASS)
(Sabdar Syed) Changing passwords periodically helps ensure database security. Oracle Applications provides a command line utility, FNDCPASS, to set Oracle Applications schema passwords. In addition to changing the schema password in the database, this utility changes the password registered in Oracl
Replication – now and then
(Kristian Köhntopp) One of the major contributing factors to the success of MySQL is the ease and simplicity of its replication. Read-slaves for scaleout and backup-slaves for noninterrupting backups are the norm in any MySQL installation I have seen in the last two years.