DatabaseJournal.com Staff

[From JavaWorld] Let DB Schema Browser fetch information from a database The Database Schema Browser utility uses Java Database Connectivity (JDBC) APIs DatabaseMetaData and ResultSet to fetch information from a database and display it to users. This simple servlet provides users with customizable options to retrieve a listing of all tables in a schema, tables […]

[From ComputerWeekly.com] With a stated goal to make DB/2 programming more natural, IBM has said the next version of its DB/2 database will improve support for Microsoft’s .net development platform. In a bid to lure users of the rival Microsoft database SQL Server, IBM said the DB/2 upgrade, codenamed Stinger, would offer functionality on Windows […]

Steve is an Oracle DBA (OCP 8i and 9i)/developer working in Denver. His Oracle experience also includes Forms and Reports, Oracle9iAS and Oracle9iDS. Steve’s Hotmail email address is stevencallan@hotmail.com. Current Articles Series Articles

[From ComputerWeekly.com Ltd. ] IBM will unveil enhancements to the next version of the DB2 database which are to help simplify development of applications for the Microsoft .net platform at the Microsoft Professional Developers Conference 2003 in Los Angeles. IBM’s DB2 upgrade, codenamed Stinger, will offer functionality on Windows ahead of the next major version […]

[From O’Reilly Perl.com] I’d like to think that I’m a reasonably decent Perl programmer now. I’d like to think that I have a good grasp of how to solve relatively common problems in Perl. But, you know, it hasn’t always been this way. Oh no. A long, long time ago, when I was a tiny […]

[From siliconvalley.internet.com] Oracle (Quote, Chart) took the time at its show in San Francisco to unveil the highly-touted “10g” grid computing approach to storing and serving files. Tuesday the Redwood Shores, Calif.-based software maker upped the ante on that strategy, announcing new database software perks and packages at its Oracle World Paris 2003 event, along […]

[From Stardeveloper.com] We very often need to import various data into MySQL databases. This becomes a tough job if we don’t have a reliable & easy-to-use MySQL GUI; At times, when I am working on deadlines, this job becomes frustrating and I find myself wishing I had a tool to do this job for me. […]

>>Script Language and Platform: SQL Server 2000 ** RUN THE SCRIPT FIRST, THEN EXECUTE THE PROC. RPT_INDEXEVAL — if no parameters are entered, shows index and fragmentation for every table in DB (to include statistics) — if parameters are entered, shows certain tables/indexes based on criteria @LessThanScanDensity = null — bit value (show less than […]

>>Script Language and Platform: MSSQL This function checks for invalid characters, and some basic format. Since SQL can’t use regular expressions, it cannot do a thorough validation, but this function DOES handle the minimum. If the email is valid, it returns 1, if not 0. *ex. This is to delete invalid emails DELETE FROM address […]

Don Schlichting is a Microsoft MSCE, MCDBA and an Oracle Certified Associate. Working at Professional Control Corporation as the IT Director, he can be reached at dons@pccweb.com. Current Articles Series Articles

[From eWeek] The latest battle in the war against database piracy took place on Capitol Hill on Tuesday, as the Coalition Against Database Piracy testified before a joint House Judiciary and Energy and Commerce Subcommittee hearing on draft legislation to protect against database thievery. The legislation, named the Database and Collections of Information Misappropriation Act, […]

[From eWeek] Edgewood Solutions LLC is aiming to make backup and recovery of Microsoft Corp.’s SQL Server databases fast and painless with SQL LiteSpeed 3, the latest version of its database backup tool. SQL LiteSpeed 3, which the company released earlier this month, features a data compression and encryption engine fronted by a graphical console […]