Log Buffer #480: a carnival of the vanities for DBAs

Posted in: Log Buffer, Technical Track

This Log Buffer Edition picks a few of the useful blog posts from Oracle, SQL Server and MySQL.

Oracle

Paul closed a bug yesterday that’s been kicking around for almost a year as a sometimes fails on CI but no-one can figure out why. Frustration!

Are You Pursuing the Most Current Version of Oracle Identity Governance Certification?

Debugging PL/SQL Collections Revisited

When you buy an Oracle Database Appliance (ODA) X5-2 off the shelve, you will get a machine with four times 10Gb copper Ethernet (bonded into two interfaces) for public communication and two 40Gb InfiniBand (bonded into one interface) for interconnect communication between the two ODA_BASE’s.

A couple of notes of the automatic generation of a SOA Suite/OSB domain

SQL Server

Despite the sophistication of the latest DB2 software versions and the power of current IBM z/server technology, it is still possible for performance and data availability to deteriorate due to a variety of things, including increased dataset extents, loss of clustering, index page splits, and other factors.

Practical Uses for Synonyms in SQL Server

Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.

SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially.

One of the difficulties of designing a completely different type of development tool such as SQL Clone is that you have to explain what it is for, but when its use is open-ended it can be exciting to see the novel uses that come out of the early-access program.

MySQL

Calculating MySQL Database, Table, and Column Sizes

SQLite and Standard SQL

MariaDB 10.0.26 now available

Migrate from MS SQL Server to MySQL

The Perfect Server CentOS 7.2 with Apache, Postfix, Dovecot, Pure-FTPD, BIND and ISPConfig 3.1

email
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 *