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

Posted in: Technical Track

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.

Interested in working with Fahd? Schedule a tech call.

About the Author

I am in love with Oracle blogging since 2007. The blogging coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies enabled me to get Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth, I have been expressing my love for Exadata. These days for the last some years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *