Take advantage of the SQL Server .NET data provider to access SQL Server data using ADO.NET, as it offers the best overall performance. It can be used to access both SQL Server 7.0 and SQL Server 2000 databases.Check out more tips!
Author: SSWUG Research
Microsoft eases VS.NET database development
BY: Eric B. Parizo – Thanks to a pair of new offerings from Microsoft, not only can applications built with Visual Studio.NET now connect natively to Oracle databases, but Java applications can also access Microsoft SQL Server databases. SearchVB spoke with AMR Research senior analyst Peter Urban ab
Regular Cleanup of Audit Tables
(Bhagwan Singh) Description: I developed this small package to execute the cleanup of my audit tables fortnightly, after reports were done.
Database Development in SQLJ, Part III: Writing Stored Procedures in SQLJ
Put SQLJ to use. This language allows you to write stored procedures with database-independent code that can be easily ported among Java-enabled database platforms. Oracle Pro Boris Milrud demonstrates how to write, load, and run a SQLJ stored procedure on an Oracle database, and shows how its resul
Standard Data Vocabularies Unquestionably Harmful
by Walter Perry – At the onset of XML four long years ago, I commenced a jeremiad against Standard Data Vocabularies (SDVs), to little effect. Almost immediately after the light bulb moment — you mean, I can get all the cool benefits of web in HTML and create my own tags?
Exclusive XML Canonicalization Version 1.0
Canonical XML [XML-C14N] specifies a standard serialization of XML that, when applied to a subdocument, includes the subdocument's ancestor context including all of the namespace declarations and attributes in the "xml:" namespace. However, some applications require a method which, to th
Can XML and Java live together?
An interview with Jonathan Schwartz, Sun Microsystems's chief strategy officer, who is about to take on the challenge of developing the company's software strategy. Is there room for XML at Sun?
Windows NT Account Lockout with SQL Server CE Replication and Invalid Password
If you use an application based on Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Replication or Remote Data Access (RDA), you may receive an error message similar to the following when you use an invalid password for use with Microsoft Internet Information Server (IIS) servers that ar
Data Mining on a Shoestring
By Frances Keeping – Did you know that your database can tell you how to increase your revenue and build customer loyalty? With Analysis Services, mining your data for gold is easy.
Oracle9i New Features for Oracle8i DBAs
By Roger Schrag – This paper offers a brief overview of the new features in the Oracle9i database of most interest to database administrators. It is written for DBAs experienced with Oracle8i who are looking for a quick-read roadmap to what has changed and what is new in Oracle9i. For each item we’l