This Log Buffer Edition covers various valuable blog posts from the fields of Oracle, SQL Server and MySQL.
Oracle:
- Oracle Big Data Appliance X5-2 with Big Data SQL for the DBA.
- Loading, Updating and Deleting From HBase Tables using HiveQL and Python.
- In keeping with the ODA quarterly patching strategy, Appliance Manager 12.1.2.3 is now available.
- From time to time someone publishes a query on the OTN database forum and asks how to make it go faster, and you look at it and think, “it’s a nice example to explain a couple of principles because it’s short, easy to understand, obvious what sort of things might be wrong, and easy to fix.”
- Optimizing the PL/SQL Challenge IV: More OR Condition Woes.
SQL Server:
- Will RDBMs be obsolete? Should Data Professionals care about Big Data technologies? What is NoSQL? What is Hadoop?
- In a development team, there are times when the relationships between developers and testers can become strained. How can you turn this potential conflict into something more positive?
- Michael Fal is a huge advocate of automation and many ways it can improve the lives of developers and DBAs alike, but you can’t just automate all your problems away.
- One way to handle a very complex database project with several databases and cross references.
- Building the Ideal VMware-based SQL Server Virtual Machine.
MySQL:
- Optimizing Out-of-order Parallel Replication with MariaDB 10.0.
- General-purpose MySQL applications should read MySQL option files like /etc/my.cnf, ~/.my.cnf, … and ~/.mylogin.cnf. But ~/.mylogin.cnf is encrypted.
- Creating and Restoring Database Backups With mysqldump and MySQL Enterprise Backup.
- If you don’t know much about bash shell, you should start with the prior post to learn about bash arrays.
- Installing Kubernetes Cluster with 3 minions on CentOS 7 to manage pods and services.
Learn more about Pythian’s expertise in Oracle , SQL Server and MySQL.
No comments