You may know that I created a SQL Reserved Keywords Checker a few years ago. I was just noticing today that a lot of people are searching for the same keywords. Here's a list of the top 10 keywords people searched for using the tool in the past year:.

OpenSQL Camp is a free unconference happening Friday, Nov. 14th through Sunday, Nov. 16th in Charlottesville, Virginia, USA. More details can be found at http://www.opensqlcamp.org.

Whether or not you have already registered for OpenSQL Camp by putting your name here:

http://www.opensqlcamp.org/index.php?title=Events/2008/AttendeeList

you should be aware of very important information.
(more…)

Previously on Log Buffer: Log Buffer #119.

And now.

Welcome to Log Buffer #120. My name is Warner, and I’m a SQL Server DBA at The Pythian Group. This is my first time on Log Buffer duties ever, so here’s hoping I can give everyone a fair and unbiased look at this week in the database blogging world (and related).

I admit I had no idea of the community or state of the PostgreSQL RDBMS, and so I definitely learned some new stuff this week. First off, over on “The Scale-out Blog” Robert Hodges invites us all to get our …

Robert Treat and I had some back and forth emails a few weeks ago about explaining database replication to customers. Replication is totally cool but it is also completely confusing to a lot of people. The basic concepts are not widely understood. Plus PostgreSQL does not help by giving you a wide range of methods, often with poorly documented trade-offs.

Based on our conversation I put together a talk for PG West in Portland called Getting Smart about the New World of PostgreSQL Replication. It explains basic concepts and surveys five replication approaches. Press the title and you can possess the slides yourself.

Robert and I had talked about putting …

Sorry for the outage, everyone. We’re looking into the causes of the downtime (and sponging the sweat off our keyboards), but for now we’re happy just to be back. Stay tuned for a real blog article soon.

The 118th edition of Log Buffer, the weekly review of database blogs, has been published on Ward Pond’s SQL Server blog.

Log Buffer is the only platform-neutral, distributed, human-edited article on database blogs. It receives several thousand views each week, and publishing an edition on your own blog brings those views to you. Hosting an edition of LB also introduces you and your blog to your colleagues in the DB blogosphere. Write me an email and I’ll get you started.

Now, here’s Ward Pond’s Log Buffer …

As I was already up since yesterday 0500 , it was dinner with Sven , Robin and some other conference visitors at a Turkish Buffet place , after which we headed to what seemed to be a great bar where they failed to serve us while waiting for over 10 minutes, so we moved on to another place. and then to be "early"

After walking around a bit in Copenhagen and looking for a bus stop to go to the university I managed to bump into Wim & Co who offered me a ride to the IT University. Where I was almost in time for the first talk by
Jan Wieck about Slony-I, A master to multiple slaves-replication system for PostgreSQL
Given my recent MySQL MultiMaster setups I was fairly interested where PostgreSQL is at today.

Jan started out with explaining where he used replication the most,
For backups and Specialized services so he could offload long running and intrusive reporting tools to an isiolated server.

While …

Welcome to the 117th edition of Log Buffer, the weekly review of database blogs.

For those of you who don’t know me, my name is Nicklas Westerlund, and I’m a MySQL DBA with The Pythian Group. This is my first time writing Log Buffer, and I hope I’ll do it right.

Let’s start off with SQL Server, where Simon Sabin asks if you know what concurrency is and how to improve it. And on SatisticsIO, Jason Massie focuses on the …

Welcome to the 116th edition of Log Buffer, the weekly review of database blogs.

This was the week of Oracle Open World (OOW), Oracle’s gigantic annual get-together in San Francisco — always the heaviest week in Oracle blogs, so let’s start there.

For day-by-day coverage of OOW on the ground, I recommend Doug’s Oracle Blog: OOW Day 1, OOW Day 1.5, OOW Day 2, …

Recently I am been testing few pieces of Storage projects of OpenSolaris with PostgreSQL. One of tests involves using an iSCSI disk  with PostgreSQL.  Unfortunately the storage that's available is  in Colorado  while my PostgreSQL server is  located in Massachusetts. Latency will definitely be one of my top problems since storage  is halfway across the country (in Colorado). Plus the fact that I will be running a database server on my end  doesn't really sound like a good idea. Come to think about it, this could be a more common problem nowadays since Cloud Storage (for example Amazon S3 Webservice ) could be  optimistically  half way across the country and pessimistically be on the other side of the world.

 So what are my options to solve such problems?  …