DatabaseJournal.com Staff

James Horne Overview Data Transformation Services (DTS) remain an important tool in the arsenal of database administrators and web designers that need to move data between data repositories. These repositories can include SQL Server 2000, a variety of other databases as well as text files, and Excel files. You’re also being compelled to move towards […]

>>Script Language and Platform: Bash – Sed This well-tested bash script is used to transfer data from Informix to PostgreSQL. Copy and paste the script into an sqlparser.sh file and make it executable. (Only works in UNIX). Author: Vasilis Ventirozos sqlparser File Table Script Code: #!/bin/bash if test $# -ne 2 then echo “usage: sqlparser […]

Ajay Gursahani This article gives a brief understanding about External tables. External Tables are defined as tables that do not reside in the database, and can be in any format for which an access driver is provided. This external table definition can be thought of as a view that allows running any SQL query against […]

marin.komadina@zg.htnet.hr Marin was born June 27, 1968 in Zagreb, Croatia. He graduated in 1993 form The Faculty for Electrotechnology and Computer Sciences, University of Zagreb in Croatia. He started his professional career as a System specialist and DBA for the Croatian company Informatika System. His most important project was the development and implementation of the […]

Marin Komadina This article explains how to organize and perform a delta incremental database backup. Delta backup will be your IT manager’s best friend, especially if he is fighting a budget, your DBA will love it because he will learn something new, and storage guys will complain because they will not get paid as before. […]

Sagent OpenLink Enables 3rd-Party Applications to Access Multiple Data Sources, Perform Analytics SAN DIEGO, Calif., February 3, 2003- Sagent (Nasdaq: SGNT), a leading provider of enterprise business intelligence solutions, today announced the availability of Sagent OpenLink, a new product that allows any ODBC or JDBC-compliant software application to leverage the analytical power of Sagent’s Data […]

[From MySQL] MySQL AB would like to confirm that the MySQL™ database is not affected by nor is responsible for the recent “Slammer” (also known as “Sapphire”) worm that has caused widespread Internet disruption. This worm attack, which began last Friday, has been linked to a set of known flaws in Microsoft SQL Server, and […]

[From Microsoft] Live Event: February 12, 2003 – 10:00am to 11:30am Pacific Time / 1:00pm Eastern Time. Event Description: Richard Waymire, a SQL Program Manager with Microsoft and Book Author will be presenting this TechNet Webcast. Richard is the primary author of “Teach Yourself SQL Server 2000 in 21 days”, which introduces the overall SQL […]

[From eWeek] As corporate IT departments go about the business of cleaning up their networks, there are strong indications that the SQL Slammer worm that brought down portions of the Internet over the weekend is based on the work of an obscure Chinese cracking group. Signatures within the worm’s source code indicate that a group […]

by Amar Kumar Padhi Definer rights A routine stored in the database by default, is executed with the definer rights (owner of the routine), depending on the user who calls it. This is a good way of having the required code perform process logic in one place. It gives better control, preventing direct access to […]

[From Microsoft] At approximately 9:30 P.M. Pacific Time on Friday, January 24, Microsoft became aware of an Internet attack causing a dramatic increase in network traffic worldwide. Microsoft immediately began investigating the issue and learned of a worm targeting Microsoft. SQL Server-2000-based and MSDE 2000-based systems not updated with the appropriate security patches. This worm […]

Marin Komadina Oracle has not solved the problem of exporting all but a few larger tables from a user schema thus far. This leaves DBAs to find their own workarounds when necessary. This article covers the three most used solutions. Full export Data dictionary view modification Fine Grained Access Control ( FGAC) Scenario A: The […]