Resource Library
Webinars
- Oracle RAC Workload Management with Alex Gorbachev (Quicktime, 26.8 Mb)
- Oracle RAC — Why VIPs? with Alex Gorbachev
- Oracle 10g Block Change Tracking Inside Out (ppt 555kb)
- Partitioning in MySQL 5.1 by Sheeri K. Cabral
Papers & Books
- MySQL Administrator's Bible by Sheeri K. Cabral
- Oracle RAC Workload Management Whitepaper by Alex Gorbachev
- 8 Rules for Designing More Secure Applications with MySQL
- Pythian in eWeek: The Backstory by Paul Vallée
- What is Behind Pythian’s Growth and Market Success? by Paul Vallée
- The Seven Deadly Habits of a DBA ... and How to Cure Them by Paul Vallée
- The Quick and Easy RMAN Restore
- Downloading from OTN Directly to your Database Server
- How to Install 32-bit Oracle on an x86-64 Platform
- Oracle 10g Block Change Tracking Inside Out by Alex Gorbachev
- Extending Oracle 10g Grid Control
Sign Up for Notification
Sign up to get e-mails from Pythian on releases of Webinars, Papers & Books and Software.
Blog
Deferrable constraints in Oracle 11gR2 may lead to logically corrupted data
Alex Fatkulin
I’ve hit a bug in Oracle 11.2.0.1 when working with deferrable constraints which I think is worth sharing as it may have profound consequences under certain scenarios. Let’s start by creating a simple table with a deferrable primary key: SQL> create table def_bug(n number primary key deferrable initially deferred); Table created SQL> insert into def_bug values (1); 1 row inserted SQL> [...]
dpanneur – your friendly DarkPAN/CPAN proxy corner store
Yanick Champoux
CC BY-NC-SA 2.0 There were two things I have wanted to do for some time now. The first was to come up with a way to quickly and easily set up a DarkPAN mirror so that we would have more control over our dependency chain at work. The second was to make a portable CPAN proxy [...]
Log Buffer #182, a Carnival of the Vanities for DBAs
Sheeri Cabral
This is the 182nd edition of Log Buffer, the weekly review of database blogs. Make sure to read the whole edition so you do not miss where to submit your SQL limerick! This week started out with me posting about International Women’s Day, and has me personally attending Confoo (Montreal) which is an excellent conference [...]
Liveblogging at Confoo: Blending NoSQL and SQL
Sheeri Cabral
Persistence Smoothie: Blending NoSQL and SQL – see user feedback and comments at http://joind.in/talk/view/1332. Michael Bleigh from Intridea, high-end Ruby and Ruby on Rails consultants, build apps from start to finish, making it scalable. He’s written a lot of stuff, available at http://github.com/intridea. @mbleigh on twitter NoSQL is a new way to think [...]
