SQL Server 2012 - Best Practice Analyzer

The following are required for using SQL Server 2012 Best Practices Analyzer:

• PowerShell V2.0   (Powershell 4.0 is out now)
• Microsoft Baseline Configuration Analyzer V2.0

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

Source: http://www.mssqltips.com/sqlservertip/2712/using-the-microsoft-sql-server-2012-best-practice-analyzer/

SQL Server 2012 - SSIS Execution Permissions

I ran into an issue where even the server administrator and sql server services accounts would not properly execute SSIS packages. I had to perform the following steps so the service account could execute a sql agent job and run a package.

Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node. Right-click Microsoft SQL Server Integration Services 11.0, and then click Properties. On the Security tab, click Edit in the Launch and Activation Permissions area. Add users and assign appropriate permissions, and then click Ok. Repeat steps 4 - 5 for Access Permissions. Restart SQL Server Management Studio. Restart the Integration Services Service. (Source MSDN)

http://stackoverflow.com/questions/13941998/sql-server-2012-integration-services-failed-when-connecting-thru-ssms