(VGirish) When handling a project with hundreds of tables, it takes some time to understand the flow within the database. Especially so if there is no document available. A possible scenario is legacy code up for maintenance or migration. After going through just a few tables, it starts to become to
Other News
When It’s Time to Change
(Alex Keh) Oracle supports .NET developers in a variety of ways. Oracle Data Provider for .NET (ODP.NET) offers many features, including support for new Microsoft ADO.NET 2.0 features, such as factory classes. And as part of Oracle Database 10g Release 2, database change notification allows a .NET c
Sorting SQL Project Files in SQL Server Management Studio
(Jasper Smith) When you have a lot of SQL files in a SQL Server Management Studio (SSMS) Project or a lot of Packages in a SSIS Project, it can become difficult to find the file or packages you are looking for as the order that they are displayed in the Solution Explorer is the order they were added
Session Management with MySQL
As the web continues to provide one of the most cost-effective ways for businesses to market and sell their goods & services, we will continue to see the investment in web-based applications rise. An inherent characteristic about the web and one of the most common technical issues businesses face wh
What is the difference between Oracle, SQL and PL/SQL?
(Lewis R Cunningham) Recently, Sudhat read my Introduction to Basic SQL and had this to say: The article is very interesting. Too Good! And also please describe what is the difference between SQL and Oracle and PL/SQL.
Customizing the Office (2007) Ribbon User Interface for Developers (Part 1 of 2)
(Frank Rice) Learn about the scenarios and XML markup that you can use to customize the Ribbon user interface (UI) in the 2007 Microsoft Office release. The Ribbon UI replaces menus, toolbars, and most of the task pane UI in the 2007 release.
Converting CSV Data to Objects
(Jeff Brand) CSV files are still found all over, and developer’s often are faced with situations for parsing and manipulating that data. Often times, we want to take the CSV data and use it to initialize objects. In this article, we’ll take a look at one approach to mapping incoming CSV data to our
IBM’s Enterprise Generation Language Leverages Existing Business Developers Skills to Expedite Java/J2EE and SOA Development
(Rikki Kirzner) Business transactions running on IBM zSeries and other mainframes are rapidly increasing with the growth of Internet-based computing and IBM forecasts mainframe-based transactions to double by 2010. Meanwhile, Service Oriented Architecture (SOA) has become a key strategic initiative
Tricks for Processing SQL Scripts
(Josef Finsel) SQL Server 2005’s Management Studio offers lots of new functionality, but you can’t always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install script. Previous versions of SQL Server had two command-line utilities: ISQL, which uses
Should Oracle fear open source?
(Candace Lombardi) Oracle continues to dominate the database software market but challenges lie ahead from open source, analysts say.