By Ed Parry – Wanna stop being a DBA ASAP?Do one of the twenty things seasoned DBA and Oracle expert Rachel Carmichael of Dragonfly Consulting LLC listed in her presentation last month at the Oracle user event IOUG Live!, and your IT death wish might come true.
Author: SSWUG Research
Microsoft reaches out to Java developers
By Paul Krill – MICROSOFT released a JDBC driver enabling Java developers to utilize Microsoft’s SQL Sever 2000 database as a data management system for Java applications.
Upgrading from SQL 7 to SQL 2000
By AjarnMark – When you are ready to make the jump to SQL 2000, you will find that there are several ways that you can do this. Of course, each method has its advantages and disadvantages, and which one you choose will be based on a number of factors. I will attempt to introduce these factors and ho
REST Roundup
by Leigh Dodds – The XML-Deviant this week takes a brief look back over the REST debate, to see what's been learned, and what's still to be done.
Recruiters endorse HR-XML proposal
By Gillian Law – The six sponsors of the HR-XML (Human Resource Extensible Markup Language) Consortium have endorsed a specification it developed for information exchange between recruitment organizations and their customers.
Generate Custom Crosstab Reports
by Roger Jennings – Designing XML Web services that return user-defined time-series crosstab reports as XML or XHTML response documents probably will be among the first challenges presented by clients or managers to Visual Studio .NET developers. This article describes what I believe to be a new app
Speed Up Jet-to-SQL Server Conversion With Conditional Compilation
by Susan Sales Harkins – By using conditional compilation constants that control SQL statement generation, you can target both Jet and SQL Server, deliver applications to either platform, and reduce conversion time.
Essential SQL Server 2000
Written by Buck Woody – When a new release of SQL Server comes out, there are many books rushed to publication so that they are released at the same time the new version of SQL Server is released. Unfortunately, this “book rush” often leads to poor quality books. But if you wait some time after a n
Query Analyzer Shortcuts
By Michael Otey – Query Analyzer is one of the most frequently used utilities in SQL Server’s tool set. Here are seven keyboard shortcuts that make Query Analyzer a more effective and productive tool.
Sophisticated Mining with Oracle Text
By Douglas Scherer – I often get asked if Oracle Text can replace full-blown document management systems, but I don’t see Oracle Text as a competitor to these systems. When combined with other Oracle database features such as Internet File System (Oracle9iFS) and the new XML datatype (XMLType), Orac