Windows 8 Task Manager slow performance to open at first time

Solution : Disable Windows Defender Real-Time protection

Overlay Icons disappear– (TortoiseSVN,Dropbox,SkyDrive,Google Drive…)

1. Regedit > KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\explorer\ShellIconOverlayIdentifiers)
2. Rename the entries under ShellIconOverlayIdentifiers to reorder the Icons.
3. End task explorer.exe and restart it. (As same as restart computer.)

Reference: http://stackoverflow.com/questions/1057734/tortoisesvn-icons-not-showing-up-under-windows-7

SSIS package using SQL Authentication on SQL Server Agent

 

1. SQL Server Business Intelligence Development Studio > SSIS tab > Package Configurations Organizer > Enable Package Configurations > Click Add > Type : XML configuration file >  Set up file path and name > Next > Select Connection manager >  Select Connection and pick Password.
   

2. Open configuration feil from you store path. > Add Password in <ConfiguredValue> element :
     <ConfiguredValue>PasswordSample</ConfiguredValue>
   

3. Add configuration file in you SQL Server agent.

Reference : SSIS package using SQL Authentication and DontSaveSensitive as ProtectionLevel

Run sqlcmd.exe without having SQL Server installed on Windows Server 2008

1. Go to www.microsoft.com/en-us/download/details.aspx?id=26728
2. Install Microsoft® SQL Server® 2008 R2 Native Client
   (1033\x86\sqlncli.msi  or 1033\x64\sqlncli.msi)
3. Install Microsoft® SQL Server® 2008 R2 Command Line Utilities
   (1033\x64\SqlCmdLnUtils.msi or 1033\x86\SqlCmdLnUtils.msi)
4. sqlcmd in C:\Program Files\Microsoft SQL Server\100\Tools\Binn\