DatabaseJournal.com Staff

[From Microsoft] As enterprise applications and their data requirements grow larger and more complex, highly scalable databases are needed to support the growth. SQL Server 2000 Enterprise Edition (64-bit) takes advantage of Intel Itanium-based servers to provide a highly scalable back end for demanding, mission-critical applications. This Flash demo highlights how SQL Server 2000 (64-bit)works […]

by MAK [Muthusamy Anantha Kumar] Having a standby server in a remote site, copying backup files directly to a Disaster recovery site or other requirements such as transfering files from one location to another using FTP creates the need for creating a FTP batch file using a changing parameter file. In this article, I will […]

by Sreeram Surapaneni Oracle is becoming one of the most flexible and sophisticated database management systems. Its ability to provide performance views for memory management components of the database is an invaluable tool especially for managing DSS systems. With it, DBA`s can more easily ensure that all the settings for Oracle memory utilization are optimal […]

[From eWeek] Sybase Inc. last week released beta code for Pocket PowerBuilder, a scaled-down version of the company’s application development platform aimed at devices. The Dublin, Calif., company said Pocket PowerBuilder will let PowerBuilder users leverage their skills on the platform and build mobile and wireless applications that run on Microsoft Corp.’s Windows CE operating […]

[From EMS HiTech] EMS HiTech is pleased to announce the Linux version of the EMS PostgreSQL Manager – a powerful PostgreSQL administration and development tool. You can download the RPM package at http://www.pgsqlmanager.com/download.phtml. The article continues at http://www.pgsqlmanager.com

by MAK [Muthusamy Anantha Kumar] Every corporation has a unique infrastructure environment. Let us consider a simple production, testing, and a development environment. The SQL scripts application, developed in a development environment will be tested in a QA environment and then moved to production on a production date. Usually the QA group simulates the implementation […]

[From internetnews.com] Dell Wednesday expressed its faith in open-source computing like never before and significantly expanded its pacts with vendors Oracle (Quote, Company Info) and EMC. Oracle Chairman and CEO Larry Ellison joined Dell CEO Michael Dell onstage at the Pierre Hotel to discuss how the two companies had inked a global sales agreement to […]

>>Script Language and Platform: T-Sql, VB Run the script to create 2 stored procs, then execute the second one called “cSpCaseSelVbNetFunctions” The VB.Net Data Access code will be returned and you can paste it into a *.vb class module. The output is switchable from System.Data.OleDb syntax to System.Data.SqlClient syntax. Author: Louis Garrett Download Script: cspCaseSelProcParamsVbNET.sql […]

In part-1 of the series, we discussed the overall view of Oracle Streams and the process of information sharing between databases. Part-2 of this article, presents a scenario to demonstrate a simple and “straight-forward” configuration for Oracle Streams. Oracle Streams Configuration In this example scenario, we use two databases (both Oracle 9.2.0) “local.world” and “remote.world”. […]

>>Script Language and Platform: MSAccess This script will scan through a list of Print Servers and extract successful print job events to an Access MDB. It saves the insertion strings into separate fields in the MDB. This enables you to identify heavily used printers and the users printing to them. You can then run queries […]

>>Script Language and Platform: MS SQL 7.0 and MS SQL 2000 –Objective: To format the phone number and to convert Alphabetic telephone number to Numeric –eg: exec telephone ‘900-call-cloe’ will display ‘(900)225-5256’ and –exec telephone ‘609@@34$$$6068D’ will display (609)346-0683 Author: Claire Hsu create procedure telephone @phone varchar(100) as declare @length int declare @count int declare […]

>>Script Language and Platform: Oracle Most of the Alert scripts found in the Books sends duplicate mails to the user.This script is developed to avoid the duplication. It consists of two scripts.Alert_master.sh is the main script which will call alert.sh for all instances in your server.Please edit the scripts to suit your environments. Author: Antony […]