English
| Previous 30 Newer Entries | Showing entries 121 to 150 of 150 |
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.
[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,
[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,
[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
[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 (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
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,
[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.
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
[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
[Read more...]Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #198 is generously published by Sam DeFilippis, who manages Oracle Notes blogs, with latest postings on Oracle GoldenGate.
As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.
Please enjoy Sam’s issue
Log Buffer #197 marks the middle of summer, and the fact that we’re a mere two weeks away from our 200th edition.
To begin this week’s reading, I’d like to highlight two Oracle blogs maintained by Sam J. DeFilippis: Oracle Notes, where he’s recently posted about troubleshooting GoldenGate and positioning a read of Extract/Replicat Trail file or Oracle redo
[Read more...]Welcome to Log Buffer, the weekly roundup of database industry news.
For your reading pleasure this week we have Log Buffer #196:
Charles Hooper blogs about an in-depth investigation on what can cause Oracle to ignore a hint.
Doug Burns reminds his readers that there are only two weeks left to
[Read more...]A short post marks Pythian’s 195th edition of Log Buffer, a blog of blogs encapsulating what’s going on in the world of database administration.
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 on why you think that others will want to read it too.
Now on to Log Buffer #195. Alex Gorbachev starts us off with his suggested readings and funnily enough,
[Read more...]We’re well into summer and almost at our 200th edition of Log Buffer, a blog of blogs about the database world.
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.
Now on to our weekly reading in Log Buffer #194:
Oracle Exadata is a topic that is getting hotter and hotter. Following Pythian’s announcement of Exadata services Oracle’s
Welcome to Log Buffer, the weekly roundup of DBA industry happenings.
Read on for the latest updates in Log Buffer #193. Don’t forget, we’re always looking for volunteer editors to publish and host an issue of Log Buffer. If you’d like this to be you, contact the Log Buffer coordinator.
ODTUG/Kaleidoscope 2010 roundup:
[Read more...]Updated: 29-Jun-2010, 30-Jun-2010.
For me, ODTUG Kaleidoscope 2010 started on Friday with the ACE Directors briefing. Best practices topic was touched there slightly and I twitted about it. I decided that the feedback deserves a blog post so I’m simply quoting the conversation here. If you have anything to add, you know where to find the comment box.
alexgorbachev:It’s Friday, and summer’s here. While it seems the industry is slowing down to a lazy pace, there is still some action so let’s splash right in to this week’s edition of Log Buffer DBA industry news in Log Buffer #192.
Alex Gorbachev had a few minutes to suggest the following interesting tidbits to me before running off to attend Oracle ACE Director activities at ODTUG/Kaleidoscope this weekend. One of these days we’ll have to see if he can share some of what
[Read more...]
-0
I found I never published this post as it was sitting in my drafts few months now — it was written in 13th February, 2010. I’m publishing it without any changes.
I learn therefore I am!
I’ve just wrote few bits about learning a new technology and after skimming through my Google Reader, I noticed a great post by Chen Shapira — Deliberate Practice. That’s reminded me about another aspect of learning that I didn’t mention — learning is a continuous process.
There are two aspects…
Welcome to Log Buffer, the weekly roundup of database blogs.
Kicking off this week in Log Buffer #191 are posts from Alisher Yuldashev:
Randolf Geist blogs on an Advanced Oracle Troubleshooting Session – PGA/UGA memory fragmentation for when a batch process takes significantly longer than expected.
[Read more...]Welcome to Log Buffer, the weekly roundup of database blogs. We’re back this week with a short Log Buffer #190. Only ten more issues, and we’ll be celebrating our 200th edition post.
Chen Shapira was eager to share news early this week, sending along her favorite picks on Tuesday.
Prof. Neil Gunther doesn’t like the way commercial load testing software distributes think times.
Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #189 is generously published by Iggy Fernandez, editor of the quarterly journal of the Northern California Oracle User Group (NoCOUG).
As always, if you’d like to host your own issue of Log Buffer, simply reach out to the Log Buffer coordinator.
Please enjoy Iggy’s issue of Log Buffer #189.
Most database companies would be proud to say that their products perform optimally out of the box. It means they accomplished a Herculean feat of engineering. But most databases have configuration options because this is almost impossible. For example, MySQL has scores of tuning options, and it needs a lot more.
So when someone benchmarks your database and makes you look bad, usually you can say “that benchmark was run by someone who doesn’t know how to properly tune my database software.”
But what if the benchmarker claims that your database didn’t need to be tuned, (via Dave Page), because it’s optimal out of the box? Do you accept the benchmark
[Read more...]It’s Friday already, and we know what that means! Log Buffer, the industry’s weekly review of database blogs is here again for your reading pleasure in the 188th issue.
Starting off this week’s issue is a request from Mark Grennan a DBA who would like to let the community know about his blog MySQL Fan Boy, where he wrote an interesting post on including a script to replace MySQL table files on a live system, making it faster and limiting locking on large table loads. Also a post this week on whether MariaDB
[Read more...]Welcome to Log Buffer. This week’s issue #187 was another group effort. Thanks to all our contributors – you rock!
Suggested by Pythian’s Bradd Piontek, is a post he really liked because he used to write pipelined functions for Dynamic Search queries, – Tom Kyte’s something new I learned about estimated cardinalities. He’s also highlighted something new Tom learned about sqlplus. And the fact that Richard Foote announced the
[Read more...]Welcome to the 186th Edition of Log Buffer. Lots to report this week, so read on…
In Oracle news:
We begin with Gary Myers at the Sydney Oracle Lab who mixes GUI and CLI and shows how to manage your database from EMACS. You have to read a post that starts with: “There is a place of shadow, a place between the dark lands of the command-line interface, and the shining brightness of the GUI. In the days of yore, many dwelled in the shadow lands, but almost all have been attracted to the lights of SQL Developer…”
Tanel Poder gives a step by step tour of his
It’s a busy time of year for Pythian. With many of our team tied up on client engagements, away at MySQL conference this week, and Collaborate 2010 next week, I’m pinch hitting as volunteer editor in helping to pull together this week’s edition of Log Buffer. Enjoy!
MySQL Conference 2010
Big news this week from MySQL Conference as Oracle’s Edward Screven elaborates on Oracle’s plans for MySQL in his opening keynote. Pythian’s Paul Vallee was interviewed by Network World’s John Brodkin, before the conference in anticipation of the session.
Ronald Bradford
[Read more...]This is the 184th edition of Log Buffer, the weekly review of database blogs. I’ve edited a couple of Log Buffers before, but this is the first time I get to post directly to the Pythian blog. Just one of the many perks of being a Pythian employee ;)
On the Oracle front:
It is always good to start the day with a pop quiz to get the brain into gear: Charles Hooper posted a 3-part series with seemingly innocent True/False questions. He covers sorting, SQL tuning and
[Read more...]Hello folks, it’s great to be back from hiatus. This is the 183rd edition of Log Buffer (arguably the best edition of Log Buffer yet!), the weekly review of database blogs.
The last time I wrote this was just under 2 years ago!!! WoW. Things have changed. Sun bought MySQL, Oracle bought Sun. Those were bombshell deals. At least you can rest assured that some things can be constant. I still eat my daily serving of broccoli (among other healthful “things”). I urge you all to go the fridge and grab some veggies prior to sitting down for this week’s… ahem… digest.
Starting with Oracle, Pythian’s own Alex Fatkulin illustrates a bug (?…likely) that could lead to logically corrupted data.
[Read more...]| Previous 30 Newer Entries | Showing entries 121 to 150 of 150 |
