(Tony Patton) Visual Studio 2008 was recently released to MSDN subscribers, and it’s slated to be available to the general public soon. These recent developments spurred me to take a closer look at the latest version of Microsoft’s flagship IDE.
Other News
VBScript: Functions and Loops
(James Payne) In our last tutorial, we discussed statements and multidimensional arrays. In this article we are going to pick up on functions and work our way through to loops. It’s a lot to cover in a short amount of time, so buckle up and put on your helmet. No not your special helmet…the other
Calculating the Financial Median in MySQL
(Roland Bouman) I believe I found a new method to calculate the median in MySQL. I would not be surprised if this method has been figured out by somebody else already. However, I can’t seem to find any resources on the internet describing this method, so for now I flatter myself by assuming the meth
Buffer Cache Hit Ratios: Useful or Not ?
(Richard Foote) The question of whether the Buffer Cache Hit Ratio (BCHR) is a useful metric or not is one of those discussions in Oracle that seems to crop up on a regular basis. I thought it might be worth briefly mentioning the topic here.
How to find a trace file Oracle 11g
(Rajender Singh) Yesterday I was doing some r&d and tried to find trace file for my session.
Text File Operations in .NET
(John Tränkenschuh) I like text files. They’re easy to understand, which makes them great teaching tools. After all, sooner or later each program must save its results.
Data Integration and Composite Business Services, Part 3: Build a multi-tenant data tier with access control and security
(Mary Taylor and Chang Jie Guo) This article explores how the capabilities of IBM DB2 address the issues of data architecture and data security in a Software as a Service (SaaS) implementation. The primary concern of a SaaS consumer is data security. The primary concern for a SaaS provider is a data
Open Source Virtualization: Oracle VM Manager Installation
(Tarry Singh) In our previous article, we looked at the open source revolution that Oracle started when it announced its hypervisor. In this article, we will install the Oracle VM Manager on our Workstation skeleton. Both installations are carried out on the latest 64-bit Oracle’s EL 5 servers.
Comparing MDX Query Results With Tablediff
(Chris Webb) Recently I was working on a project where the customer wanted to upgrade from SP1 to SP2 but found that when they did so the results of some of the calculations on their cube changed. Unfortunately these changes weren’t easy to spot: their MDX Script was >1500 lines long and the bugs th
2008: Converting XML to HIERARCHYID
(Peter DeBetta) While working on a new book, I have been experimenting with the new HIERARCHYID data type. And since I’ve seen comparisons drawn between using XML versus using HIERARCHYID to manage a hierarchy of data, I decided that it would likely be very useful if I could convert an XML structure