I’m back in the blogosphere!
This blog will focus on Smalltalk (mostly Pharo, Squeak, Dolphin, VAST and VW), databases (usually MySQL, PostgreSQL, SQL Server, DB2, InterBase and Firebird), algorithms and open source tools. I’ll throw in some literature, music and mathematics occasionally.
Requirements to enjoy this blog : an interest in problem solving, a database and a Smalltalk environment!
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]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]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]Welcome to the 160th edition of Log Buffer, the weekly review of database blogs.
MySQL
Blame it on MyISAM, says Mark Callaghan of High Availability MySQL, on considering sql_mode and type coercion. “I think that MyISAM has its place,” writes Mark. “It does fast table scans, but InnoDB is much faster on just about everything else. I am just not thrilled with the impact it has had on MySQL.”
Not that those other engines are without flaw. Peter Zaitsev reports on an InnoDB performance gotcha with larger queries.
Here on the …
[Read more]This is the 158th edition of Log Buffer, the weekly review of database blogs.
SQL Server
Simon Sabin has a TSQL Challenge – counting non zero columns. He says, “I’m working on a project where I need to cycle a flag amongst a set of columns. To achieve this I am storing a position value in each column which allows me to cycle them . . . So the challenge is to find out the how many non zero columns there are, the twist is to use as little code as possible.”
On a cue from Simon, Aaron Bertrand shares …
[Read more]Welcome to the 154th edition of Log Buffer, the weekly review of database blogs. Let’s dive right in, shall we?
Oracle
On Radio Free Tooting, Andrew Clarke says, “No SQL, so what?” taking as his keynote something Nuno Souto said: “ . . . Google, Facebook, Myspace, Ning etcetc, and what they do as far as IT goes, are absolutely and totally irrelevant to the VAST majority of enterprise business.”
Aman Sharma gives an overview of Library Cache on Arista’s Oracle Blog.
On The Dutch Prutser’s Blog, …
[Read more]This is the 153rd edition of Log Buffer, the weekly review of database blogs.
Let’s start by revisiting a perennial issue with Craig Mullins addresses with the question, Are DBAs Obsolete? “Before we go any further, let me briefly answer the question posed in the title of this blog entry: ‘No Way!’,” writes Craig. “Every time I hear this it makes me shake my head sadly as I regard just how gullible IT publications can be.” He argues that an Internet-paced attitude regarding the work of the DBA may be the first culprit in the devaluation of the DBA’s work.
Oracle
Dion Cho, the Oracle Performance Storyteller, …
[Read more]Welcome to the 151st edition of Log Buffer, the weekly review of database blogs. We’re going to take a fast tour through the best blogs from the week gone by, beginning this time, with Oracle.
Jonathan Lewis writes, “It occurred to me recently that I might be making casual use of terms that weren’t necessarily very well known to the less experienced user. So I’ve decided to build a glossary of terms – and I’ll try to add to it from time to time whenever I have a few minutes.”
Jonathan might want to add “Method R” to the glossary. Cary Millsap was making it understood, …
[Read more]