The Acumen software design blog provides you with helpful articles about Databases.

This web site provides a good overview.

Database Wikipedia

HOWTO: Backup/Restore MongoDB w/ PHP

, ,
Dumping a MongoDB database is done using the "mongodump" utility in the command prompt. This dump creates a binary export of the database. This export can be restored using the "mongorestore" utility. A basic dump of a local MongoDB database…

SSAS - Attribute Hierarchies Error

, ,
SQL In his excellent book, Star Schema, Christopher Adamson begins Chapter 7, "Hierarchies and Snowflakes," with the following language: It is possible to describe a dimension table as a series of parent-child relationships among groups…

HOWTO: Improve SQL Server in Third-Party App

, ,
SQL Server  Description: We have encountered the unfortunate situation where a company has a third-party application and the performance problems associated with this application cannot be solved despite many in-house efforts to do so and…

SOLVED: Access Dialog Issue

, ,
Microsoft Access kept hanging on when .Show was called the second time in an application. I created a simple example showing it either hanging or killing the Access 2010 program running windows 7. Clicking the first button and then the second…

Move Crystal Report between Servers

,
Crystal Report Object reference not set to an instance of an object. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. CrystalReportSource1.ReportDocument.ExportToHttpResponse(ExportFormatType.PortableDocFormat,…

Aptify Views and SQL Temporary Tables

,
Building additional SQL views in Aptify Association and Membership Management Software can sometimes require you to use SQL temporary tables in your view. If you then attempt to create a database object from said view: You will get an Aptify…