HOWTO: Backup/Restore MongoDB w/ PHP
Database, MongoDB, NoSQLDumping 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
Database, SQL Server, SSASSQL 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
Database, SQL, SQL ServerSQL 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
Access, Database, MicrosoftMicrosoft 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 Reports, DatabaseCrystal 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
Database, SQLBuilding 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…