(Mark Riddoch) Here we take a look at how one of the example filters supplied with the MaxScale 1.0 beta can answer that simplest of profiling questions – “Which of my database queries run within the MySQL server for the longest time?”.
Other News
Secure Your Connection String
Here’s an old problem for which the solution continues to creep out now and again. How do you make your database connection string for applications? I was reminded of this again on one of my group forums for Java. The author was pointing out that many times our connection strings are not only visible, but sometimes find themselves embedded in […]
Tips for using User-Defined Functions in SQL Server 2014
Tips for using User-Defined Functions in SQL Server 2014 Try to avoid using nested user-defined functions. Because using nested user-defined functions can result in some performance degradation, try to break down a nested function into simpler functions. Consider using CLR user-defined functions. The CLR user-defined functions were first introduced in SQL Server 2005. You can write the user-defined functions in...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Bind Your Error Handler Before Your Readable Handler When Using Node.js Streams
(Ben Nadel) If you’ve been using Node.js for a while, streams are probably second nature to you; but, for me, streams have proven to be quite a hurdle with many facets that don’t seem immediately obvious. One such concept that recently tripped me up was the importance of binding your “error” event h
Understanding Neural Network Batch Training: A Tutorial
(James McCaffrey) There are two different techniques for training a neural network: batch and online. Understanding their similarities and differences is important in order to be able to create accurate prediction systems.
Ensuring High Availability in ADF Task Flows
(Duncan Mills) Just a quick article today on ADF Controller Scopes and specifically ensuring that your application is correctly propagating state stored in PageFlow and View Scope across the cluster.
Showing Foreign Key Names in your Data Modeler Diagrams
(Jeff Smith) The question: In version 4 of Oracle SQL Developer Data Modeler, how do I get the names of foreign keys to appear on the relational model diagram?
OGG-00212, what a frustrating error.
(Bobby Curtis) Normally, I don’t mind errors when I’m working with Oracle GoldenGate (OGG); I actually like getting errors, keeps me on my toes and gives me something to solve. Clients on the other hand do not like errors…LOL. Solving errors in OGG is normally pretty straight forward with the help
pureScale at the Beach. – What’s New in the DB2 ‘Cancun Release’
(Kelly Schlamb) Today, I’m thinking about the beach. We’re heading into the last long weekend of the summer, the weather is supposed to be nice, and later today I’ll be going up to the lake with my family. But that’s not really why the beach is on my mind.
DB2 10 for z/OS, 1 MB Page Frames, and the Number 6656
(Robert Catterall) I recently received an interesting message from a mainframe DB2 person I’ve known for a long time. At his DB2 10 for z/OS site, 1 MB page frames had recently been made available on the System z servers, and my friend moved to leverage this resource via page-fixed DB2 buffer pools.