What Are Some Sharepoint Best Practices?

Question

Hi guys I am new to Sharepoint. Is it a good practice to query the content database tables through the SQL Server Management studio?

Which things need to be considered for Sharepoint testing? As of now I have considered Authorizations and Performance of Sharepoint portal.

Still there are lot of things need to be considered but since I am new to Sharepoint can anyone please guide me on how we do Sharepoint testing and things to be considered for Sharepoint testing?

Any help really appreciated. Thanks in advance.

Answer 1

Annop, I can answer your first question. The best practice is to use the Sharepoint API to access the database. The Sharepoint database is proprietary to Sharepoint, and Microsoft recommends that it not be accessed directly (or at least never written to directly). The database contains field names like StringField1, StringField2, NumericField1, etc. so composing a meaningful SQL query would be difficult.

Answer 2

Regarding your second question, the following link contains several resources to help you with Sharepoint testing:

http://jopx.blogspot.com/2009/03/sharepoint-unit-testing.html

Answer 3

here is a link to help unit testing sharepoint with mocking http://www.typemock.com/sharepointpage.php

Hope it helps