(Peter Coffee) Today’s ‘perfect storm’ of sophisticated attacks, corporate governance mandates and public awareness of database security risks demands the prompt and determined response of database builders and application developers. In this report, eWEEK Labs profiles the combination of emerging t
Other News
Review: SQL Auditor
(Mike Pearson) SSW SQL Auditor is an extremely useful tool which allows developers to generate reports on design issues and areas where SQL performance could be improved. It does this by checking the database design against common SQL Server design rules and report on the elements that do not confor
Programming in a Distributed Environment
DB2 Connect lets an application program access data in DB2 databases on System/390 and AS/400 servers. For example, an application running on Windows can access data in a DB2 Universal Database for OS/390 database. You can create new applications, or modify existing applications to run in a host or
Compare Query Results – Part II
(Muthusamy Anantha Kumar) In part I of this article, we discussed how to compare the query results executed on two different servers. In part II, we are going to discuss how to compare results of the same query on the same or different server but on different databases. This article takes advant
CASE STUDY: AIM Healthcare Services, Inc. Increased capacity and reduced TCO by migrating a mission-critical database from Oracle to Microsoft SQL Server
DB Best provided AIM Healthcare with the DB Best SQL Converter plus critical consulting services to quickly and cost-effectively migrate their claims-processing database from Oracle to Microsoft SQL Server. This enabled AIM Healthcare to significantly increase the capacity of their claims proces
Predictable Oracle applications tuning, part 2
(David Welch) Part 1 of this tip debated some common beliefs about apps tuning and offered an approach to efficient project management. This part touches on the specifics of v$sqlarea view, Statspack, index counts, CPU and user involvement. (R)
Slicing and Dicing J2EE
(Ted Neward) There was a time not too long ago when a Java developer could walk up to a new enterprise Java development project and know ahead of time which tools they would use. It was all so simple then: J2EE was new, the HTML browser was the accepted norm for user interface, and complexity, a
Comparative Management Cost Study of Oracle Database 10g and Microsoft SQL Server 2000
As previously published by Progressive Strategies, the Edison Group has performed a Comparative Management Cost Study (CMCS) comparing Oracle Database 10g and Microsoft SQL Server 2000. This effort came about as a result of our review of the pre-release announcements from Oracle Corporation rega
NULL values in a database: Should it be allowed?
(Alf Pedersen) This is a hot topic, and many argue that it should be allowed to have NULL values in a database. The reality is; all database systems I know of, allow NULL values for columns. But is it right; or even better; are NULL values at all allowed according to the relational model?
Optimizing Microsoft SQL Server Analysis Services: Optimize Query Performance with a Derived Measure
(William E. Pearson, III) Because a significant part of my practice consists of being called upon to tune MSAS implementations performed by others, I come across the less-than-optimal use of calculated members quite often. As most of us know, calculated members are dimensions or measures (depending