(John Sasak) When it comes to database for .NET, there are several options in addition to the well known ones such as SQL Server or MySQL. One of them is Matisse, a post-relational database by Matisse Software.
Other News
SQL Server backups made easy using Maintenance Plans
(Greg Robidoux) If you’re new to SQL Server and not sure how to set up backups, Maintenance Plans may be the way to go. Although not all of the backup functionality is available using Maintenance Plans, Microsoft has developed an easy interface to set up backups for all of your databases. (R)
Testing databases that contain a million rows with SQL
(Arthur Fuller) Benchmark testing can be a waste of time if you don’t have a realistic data set. Arthur Fuller exhibits how you can set up your test to accommodate for more than one million rows, thus returning more accurate test results.
You experience a decrease in query performance after you perform an incremental process on a virtual dimension in SQL Server 2000 Analysis Services
When you run a query against Microsoft SQL Server 2000 Analysis Services build 8.00.0909 or a later build, you may experience a decrease in query performance. The problem occurs when the following conditions are true: • The query uses a virtual dimension or a changing dimension. • You run the
Remove ASP.NET Page Output Cache Entries
(Steven Smith) This article discusses two techniques for programmatically invalidating the cache of ASP.NET pages that use Output Caching, allowing control over cache expiration from code.
There’s More to Java vs. .NET Than Technology
(Linda L. Briggs) Endless debates swirl around the technical merits of Microsoft’s .NET platform vs. Sun Microsystems’ J2EE. Both companies tout their products’ scalability, security, interoperability, speed, support for other products and more. But what about the business case for either platform?
Managing XML data: Identify XML documents
(Elliotte Rusty Harold) The name of an XML file does not have to end in .xml. In fact, an XML document doesn’t have to be in a file at all. It can be a database record, a piece of a file, a transitory stream of bytes in memory that’s never written to disk, or a combination of several different files
BMC Software Rolls Out SmartDBA 3.0
BMC Software, Inc., a provider of enterprise management solutions, introduced a solution for managing and tuning every aspect of the DB2 Universal Database (UDB). With the introduction of SmartDBA Performance Solution for DB2 UDB version 3.0, BMC Software said it is making it possible for Unix, Linu
SQL/400 Data Manipulation Language
In the previous chapter we learned how to use SQL’s data definition language (DDL) to create SQL base tables that contain data and SQL views that provide alternative ways to access data in base tables. In this chapter we begin our study of SQL’s data manipulation language (DML), which provides data
What’s My Line? Tracking Exceptions in Oracle 10g
(Adrian Billington) It has always been possible in PL/SQL to identify the source of an exception in a block of code; i.e. to know the precise point at which a block of code failed. However, until Oracle 10g, it has not been possible for developers to intervene in the exception in any way whilst reta