FREE Microsoft eBooks

Microsoft Senior Sales Excellence Manager – Eric Ligman posted a list of almost 300 FREE Microsoft eBooks. You can download them all from hos blog at the following address:
http://blogs.msdn.com/b/mssmallbiz/archive/2014/07/07/largest-collection-of-free-microsoft-ebooks-ever-including-windows-8-1-windows-8-windows-7-office-2013-office-365-office-2010-sharepoint-2013-dynamics-crm-powershell-exchange-server-lync-2013-system-center-azure-cloud-sql.aspx

Advertisements

Migrate database to a lower version

It is not supported to downgrade a Microsoft SQL Server by using the detach/attach or backup methods. However, it it possible to script data from the upgraded database and then import it into a new database in the lower version of SQL Server. A good description of this can be found on the following page:
http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/

Check Database Size

There is a standard SQL report that shows how much space a database is using. In SQL Server Management Studio for SQL Server 2008 R2 and newer, right-click on the database you are interested in and select Reports->Standard Reports->Disk Usage.

There is a good description of this report, including information about how to resize a Operations Manager database in the SCOMfaq.ch blog: http://blog.scomfaq.ch/2012/06/26/scom-check-size-of-databases-sql-standard-reports/