DatabaseJournal.com Staff

[From Windows IT Pro ] A few weeks ago, Microsoft released SQL Server 2000 Service Pack 4 (SP4) to beta testers. Typically, service pack beta programs are by invitation only; however, SP4 is available to the general public. You can sign up for the beta program at http://lists.sqlmag.com/t?ctl=410:7B3DB . You’ll also find information about how […]

[From TechRepublic] On a recent project we had a very complex Web application to deliver in an environment where many of the end users had slow connections to the server on which the application was to be deployed. As such, conservation of bandwidth was one of the priorities. We decided to design for bandwidth constraints […]

[From Apex SQL Tools] Apex SQL Tools has a new version of Apex SQL Audit, SQL Audit Tool for database auditing. Apex SQL Audit is a SQL Audit Tool with a redesigned interface with customizable toolbars, windows themes for designing and implementing SQL audit trails. Apex SQL Audit is a SQL tool with an ASP.NET […]

This stored procedure will build an XML document containing metadata for a given tablename / parameter. I have placed this in an asp file along with a stylesheet to format the output in our environment. A little tweaking with vbScript for a pull down list of tablenames, and it works well. Now all of our […]

[From Oracle Corp.] Join the Combined Companies Launch Webcast Live Tuesday, January 18th Join us from 9:30 a.m. – 1:00 p.m. PST to hear Oracle’s Executive Management Team launch the integration of Oracle and PeopleSoft, hosted by Oracle Presidents Safra Catz and Charles Phillips. The article continues at http://www.oracle.com/peoplesoft/launch_18jan05.html

>>Script Language and Platform: SQL Server 2000 –Objective: Displays first day previous month –Usage: –result: select dbo.FirstDayofPreviousMonth (’03/04/2004′) 2004-02-01 00:00:00.000 select dbo.FirstDayofPreviousMonth (’01/01/2004′) 2003-12-01 00:00:00.000 select dbo.FirstDayofPreviousMonth (’08/08/2004′) 2004-07-01 00:00:00.000 Author: MAK create function dbo.FirstDayofPreviousMonth (@date datetime) returns datetime as –Author:MAK –Objective: returns first day of previous month for a given date. begin declare @returndate […]

[From InfoWorld] MySQL at the end of January is expected to release a beta version of its MySQL 5.0 open source database, which is to feature enterprise-level functionality such as stored procedures and triggers, according to a company representative. The article continues at http://www.infoworld.com/article/05/01/04/HNmysql5beta_1.html

[From Oracle Corp.] REDWOOD SHORES, Calif. 22-DEC-2004 The Oracle Education Foundation would like to congratulate the winners of the latest ThinkQuest competition. The winning Web sites reflect the competition’s unique focus on collaborative, cross-cultural learning, featuring team members from nine countries – Australia, Germany, India, Mexico, Netherlands, Pakistan, Singapore, the United Kingdom and the United […]

[From eSecurityPlanet] Anti-virus is running on every computer in the building. Sophisticated intrusion detection and threat analysis systems keep you apprised of any attempts to gain access to your network. Firewalls provide a robust perimeter, and digital rights are managed so well that no employee has managed to sneak a file or email to a […]

[From WebProNews] Most SQL Server Configuration Settings Should Not Be Changed In this article, we are going to take a look at some of the performance-related SQL Server configuration settings. These are SQL Server-specific settings that can be modified using either Enterprise Manager or SP_CONFIGURE. As the title of this article says, in most cases, […]

[From Business Wire] RESTON, Va.–(BUSINESS WIRE)–Dec. 16, 2004–Learning Tree International (NASDAQ NM:LTRE) has announced the addition of Hands-On Oracle Database 10g: Backup, Recovery & Server Tuning to its selection of Oracle-based technology courses. Over the course of 5 days, participants will be led by an expert instructor in hands-on exercises designed to provide in-depth knowledge […]

[From Quest Software Inc.] IRVINE, Calif., December 8, 2004 – Quest Software Inc. (Nasdaq: QSFT), a leading provider of application, database and Windows management solutions, today announced the release of Quest Central® for SQL Server version 5.0. The new version of Quest Central for SQL Server includes Performance Analysis to optimize Microsoft SQL Server performance, […]