Welcome to the 167th edition of Log Buffer, the weekly review of database blogs.
Since all that OOW news forced Gerry to give them short shrift last week, let’s begin with blogs on . . .
SQL Server
Jeremiah Peschka gets our week going with his refresher introduction to SQL Server system databases.
Likewise, Pinal Dave reviews the difference between candidate keys and primary key.
…
[Read more]
If you are SQL Server DBA interested in comparing "apples to
apples" with MySQL... tomorrow's free webinar will be worth checking out.
Windows/SQL Server vet Mike Frank and I will be running through
the feature sets of both products and sorting out functional
equivalents. (And yes, there will be some apples to oranges
comparisons as well!) We'll be covering security, log
shipping/replication, datatypes, partitioning and clustering just
to name a few.
It's not too late to sign up for this and the rest of the "MySQL
on Windows" webinar series, either...
Register for tomorrow's webinar here
View the upcoming webinars scheduled in the rest of the "MySQL on
Windows" series …
Welcome to the 165th edition of Log Buffer, the weekly review of database blogs.
Since they haven’t had any Log Buffer love for a couple weeks, let’s start this one with . . .
PostgreSQL
Selena Marie Deckelmann was tending the garden and found a Snow Leopard amongst the Macintoshes. The result, her post Snow Leopard and PostgreSQL: installation help links.
Josh Berkus posts a poll on encrypted backup. he writes, …
[Read more]Patents. M&A. Adoption. Business strategies. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca
“Tracking the open source news wires, so you don’t have
to.”
This bumper edition of 451 CAOS Links is brought to you courtesy of the Open World Forum’s temperamental wireless connection.
Patents
# Red Hat urged
the Supreme Court to to make clear that it excludes software from
patentability, while the SFLC and the FSF also filed briefs with the US Supreme Court
arguing against software patents.
Investment and M&A
# The WSJ …
Welcome to the 164th edition of Log Buffer, the weekly review of database blogs.
SQL Server
We have a delicious assortment of technical posts from the SQL Server world this week.
Piotr Rodak writes, “While I always knew and imagined that ON DELETE CASCADE may be useful, I wondered, what scenarios would be suitable for ON UPDATE CASCADE. I still don’t have this answer, but I came across some interesting behavior which kept me occupied for quite a bit more time that I had intended to.”
On In Recovery…, Paul S. Randall pursued the answers to …
[Read more]Welcome, readers, to the 163rd edition of Log Buffer, the weekly review of database blogs, your sieve
Oracle
First, the ghastly news—Tom Kyte said “I’m not a DBA anymore.” Say it ain’t so, Tom! “After nine years and nine months of running the database that hosts asktom, I’ve retired . . . not from answering questions, but rather from being the DBA and semi-SA for the machine that was asktom.oracle.com.” Okay, so he said it ain’t so.
Meanwhile, Tom’s Oak Table colleague, Jonathan Lewis, played no head games on us, but he has been at the hash …
[Read more]Welcome to the 162nd edition of Log Buffer, the weekly review of database blogs.
Oracle
The big news this week came was Oracle’s unveiling the OLTP Oracle Database Machine & Exadata v2, as reported by Alex Gorbachev.
Kevin Closson covered it, of course: Oracle Drops Exadata In Favor of Sun FlashFire Based OLTP Database Machine?, and he and his readers kick it around in a diverting way.
…
[Read more]Devart, a vendor of native connectivity solutions and development tools for Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite databases, has announced the release of dbForge Schema Compare for SQL Server 1.50, a sophisticated tool specially designed to meet a diversity of comparison tasks, help analyze schema differences at a glance, and synchronize them correctly, saving time and efforts.
With the new release, Devart continues its dedication to providing a line of safe as well as powerful tools for SQL Server database synchronization.
The highlights of Schema Compare for SQL Server 1.50 include:
* Table data verification after synchronization
dbForge Schema Compare for SQL Server 1.50 moves forward in delivering safe synchronization. The present-day market, saturated with all sorts of …
[Read more]Welcome to the 161st edition of Log Buffer, the weekly review of database blogs … and the first one under my penmanship.
MySQL
Johan Andersson explains in a very simple way the scenarios in which you may fall into a split brain situation and how to avoid it in MySQL Cluster on two hosts – options and implications. An article worth reading from one of the MySQL Cluster experts.
I love simple scripts that solve complex problems. I love it even more when the command line can be defined in an alias, and SQL from SQL offers some …
[Read more]Update 16-Sep-09: Apparently, all this was true and you can find more details after the announcement that posted here.
OK. It’s not often that I make predictions these days but this was on my mind for a while so here we go. Mind you, I don’t have any confirmed insider information so it’s based on some assumptions, my perspective on Oracle-Sun acquisition and some vibes I can feel in the air.
The rumors are that Oracle Exadata v2 and Oracle Database Machine v2 are going to be announced within few weeks and my take is that it’s going to happen at the Oracle Open World. I don’t think it comes as a surprise to anyone that it will be configured with Oracle Database 11g Release 2.
Moving on to …
[Read more]