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

Posted in: Microsoft SQL Server, MySQL, Oracle, Technical Track

This Log Buffer Edition throws spotlight on some of the salient blog posts from Oracle, SQL Server and MySQL.

Oracle:

  • STANDARD date considerations in Oracle SQL and PL/SQL
  • My good friend, Oracle icon Karen Morton passed away.
  • Multiple invisible indexes on the same column in #Oracle 12c
  • Little things worth knowing: Data Guard Broker Setup changes in 12c
  • Things that are there but you cannot use

SQL Server:

  • Dynamic Grouping in SSRS Reports
  • SQL 2014 Clustered Columnstore index rebuild and maintenance considerations
  • SQL Server 2016 CTP2
  • Azure SQL Database Security Features
  • Visualize the timeline of your SQL jobs using Google graph and email

MySQL:

  • Shinguz: Max_used_connections per user/account
  • Generally in MySQL we send queries massaged to a point where optimizer doesn’t have to think about anything.
  • Replication is the process that transfers data from an active master to a slave server, which reproduces the data stream to achieve, as best as possible, a faithful copy of the data in the master.
  • Unknown column ‘smth’ in ‘field list’ -> Oldie but goodie error
  • Why base64-output=DECODE-ROWS does not print row events in MySQL binary logs

Learn more about Pythian’s expertise in Oracle , SQL ServerMySQL.

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 *