(Shlomi Noach) We’re migrating some of our “vanilla” MySQL 5.5 servers to Percona Server 5.5. One of the major incentives is the crash-safe replication feature, allowing slaves to die (power failure) and resume replication without losing position in relay logs.
Other News
DB2 Tips n Tricks Part 34 – Remotely Start Stop DB2 Instance from Client Machine
(Harishkumar Baburao Pathangay) How to Remotely Start Stop DB2 Instance from Client Machine Solution:
3 Reasons Your DB2 Environment Is Becoming Partly Cloudy
(Dave Beulke) Existing traditional data models are going through transformations as Big Data, NoSQL, and Cloud Database as a Service capabilities rapidly take business to new heights.
Convert row-organized tables to column-organized tables in DB2 10.5 with BLU Acceleration
(Jim Seeger, Tan Jin Xu and Prashanthini Shivanna) With IBM DB2 10.5, you can easily convert row-organized tables to column-organized tables by using command-line utilities or IBM Optim Data Studio 4.1.
How to Build an Album Web Page with AJAX and ASP.NET MVC3
(Alex Taimassov) Viewing sets of images such as albums is a common functionality of many web applications. In this article we will take how to quickly build such functionality with Unobtrusive AJAX in an ASP.NET MVC 3 environment. Specifically, we want our application to have this functionality:
Oracle 12c – New SYS-level Administration Privileges
(Steve Ries) For a while now, Oracle has been moving its security model toward a more differentiated set of privileges than just SYSDBA and SYSOPER. We saw this in 11g with the SYSASM privilege.
RMAN-07518: Reason: Foreign database file DBID
(Fahd Mirza) While cloning a database to another system through RMAN in an 11.2 database on a Linux system, there was a need to catalog the backups after putting the destination instance in mount status, before the restore/recover process could be started.
ORA-00031, ORA-03113 and ORA-03114
(Andrew Reid) This was tested on Oracle 11.2. I had a session in the middle of a long-running operation:
Broken ownership chain – Dynamic SQL
(Derik Hammer) Today I had a co-worker come to my desk wondering why his service was getting a permissions error when selecting from a table. His confusion was rooted in the fact that his service has been using this stored procedure for over a year. He is granting access to the underlying tables by
View, Pugh, Barney McGrew…
(Mark Broadbent) …Cuthbert, Dibble, Grub.