By Margaret Kane – Lexmark has been forced to swallow a $15m loss after an Oracle customer relationship management project went awry.
Author: SSWUG Research
Diagnose Server Performance Problems with SQL Server’s SQL Profiler
By Andrew Georgopulos – Databases are complicated because they have so many interdependent elements. The components’ interdependence is most evident when trying to improve server performance. When things slow down and performance seems to flag, organizations tend to look at the server as the source
SQL Server 2000 Full-Text Search Deployment White Paper
The SQL Server 2000 Full-Text Search Deployment white paper is for database administrators who have to deploy full-text search applications, currently use full-text search, or want to explore what full-text search offers. It outlines the hardware and operating system requirements for efficient full
Introducing Mutation Events
by Antoine Quint – Last month we completed work on a simple yet functional implementation of text wrapping for SVG. My only complaint is that the text-wrapping component lies about its XML integration. Last month I raved about how this text-wrapping component was a clean extension of SVG 1.0; but, l
SQL Server 2000 Windows CE Edition and the .NET Compact Framework
Learn how to connect embedded devices to Enterprise information systems with Microsoft SQL Server 2000 Windows CE Edition 2.0 and the .NET Compact Framework.
Web Services Security Pushes Ahead
by Michael McCarthy – Security in Web services has been the source of much hand-wringing in the press, but it’s actually moving forward rapidly. A quickstart initiative by Microsoft, IBM, and VeriSign is helping to establish some basic, implementable, security standards. Eric Schmidt tells us why th
OPENXML
With SQL Server 2000, there are many ways you can get XML representation of relational data. The options include using FOR XML clause with SELECT statement, ADO Recordset’s Save method with adPersistXML parameter, etc. It would be nice to have a reverse mechanism, which allows turning XML document i
Oracle Moves Onward With Outsourcing
Oracle’s strategy to increase its hosted application revenue is paying off for the software giant — thanks to a motivated sales force and cost-conscious enterprise customers.
Embarcadero Unifies DBA Management Tasks
By John S. McCright – Embarcadero Technologies Inc. aims to make it easier to manage computing environments that run databases from several vendors.Upgrades to the company’s DBArtisan and SQL Debugger tools will let database administrators manage and develop applications across IBM, Oracle C
Using a CSV with an IN sub-select
One of the most asked questions involves a bit of code like this: Select * From Products Where ProductID in (@SomeCSVString). I’ve always said the only way to do this was through dynamic SQL. Actually there’s a better way in SQL Server 2000. It doesn’t involve dynamic SQL and it’s really easy to use