(Barry McGillin) Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had the issues of passing variables to subscripts or managing password visibility when creating users, building objects or grantin
Other News
APAR Friday: Did you know you can now query SYSLGRNX, SYSUTIL, and SYSUTILX??
(Willie Favero) Yup, you read that correctly. You can now run SELECT against the directory table SYSIBM.SYSLGRNX. But that’s only 1/3 of the story. You can also now use SELECT against the directory tables SYSIBM.SYSUTILX and SYSIBM,SYSUTIL.
Executing MySQL queries with PHP mysqli
(Ulf Wendel) The mysqli quickstart series is coming to an end. Today, the post is about non-prepared statements. You may also want to check out the following related blog posts:
T-SQL to get various details on currently running Active processes on SQL Server Instance
(Manjunath C Bhat) Couple of day back i was working on something very important which will run some stored procedures to accomplish the task. Now there can be many transactions or different piece of codes in a Stored Procedure. Now just think that you come across a weird situation where you are not
How & where to use Repeater control?
(SheoNarayan) To list small collection of records on the page with custom layout, we can use asp:Repeater control. This article explains how to use asp:Repeater control.
Application Performance Optimization Replication
Application Performance Optimization – Replication I have been talking about Sharding as a technique for improving application performance. Sharding distributes your data across multiple servers with the intention to allow multiple server to server requests for data. Replication is another technique that is a close cousin to sharding. Replication is a term that is well understood for Relational database engineers. […]
Semantic Web as Relational Data and RDF
The Semantic Web is about creating a web of data by integrating data that comes from diverse sources: HTML pages, XML documents, spreadsheets, relational databases, etc. In order for software applications to be able to make use of these diverse data sources, a primary objective is to make the Inte
A Short Primer on XQuery
(Keith W. Boone) I was first introduced to the XQuery standard over 10 years ago when it was first in development as a draft W3C Standard. Back then, it was a mess and I swore I would never use it for anything.
Matching the Expected Output – Analytic RANK, ROW_NUMBER, DENSE_RANK, or Something Different?
(Charles Hooper) I noticed an interesting request on the comp.databases.oracle.misc usenet group, and I thought that I would make an attempt at solving the request. The original poster (OP) stated that he had a table with data similar to the following:
MDX: Nonempty v/s NonEmpty
(Karan Gulati) Returns the set of tuples that are not empty from a specified set, based on the cross product of the specified set with a second set.