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

Aug 12, 2011 / By Fahd Mirza

Tags: , , ,

The season of conferences, webinars and seminars is coming. As the summer vacations are coming to a sumptuous and fulfilling end, the techies are getting ready towards sharpening and sharing their technical know-how with the public through the events. From MySQL to Oracle to SQL Server, the things are all set to appease your technical buds through the events. This Log Buffer contains some news about those events along with much more in this Log Buffer #233.

Oracle:

Richard Foote and Indexes go hand in hand. Here is another sparkling post from him.

A couple of Gerry‘s customers have claimed to me that it’s not possible to apply all the latest available Solaris patches using Ops Center Enterprise Manager. But he thinks that it is possible.

Skiller knows which mobile market to target when they want to create a cross-platform mobile software development kit for social networking games. They choose Java ME technology. Hinkmond has more.

Kerrie Foy presents a recap of recent customer announcements regarding the Agile, which is quite a lot in the news.

Tanel Poder has uploaded Full scans, direct path reads and ORA-8103 error hacking session video on the blip.tv

Doug‘s default method of communicating* SQL performance issues to colleagues is SQL Monitoring reports now for the last two years or so.

No other company in the world outside of Oracle has got more ACEs than Pythian. So much so that Oracle itself calls it an Oracle ACE Factory. Pythian is where Exadata and other technologies change lives. Pythian’s Oracle ACE Fahd Mirza was profiled in latest issue of Oracle Magazine.
SQL Server:

In Bellevue, the Service Broker sample application from SQLskills Immersion Event was a success and Klaus Aschenbrenner shares his sample Service Broker application.

In his famous development series, Pinal Dave sheds light on Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ).

Finding duplicate rows in a table can be done easily by using ROW_NUMBER() function. You can number each similar rows by using PARTITION BY clause. Vishal has more.

Jen McCown got amused a lot as he got an interesting T-SQL error.

James Serra lets us know that the newly released product guide of Denali contains the latest datasheets, white papers, click-through and auto-running demonstrations, hands-on lab previews, technical presentations, and other useful links.

MySQL:

Conor O’Mahony over at IBM wrote a good post on a favorite topic of mine “The Future of the NoSQL, SQL, and RDBMS Markets”.

Alex Lurthu wanted to optimize and test backups for one of HIS new large scale setup before he could finalize on the backup plan. His challenge was the data volume was almost 30x more than his normal volumes.

Jay Lyman has written about how a bad economy is indeed good for open source software.

Henrit Ingo is running sysbench tests against a Galera cluster after his vacations.

Percona, the leading independent provider of professional services for MySQL, will host the Percona Live MySQL Conference and Expo on April 10-12, 2012.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>