By Matt Hicks – Oracle Corp.’s push toward more extensive support for Linux may help propel the open-source operating system into broader enterprise use, although some Oracle customers may be slow to commit to running the company’s database on Linux.
Author: SSWUG Research
Index Optimization Tips
In this article, Alexander Chigrik shows you how you can improve the speed of your queries by choosing the proper indexes, what kinds of indexes MS SQL Server supports and what is the advantage and disadvantage of using indexes in a particular situation.
A Script That Lists All Tables and Their Column Names With Data Types
(Jatin Kumar Shah) This script creates a report of all user owned tables and their columns with data types and nullability information.
New Onyx CRM Suite Supports Oracle Database
By Erika Morphy – Because the Onyx architecture separates the application, database and hardware, the company is positioned to offer additional database support without a lot of work.
SQLXML 3.0 SP1
Get the latest update to SQLXML with new security features and performance enhancements.
INF: SQL Server 2000 Full-Text Search Deployment White Paper (Q323739)
The SQLFulltextsearch.exe file contains the SQL Server 2000 Full-Text Search Deployment white paper.
Fun with Numbers in Transact-SQL Queries
by Vyas Kondreddi – Recently, someone asked in a Microsoft public SQL Server newsgroup how can you sort characters within a string? For example, a string contains ‘CBA’, and he wanted to sort the characters within the string and make it ‘ABC’. Instead of going for a procedural solution, just for fun
Oracle and Open Source Technologies and Applications
Sean Hull has compiled this extensive collection of open source tools that can be used with Oracle databases. Sean is a coauthor of Oracle & Open Source.
Enlighten
By Alan Joch – Take the next step beyond business intelligence. Tight integration of core BI technologies in the Oracle database kernel and Oracle9iAS gives you true business insight, in real time, from one place: the database.
Tip: Using pull-based DOMs
By Uche Ogbuji – XML application developers usually have to contend with the complexities of SAX or the inefficiencies of DOM. This tip shows how a pull approach to DOM can effectively bridge the gap between the two by offering simple, efficient parsing.