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

Several web sites provide a good overview.

Microsoft Official SQL Servers

Microsoft SQL Servers Wikipedia

NoSQL vs. SQL

, , , ,
NoSQL’s popularity has been on the rise over the last five years, with favorites like MongoDB, CouchDB, Cassandra, and Redis on the forefront. With NoSQL’s strengths in its fantastic performance and the ability to store and query denormalized…

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…

Start using SQL Server schema objects

,
When we use the word "schema", we are usually referring to the overall design definitions of tables, views, stored procedures and other objects in a database. Within Microsoft SQL Server, however, there is an object called "schema" which permits…

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: Migrate VS Project with SQL to IIS

, ,
SQL Server Problem When migrating a Visual Studio project with a local SQL Server application database to IIS, you receive the following error: "Failed to generate a user instance of SQL Server due to failure in retrieving the user's…