DatabaseJournal.com Staff

By Paul C. Zikopoulos The Version 8.2.2 update of the IBM DB2 Universal Database product (DB2 UDB) includes a new capability that allows database administrators (DBAs) to use a single page size for their entire database. Page Sizes in DB2 UDB DB2 UDB supports four different page sizes: 4 KB, 8 KB, 16 KB, and […]

[From eSecurity Planet] Critical software vulnerabilities are increasing being found — not in the operating system — but in applications and major databases. The information comes out of a new quarterly report, the Top 20 Internet Security Vulnerabilities from the SANS Institute, a major source of security training and certification based in Bethesda, Md. Analysts […]

>>Script Language and Platform: VBScript This script will send a simple email using CDOSys. Usage: cscript sendcdosysmail.vbs “mak_999@yahoo.com” “mak_999@yahoo.com” “test” “This is a test message” “MySMTPServer” or sendcdosysmail.vbs “mak_999@yahoo.com” “mak_999@yahoo.com” “test” “This is a test message” “MySMTPServer” Author: MAK Download Script: sendcdosysmail.vbs Disclaimer: We hope that the information on these script pages is valuable to […]

[From Asp 101] I recently got the following announcement from my contact at Microsoft: Today, Microsoft announced the availability of Visual Studio 2005 Beta 2, .NET Framework 2.0 Beta 2 and SQL Server 2005 April CTP (Community Technology Preview), the latest major milestone in delivering the next generation products. Together, SQL Server 2005 and Visual […]

>>Script Language and Platform: VbScript cscript EnumGroupMembers.vbs “Group Name” “Domain Name” Example: cscript EnumGroupMembers.vbs “Tech SQLDBA” “Americas” Result: Amuthusamy CHsu KKordell Author: MAK ‘Objective: To enumerate the members of a domain group ‘Created by: MAK ‘Date: April 11,2005 Dim Group Dim GroupName Dim GroupDomain Dim objArgs Set objArgs = WScript.Arguments GroupName =objArgs(0) GroupDomain=objArgs(1) Set Group […]

by Paul C Zikopoulos One of the most frustrating tasks that database administrators (DBAs) have to perform is trying to figure out when one database application’s request is blocking another. Sure, most databases have built-in deadlock detectors and timeouts to help these sorts of issues work themselves out. However, being able to easily identify applications […]

>>Script Language and Platform: SQL Server 2000 This function strips HTML tags (or any string between < and > characters) out of text strings. Example: Declare @MyText varchar(30) Set @MyText = ‘My sample Text’ Select dbo.fnStripTags(@MyText) Results: ——————— My sample Text (1 row(s) affected) Author: Robert Davis /****** Object: User Defined Function dbo.fnStripTags Script Author: […]

[From MySQL AB.] A new version of MySQL Community Edition 5.0.3-beta Open Source database management system has been released. This version now includes support for Stored Procedures, Triggers, Views and many other features. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror […]

by Sreeram Surapaneni Overview: SQL tuning is one of the challenging tasks faced by Database Administrators. It is an interesting and creative, but at the same time, daunting task. Manual tuning of SQL statements requires through knowledge of how the statements are executed in the background and experience to understand suitable access paths to yield […]

by Paul C. Zikopoulos I know it’s an old saying, but it certainly is an accurate one in this case. Visualizing data makes it easier to understand and act on. In fact, quite often, patterns or correlations that you never thought existed suddenly become apparent with visualization. The IBM DB2 Universal Database Version 8.2 product […]

[From mrc] March 18, 2005, Lombard, IL, mrc announced the addition of the MySQL database to its roster of m-PowerTM supported databases today. The MySQL database server is considered the world’s most popular open source database. Over six million installations use MySQL to power high-volume Web sites and other critical business systems including industry-leaders like […]

[From internetnews.com] Oracle Corporation (Quote, Chart) won the bidding battle for retail software specialist Retek (Quote, Chart) with an offer of $11.25 per share after rival SAP dropped out of the bidding competition for the Minnesota-based company. The deal’s value is estimated to be about $630 million, based on Retek’s estimated 56 million outstanding shares, […]