DatabaseJournal.com Staff

>>Script Language and Platform: SQL Server 2000 Build a function to retrieve the absolute day, month, and year between two dates. The function executes in this way: select * from AbsDateDiff(”03-FEB-2004”,”01-APR-2005”) The OutPut is year month day ————————————- 1 1 29 (1 row(s) affected) Copy this function and execute in Query Analyzer. Pass any two […]

>>Script Language and Platform: MS SQL This scripts helps implement LogMiner. It takes some examples from Unix naming convention and some for Windows. Just copy this script in a file and run that file on OS level. Otherwise cut and paste portions. Author: Satish Mehta #!/bin/bash #Create a pfile from the existing spfile and then […]

>>Script Language and Platform: SQL Server This script will create a UDF that will show the maximum day for a given date or month that you supply. Format date supplied as parameter should be : “MM/DD/YYYY”; it will produce a single int value. In example if you supplied date like “02/13/2004”, the UDF will show […]

[From Oracle Corp.] A SECURITY CONFERENCE, SAN FRANCISCO 21-FEB-2005 Oracle today announced it has enhanced its security evaluation program with new security evaluations that help ensure security-conscious customers can rely on Oracle(r) for a secure, integrated infrastructure stack. The latest evaluations bring the total number of independent security certifications to 22 and extend beyond Oracle […]

[From Sybase Inc.] Dublin, CA – February 15, 2005 — Sybase today announced that its enterprise class relational database Sybase ASE 12.5.2 has attained a security certification of level 4 (EAL4) from the International Common Criteria for Information Technology Security Evaluation, making it the most recent database offering in the industry to achieve this level […]

By Alexander Bubernak The most importing thing in collecting trace data is collecting properly scoped data. You should know the application and user interaction. Collecting too little data can point you in the wrong direction. Collecting data in the middle of a performance problem or long wait will give you a partial trace file missing […]

[From The Register] Sun Microsystems last week tossed the word “database” in front of numerous financial analysts and triggered a flood of speculation. During Sun’s analyst conference, the company hinted that it might be looking to acquire and then possibly open source a database. This move would round out its enterprise software portfolio, helping it […]

[From internetnews.com] An unpublished study from code analysis firm Coverity indicates that open source database MySQL has relatively few defects in comparison to its commercial competition. Coverity analyzed MySQL 4.1.8 last month and found a total of 97 bugs among the open source database’s approximately 425,000 lines of code. The defects cross over nine different […]

[From News.Com] A source-code analysis of the MySQL database, a popular open-source program at the heart of many Web sites, revealed few bugs compared with the number found in commercial code, testing company Coverity said Friday. The analysis, done using the company’s homegrown tools, found 97 flaws, at least one of which was a serious […]

[From The Australian Software Company (TASC)] Sydney, 2nd February 2005 – The Australian Software Company, TASC, has released SQL Delta version 3.0, a database tool that quickly analyses and compares, as well as synchronizes structures and data for SQL servers. “Working with customer feedback we have made significant productivity improvements with the addition of a […]

>>Script Language and Platform: SQL Server 2000 This script gives the TotalSize, UsedSize, FreeSpace and Freepercent of an .MDF file of a SQL Server database. –Usage exec usp_getmdfsize ”Agent” –results DatabaseName,Filename,TotalMB,UsedMB,Free,FreePercent Agent,C:Program FilesMicrosoft SQL ServerMSSQLdataAgent.mdf,49,39,10,20.60301507538 Agent,C:Program FilesMicrosoft SQL ServerMSSQLdataAgent2.NDF,3,0,2,97.91666666667 Author: MAK Download Script: usp_getmdfsize.sql Disclaimer: We hope that the information on these script pages is […]

This script will create a UDF called FormatDate that allows you to format a date by simply supplying a format such as ‘mm/dd/yyyy’, ‘yyyymmdd’, ‘dddd, mmmm d1, yyyy’, etc. The comment header provides additional examples of how to use the function. The script has been tested on SQL Server 2000. Author: Rusty Hansen Download Script: […]