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

Feb 7, 2014 / By Fahd Mirza

Tags:

Here in your hands, there is yet another fresh sizzling hot edition of the celebrated Log Buffer. Enjoy the collection of assorted gems from Oracle, SQL Server and MySQL.

Oracle:

Oracle Cloud—The Modern Cloud for Your Modern Business.

Oracle ADF Virtual Developer Day – On Demand in YouTube.

When Impala started, many of the early adopters were experts in HiveQL, so the Impala documentation assumed some familiarity with Hive SQL syntax and behavior.

Improve Your Customer Experience Through World-Class Data Quality.

There continues to be a disproportionate amount of hype around ‘NoSQL‘ data stores.

SQL Server:

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.

Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data.

When should you use a SQL CLR Aggregate? Lots of people have struggled with this one, but David Poole found a use, and has some interesting performance data analysis as well.

Free eBook: Understanding SQL Server Concurrency.

Fix SQL Server Log Shipping After a New Database File has been Added.

MySQL:

MariaDB 5.5.35 was recently released (it is the latest MariaDB 5.5), and is available for download.

jQuery and GIS distance in MariaDB.

Filesort optimization in 5.7.3: pack values in the sort buffer

Keith Hollman has written about –use-tts backup & restore.

Why delegating code to MySQL Stored Routines is poor engineering practice.

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>