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

Posted in: Technical Track

This Log Buffer Edition is a one-stop joint to know about the latest blog entries regarding database technologies like Oracle, SQL Server, and MySQL. Enjoy!

Oracle:

Whilst working with Oracle BPM Process Composer, Andrew began to receive the following error when opening projects…

Christian Screen is moving ODBC DSNs from source machine to target.

Dimitri Gielis is starting a series of blog posts about APEX 4.2.

Mohan Prabhala blogs about what enables Oracle Secure Global Desktop to allow access from anywhere.

Prateek Kumar Shaw came across a use case where we need to have select all and select none as well as get selected rows into backing bean where welater  want to perform operations on select records of a table.

SQL Server:

In Kalen Delaney‘s experience, it is MUCH more common to have people turn off row or page locks when they shouldn’t, and by inspecting the sys.indexes catalog view, you can tell if that has happened.

Many people are looking for books about Analysis Services Tabular. Marco Russo mentions two books.

Why are so many DBCC commands undocumented? Paul asks.

Pedro has started a new challenge in life. Challenge always corresponds to change, which is always lively.

Dinesh Priyankara has a cool blogpost about TABLE Type and MERGE Statement.

MySQL:

How exactly secure is ClouSE for MySQL, the first secure database in the cloud? Are we protected against standard application level security attacks or even accidental admin mistakes? Artem Livshits answers.

MySQL as a Key Value Store (KVS) is always intriguing. Andres Karlsson shares his experience.

Brendan Gregg works on weird and challenging performance issues in the cloud, often deep inside the operating system kernel. Yes, it’s already interesting.

Sean Hull mentions five things you overlook normally with MySQL dumps.

Transparent encryption does not make your database secure, Justin Swanhart says.

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This 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 has enabled me to receive the 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. For the last few 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 *