DatabaseJournal.com Staff

>>Script Language and Platform: SQL Server 2000This function returns the Zodiac for a given date. Usage: select dbo.udf_zodiac(’09-09-1971′) as Zodiac go –result Virgo select dbo.udf_zodiac(’10-28-1970′) as Zodiac go –result Scorpio select dbo.udf_zodiac(’05-02-1945′) as Zodiac go –result Taurus Author: MAK Download Script:zodiac.sql Disclaimer: We hope that the information on these script pages is valuable to you. […]

[From Original Software] Chicago, Ill., July 31, 2006 Adapting unique data validation technology to automatically collect, sort and test database content without bringing systems offline, Original Software (www.origsoft.com), today released its automated database integrity and diagnostics testing tool, TestBench-Live for IBM iSeries systems. Using advanced data rules, TestBench-Live allows database managers to quickly and easily […]

>>Script Language and Platform: Oracle 9i This script is designed with an intention of recreating the temp files automatically. This script will first create a temp file of its own, then it will drop the existing overloaded tempfile. After that it will recreate a new fresh tempfile in the same location with the same name […]

[From OTN] Developers today benefit from a range of server-side technologies that function as the middle layer between a Web server and the database, including JavaServer Pages (JSP), Active Server Pages (ASP), PHP, and if you’re an Oracle developer, PL/SQL Server Pages. When I was introduced to Python programming language back in 2003, I was […]

[From PremiumSoft] This new version supports Foreign Key Data Selection and is a universal binary. Remote PostgreSQL connection is as easy as using pgadmin or phpMyAdmin. Navicat features an intuitive interface and provides a set of useful tools to manage, backup/ restore, import/export data, Synchronize database and connect to remote PostgreSQL server, etc. Downloaded at: […]

[From Oracle Corp.] REDWOOD SHORES, Calif. 24-JUL-2006 Oracle and HP (NYSE: HPQ) (Nasdaq: HPQ) today announced that they have developed reference configurations that can accelerate implementation by IT departments of Oracle(r) Database 10g-based data warehouses on HP servers and storage. Reference configurations help customers get the database, server, and storage mix they need, right out […]

>>Script Language and Platform: SQL Server 2000 Objective: To simulate MS-Access NZ function. –Usage: select dbo.NZ(NULL,’haha’) as results –results = haha select dbo.NZ(123,’haha’) as results –results = 123 select dbo.NZ(‘ABCDE’,’haha’) as results –results ABCDE select dbo.NZ(‘ABCDE’,0) as results –results ABCDE select dbo.NZ(NULL,1) as results –results 1 Author: MAK create function dbo.NZ (@a sql_variant,@y sql_variant) returns […]

>>Script Language and Platform: SQL Server 2000 –No cursor kill for SPID/Connections –Returns No. of connections killed — –Usage usp_killDBConnections @DBName=”NorthWind” Author: Ajith Dharwar Download Script: usp_killDBConnections.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole […]

>>Script Language and Platform: SQL Server 2000 Save this script as test.sql Open query analyzer or use osql to execute this script. You could create a batch file to run this sql script to loop through a bunch of server and execute OSQL. Useful to find which machine has SP3 and which has SP3a. Author: […]

Sreeram Surapaneni, OCP, has been working as a database administrator for the past 11 years at Research In Motion, Ltd., and resides in Ontario, Canada. He has several years’ experience in various flavors of UNIX and Linux and with Oracle.. He has special interest and experience in RAC in the Linux environment with ASM. Prior […]

>>Script Language and Platform: SQL/ Oracle This script gives you statiscs by session of oracle Database. Author: Ghazi ben Youssef Download Script: session_stats.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on […]

by Paul C. Zikopoulos In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphereSoftware (Rational AD) product to create and work with IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows database connections. Part 2 introduced you to some of […]