Database Overview
A database is a means of storing information in such a way that information can be retrieved from it. In simplest terms, a relational database is one that presents information in tables with rows and columns. A table is referred to as a relation in the sense that it is a collection of objects of the same type (rows). Data in a table can be related according to common keys or concepts, and the ability to retrieve related data from a table is the basis for the term relational database. A Database Management System (DBMS) handles the way data is stored, maintained, and retrieved. In the case of a relational database, a Relational Database Management System (RDBMS) performs these tasks.
Database Related Queries/Issues.
MsSQL
MsSQL Database full Recovery from transaction logs.
MsSQL Enable Mixed Mode Authentication
MsSql Database Maintenanace - Best Practices by Microsoft
MsSQL Database/Logs Shrinking
MySQL
MySQL Database Optimization
Shrinking of IBDATA1 Of MySQL Database.
