DatabaseJournal.com Staff

by Shailesh Khanal How many times you have been asked by a developer if you can recover a stored procedure or a table structure because he/she made a change in the existing environment. In a controlled database development environment, scripts for all database objects including tables, views, triggers and stored procedures should be maintained in […]

>>Script Language and Platform: SQL This script checks your database size. Author: Anirban Dey Download Script: DBSIZE_REPORT.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 these pages is provided “as -is”, […]

[From InternetNews] Oracle on Wednesday unveiled the latest release of its PeopleSoft Enterprise suite, including Human Capital Management 9.1, PeopleTools 8.50, Learning Management 9.1 and Enterprise Portal 9.1. Company officials said the refreshed application suite incorporated new features and functionality designed to accommodate the end user, empower upper management and reduce the total cost of […]

[From Computerworld] Windows Server 2008 Hyper-V R2 and System Center Virtual Machine Manager 2008 R2 offer substantial performance and functionality enhancements over the previous editions, but support for non-Windows guests remains extremely limited. Microsoft is poised to improve its standing in the world of virtualization with the much-anticipated update to Windows Server 2008 Hyper-V, Redmond’s […]

>>Script Language and Platform: SQL Server This script displays the size of a given file. –Usage: select dbo.udf_CheckFileSize (”d:sqldumpstestlatency_20041206_08_00_07.TRN”) select dbo.udf_CheckFileSize (”d:sqldumpsmsdbx.bak”) select dbo.udf_CheckFileSize (”x:sqldumpsmsd.bak”) –Results 145920 bytes 23092736 bytes -1 means File not found or path not found -2 error during FSO process Author: MAK Create function udf_CheckFileSize (@filename varchar(1000)) returns bigint as –Created […]

[From SQL Server Performance] Continuing from Part 1, our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated. To do this, run the following command against the target database… The article continues at http://www.sql-server-performance.com/articles/dba/migrating_databases_checklist_part2_p1.aspx

>>Script Language and Platform: MSSQL 2000 & MSSQL 2005 The following procedure helps you to send a message to all users who access a specified database in a server. Author: Shiva /* ————————————————- The Following Procedure Helps You To Send a Message to all Users Who Access the Specified Database in a Server */ Create […]

>>Script Language and Platform: VBScript This script lists all of the processes on a server. USAGE: monitorprocess.vbs c:process.log Server1 Result is stored in c:process.log as shown below: 6 ,Process Name= SERVICES.EXE,Process ID=264,Path=C:WINNTsystem32services.exe 7 ,Process Name= LSASS.EXE,Process ID=276,Path=C:WINNTsystem32lsass.exe 8 ,Process Name= termsrv.exe,Process ID=376,Path=C:WINNTSystem32termsrv.exe 9 ,Process Name= svchost.exe,Process ID=508,Path=C:WINNTsystem32svchost.exe Author: MAK Download Script: monitorprocess.vbs_ Disclaimer: We hope […]

>>Script Language and Platform: Oracle Purpose: To read raw session trace file with option to format trace file with TKPROF and read it in SQLPLUS Session. Author: Neaman Ahmed #!/bin/sh ################################################################# ################################################################# ## Copyright (c)2004 Kalson Systems ## ## Author :Neaman Ahmed ## ## ScriptName:trace ## ## Purpose: To read raw session trace file with […]

[From PremiumSoft CyberTech, Ltd.] PremiumSoft has released version 8.1.3 of Navicat supporting the new Mac OS X 10.6 – Snow Leopard. All features in Navicat 8.1.3 are now compatible with the new Mac system. Mac OS X 10.6 – Snow Leopard is a new operating system from Apple, Inc. which is released on August 28, […]

[From MSDN Blogs] Got your token yet? All set up but dreading the work needed to replicate your on-premises database structure to the cloud? Sure the simple “kick-the-tires” scenario with one or two tables isn’t too hard, but something like AdventureWorks might have you both kicking and screaming. Well there’s help on the way! Check […]

[From OTN] The Oracle Rdb Engineering and Oracle Database on OpenVMS teams are pleased to offer a series of Oracle Rdb and Oracle Database on OpenVMS Technical Forums in various locations around the world. These Forums are offered at no charge and present a series of sessions conducted by acknowledged technical specialists from our development […]