(Randolf Geist) A new version 4.1 of the XPLAN_ASH utility is available for download.
Other News
12c nasty with remote query optimization
(connormcdonald) We have a fairly common query process, where we run a MERGE command to compare a remote table to a local copy of it, as “poor mans” Golden Gate to bring that table up to date on a regular basis.
DB2 Application Performance Management
(Craig S. Mullins) Assuring optimal performance for database applications can be a tricky thing. In today’s blog I ruminate on the high-level issues involved in optimizing your DB2 for z/OS applications.
Failover with the MySQL Utilities – Part 1: mysqlrpladmin
(Stephane Combaudon) MySQL Utilities are a set of tools provided by Oracle to perform many kinds of administrative tasks. When GTID-replication is enabled, 2 tools can be used for slave promotion: mysqlrpladmin and mysqlfailover. We will review mysqlrpladmin (version 1.4.3) in this post.
Working with FileTable Constraints
(John Pertell) I’ve been playing a little more with FileTables lately, and I thought I’d share some of what I’ve seen when applying my own constraints. I’m testing with a SQL 2014 Developer Edition instance, but I can recreate everything here in 2012 editions too.
Scheduling Tasks with Revalee and MVC
So you’re almost finished with the user registration portion of your MVC project, but you need to be able to send an email to each user 3 days before their 30-day trial plans are about to expire. Now what?
Back to Buffer Pool Basics: Part 6 – PGFIX(NO/YES)
(Willie Favero) This simplest of changes could give you your biggest bang for your buck. It’s the easiest buffer pool change you can make to reduce your CPU usage. There are a few things to consider like all things DB2.
Caching: the Good, the Bad and the Hype
(Dino Esposito) One of the more important aspects of the scalability of an ASP.NET site is caching. To do this effectively, one must understand the relative permanence and importance of the data that is presented to the user, and work out which of the four major aspects of caching should be used. T
ASP.NET MVC bibliography
(Vishwas Sutar) This brief article explores the features and differences in different versions of the ASP.NET MVC.
Migrating From ui-if To ng-if In AngularJS
(Ben Nadel) When I first started using AngularJS a few years ago, I also started using a library called Angular-UI. This was a supplemental module that filled in a few of the holes in the AngularJS core. For me, the best part of Angular-UI was a directive called “ui-if”.