(Dinis Cruz) When me and Abe where at DefCon working on the final version of the slides for the RESTing On Your Laurels will Get YOu Pwned presentation, we come up with a nice way to talk about the different approaches that can be taken when converting XML into Objects (the examples here are in Jav
Author: SSWUG Research
Care and Feeding of Statistical Views
(Ember Crooks) The whole point of statistical views is to improve the performance of SQL that joins tables. Or to help you collect statistics on expressions – though if you’ve got 10.5, consider expression-based indexes for that instead. Giving the DB2 Optimizer more data is generally a good thing f
December 24, 2013
(Matthias Nicola) As you probably noticed, DB2 10.5 features a new technology called BLU Acceleration which provides significant gains in performance, reduced storage consumption, and simplicity for analytical database workloads.
TechTip: Add Lock Detection to Your DB2 for i Arsenal
(Michael Sansoterra) If you’ve ever wanted to yell at users and tell them to exit a specific screen (or wanted to just happily end their job automatically) because they’re locking a record, then this tip is for you. Best of all, you’ll be able to use this functionality right from the comfort of your
Integrating pt-online-schema-change with a Scripted Deployment
(Mike Benshoof) Recently, I helped a client that was having issues with deployments causing locking in their production databases. At a high level, the two key components used in the environment were:
Bindings in Knockout Part 1
(RamaSagar Pulidindi) Knockout is a standalone JavaScript implementation of the Model-View-ViewModel pattern with templates.
Analyzing Historical Performance Data – More Reports, Tuning Tactics
(Lockwood Lyon) This report allows the DBA to drill down into plan/package details. It gives extremely detailed information about Plans and Packages. It is typically used after the DBA has referenced the Accounting Short Report and determined that there may be a performance issue.
ADO.NET: How to use a Stored Procedure
(Ged Mead) This post shows you how to use an existing Stored Procedure. Because this is a series on ADO.NET, I don’t want to get distracted from that mainstream topic and that does mean that sometimes I don’t cover SQL Server techniques that you might not be familiar with.
An Advantage of MySQL Row-based Replication
(Ike Walker) Recently I wrote about one advantage of MySQL statement-based replication. In the comments of that post Andrew Moore pointed out that I can set slave_exec_mode=IDEMPOTENT on my replicas in order to get similar behavior in row-based replication. Thanks Andrew!
Count number of rows returned in APEX report
(Scott Wesley) Often I want to configure an APEX page based on how many rows have been returned in a (typically classic) report region. There are a number of methods for determining this row count, and some have advantages over others.