As always, this fresh Log Buffer Edition shares some of the unusual yet innovative and information-rich blog posts from across the realms of Oracle, SQL Server and MySQL.
A developer reported problems when running a CREATE OR REPLACE TYPE statement in a development database. It was failing with an ORA-00604 followed by an ORA-00001. These messages could be seen again and again in the alert log.
- Few Random Solaris Commands : intrstat, croinfo, dlstat, fmstat for Oracle DBA
- When to use Oracle Database In-Memory?
- Oracle Linux and Oracle VM at EMCWorld 2015
- SQLcl connections – Lazy mans SQL*Net completion
- SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.
- The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value, whereas STUFF allows you insert or replace a string value into or in between another string value.
- After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.
- Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?
- There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution.
- MariaDB 5.5.43 now available
- Testing MySQL with “read-only” filesystem
- There are tools like pt-kill from the percona tool kit that may print/kill the long running transactions at MariaDB, MySQL or at Percona data instances, but a lot of backup scripts are just some simple bash lines.
- Optimizer hints in MySQL 5.7.7 – The missed manual
- Going beyond 1.3 MILLION SQL Queries/second