need to collect statistics such as transactions per second (tps) on my SQL Server machines for periodic reporting. I’ve used the Performance Monitor extensively, but I’m unable to produce a set of SQL Server performance numbers that are meaningful to DBAs [database administrators]. Are any utilities
Author: SSWUG Research
Upgrading from SQL Server 7.0 to 2000
By Rhys Kerrigan – I recently came across the following error while upgrading to SQL Server 2000. “The Ordinal 105 could not be located in the dll Opens60.dll”The following options are available to recover from this problem.
Security Models and Scenarios for SQL Server 2000 Windows CE Edition 2.0
Easily convert your eMbedded Visual Basic applications to SQL Server CE 2.0.
SQL Server DTS Optimization Tips
In his latest article, Alexander Chigrik offers fourteen helpful tips to ensure you are using SQL Server Data Transformation Services (DTS) in the most efficient manner possible.
RDF, What’s It Good For?
by Kendall Grant Clark – The Resource Description Framework is still among the most interesting of W3C technologies. But it’s got persistent troubles, including having had its reputation beaten up unfairly as a result of the many and often nasty fights about RSS. But, just like my eccentric old uncl
Apple ‘Lowers the Bar’ for Web Services Developers
By Darryl K. Taft – Apple Computer Inc. enhanced its support for Web services with the announcement this week of WebObjects 5.2, the company’s Web services development platform.Bob Fraser, Apple’s product manager for WebObjects, said WebObjects 5.2 enables developers to create prototypes in
Parse HTML with an SGMLReader
SgmlReader is an XmlReader API over any SGML document. A command line utility is also provided which outputs the well formed XML result. HTML is an SGML grammar, so you can use this tool to convert HTML into well-formed XML. The utility was created by Microsoft XML guru Chris Lovett.
Connection Pooling with SQL Server 2000 Analysis Services
Connection pooling with SQL Server 2000 Analysis Services gives improved control over resource management.
Ellison Tells OracleWorld: Spend Less
By John Taschek – Larry Ellison, part-time Oracle Corp. captain and full-time sailor, closed out the OracleWorld show here on Thursday by pointing out all the problems with the high-tech industry. Ever the salesman, as well as sailor, the Oracle chairman and CEO also said that Oracle has all the ans
Generate a bar graph for tablespace utilization
By Shishir Dani – Almost all Oracle DBAs need to continually check the status of various tablespaces in the database. Here is a SQL script that will generate a bar graph showing the status of tablespaces in the database.