While trying to access databases, logins, etc in SQL Server Management Studio 2008 R2, below error is always popping up. I browsed over google to find out a solution but those resolutions did not s...

I am learning MySQL architecture. I come up with the following illustration: There are 4 concepts that I don't understand well: double write buffer log buffer write-ahead log redo log I re...

I looked around and found some of the MySQL engines are innodb and MyISAM. Perhaps there are few more. My question is what are these database engines? What are the differences between differ...

I'm looking for a database engine that can handle data constraints specified via RegEx. So in addition to the datatype, I want to be able to control the format of the data. E.g. a varchar(255) fiel...

I have an application database with a table for users (1kbyte of data per user based on counting fields * typelength), and about 100 things of the same size belonging to a user (0.5 kbyte per thing...

Can someone please explain what is the main difference between SQL Server Compact Edition and SQL Server Express Edition? For what purpose I should use this or that one? Thanks

I am interested in learning how a database engine works (i.e. the internals of it). I know most of the basic data structures taught in CS (trees, hash tables, lists, etc.) as well as a pretty...