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

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

GIF Support in Outlook

I been waiting for the day when Outlook will get GIF support and it is here. I been creating GIF to explain a situation or when creating troubleshooting mailer. Now that outlook has given support to GIF, I can draft GIF embedded mail with more grace. So effectively another dimension i.e.time has been added to my mails. I use ScreentoGIF  to create GIF and it is a nice piece of software with ton of option to edit your recorded GIF like reducing delay between frames, reducing adding transition, adding caption..etc. One thing I recommend is adding a progress bar, so that user intuitively knows at what state the animation is in, when he/she starts noticing it.