(Sérgio Fontes) In this series of articles I want to analyze and describe database and query development for web solutions, as development technology we will use SQL and Microsoft SQL Server 2000 as the database engine. After making a small trip on the SQL basics we are ready to take a look on T-SQL
Other News
Trying Oracle on Linux in the Enterprise
(Kevin Cade) My company runs its Oracle databases on HPUX11i and Hewlett Packard hardware. Oracle and HP are certified for use with Linux, so I wanted to see how the performance of some of our databases would compare if moved to Linux. My ideal goal was for Linux to do everything HPUX does, inte
Oracle on the Web, Part 4 – Upgrading HTML DB
(Steve Callan) In part 4 of the HTML DB series, I will cover the steps of upgrading to version 1.6 and creating a simple Web service. The upgrade/installation steps come straight out of the March 2005 Oracle HTML DB Installation Guide, Release 1.6. The steps to create a simple Web service are from t
SQL and PL/SQL Features
(Arup Nanda) Encryption is a topic that evokes a mixed reaction in many users: interest coupled with a sense of wariness arising from the perceived complexity of key management, which can render the setup ineffective if not done correctly. There is also performance overhead associated with encryptin
Embedded SQL in Java
(DJ Walker-Morgan) One dilemma of deployment is what to do about a SQL database. For easy deployment of a Java application, you’ve probably used tools like Web Start to let the application download and run in almost a single click, but as soon as you want to start using an SQL database for persisten
Cryptography and .NET Framework – Part 1
(Bipin Joshi) Security is key consideration for many applications. Providing authentication and authorization services to your application is just one part of the overall security. What about the data that is being used and transferred in the application? That is where cryptography comes into pi
Embarcadero Data Lifecycle Management Series: Migrating to MySQL
With the popularity of MySQL rising, more corporations are beginning to explore how best to migrate existing systems to the MySQL platform. Understanding the reasons for migrating to MySQL and how such migrations, whether large or small, are performed successfully, can help you fully leverage the be
What’s new in Visual Studio 2005
(Alex Homer) Accompanying the forthcoming release of .NET Framework 2.0 is a new set of development tools in the form of Visual Studio 2005. This is available in a number of permuations, ranging from the cut-down Express versions up to the new Visual Studio 2005 Team System.
The Keys To The Database
(Robert Catterall) Primary key selection decisions are among the more important choices in developing a DB2 database design. In this column, I’ll share my thoughts on primary key selection and explain how changes in recent DB2 versions (for mainframes and for Linux, Unix, and Windows) affect pri
WebSphere Focus: Rationalizing WebSphere tools strategy
(Jack Vaughan) While software product after software product has been tagged with the WebSphere moniker over the years, products in IBM’s tools catalog have been something of an exception. Not that they weren’t rebranded for a while. (R)