Refresh Site Collections in Config Database

Synchronizes the content database with the configuration database of the farm with respect to what site collections actually exist in the content database.  Ensures that all site collections in the content database are registered in the configuration database and removes any site collection references in the configuration database if the site collection does not exist in the content database.


$db = Get-SPDatabase | where {$_.Name -eq "DatabaseName"}
$db.RefreshSitesInConfigurationDatabase()

Free SharePoint eBooks

http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies-en-us.aspx#[Category]%20Office

Database Maintenance Best Practices

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Database-Maintenance-Best-Practices-Part-I-e28093-clarifying-ambiguous-recommendations-for-Sharepoint.aspx

Reporting Services Add-In for SQL 2012

http://www.microsoft.com/en-us/download/details.aspx?id=29068

Slow Report Rendering in SSRS Integrated Mode

http://www.sqlchick.com/entries/2011/1/25/whats-up-with-the-slow-ssrs-r2-rendering-in-sharepoint-2010.html