Tempdb Corruption

For the longest time the guidance around tempdb is that if you shrink it on a live system then it could cause tempdb corruption.

http://www.sqlskills.com/blogs/paul/shrinking-tempdb-longer-prohibited/

http://support.microsoft.com/kb/307487/en-us

Remember though, shrinking should be a rare operation, whether data or log file shrinking – and never a regular operation.

http://kmp.dell.com/services/kedge/application_services/databases/f/601/t/6558.aspx

The EXECUTE permission was denied on the object 'sp_help', database 'mssqlsystemresource', schema 'sys'.

ERROR:

Msg 229, Level 14, State 5, Procedure sp_help, Line 1

The EXECUTE permission was denied on the object 'sp_help', database 'mssqlsystemresource', schema 'sys'.

Solution:
 Use Master

Go

GRANT EXECUTE ON sp_help to Public

Encryption Key for the Reporting Services Fails

ERROR:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. 
---> System.Runtime.InteropServices.COMException (0XXXXXX): Password doesn't meet the requirements of the filter dll's 

Solution :

Remove the custom password filter on:
         HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\LSA - Notification Packages

Installing SQL Server 2012 or 2014 on Windows 2003

SQL Server 2012 or 2014 cannot be installed on the Windows 2003 Server.

Hardware Software Requirements for SQL Server 2012 : http://msdn.microsoft.com/en-us/library/ms143506%28v=sql.110%29.aspx

Database Files location with Comma separated

Enclosed script will provide the details of MDF and LDF locations with a comma separated. This will help us to collect the inventory during the intial requirement gathering.

 https://gallery.technet.microsoft.com/Database-Files-location-08d507df