Skip to main content

Undoing the mistake of selecting Sticky Notes as notes keep

Sticky Notes seems straight forward means to keep notes that you need handy, like quick notes on command you use frequently. Unfortunately, once your notes reaches certain number, the program starts to lag in response i.e. your click or select will not register and you end getting frustrated. I been there and I resorted to copying and pasting notes from sticky notes to more awesome OneNote. I soon got tired of unresponsive sticky note and resorted to finding where the data is stored and how to retrieve it.

Following are my finding(or googling),
1. In Windows 10, Sticky notes stores data at %LocalAppData%/Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState and inside file with extension *.sqlite.
2. Now to open the file we can use windows tools under download page. I used sqlite3.exe
3. Type in following commands after getting to folder where sqlite3.exe exists,

  1. sqlite3.exe - This is to get to sqlite prompt
  2. .excel - This is to specify that following command should show result in Excel
  3. SELECT * FROM Note - This command will display the table information in an excel

That is it, your sticky notes will be in the first column of the excel sheet that opens.


  1. Great post! This is very useful for me and gain more information, Thanks for sharing with us.



Post a Comment

Popular posts from this blog

BizTalk Deployment Framework fix for compatibility issues with BizTalk 2016

Objective My objective was to modify BizTalk Deployment framework source, with the intend of getting it to work with BizTalk 2016, as it does not work out of the box with BizTalk 2016.
Source Location BizTalk Deployment Framework source is located at CodePlex and downloaded from below link It has BTDF 6.0 under dev folder and BTDF 5.0- 5.6 under release folder. BTDF 5.6 release version is more suited, as it is a stable release, hence it is modified to suit our need. All the references going forth are from the 5.6 release folder.
Modifications Below is the modification that were done in order to get BTDF 5.6 release version, working.    1.Added copy of BizTalk 2016 SSOClient to \Tools\SSOSettingsFileImport\ExternalReferences\BTS2016\Microsoft.BizTalk.Interop.SSOClient.dll, we will use as reference later. 2.In solution, \Tools\SSOSettingsFileImport\SSOSettingsFileImport.sln clone projects SSOSettingsEditorBTS2013R2, SSOSettingsFile…

Automating adding user to user groups

Every now and then, I would come across situation, where I have to add new member to project. As part of the process, I have to give the new guys user permission to the machine (mostly BizTalk Server machines). When you have multiple servers, the task gets monotonous. During once such, instance, I sought the enlightenment google caters and found below script to do the same, in matter of seconds. I am not sure which article guided me to the solution, so I am not referencing it.

Below is the script for adding users to group, generally for stand alone BizTalk machine,

$group = [ADSI]"WinNT://localhost/Users"

$group = [ADSI]"WinNT://localhost/BizTalk Application Users"

$group = [ADSI]"WinNT://localhost/BizTalk Isolated Host Users"