(Sudip Datta) Why should DBAs and IT managers care about improving deployment management? Datta: If you were to define deployment in terms of the full software lifecycle, it would include things such as installation, patching, cloning, software configuration, compliance tracking—such as tracking
Other News
SQL Server – A Capacity Management Data Repository?
(Adrian Heald) An outsourced Department I have had some association with has recently completed negotiation of a contract extension with its service provider. As part of this new contract the capacity management function has moved back in house. Well, part of the capacity management function anyway.
You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you install Microsoft Windows XP Service Pack 2
When you run a distributed transaction against an instance of SQL Server, you may receive an error message that is similar to the following: Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB provider ‘SQLOLEDB’ was unable to begin a distributed t
Relational Database Sales Up
(Antone Gonsalves) New license revenue in the global relational database market increased by 5.1 percent last year, as IBM’s DB2 database surpassed Oracle for the first time, a market research firm reports.
Use Location Information in Enterprise Reporting
(Justin Lokitz and Madeline Alameda) Location information is everywhere; it can be found across all lines of business, all industries, and in virtually every organization and department in the world. However, most organizations regard location information in one of only two ways: –Location as a
Schema Binding for Java Web Services
(Mitch Gitman) Sometimes you just wish software architects weren’t so creative or, at least, were more coordinated. It seems that’s what happened with SOAP, the standard format for web services messages. The SOAP specification started out defining a lot of protocol-specific XML structures that n
Building Joins the Easy Way
(Dale Elizabeth Corey) Okay, I admit it. Before I became an SQL Server 2000 DBA, I was bottlefed on Microsoft Access. When it came to building complex queries with joins, I became an expert on Access’s Grid Manager, formally known as a form of Query By Example (QBE) developed by IBM’s Dr. Zloof in t
DB2 UDB set record for 4-way server performance on TPC-H 300GB benchmark
IBM continues to deliver record breaking performance results with the publication of a new TPC-H benchmark at the 300GB scale factor. DB2 Universal Database v8.1 running on an IBM eServer xSeries 365 set a new record for 4-way performance running the 300GB TPC-H benchmark. DB2 UDB and the x365 achie
Oracle Service Manager
(Rob Kayman) My goal is to create a Microsoft Windows utility to watch and administer, in a simple manner, Oracle Windows services on local and remote machines. The baseline operation of the utility mirrors the Service Manager that ships with Microsoft SQL Server 2000. I used Visual Studio .NET 2003
DB2 UDB Practical Performance Tuning
(John Maenpaa) This will be an introduction to the tools available to analyze the performance of DB2 applications running on Linux, UNIX, and Windows platforms. We’ll focus on practical methods and tools that are readily available for these platforms. Platform-specific tools will be covered firs