How to Logoff of Windows Server 2012 R2(and Windows 8 too?)

I have been playing around in Windows Azure a lot lately and I keep forgetting how to logoff of Windows Server 2012 R2. So, Here it is…


  1. Click Start button to get to the “Start” screen. image
  2. Click on your Account Picture in the top right corner.


  1. Select “Sign Out”



“Operation must use an updateable Query” error when updating Excel


Make sure that your connection string does not have “IMEX=1” in it.

private void UpdateEmailSent( string apexId ) {
            try {
                string excelConnectionString = string.Format( "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES\";", lmiUserFileTextBox.Text );
                System.Data.OleDb.OleDbConnection MyConnection;
                System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand( );
                string sql = null;
                MyConnection = new System.Data.OleDb.OleDbConnection( excelConnectionString );
                MyConnection.Open( );
                myCommand.Connection = MyConnection;
                sql = string.Format( "UPDATE [Sheet1$] SET [Email Sent] = 'X' WHERE [APEXID]='{0}'", apexId );
                myCommand.CommandText = sql;
                myCommand.ExecuteNonQuery( );
                MyConnection.Close( );
            } catch ( Exception ex ) {
                MessageBox.Show( ex.ToString( ) );

How To Cycle Through Dialog Buttons in Mac OSX Dialog Window

ImageI was working in Lightroom tonight deleting some photos and I was not able to cycle through the different buttons using my keyboard arrow keys in a dialog window. Turns out you have to enable this “feature” by going to System Preferences > Keyboard > Keyboard Shortcuts and selecting the “All controls” option under Full Keyboard Access. Really???


How to read the 64 bit registry from a 32 bit application or vice versa | Rhyous

I was recently trying to update a 32-bit migration utility running on Win7 64 that needs to cleanup some registry entries in the 64 and 32 bit registry HKLM hives. Unfortunately accessing the 64-bit hive was not as obvious as I expected. Came across this article which explains how to tackle this issue.

How to read the 64 bit registry from a 32 bit application or vice versa | Rhyous.