(Brian Moran) Technology solutions have become so complex over the past few years that it’s impossible for one person to know and understand every detail of every tool that an end-to-end solution includes. Unfortunately, businesses can’t afford to maintain an army of world-class experts—a master for
Other News
Executing External Programs From Within Oracle
(James Koopmann) Finally, Oracle 10g has given us the ability to execute external programs from within Oracle. Let’s take a look at what we need to do to expose this new feature.
How to set up a linked server to a Sybase database server and troubleshoot problems that may occur
This step-by-step article describes how to set up a linked server to a Sybase database server on a computer that is running Microsoft SQL Server. Additionally, this article contains basic troubleshooting steps for problems that may occur when you set up a linked server to a Sybase database server.
Tomorrow’s Web Today
(Daniel Zambonini) Ten to midnight — it’s your partner’s birthday tomorrow, and you’ve forgotten their gift! Suddenly, a thought comes to mind: she’s always wanted to see a musical in the big city. “Barry,” you say, for that is the name of your web agent, “buy two tickets for Cats in London for tom
Heterogeneous Management Tools
(Michael Otey) SQL Server has a great set of management tools—Enterprise Manager, Query Analyzer, and SQL Server Profiler are powerful and easy to use. Although these tools bring valuable benefits, they have some limitations as well. First, the tools manage only SQL Server. Second, the management to
No-charge access to Linux for pSeries and DB2 Universal DatabaseTest Drive
Read the information below and agree to the terms and conditions by clicking on the “I Agree” button. After you fill in the signup form, your application will be processed and upon proper egilibility you will receive a Test Drive user ID and password via e-mail. Applicants will receive a user ID
Use XML Query Definitions in .NET Applications
(David Clark) The Command objects in ADO.NET (such as OleDbCommand and SqlCommand) are a central aspect of the .NET database access strategy. When used properly, they provide excellent performance and security.
Converting JDBC Result Sets to XML
(Jeff Ryan) XML has become the common format for passing data between components residing on different platforms. With the move to XML-based services, developers often find themselves converting various data structures to and from XML. Arguably, the most prevalent form of persisting data is in relat
What’s New in FOR XML in Microsoft SQL Server 2005
(Michael Rys) In Microsoft SQL Server 2000, we introduced the FOR XML clause to the SELECT statement. This clause provides the ability to aggregate the relational rowset returned by the SELECT statement into XML. FOR XML on the server supports three modes—RAW, AUTO, and EXPLICIT—that provide differe
Oracle Tip: Choosing an efficient design for Boolean column values
When designing a database table structure, it’s important to choose an efficient strategy for storing a logical Boolean that you can use in many programming environments. (Although Oracle doesn’t come with a Boolean datatype for database columns, it does have a Boolean datatype in PL/SQL.) (R)