WakaTime for SQL Server SQL Server

The open source plugin for productivity metrics, goals, leaderboards, and automatic time tracking.

Installing

  1. Download WakaTime.dll, Nlog.dll and Nlog.config.

  2. Inside regedit.exe go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0_Config\AutomationOptions\LookInFolders.

  3. Copy WakaTime.Addin to one of those folders. I recommend copying into C:\Users\\AppData\Roaming\Microsoft\MSEnvShared\Addins.

  4. Edit WakaTime.Addin and change the node Extensibility/Addin/Assembly to the full path of WakaTime.dll you downloaded.

  5. Right click on WakaTime.dll and select Unblock.

  6. Into Nlog.config file you must change two nodes as described below:

    1. Change the node nlog/targets/target/fileName to the path you want to save logs.

    2. Change the node nlog/targets/target/archiveFileName to the path you want to archive logs.

  7. Restart SQL Server Management Studio.

  8. Enter your API key , then press enter.

  9. Use SQL Server Management Studio like you normally do and your time will be tracked for you automatically.

  10. Visit https://wakatime.com/dashboard to see your coding activity.