Showing entries 11 to 20 of 61
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: DB2 (reset)
Log Buffer #209, A Carnival of the Vanities for DBAs

Welcome to Log Buffer, the weekly news update of happenings in the database world.

A big shout out to Pythian team members Andrey, Gwen, Fahd, and Don for their submissions. We have lots of news and recommended reading this week so let’s get going with Log Buffer #209.

Andrey Goryunov’s top picks:

Dion Cho, the Oracle Performance Storyteller, provides an explanation of parallel DML execution plan.

Christian …

[Read more]
Here Again

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!

Log Buffer #205, A Carnival of the Vanities for DBAs

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]
Log Buffer #204, A Carnival of the Vanities for DBAs

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]
Log Buffer #182, a Carnival of the Vanities for DBAs

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]
Log Buffer #180: A Carnival of the Vanities for DBAs

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]
Log Buffer #160: a Carnival of the Vanities for DBAs

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]
Log Buffer #158: a Carnival of the Vanities for DBAs

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]
Log Buffer #154: a Carnival of the Vanities for DBAs

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]
Log Buffer #153: a Carnival of the Vanities for DBAs

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]
Showing entries 11 to 20 of 61
« 10 Newer Entries | 10 Older Entries »