Pauls Blog

They used to be stored in Appdata roaming. They are now stored in a local sqlite database at %LOCALAPPDATA%\Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState\plum.sqlite

http://nbnmtm.australiaeast.cloudapp.azure.com/nbnmtm.html

foreach (DriveInfo DI in DriveInfo.GetDrives()) Console.WriteLine( ( DI.IsReady ? (DI.VolumeLabel.Length == 0 ? "Drive Type: " + DI.DriveType.ToString() : "Volume Label: " + DI.VolumeLabel) : "Not Ready : " + DI.DriveType.ToString() ) + // " (" + DI.Name.Replace("\\", "") + ")" " (" + DI.Name + ")" + Environment.NewLine ); Code highlighting compliments of http://markup.su/highlighter/ Another options is  http://hilite.me/

COLLATE sql_latin1_general_cp1_cs_as

First, create your certificate with something like... CREATE CERTIFICATE YourTestKey1    ENCRYPTION BY PASSWORD = 'a secure password    WITH SUBJECT = 'My Test Key',      EXPIRY_DATE = '20201231'; GO More to follow.....

Rarely do you need select from a select statement. Occasionally this pops up with complex PIVOTs and UNPIVOTs. The tip when doing this is (in MSSQL) is the "table" select statement needs to be aliased. For example, the following statement will not work: SELECT * FROM ( SELECT * FROM blah )  However, the following statement will work: SELECT * FROM ( SELECT * FROM blah ) x

https://technet.microsoft.com/en-us/library/ff432698.aspx change user /install change user /execute change user /query