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 sqlite.org 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.

Comments

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

    easyblogging
    Technology

    ReplyDelete
  2. Wild West Gold Online - Sands Casino Resort
    Play for real money at Wild West Gold Slot Machine. Play hundreds of the latest septcasino online slots kadangpintar at 제왕카지노 Sands Casino Resort in West Virginia. Claim your welcome bonuses.

    ReplyDelete

Post a Comment

Popular posts from this blog

Getting user First Name and Last Name from Active Directory

Recently, I had to create a asp.net MVC portal for organizing test messages. Since site is personalized for User, we were required to fetch and disply username, when they login. This being intranet site, user is authenticated using Windows Authentication. Windows user names are most of the time are mix of literal, not conveying users First and Last name. I used following code to get User First and Last name, using DirectorySearcher class to query Active Directory. Since user name in HttpContext is in format DomainName\\UserName, I had to extract user name alone and use it filter. using System.DirectoryServices; ... ... DirectorySearcher ds = new DirectorySearcher(); var indexOfBS = User.Identity.Name.IndexOf( "\\" ); ds.Filter = String.Format( "((SAMAccountName={0}))" , User.Identity.Name.Substring(indexOfBS + 1, User.Identity.Name.Length - indexOfBS - 1)); ds.PropertiesToLoad.Add( "givenName" ); ds.PropertiesToLoad.Add( "sn" ); var direc