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 responds, writing about his …
[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]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 I hope to return to next year. I learned a lot from confoo, especially the blending nosql and sql session I attended.
This week was also the Hotsos Symposium. …
[Read more]The 181st edition of Log Buffer has been published by Gary Myers on his Sydney Oracle Lab.
Having recently moved his blog, Gary approached the Log Buffer coordinator to volunteer for an edition because he knows that, with LB being a popular and established destination in the database blogoshphere, it would help him broadcast his new blog and welcome readers to it. You can do it too–simply send an email to the Log Buffer coordinator.
Here’s Gary’s Log Buffer #181.
Hello and welcome to Log Buffer #180. Time’s a-wastin’, so let’s go!
Oracle
There was so much Oracle stuff this week that I’ve decided to cram a little more of it into Log Buffer by providing a little less context than usual.
Jonathan Lewis shares an explication of aliases: “I was asked the following question recently: ‘Does the use of table aliases affect performance?’ To which the best answer is probably ‘Yes, though in general you probably won’t notice the difference and there are reasons more imporant [sic] than performance for using table aliases.'”
Doug Burns continues his most recent series: Statistics on Partitioned Tables …
[Read more]You have found the 179th edition of Log Buffer, the weekly review of database blogs. Welcome. Enjoy your stay. We begin with . . .
SQL Server
Merrill Alrich gets going with a fresh juxtaposition–his thoughts on motorcycles and Access. “Many DBAs,” he writes, “have been called in to rescue people, or teams, or projects who have mission critical Access applications gone horribly wrong. It’s very unpleasant, especially the typical discussion we have to have with the Access afficionado . . . ”
Brent Ozar is in on this discussion too. Here he gives his …
[Read more]Gerry Narvaja has published the 178th edition of Log Buffer, the weekly review of database blogs.
LB is always looking for contributors, so if you’d like to publish an edition of your own, drop a line to the Log Buffer coordinator. It’s an excellent way to put your stamp on the database blogosphere.
Here is Gerry Narvaja’s Log Buffer #178.