(Laura) Philip Howard, IT analyst with Bloor Research provides a comprehensive comparison of IBM and Oracle systems for online transaction processing (OLTP)
Other News
Oracle Database Time Model Viewer in Excel 4
(Charles Hooper) In the previous three parts of this series we started building an Oracle Database time model statistics viewer using nothing more than Microsoft Excel. The end result will hopefully duplicate some of the functionality that is found in a portion of a program that I have been buildin
Use of MSXML (MSXML3, MSXML4, MSXML6 our COM component libraries) in .NET applications are not supported
(farukcelik) Our KB article http://support.microsoft.com/kb/815112 clearly states this. Then, you may ask me “Why this guy is repeating the documented thing in this blog post ?”. Answer is simple, we do see lots of issues coming from our customers about this and I want to mention about this point in
SQL Server Data Comparison Tool in Visual Studio 2010
(Karthikeyan Anbarasan) In my earlier article we have discussed about the SQL Server schema comparison tool in Visual Studio 2010. Today in this article I’m going to explain yet another new tool in Visual Studio 2010 which is nothing but the DATA COMPARISION tool.
Passing Large Files in Windows Communication Foundation (WCF) using Streaming and TCP
(Joydip Kanjilal) In Windows Communication Foundation (WCF) you can opt for buffering or streaming mode for transferring data. Both these modes have pros and cons.
Using xsd.exe to create strong types in VB
(Jim Roth) This article will outline the method for creating Web Service methods that will return strongly-typed data to the consumer. I’ve seen some C# examples of this, but this one is presented using VB, and done in Visual Studio 2008 (it works the same in VS 2010). This example will also use a W
More on PHP and Oracle 11gR2 Improvements to Client Result Caching
(christopher.jones) Oracle 11.2 brought several improvements to Client Result Caching. CRC is way for the results of queries to be cached in the database client process for reuse.
Removing all databases from a MySQL instance
(Darren Cassar) Many out there will have different ideas about this, some using procs, some using a function, others using a shell script. Well I didn’t want to spend much time on it so decided a group_concat(concat would be enough.
Required rights for SQL Server service account
(jamesask) This topic comes up from time to time in my daily support work, so I thought I would make a quick post on the rights required if you do not want the SQL Server service account to be a member of the Local Administrators group on Windows. Having the SQL Server service account as a member
Data Architect: DB2 Indexes and Query Performance: Part 2
(Robert Catterall) In the first installment of this two-part column, I focused on the pros and cons of reducing query times by adding indexes to a DB2 database. We discovered that there is a point where aggregate index costs—more-expensive INSERT and DELETE operations, for example—outweigh a new ind