(Muthusamy Anantha Kumar) Among other enhancements in SQL Server 2005, enhancements were made to the OPENROWSET function. This article illustrates BULK operations of the OPENROWSET function.
Other News
Visual Basic 2005 and MySQL 5 Developer Notes – Part Two
(Mike Hillyer) In my last article I covered the schema that I would be using for this application, and in this article I will cover some of the preparation that I will be performing in VB2005.
Questions Still Abound over GPL 3
(Peter Galli) There was much discussion about the provisions contained in the first draft of the GNU General Public License 3.0 at the Open Source Business Conference here Feb. 14, including the anti-DRM wording, the license compatibility clause and the complete corresponding source code requirement
IBM Pumps Up DB2 Lineup
IBM is working to expand the adoption of its DB2 database server, giving users three new options: a specialty processor designed to handle data-intensive workloads on the mainframe, an upgrade of DB2 for z/OS, and a free version of DB2.
Hacking the XML in Your TiVo
(Bob DuCharme) When I was a kid, our television set picked up just a few broadcast channels over the wire aerial mounted on our roof. This offered us a limited choice of what to watch, so we saw a lot of I Love Lucy reruns. Now that we have hundreds of channels over the satellite dish, libraries
Building PHP Applications Using the ATK Framework
(Ivo Jansch) Companies of all sizes are seeking a rapid but structured approach to “Webifying” their existing traditional Oracle-based applications. Increasingly, the combination of Oracle Database and PHP is an attractive option.
You may receive an ‘Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action’ error message when you run a SQL Server Agent job in SQL Server 2000
When you run a SQL Server Agent job in Microsoft SQL Server 2000, you may receive the following error message: Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action.
Exploit SharePoint List Definitions to Maximize Your Brand
(Robert Bogue) When you’re trying to change the way that SharePoint appears and operates to something more in-line with what your organization needs, you’ll find that modifying the site definition to change the appearance is a good first start. As you get more advanced, you may decide that you n
Building an XML Utilities Package, Requirements
(Lewis R Cunningham) I am frequently asked different questions about PL/SQL, XML, getting started, methodologies, etc and have decided to bring all of that together into a set of posts. I will build a utility package to help me debug and test my XML. I’ll cover the steps I normally follow to design
Developing and Implementing Applications, continued
(Kevin Loney and Bob Bryla) You can use the Database Resource Manager to allocate percentages of system resources to classes of users and jobs. For example, you could allocate 75 percent of the available CPU resources to your online users, leaving 25 percent to your batch users. To use the Database