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…