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

Aug 16, 2013 / By Fahd Mirza

Tags: , , ,

Does size matter? This question has been teasing mankind since the beginning. But now, due to improvements in technology, size doesn’t really matter. Databases now have the features to tackle all data: big, medium, small, or very small. This Log Buffer Edition is here once again to bring you your data news of all sizes.

Oracle:

Marco tells us how to create a pluggable database by cloning an existing local PDB and talks about a bug in Oracle 12c.

Niall installs SQL Developer on Debian Based Distributions.

Jonathan Lewis came across a funny little problem when setting up some materialized views.

Chris Antognini talks about the broken statistics “parse count (total)” and “session cursor cache hits”.

Tanel Poder writes about scalar subquery unnesting transformation in Oracle 12c.

SQL Server:

Thomas LeBlanc discusses Baton Rouge SQLSaturday and Tech Day 2013.

Audrey Hammonds has a tip for bloggers and blog-readers: Think like a journalist!

AlwaysOn was introduced in SQL Server 2012, and there are some enhancements in SQL Server 2014.

Jose Chinchilla is configuring BIDS 2008 /2008 R2 and Visual Studio 2008 to work with Database and Business Intelligence Projects as well as Team Foundation Server (TFS).

Kenneth Fisher has posted yet another script from his arsenal.

Shaun Stuart is enabling compression in SQL Server.

MySQL:

Dave Stokes invites us to learn how many government agencies, such as NASA, Census, NARA, and DoD, deploy MySQL as the default database for their mission-critical applications.

Who is working on MySQL 5.7?  Stewart Smith asks.

Andrew Morgan informs that there are new replication and HA white papers for MySQL.

Giuseppe Maxia says that time zones are a tricky feature. You live in a given time zone, and most of the time you won’t think about that at all.

Nilnandan Joshi describes third party solutions for master-master replication in MySQL.

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>