DatabaseJournal.com Staff

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title. A small navigation bar at the top and bottom of each page links to series articles for each database. Browse our articles by author. MS SQL: […]

>>Script Language and Platform: T-SQL/ SQL SERVER Let’s say we have txt file dts_2_11012005.txt. The file is located in subdirectory C:STUDIESsql_serveropenrowset_txt_to_sql. dts_2_11012005.txt is a Tab Delimited file, which contains following columns : emp_id Width 9 fname Width 8 minit Width 1 lname Width 9 job_id Width 2 job_lvl Width 3 pub_id Width 4 hire_date Width […]

>>Script Language and Platform: MS SQL Server Example which shows how to get the first and last day of the current month, the first day of the next month, and the last day of the previous month. No string functions or case statements. Author: George Neblina Download Script:get_first_last.sql Disclaimer: We hope that the information on […]

[From Firebird News] Today it became generally known that MySQL has acquired a company called Netfrastructure. This company offers a product which is a reimplementation of the Firebird database architecture, combined with a web-based application server front end. It was designed by Jim Starkey in the late nineties and combines a database, a custom java […]

by Paul C. Zikopoulos In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphere Software (“Rational AD”) product to create and work with IBM DB2 Universal Database (“DB2 UDB”) for Linux, UNIX, and Windows database connections. In Part 2 (and the upcoming […]

>>Script Language and Platform: TSQL/SQL Server 2000 If you apply a DatePart function to seperate the date and time, in this case, the index will not be used (because of function usage) and your query may take too much long time. These two functions will ease your life if you assign the returned values to […]

by Vincent Chan This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3). Oracle Database 10g and Oracle Real Application Cluster (RAC) 10g itself, boast many new and exciting features that simplify database manageability and provide higher availability and scalability. Compared to […]

[From EMS Software Development] EMS Company announces SQL Manager 2005 for InterBase/Firebird – the new major version of the powerful InterBase and Firebird administration and development tool! What’s new in the latest version? Latest InterBase and Firebird versions support Improved user interface Completely remade Visual Database Designer New data management tools New connection options and […]

[From Webyog Softworks Pvt. Ltd.] SQLyog, a GUI for MySQL comes in four flavors: SQLyog Enterprise Trial, SQLyog Pro, SQLyog Free Edition and SJA For Linux. Features HTML Schema Documentation Shortcuts to quickly generate SQL statements and paste object names Learn MySQL by looking at the SQL generated by SQLyog Multi-tab Query Editor and Result-set […]

[From ZDNet UK News] Oracle executives took the stage in San Francisco on Wednesday to rally support for the company’s development plans after a run of recent acquisitions that has left Wall Street lukewarm on the firm. The article continues at http://news.zdnet.co.uk/software/applications/0,39020384,39247980,00.htm

by Paul C. Zikopoulos, IBM Canada In a previous series of articles, I covered the rich application development integration between the Microsoft Visual Studio .NET integrated development environment (IDE), the native IBM DB2 Universal Database (DB2 UDB) managed provider for .NET, and the .NET framework. I have received a lot of feedback from readers who […]

[From Cybernoon] The event will hold 90 business and technical sessions covering 11 tracks… Oracle India Private Limited (Oracle India) announced today that it will host the premier Oracle OpenWorld conference in Mumbai on January 10-11, 2006. Oracle OpenWorld is Oracle’s global technology and business conference for customers, partners, business and IT decision makers. India […]