(Ray Rischpater) The last five years has seen a revolution in mobile application development as carriers around the globe have embraced developers in an effort to raise the average revenue per subscriber (ARPU). It’s an exciting fact that, as developers, we can now tap carriers to distribute mobile
Other News
Introduction to Basic SQL, Part 3 – Complex Joins and Sub-queries
(Lewis R Cunningham) In my previous article, I covered SQL Joins with two tables. Today, I will cover joining tables with three or more tables and using sub-queries to join. I’ll also throw in some details about the UNION clause and show other places a sub-query might be used.
WebSphere Replication Server Using Q Replication High Availability Scenarios for the AIX Platform
(Nagraj Alur, Steffen Herold, Huey Kim, Makiko Tsuchida and Mark Wiman) This IBM Redbook provides detailed instructions and scripts on managing failover and switchback in a bidirectional Q replication environment for the AIX platform. (pdf)
You can enable the lock pages in memory permissions to prevent SQL Server 2005 64-bit buffer pool memory from being paged out of physical memory
Under certain circumstances, the working set of the Microsoft SQL Server 2005 64-bit process may be paged out by Microsoft Windows. This behavior may cause a decrease in SQL Server 64-bit performance. Microsoft has found an issue that may cause the SQL Server 2005 64-bit working set to be trimmed.
Multiple MySQL Vulnerabilities
(Sophos) Several vulnerabilities have been reported in the MySQL database manager, which could be exploited by attackers to compromise a vulnerable system or obtain sensitive information.
Tools for Your .NET Space
(Christian Shay) You’re working on some C# or VB.NET routines that manipulate data you’re retrieving from Oracle Database. You need to access the database to edit and debug some stored procedures, modify some data in a table, change the structure of a table or view, or perform one of countless other
Database Output from CL
(Ted) I know that IBM added a lot of new programming features to CL in the past two releases. However, one of the features I’ve been hoping for–the ability to do output operations to database files–doesn’t appear to be among them. Please tell me that I’m wrong and that there really is a way to upd
De-duplicate tables using Oracle’s analytic functions
(Bob Watkins) Tables that don’t have a Primary Key constraint protecting them can have duplicate rows inserted into them. The traditional way to locate such duplicates is with a query using the GROUP BY and HAVING keywords. After grouping the data on the key columns and counting the rows in each gro
Database Visualization
(VGirish) When handling a project with hundreds of tables, it takes some time to understand the flows within the database. This is especially so if there is no document available. A possible scenario is legacy code up for maintenance or migration. After going through just a few tables, it becomes to
Paying Homage to Exploratory Data Analysis
(Steve Miller) When I first arrived to the work world 30 years ago, I encountered two roadblocks to my enthusiasm for mathematical and statistical optimization techniques in business. The first was a data management problem. Collecting, integrating, organizing and manipulating data was a very thorny