If you want to manage the records same as you maintain in SQL server database then in that case you can use SharePoint list. List are generally meant to hold your records. Sometime you want to add some documents with records for that scenario SharePoint list supports attachments. While if you want to maintain documents and their properties then you can use SharePoint library. SharePoint libraries are meant to store the documents same as you store blobs in SQL server database. Sometime you also want to store the information about the document, then for that SharePoint provides metadata for the libraries.