Refresh SSMS Sql Server Intellisense Autocorrect

To refresh the intellisense after adding a new table or columns, is actually pretty easy.  I used to end up restarting SSMS, but no more!

There are two ways to refresh the cache: 
1) Go to Edit -> IntelliSense -> Refresh Local Cache 
2) Hit Ctrl+Shift+R


https://blogs.msdn.microsoft.com/dtjones/2008/09/11/refreshing-the-intellisense-cache/

SSIS: Method not found: Boolean when trying to debug project

1)  Open Visual Studio Developer Command Prompt with as admin.

2)  Cd to the path of the visual studio assemblies.  For 2012:  

 cd "C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies"


3) Run gacutil /if Microsoft.SqlServer.Dts.Design.dll

4) Restart Visual Studio


Taken from:

http://stackoverflow.com/questions/24745396/isvisualstudio2012proinstalled-method-not-found-error-when-running-an-ssis-pac

SSIS Toolbox Empty

If you see the toolbox is empty when working in SSIS, it is because it uses a seperate SSIS Toolbox.  Click on the Control Flow, and in the far right of the window is an icon to display the SSIS Toolbox.  More details (including pictures) can be found in the link below:

http://www.jamesserra.com/archive/2013/01/ssis-2012-empty-toolbox/