Welcome to Log Buffer, the weekly round up of news and happenings in the database world.
We’re planning our publishing calendar for 2011. Happy to announce that we’ll have a few guest hosts in the New Year. Don’t forget if you’d like to host or edit a future edition of Log Buffer on your own blog, send a note to the Log Buffer coordinator.
We’ve had several contributions of favorite reads from the team this week. Enjoy this issue, Log Buffer #208.
Gwen Shapira’s picks:
…
[Read more]Everyone loves the colorful and easy lighting fire logs you can buy in the store for between $3-5, and from our feedback we are savoring the fact that everyone also adores the vibrant and flamboyant Log Buffer.
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.
Oracle Jewels:
Discussing the common errors by the DBAs, Hemant K Chitale from Oracle …
[Read more]Before launching into this, I must give due deference to Mogens Nørgaard’s landmark article, You Probably Don’t Need RAC (YPDNR), available here, but originally published Q3 2003 in IOUG Select Journal. Mogens showed that you can be a friend of Oracle without always agreeing with everything they do.
At Blue Gecko, many of our remote DBA customers have been asking us about Golden Gate. In July 2009, Oracle bought Golden Gate Software, just one of several companies that have developed log-based replication mechanisms for Oracle and other databases. This was one of many major acquisitions by Oracle in 2009, including Sun and Relsys. But unlike most of Oracle’s acquisitions, …
[Read more]Oracle:
Arup Nanda posted an excellent script on how to summarize backup information from the rman catalog. He also posted a tool for automatically purging time-based partitions.
Pythian’s resident Exadata expert, Marc Fielding posted links to the …
[Read more]A very warm welcome to the Log Buffer, the premier medley of fresh information culled from the blogs related to the technology which stores the world, yes, the databases.
In this edition, the Log Buffer #205, we have yet again found the pulse of the industry.
Oracle:
On the Oracle front, leading Oracle technologist Andrey Goryunov carries on his hands-on experiments of newest version of the Oracle database. This time he slices away chopt.
It’s always very informative and exciting to know about internals of RAC Stuff like what actually is maintained in the Voting Disk . Riyaj has it …
[Read more]Welcome to Log Buffer, the weekly roundup of happenings in the database world.
Lots to cover this week, so let’s get on with Log Buffer #204. Enjoy!
Oracle:
Pythian’s Gwen Shapira dabbles with MySQL and explores MySQL troubleshooting for the Oracle DBA.
Venkat Janakiraman explores how connectivity works for BI EE 11g on …
[Read more]
New Community version of GreenSQL Database Firewall, version 1.3
is now available.
GreenSQL 1.3 includes new features, many bug fixes and
enhancements.
In this version, GreenSQL improvers the native support for PostgreSQL (http://www.postgresql.org) databases, improvers the native support for MySQL (http://www.mysql.com) databases and provides many Protocol and Network Optimizations. The Web Based GUI usability has been improved and many bugs been fixed.
GreenSQL community version 1.3.0 improvements and enhancements include:
1. Proxies dashboard: correctly displaying the proxy current
status
2. Proxies automatic reloading fixes
3. Alerts include User IP Address
4. MySQL and PostgreSQL protocol fixes
5. Network optimizations
6. Alerts – redesign and graphics
7. …
Welcome to Log Buffer. The weekly roundup of posts, and news of what’s happening in the database world.
At Pythian, we’re pretty much recovered from a hectic Oracle OpenWorld 2010, and I’m no longer an OOW virgin. What an experience! I had the pleasure of meeting many of you Log Buffer readers and contributors at the Annual Blogger’s Meetup at Jillian’s. Great to put faces to names. And I now officially feel like “Vanessa from Log Buffer”, as many of your t-shirts will show.
Many thanks to Marc Fielding for providing the hot items for this week’s post, in …
[Read more]To get information from a database it is necessary to execute a query to get this data.
Usually an ordinary SQL editor is used to create queries. To use such editor, one should remember the syntax of the SELECT operator and the names of tables and columns.
Let’s use a visual instrument developed specially to design queries, and see that it’s much easier to create queries visually instead of typing them in an editor.
Task:
It’s necessary to show the salaries of the employees of departments situated in different cities for the 2008 year in descending order.
We will do this on a MySQL server database. The process of creating this database was described in the How to: Create MySQL Database in One Shot article. You can …
[Read more]Welcome to Log Buffer. The weekly review of DBA industry news. Enjoy Log Buffer #199.
Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.
And, for inquiries about hosting or editing a future edition of Log Buffer on your own blog, send your query to the Log Buffer coordinator. (Please include the words “Log …
[Read more]