(Ben Nadel) Lately, I’ve been trying to wrap my head around Node.js streams by reading through the Node.js source code. In the latest branch, I noticed that there were a lot of calls to debug(). And, when I looked at the source code for debug(), I noticed that it only ran when the environmental vari
Other News
The Latest and Greatest MySQL Replication Features in MySQL 5.7.5
(Luis Soares) The latest and greatest MySQL 5.7 development milestone release (DMR) is out (changelog). It is great to see such a strong and steady cadence of development releases. The latest one, 5.7.5, is packed with awesome features. Let me highlight a few ones related to replication.
Query to show sql_ids related to SQL Profiles
(Bobby Durrett) I have a number 0f SQL Profiles on a database I’m working on and I wanted to know the sql_id of the SQL statements that they relate to. Here is what I came up with:
PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME
(Andrew Reid) I tested this on Oracle 11.2. I created a profile called FOR_ANDREW with PASSWORD_REUSE_MAX set to 1. This meant that I could not reuse a password until I had used one other password first:
SCSM 2012 Setup Wizard error when selecting SQL Server instance
(Kubilay Hüsmenoðlu) When installing System Center Service Manager 2012 you are asked for a SQL Server instance that will host the ServiceManager database. After that the setup wizard looks for instances on the specified SQL Server machine.
Improved overload protection and workload prioritization for WebSphere Application Server
(Samantha Callich-Fortner) In IBM WebSphere Application Server Network Deployment, Intelligent Management features automatically protect against server overload, and the autonomic request flow manager (ARFM) lets you preferentially throttle traffic to ensure mission-critical applications continue to
Oracle Bloom Filters
(David Fitzjarrell) In Oracle releases 10.2.0.x and later join processing can be made more efficient by the use of Bloom filters, primarily to reduce traffic between parallel query slaves. What is a Bloom filter? Named after Burton Howard Bloom, who came up with the concept in the 1970s, it’s an eff
Session Time Out Warning Message Using jQuery in ASP.NET
(Sandeep Singh Shekhawat) In this article, we will look at how to show a warning message to the user prior to 15 minutes before the session time out, in other words if the user is in an idle state for more than 5 minutes then the user gets a message in the browser.
Starvation: Electronic books, DRM, the local library, and database locks
(Henrik Loeser) Over the past days I ran into an interesting database problem. It boils down to resource management and database locks. One of my sons is an avid reader and thus we have an ongoing flow of hardcopy and electronic books, most of them provided by the local public library (THANK YOU!).
DB2 Tips n Tricks Part 45 – How To Find JAVA Driver Name and Version
(Harishkumar Baburao Pathangay) How to Find JAVA Driver Name and Version Solution: