(Thomas) There are a few ways to implement counters. Even though it’s not a complex feature, often I see people having problems around it. This post describes how bad implementation can impact both application and MySQL performance and how to improve it.
Other News
Exploring IMS disaster recovery solutions, Part 1: Overview
(Glenn Galler and Ron Bisceglia) Every customer needs a Disaster Recovery (DR) plan. The strategies used differ from one customer to another and they differ in time to recovery and loss of data. For IMS, there are five types of disaster recovery solutions: restart, recovery, recovery and restart, co
Steps to Rename a Subscriber Database for SQL Server Transactional Replication
(Mohammed Moinudheen) I have transactional replication configured in production. The business team has a requirement to rename the subscription database. Is it possible to rename the subscription database and ensure that transactional replication will continue to function as before. If so, how could
JavaScript Patterns
JavaScript Patterns What, how can there be patterns in a scripting language? That was what I asked myself when I came across the book titled “JavaScript Patterns.” So, I had to look into it. Here are a few bullets from the back cover: Create objects that go beyond the basic patterns of using object literals and constructor functions Learn the […]
CLR Capability in SQL
SSWUGtv With Stephen Wynkoop In todays issue of SSWUGtv Steve interviews Dan Clark as he shares his thoughts bout self-service BI. Is PowerPivt the tool you should be using? Find the answers here on this edition of SSWUGtv. Watch the Show CLR Capability in SQL We have been discussing the value of the CLR in SQL Server for the last […]
Using current_scn for RMAN incremental ? Think again..
(Amit) I am bloging about experience we had using rman incremental backup for syncing standby database.
APEX – it’s only good for CRUD applications?
(Joel R. Kallman) The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
Regexp hungry for CPU? Real time sql monitoring shows just how
(Dominic Brooks) First up, an execution plan showing the old problem of how the costs of a scalar subquery are not properly accounted for, even in the latest 11gR2 releases.
Reflecting Implemented Interface Information
(Richard Carr) The eleventh part of the Reflection tutorial describes the techniques for examining a type and determining which interfaces, if any, it implements. The processes can be used to find implemented interfaces for classes, structures and other interfaces.
jQuery HTML5 :dataAttr Pseudo Selector
(Elijah Manor) A while back someone on twitter was asking me how they might find a set of DOM elements by using doing a partial search on their HTML5 data attribute.