DatabaseJournal.com Staff

[From SQL Server Magazine] IT professionals can easily be overwhelmed by the mass of technical information that’s available on the Web and in myriad other formats, and separating the informational wheat from the chaff can be a real challenge. You have to figure out how to meld together a jumble of random white papers, Microsoft […]

[From SQL-Server-Performance.com] Learn how to perform a performance audit of your SQL Server database settings in Part 5 of the on-going SQL Server performance audit series by Brad McGehee. The complete article is available at http://www.sql-server-performance.com/sql_server_performance_audit6.asp.

[From eWeek] IBM is looking to add to the high-availability, scalability and ease-of-management features of its DB2 Universal Database with an upgraded version of the software. IBM recently announced that DB2 Version 8.1 will be available Nov. 21 and will include such things as Self Managing And Resource Tuning, or SMART, capabilities, which simplify system […]

Gaurav Sharan Gupta In Oracle we sometimes come across poor performance in our databases. Though there may be a number of reasons for performance degradation, we can prevent some issues by properly designing and/or diagnosing the database. Row Migration (RM) and Row Chaining (RC) are two potential problems that can be prevented. By suitably diagnosing […]

SQL Server maintenance plans are a great way to set up scheduled maintenance on your databases. With a few quick mouse clicks you have the jobs automatically created for you. However, finding out which jobs run when for which maintenance plans can be a royal pain in the behind if you have lots of plans […]

EDGAR Online, Inc. today announced the formation of EDGAR Analyst LLC, a joint venture that unites EDGAR Online with Universal Business Matrix, LLC (UBmatrix). The purpose of EDGAR Analyst LLC is to develop the first global XBRL data exchange. XBRL is a new business-specific XML financial reporting language that is expected to become the standard […]

Alligator company has officially released version 1.14 of its professional RDBMS management tool, AlligatorSQL. AlligatorSQL offers a professional way to manage stored objects in an Oracle 8i, MySQL, Interbase, or SQL Server database. With simple clicks you can drag and drop objects from one database to another, analyze data and import or export different file […]

Oracle Corp. is attempting to gain industry consensus on a new Web services specification for choreographing interactions in business-to-business transactions. Oracle wants the World Wide Web Consortium (W3C) to create an industrywide working group that will guide the development of standards focused on Web services choreography. Additionally, the plan would include an interoperability test suite, […]

Welcome to DatabaseJournal.com! Over the last few months our staff at Jupitermedia.com has been developing a database-focused Web site that will embrace the entire database sector, with in-depth coverage of Microsoft SQL Server, Oracle Database, IBM DB2, Sybase, MySQL, and more. Database Journal will offer tutorials, news, FAQs, scripts, tips, forums, and much, much more. […]

Welcome to DatabaseJournal.com! Over the last few months our staff at Jupitermedia.com has been developing a database-focused Web site that will embrace the entire database sector, with in-depth coverage of Microsoft SQL Server, Oracle Database, IBM DB2, Sybase, MySQL, and more. DatabaseJournal.com will continue to offer the same great content you’ve come to find on […]

To prevent databases from running into serious problems, DBAs typically setup alerts for specific errors; for example, the error “table corrupt” could lead to “database corrupted”. The problem is there are a large number of alerts for the “table corrupt” error message (about 40), and while you probably don’t want to set all 40 of […]

by Alan Richmond How often have you put off coding part of an application because the database wasn’t ready? If you answered even once, you delayed a project — which means you delayed your client. Maybe it was only a couple of days, maybe it was a couple of weeks. In either case, it took […]