By Mikael Bergkvist – Thinking out of the box might be a dangerous thing. Usually it’s assumed to be good, but how can it, in a world where solutions are sold for a profit? This is the direct opposite to creativity, which is the driving force behind the capitalistic principle of creating nish
Other News
True DBA Blooper #4: Mysteries solved
By Ellen O’Brien – When the call went out for DBA bloopers, Christopher James Thompson sent a whopping five memorable blunders. Is he more accident prone that most DBAs? We doubt it. Thompson is probably just more honest. Here Thompson recounts two of his favorite bloopers for SearchDatabase.com rea
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
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
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.
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
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
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.
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
Appropriate Uses of MSDE
Several Microsoft product licenses convey the right to use and redistribute the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) version 2.0. Review the information on this page to learn which product licenses or subscription services convey the redistribution rights you require. In all cases, y