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 :
  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\