This Log Buffer Edition brings some freshly picked blog posts right out of the gardens of Oracle, SQL Server and MySQL.
Oracle:
Suppose you have a process A that you want to run faster. This process doesn’t commit (much), so it doesn’t wait on log file sync. However, there is another multi-threaded process, B, that commits very frequently, and spends a lot of time on “log file sync”.
New Solaris 11 CPU package to install and track CVE security fixes.
Upgrade/Migrate/Consolidate to Oracle 12c and Parallel Multitenant Upgrade Internals.
CVE metadata in Solaris IPS packages for improved Compliance reporting.
SQL Server:
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
Explaining The SQL Server 2014 Analysis Services Data Mining Model Lift Chart.
By this stage, you should be familiar with the basics of SQL Server indexes. We’ve discussed what an Index actually is, as well as some of the most common types you’re likely to encounter. Now that we’ve seen some simple examples of how Indexes can be useful, we’re going to delve deeper into nonclustered indexes, as we’ll see how they can improve the performance of more complex queries.
The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.
A technique to deal with lack of metadata for stored procedures when used with SSIS.
MySQL:
How to mess up your data using ONE command in MySQL/Galera.
High season is coming, how do you make sure that MySQL will handle the increased load? Stress tests could help with that, but it’s not a good idea to run them in a production environment. In this case Select_scan, Select_full_join and other MySQL counters could quickly give you an idea of how many queries are not performing well and could cause a performance degradation as the load goes up.
Nasty MySQL Replication Bugs that Affect Upgrade to 5.6.
(More) Secure local passwords in MySQL 5.6 and up.
Alternatives for chunking bulk deletes in common_schema.
No comments