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 [email protected] 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.
No comments