By Wylie Wong – Oracle is shipping its Oracle 9i Developer Suite, a set of tools that Java and SQL developers can use to build their Web-based software. It includes the 9i JDeveloper Java development application and tools for building data warehousing and analysis systems, through which companies ca
Community
Increase SQL Server stored procedure performance with these tips
By Kevin Brown – Developers often take advantage of stored procedures to enhance the performance of database applications that use Microsoft SQL Server. Stored procedures offer a number of advantages over normal SQL statements: They’re precompiled and preoptimized, and they offer some programmable f
Auto-Audit 2.0 General Info
Auto-Audit proves a comprehensive, enterprise level tool for auditing Micrsoft SQL Server Databases unmatched on the market today. The tool is both configurable and scriptable and ships with the power of Microsoft VBScript and JScript parser. Whether you are relatively new to SQL Server and just n
Microsoft to revamp portal software
By Wylie Wong – The software kingpin is updating its SharePoint Portal Server software to support the company’s overarching .Net strategy to move computing to the Web. The updated software, slated for availability in the middle of next year, will allow nontechnical employees to build corporate porta
Ignoring testing could lead to Web services disaster
By Eric B. Parizo – Before it can work well, a Web services must work, period. One analyst firm warns that unless testing plays a prominent role in development cycles, many Web services may be cast aside before they achieve their full potential and after they've already cost companies lots of ca
DB2 to gain XML querying
By Martin Veitch – IBM plans to include XML querying capabilities so database administrators can delve into unstructured data, including multimedia files. Jeff Jones, DB2 marketing director, said the next DB2 will host "some form of XQuery support". XQuery is one of the most popular emerging
Pull Parsing in C# and Java
by Niel Bornstein – In my first article in this series, I wrote about porting a SAX application called RSSReader to the new Microsoft .NET Framework XmlReader. After publication, I received a message from Chris Lovett of Microsoft suggesting I revisit the subject. As he said, while the code I presen
Accessing SQL Server Using HTTP
You can access Microsoft® SQL Server™ 2000 using HTTP. For more information about the URL syntax that is support by the SQL ISAPI extension, see URL Access. Before queries can be specified using HTTP, a virtual root must be created using the IIS Virtual Directory Management for SQL Server utility.
SQL Server Accelerator for BI Overview
Reduced time to market is a competitive advantage in today’s fast-moving, information-driven economy. To respond rapidly in this environment, companies must be able to quickly and easily access the information they need to make decisions that impact their customers, sales and profit growth opportuni
Reasons to move your .NET network from Oracle to SQL Server
By Sanders Kaufman, Jr. – In the case of a .NET architecture, the answer to both questions is a .NET server. In this article, we explore the reasons why there may be an Oracle server in your network, what it will take to move it to SQL Server, and what you will gain by the move.