SQL Server Management Studio

The WakaTime plugin for SQL Server Management Studio is open-source on GitHub.

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.