DatabaseJournal.com Staff

anovick@NovickSoftware.com Andrew Novick develops applications as consultant, project manager, trainer, author, and Principal of Novick Software. His firm specializes in implementing solutions using the Microsoft tool set: SQL Server, ASP, ASP.Net, Visual Basic and VB.Net. 2003 marks his 32nd year of computer programming, starting in High School with a PDP-8 and moving on a degree […]

>>Script Language and Platform: T-SQL/SQL 2000 Microsoft SQL 2000 User-Defined Function that mimics the Format command in Visual Basic for Dates. Accepts a Date value and string format template. Returns the date formatted to the template. Author: Brian Gollwitzer Download Script: formatDate.sql Disclaimer: We hope that the information on these script pages is valuable to […]

>>Script Language and Platform: SQL Server 2000 Converts the grouped row values separated by commas or slash. If you have a table such as the one below: TBFundInOut IDNO AccountNo A-123456789, ”S-123456” A-222222222, ”S-123456” B-123456873, ”S-121212” C-125343534, ”S-873645” TBClientData IDNO Name A-123456789, ”Peter” A-222222222, ”Chan” B-123456873, ”Wong” C-125343534, ”LEE” query result will be: AccountNo Name […]

by MAK [Muthusamy Anantha Kumar] Applies to: SQL Server 7.0 and 2000. Security audit in SQL server captures only successful and failed logins. It does not capture the application that uses the login. Login used by an application may have full read and write access on all of the tables and procedures but the application […]

This second article of this series briefly covers the Oracle Warehouse Builder architecture, and how it adapts to the industry standards. Some of the typical steps or phases that are part of the datawarehouse life are: Designing the DW model and the physical structures. Identifying the source(s). (Database systems, flat files etc.) Designing the extraction, […]

by MAK [Muthusamy Anantha Kumar] In a typical Client – Server environment it is often necessary to create ODBC DSN on many client machines or servers for front-end applications such as VB, or MS-Access, which uses ODBC DSN for linked tables. Even for creating linked servers to heterogeneous systems like Oracle, Sybase and mainframe DB2 […]

>>Script Language and Platform: SQL Server This script can change any string to “Title Case” (i.e: 1st letter of each word in the parameter is capitalised, and subsequent letters of each word are made to lower case) For Example: “HeLLo wOrlD” would be outputted as “Hello World” using this function. FAQs: ===== How to create […]

[From Datanamic Solutions B.V.] Hazerswoude – 21 July 2003 – Datanamic Solutions B.V. today announced DeZign for Databases V3, a significant upgrade to its powerful, easy-to-use database design and modeling product. This new release offers powerful sub-diagram management facilities, a complete new look and feel, many new and enhanced modeling features, a new scripting engine […]

>>Script Language and Platform: Sql Server This vbscript is used to alert and email receipients on Filegroup space usage. Ouput: ‘% Space Avail. , Space Avail. Filesize, MaxSize, FileName, DBname, FileGroup Author: Jim Mccoy Download Script: sp_dba_spacealert_dmo.vbs Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the […]

[From IronGrid, Inc.] With Single-User and Server Editions, Java Developers Now Can Troubleshoot and Track Database Performance Over Time AUSTIN, TX – July 21, 2003 – IronGrid, Inc., which provides tools that help Java developers improve software performance, today unveiled IronTrack SQL. An intuitive, easy-to-install tool that allows developers to establish an application’s JDBC performance […]

Jim Czuprynski has accumulated over 30 years of experience during his information technology career. He has filled diverse roles at several Fortune 1000 companies in those three decades – mainframe programmer, applications developer, business analyst, and project manager – before becoming an Oracle database administrator in 2001. He currently holds OCP certification for Oracle 9i, […]

>>Script Language and Platform: SQL 7.0/2000 This script includes stored procedure and function. The user only needs to specify the given date (datetime) and how many workdays after the given date (int). The result will skip weekends and give you the correct workday result,even if your starting date is specified as Saturday or Sunday. The […]