(Iain Thomson) Microsoft has revealed some of the changes in the forthcoming release of its SQL 2005 database, scheduled for later in the year.
Other News
The Man On The Hot Seat For Oracle-PeopleSoft
(Charles Babcock) CEO Larry Ellison and co-presidents Safra Katz and Charles Phillips held forth on stage. But it was clear at Tuesday’s event at the Oracle campus that the stationmaster who will run the merger of Oracle-PeopleSoft applications is John Wookey, Oracle senior VP for applications.
The Three Ms of BI: Manage, Monitor and Model
(Guy Creese) Business intelligence is awash in so many products, buzzwords and technologies that it is often hard to see the forest for the trees. It is at times like this that I put on my industry analyst’s cap and muse, “Hmm, what is this: manage, monitor or model?” This tripartite way of looking
Introducing the Amara XML Toolkit
(Uche Ogbuji) As part of my roundup of Python data bindings, I introduced my own Anobind project. Over the column’s history, I’ve also developed other code to meet some need emphasized in one of the previous articles. I recently collected all of these various little projects together into one open s
Tracking Down Newly Created Databases
(Eli Leiba) There are cases, especially in large organizations, where the DBA team is too small to handle all the database management tasks on all the SQL Servers across the organization. In these cases, the DBA can grant programmers the db_owner role. (R)
Beware of Email Bearing Patches
(Terri Wells) If it says it’s from Microsoft and contains a “patch” attachment for you to download, don’t. It’s probably a Trojan horse.
SQL Server Jobs Can Negatively Affect Performance, If You Are Not Careful
(Brad M. McGehee) Virtually every SQL Server runs one or more daily jobs. And most likely, runs many weekly jobs. Unfortunately, most DBAs set up jobs, and then forget about them, unless of course they break. But if they run day after day without any problems, most jobs are forgotten about.
Schemas (Sample Chapter)
(Elliotte Rusty Harold) Document Type Definitions (DTDs) are an outgrowth of XML’s heritage in the Standardized General Markup Language (SGML). SGML was always intended for narrative-style documents: books, reports, technical manuals, brochures, Web pages, and the like. DTDs were designed to serve t
Query Index Server with IXSSO in .NET
(Lance Bailles) There are many articles on the internet about querying Index Server using MSIDXS but few concerning IXSSO in .Net. It is my hope that this article will help more developers to return to the more efficient IXSSO when developing Index Server solutions in the .Net framework. The complet
Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services
(Alok Mehta) Microsoft Office 2003 contains powerful XML-based functionality, including Web services integration. For example, using the Web services capabilities of Office 2003, developers can create a variety of solutions that help users increase their productivity on eBay. Web services offere