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 like normal and your stats will automatically show on your WakaTime Dashboard.