DatabaseJournal.com Staff

[From Search Oracle] Users and analysts are generally giving favorable reviews to Oracle’s Fusion Applications line, which had its coming-out party at Oracle OpenWorld earlier this month. But they warn that there are several issues they need to think through before making a strategic commitment. The article continues at http://searchoracle.techtarget.com/news/article/0,289142,sid41_gci1373120,00.html

Here’s a diagnostic table and stored procedure to track the fragmentation of large tables within databases. The user passes the database name and the table name as parameters to the SP. The SP can be set up to run as a scheduled job every few hours to produce a historical trend of fragmentation. From the […]

>>Script Language and Platform: SQL Server 2000 This script moves databases to different physical locations. This script can also be used to just detach/attach user databases as part of your bigger process. You can customize the script to use cursors which I HATE. Author: Ajith Dharwar DECLARE @Path varchar(400) SET @Path = “D:MSSQLData” use [master] […]

[From Web Developer’s Virtual Library] Surprisingly many developers I come across in my daily work do not run a local server. This always amuses me, mostly because if you took my local server off my laptop I would probably go into death throws fairly soon thereafter. Maybe it is just the way I have come […]

[From InternetNews] The open source dynamic language PHP has been a mainstay of the Web application delivery landscape for the past decade, but only in recent years has it made serious inroads into enterprise IT development. Now with the release of the new Zend Server 5.0 PHP application server, advocates see PHP hitting mainstream IT […]

[From Embarcadero] SAN FRANCISCO – Oct. 20, 2009 — Embarcadero, provider of multi-platform database tools and developer software, is adding more graphical capabilities to DB Optimizer to make it easier for developers and DBAs to do SQL profiling and tuning. With the new DB Optimizer 2.0, Embarcadero is innovating on the SQL tuning front by […]

[From eWeek] Greenplum Software has released a free version of its database software to appeal to data analysts. The new version shares much of the same capabilities as Greenplum Database 3.3, except it can only be run on a single node. The article continues at http://www.eweek.com/c/a/Database/Greenplum-Offers-New-Database-Software-for-Free-436760/?kc=rss

>>Script Language and Platform: MS SQL Server This dynamic SQL function just needs to pass the Julian date and it will return Standard Date. Author: Anand Mahendra Download Script: JulianDate_To_StandardDate.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 […]

[From SD Times] When the information page for MySQL 6.0 vanished from MySQL.com in early October, the community began whispering that the project had been killed by its new owner, Oracle. But in reality, the reason for the removal was far less sinister. MySQL 5.4 included a non-coded new feature: a redesigned release schedule. The […]

>>Script Language and Platform: TSQL/SQL Server 2000 This script returns the first/last date of the month after receiving any date of the month. Author: Anjum Niaz SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE FUNCTION [GetFirstDateofMonth] (@Date as DateTime) RETURNS DateTime AS BEGIN Declare @FirstDate DateTime Set @FirstDate = DateAdd(Day, 1, @Date – Day(@Date) […]

[From MSDN Blogs] We would like to remind all customers that Service Pack Support for SQL Server 2005 Service Pack 2 (SP2) will end on January 12, 2010 and support for SQL Server 2008 RTM will end on April 13, 2010. Microsoft is ending support for these products as part of our Service Pack support […]

[From Web Developer’s Virtual Library] Pagination is something I always find to be a rather painful and mind-numbing process. Most of the time I am much more concerned about actual processes going on rather than some little links that are just going to make navigation somewhat easier and pageloads smaller. But the fact is that […]