(Geert Vanhove) SQL Server database systems are more than ever before being chosen as the preferred backend database solution for large business’s critical systems. And SQL Server richly deserves this status. As a result of this, more users than ever before are blocked in their daily activity when t
Other News
Encrypting data in SQL Server: Dos and don’ts
(Serdar Yegulalp) There have been all too many instances in the news lately where someone has gained outside access to a database — usually for a turnkey commerce solution — discovered that sensitive information in the database such as user names, passwords, credit card numbers or addresses were a
Samsonite to dump Oracle under SAP program
(Robert Westervelt) SAP is highlighting its latest customer win under its broadened Safe Passage program, which was launched to lure away newly acquired PeopleSoft, J.D. Edwards Co. and Retek customers from Oracle onto SAP. (R)
BLOBs help you manage files from Web apps
(Paul Holm) A common requirement for business applications is to be able to manage documents from a Web application. Documents may include file types such as pictures, Excel files, Word files and video. (R)
Asked and Answered
(Robert Catterall) Do you know of any products that use DRDA without a local DB2 in an MVS (OS/390, Z/OS) environment? I’m looking for a way to isolate DB2 into its own LPAR to take advantage of IBM’s Workload License Charges (WLC) pricing. By running DB2 in one LPAR and having CICS and batch separa
A View of Creating an Oracle User – Part II
(James Koopmann) In Part I of this series, a methodology was given on how to create a user. If you did not get a chance to read Part I, please do so now before continuing with Part II, as Part II builds upon Part I and requires an understanding of how a basic user is created.
Obtaining Wireless News with J2ME and PHP
(Alessandro Lacava) The Java 2 Platform, Micro Edition (J2ME) is targeted at cell phones, smart cards, pagers, and other consumer devices. J2ME technology consists of a virtual machine and a set of APIs suitable for tailored runtime environments for these devices. PHP, on the other hand, is a widely
First Steps With Jakarta Struts, Part 2
(John Topley) Last time we looked at Jakarta Struts, I explained the persistence and business object layers and we wrote code to retrieve the list of topics from the database and represent them as objects. We used a Struts ActionMapping and an ActionForward, to get as far as the JSP that will actual
MySQL’s Full-Text Formulas
(Peter Gulutzan) A MySQL full-text query returns rows according to relevance. But what is relevance? It is a floating-point number based on formulas. Researchers have shown that these formulas produce results that real users want. I will disclose how MySQL 4.1 uses them, with a bit of arithmetic and
Joins and Aggregates Are Critical for Achieving Faster Data Retrieval in a Dimensional Data Warehouse
(Craig Abramson and Thomas Mascoli) Discover how to improve the performance of your data warehouse with this white paper. It shows you how to use techniques such as maintaining aggregates, separating descriptive data from factual information, and preparing fact and dimensional tables. (pdf)