DatabaseJournal.com Staff

[From ZDNet Asia] The GROUP BY clause is a SQL language construct used to priovide summary data for column returned in a SELECT statement. This functionality groups values from specified fields together, providing a single record of distinct values for each group. The article continues at http://www.zdnetasia.com/techguide/storage/0,39045058,62047753,00.htm

[From SQL Server Magazine] SQL Server 2008 and SQL Server 2005 include dynamic management views (DMVs) and dynamic management functions (DMFs) that provide performance-related information. However, the most useful information is obtained when you combine results from various DMVs and DMFs. For example, you can combine their results to identify T-SQL statements that are using […]

[From SQL Server Magazine] One of the housekeeping challenges DBAs face is to keep track of their databases’ growth and how much space is being used by each table and index in those databases. To meet this challenge, I wrote a stored procedure, usp_ SpaceUsedAnalyzer, that extends the functionality of the sp_spaceused system stored procedure […]

[From Birdstep Technology, Inc,] SEATTLE – October 26, 2008 – Birdstep Technology (OSE: BIRD) today announced the upcoming release of version 9.0 of its Raima Database Manager Embedded also known as RDM Embedded. This is the latest release from the Raima Database Management Family providing exciting new capabilities and functionality for embedded systems application developers, […]

[From Microsoft Corp.] The Beta version of SQL Server 2005 Service Pack 3 (SP3) is now available. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer Standard Workgroup The article continues at http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA&displaylang=en

[From SQL Server Performance] In this fast moving world, data is the heart and soul of any enterprise. It has become an essential task for organizations around the world to protect their data. Database Administrators have a tough job to implement database backup and disaster recovery plans. Backing up your databases can protect an organization […]

[From MarketWatch] LAS VEGAS, Oct 27, 2008 /PRNewswire via COMTEX/ — Latest addition to iReplay testing solution allows IBM’s Informix database users to re-create full-scale production workloads. Exact Solutions today announced plans to add support for IBM’s Informix Data Server to two key software products: iReplay, the database workload capture & replay solution; and iWatch, […]

[From IBM] LAS VEGAS – 27 Oct 2008: Today IBM announced IBM solidDB Universal Cache, relational, in-memory database technology that accelerates not only IBM’s relational databases, but also other industry-leading databases. An industry first, solidDB Universal Cache relies on relational, in-memory database software to accelerate IBM’s own DB2 and Informix Dynamic Server, Microsoft SQL Server, […]

by Alex Polishchuk One of the issues that companies are facing in their operations is database migration to new hardware, or a different operating system platform, or even a new database vendor. There are many steps and factors involved in this process. This article will describe the overall process and interviews with companies that went […]

[From MSDN Blogs] Today at PDC, Ray Ozzie announced our all up cloud services platform. It was a great day for a whole bunch of us who have worked on the database part of the platform for the past 2 years. We announced our cloud compute, storage and management service called Windows Azure. These are […]

[From Search Oracle] Oracle’s SaaS and cloud computing efforts seem to be scattered across the sky — the company is partnering with Amazon.com, buying data center space in Utah, partnering with Intel, and has in fact already been hosting solutions for its customers for years. So what does the future hold for Oracle? Might the […]

>>Script Language and Platform: Oracle This script will monitor and record history for TEMP table space use. It will also send an alert if more than 80% used. Author: Kalpesh Patel Download Script: check_temp_tablespace.txt Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in […]