DatabaseJournal.com Staff

[From Groove Networks Inc.] Groove Networks Inc. today announced the Groove Enterprise Data Bridge, a product that allows organizations to securely deliver live enterprise data from nearly any source directly to users’ PCs, in the context of their teams, project work and collaborative tools. Integrated with Groove Virtual Office software, the Enterprise Data Bridge speeds […]

This SQL script from Richard Ding checks the current database activity in SQL server by using a cursor to loop through the db name list into which table joins pull out rows from sysprocesses and syslockinfo. The result of table names currently being used as well as the type of locks set on them are […]

>>Script Language and Platform: Oracle This procedure makes appointments in MS outlook via OLE2 objects in Oracle. Author: Julio Paz ———————————————————————– — appointments via OLE2 in ORACLE ———————————————————————– PROCEDURE CITAS (subject_par char, location_par char, start_par date, end_par date, body_par char) IS objOutlook OLE2.OBJ_TYPE; objCITA OLE2.OBJ_TYPE; objCITA2 OLE2.OBJ_TYPE; objArg OLE2.LIST_TYPE; BEGIN objOutlook := OLE2.CREATE_OBJ(‘Outlook.Application’); — Se […]

>>Script Language and Platform: SQL If Database is in Archive log mode then look for archive generation. Author: Susmit Sarkar rem Usage: UPDATE/DELETE in a loop and commit very n records rem ======================================= declare r number := 0; cursor cursor_name is SELECT rowid, t.column_name FROM table_name t WHERE column_name = ‘value’; begin for x in […]

[From EMS-HiTech] EMS HiTech Company is pleased to announce PostgreSQL Manager 2.5 – the next version of the powerful GUI tool for PostgreSQL Server. What’s new in version 2.5? 1. Support for PostgreSQL 8.0 2. Improved Rule Editor and Function Debugger 3. Some other improvements and bug fixes. The article continues at http://www.ems-hitech.com/news.phtml?id=486

[From Windows IT Pro – SQL Server Magazine] In “Sarbanes-Oxley: Accountants Setting IT Policy” ( http://www.windowsitpro.com/article/articleid/43825/43825.html ), I talked about how the U.S. Public Company Accounting Reform and Investor Protection Act of 2002, aka the Sarbanes-Oxley Act, might affect SQL Server DBAs and developers. Sarbanes-Oxley is a sweeping set of new laws passed in the […]

>>Script Language and Platform: ASP/SQL Server This script creates a form in which records can be inserted, updated and deleted. Author: SYED ATIF AHMED Download Script: books.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole […]

by Allen One of the very common questions appearing on various developer forums is that of comparing the pros and cons of MySQL and MS SQL. While comparisons have been made by many, mostly on technical issues, I personally find that they are difficult to compare, especially regarding their performance. It is not true that […]

>>Script Language and Platform: T-Sql This script gives a table, with Table, Index, Index contained, Index that contains. I recommend to review each case, before you drop. I run it in the Query Analyzer, one statement at a time. Author: Fernando Madrigal Hidalgo USE database — tab,idx,col,order create view listaidxcols as select SO.name as tabname, […]

[From Developer.com] One of the excellent features of SQL Server 2005 is its integration with the .NET common language runtime (CLR), which extends SQL Server’s capability in several important ways. The integration enables developers to create database objects such as stored procedures, user-defined functions, and triggers by using modern object-oriented languages such as VB.NET and […]

[From PremiumSoft ™ CyberTech Ltd] Navicat lets you perform MySQL administration and database development. It allows you to import/export data, backup, transfer databases from server to server, create queries and manage local or remote MySQL server. This new version supports import CSV, DBF, XML to MySQL through helpful Import/Export Wizard and fixed some small bugs. […]

By Peter Gulutzan On July 15 2004, Oleksandr Byelkin of Ukraine merged his "views" code into MySQL. I have verified that the MySQL version 5.0 Linux source download supports views. This report will interest people who know MySQL, who know what views are, and who have been waiting a long time for MySQL to support […]