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

Posted in: Log Buffer, Technical Track

As the festive season of holidays draws near, there is a spring in the blogosphere. This Log Buffer edition anticipates that and picks some lively blog posts from Oracle, SQL Server and MySQL.

Oracle:

  • Truncate is one of those commands that cannot be undone trivially…In fact, you might well be looking at a database recovery in order to get a truncated table back to a “full” state.
  • It should be rare to see many TNS listener processes running on 1 OS. Some listeners are even Global Data Services listener.
  • The fact that an extension explicitly created by a user through DBMS_STATS can invalidate objects like packages is not new in 12c. It has been like that since the introduction of extensions in 11g.
  • Monitoring is a critical and necessary function to ensure that systems and process are running properly. Good monitoring practice can also be proactive in identifying and resolving potential problems before they occur.
  • Creating Multiple Tables in a Single Transaction.

SQL Server:

  • Execute these stored procedures to backup all your database daily and your transaction logs several time daily.
  • At some point you are going to experience issues with database performance.  You need to have a process to follow and certain tasks that you should perform.
  • PowerShell is like any computer language: you must understand the paradigms, the constructs, and the way it is designed to work to get the most value from it.
  • With the introduction of SQL Server 2016 you now have a new way to encrypt columns called Always Encrypted.
  • Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure.

MySQL:

  • Ahead of Oracle’s OpenWorld conference in 2013, the company first began to talk about a major new release of its open-source MySQL database. Now two years later, development on MySQL 5.7 is compete and general availability is set for October 26.
  • POWER8 Accelerated CRC32 merged in MariaDB 10.1
  • used_key_parts: EXPLAIN FORMAT=JSON provides insight into which part of multiple-column key is used.
  • MySQL 5.8 Planning: C++11 and Native Partitioning.
  • Knowing which privileges a given account has is easy – just issue SHOW GRANTS FOR user@host.  But what about when you need visibility into privileges from the other direction – which accounts can access specific data?

 

Learn more about Pythian’s expertise in Oracle SQL Server & MySQL.

email

Author

Interested in working with Fahd? Schedule a tech call.

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 *