Posts Categorized: Technical Blog
Microsoft introduced Change Data Capture (CDC) technology in SQL Server 2008. This technology captures DML (insert/update/delete) changes to a table. After CDC is enabled for a database and a given table, one can use cdc.fn_cdc_get_all_changes_ function to query changes made to the table. The challenge was to produce a “log” table with columns like this…
When applying Database October 2010 CPU patch (or any patch for that matter) to the 10.2.0.4, on HP-UX, you might encounter the following errors, when running the opatch utility…Here’s a quick fix.
Who from Pythian are at the UKOUG conference this year? In additional to myself, it’s Christo Kutrovsky, Daniel Fink, Paul Vallee and Andrew Poodle. Christo, Dan and myself are presenting, Andrew is helping organization of MySQL track as a MySQL SIG Chair and Paul… well, I’d say Paul is a slacker so he is covering the beer tap to pay up! :) It’s close to 2am – gotta get some sleep before tomorrow.
The Oracle Enterprise Manager Grid Control monitoring plug-ins for Exadata have been released. This is great news for Exadata users, since important components like InfiniBand switches previously had no direct monitoring. The plug-in bundle includes five separate monitoring plugins, here they are.
Winter has started and the holiday season is approaching fast. With the chillness of winter and festive mode induced by the holidays, bloggers across the planet are coming up with more and more exciting ideas. Let’s start with sizzling Log Buffer #207.
This blog post mentions some of very important components of Exadata Storage Server, which are physical disks, cell disks, grid disks and ASM disks and their correspondence.
I just recently faced an issue on how to automate the Workflow Mailer override address for development and testing environments during the EBS cloning process. The problem is that the only official way to set the override address in the latest ATG releases is to go through the OAM portal and change the override email via the GUI interface. I came to this solution.
I just got an Exadata Customer Advisory e-mail from Oracle, identifying “an important issue that needs your immediate attention” and pointing to MOS note 1265396.1. The only fix is to upgrade to the newly-released version 18.104.22.168.1 of the storage server software.
Welcome to Log Buffer, the weekly news blog about blogs in the datasphere.
I’m here at the PASS Community Summit 2010 in Seattle, WA. This happens to be the largest SQL Server conference in the world with regards to content, attendees and Microsoft participation. There have been several announcements made in today’s keynote, few of which were just waiting to be blogged about from the insiders since earlier this year. First of which is the release of SQL Server 2008 R2 Parallel Data Warehouse.