(Robert Catterall) I inherited a reasonably large DB2 subsystem that exclusively uses user defined/user managed storage. As you know, once you start managing hundreds of DASD volumes manually, even with homegrown reports, the situation gets out of hand quickly. I want to lead the way to more eff
Other News
Using SQL Server’s XML Support (Sample Chapter)
(Ken Henderson) As we saw in the earlier discussions of updategrams and OPENXML, inserting XML data into a SQL Server database is relatively easy. However, both of these methods of loading data have one serious drawback: They’re not suitable for loading large amounts of data. In the same way tha
Lessons Learned: Oracle performance tuning 101
Introducing the first installment of SearchOracle.com’s Lessons Learned series. Each week you will get a mini-lesson pertaining to a highly-specific database administration, application development, data warehousing and business intelligence, or E-Business Suite topic. The lessons are comprised
BUG: MSDTC Fails to Mutually Authenticate When Computers Do Not Run in the Same Domain
When two computers that are not running in the same domain use Microsoft Distributed Transaction Coordinator (MSDTC) for communication and for distributed transactions, the mutual authentication may fail. When you run a distributed transaction against a linked server in Microsoft SQL Server 2000
Using DTS to Generate and Email Excel Reports
(Joseph Sack) This article explains how to create a DTS Package that performs the following tasks: –Deletes existing rows from the Excel Spreadsheet –Populates the spreadsheet with SQL Server data –Emails the attached Excel spreadsheet using ActiveX and CDO (R)
SVG and Typography: Bells and Whistles
(Fabio Arciniegas A.) In this installment of our discussion of SVG and typography, we make a departure from the sobriety of the typographic strategies we’ve been discussing so far and go for the other half of the fun: the bells and whistles of effects, distortions, coloring, and other unusual treatm
Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Further Control of Processing Location and Expression Arrangement
(William E. Pearson, III) In this article, we will continue our examination of an area of considerable interest to MSAS developers and practitioners, and an area where optimization skills are vital to the efficient operation of both client and server. In our last article, MDX Optimization Techniques
New Features in Oracle 10g for SQL*Plus and iSQL*Plus
(James Koopmann) Don’t wait for your shop to get an Oracle 10g database up and running. Download the client software and start using these great new features that will make a few of your everyday tasks a bit more bearable.
Float like a butterfly, sting like a bee
(Philip Howard) I have no idea of whether IBM had Cassius Clay (or even Mohammed Ali) in mind when it nicknamed the forthcoming release of DB2 UDB “Stinger” but the product certainly looks likely to pack a punch when it is released later this year.
SQL Server clients are authenticated as guests if Simple File Sharing is enabled
You receive the following error message: Login failed for user ‘ServerNameguest’ You receive this error message if either of the following conditions is true: –You try to register a server in SQL Server Enterprise Manager. –You try to connect to Microsoft SQL Server 2000 by using SQ