Hotmail and Emojis – Day 02 ( Personal Feedback )

 

Lineage

A quick follow-up to my earlier struggle with Hotmail and Emojis.

Here is the initial post :-

  1. Hotmail and Emojis – Day 01
    Link

 

Personal Feedback

There are multiple layers of breakdown here:-

  1. Product Management
    • It is very difficult to see how this feature became a default use case.
  2. Development
    • Most developers think a bit about what they are coding
    • Opt-In
      • How do I enable it
    • Opt-Out
      • How do users opt out
      • Does the user have to repeatedly say No, I don’t want this feature
      • Or can they opt out once and be offered a choice as to No for now or Never
        • That, is I do not want this to be my new reality
        • And, be told how to enable it when they want it
  3. Usability Testing
    • It appears the only test case is how to force emojis once certain keystrokes are entered
  4. DevOps
    • This is also a cautionary tale about DevOps or deployment group
    • Did you use it while rolling it out
      • Or was everything automated
    • And, have you returned to using it
    • What has your experience being, when you wanted to say No
  5. Product Support

 

Hotmail and Emojis – Day 01

Background

Microsoft Hotmail and I have been entangled in a show of wills lately.

Emojis

Our combustive entanglement is about suggestive emojis.

I used :- quite a bit and once I enter those three characters, Microsoft thinks it is a stand in.

Use Case

Here is one use case :-

emojis.20190212.0639AM

Get out of Hell

Here are the options that are suppose to allow one to revert to the previous behavior.

But, unfortunately they do not work.

Outlook Settings – Customize Actions

Outline
  1. Access Hotmail
  2. Click the settings button ( settings.20190212.0643AM)
  3. View all outlook settings
  4. Click on “Compose and Reply”
    • Joyful Animations
      • Show joyful animations in the reading pane :- Uncheck
    • Quick Suggestions
      • Offer suggestions based on keywords in my messages :- Uncheck
      • Use browser locations to show places near me :- Uncheck
    • Suggested Replies
      • Show Suggested Replies :- Uncheck
  5. Click on “Customize Actions
    • Insert emojis and GIFS :- Uncheck
Images
Image – Compose and Reply

composeAndReply.01.20190212.0709AM.PNG

Image – Customize Actions

customizeActions.02.20190212.0605AM.PNG

Works

Email Compose

  1. For each email
  2. During Compose
    • Access Formatting panel
    • Click on Ellipse Button (emailCompose.formatting.ellipse.20190212.0957AM )
    • From the drop down menu, select “Switch to plain text

Please keep in mind that thing function only works per individual email and it strips out various modern functionalities.

Images
Image – Compose – Formatting

emailCompose.formatting.20190212.1000AM

Image – Compose – Image Switch to Plain Text

emailCompose.20190212.0954AM

 

Comments

New experiences in Outlook.com

Can I turn off ‘common expression’ highlighting?

Link

Anonymous.20190211.0757AM.PNG

Jessica.20190211.0740AM.PNG

DuncanArundel.20190202.0616AM

 

Mark.20190201.0709AM.PNG

Deborah.20190210.0610AM.PNG

JoeSivulka.20190206.1305.PNG

AdeleP.20190206.1007AM

Anonymous.20190204.0450AM

Cheryl.20190131.1353

RobertGarber.20190107.0815AM

idiotsRunThisSite.20190106.1452

John.20190212.1259.PNG

Anonymous.20181102.0927AM

hellYes.20180827.1151AM

Ken.20180908.1421.PNG

Tom.20190204.0802AM.PNG

 

PGP – Public Key – Viewing Metadata

Background

Let us quickly touch on tools we can use to view information in Public keys.

Tools

Outline

  1. OpenPGP
    • GPG4Win
      • GNU Private Assistant
  2. PGP Corporation
    • PGP Command Line
      • PGP

In depth

GPG4Win

GNU Private Assistant

Outline
  1. Load Public key
  2. Select Public Key
  3. View Key Information
Images
Image – Key Manager

KeyManager.20190211.0314PM.PNG

PGP Corporation

PGP Command Line

Outline
Syntax
Syntax – Display Key

pgp.exe --list-packets [keyfile]

Syntax – Display Key – Grep on Key ID

pgp.exe --list-packets [keyfile] | find /I "Key ID"<span id="mce_SELREST_start" style="overflow:hidden;line-height:0;"></span>

Output
>"F:\PGP Corporation\PGP Command Line"\pgp.exe --list-packets Prod_public.asc | find /I "Key ID"
        Key ID - 0xB7587153C4818072
        Sub: issuer key ID(sub 16)(8 bytes)
                Key ID - 0xB7587153C4818072
        Key ID - 0xF91B56A899D9CBEE
                Sub: issuer key ID(sub 16)(8 bytes)
                        Key ID - 0xF91B56A899D9CBEE
        Sub: issuer key ID(sub 16)(8 bytes)
                Key ID - 0xB7587153C4818072
        Key ID - 0x2E9493F0BADB7C37
        Sub: issuer key ID(sub 16)(8 bytes)
                Key ID - 0x2E9493F0BADB7C37
Prod_public.asc:dump packets (0:packets decoded successfully)     Key ID - 0xD7447ADF906B1C98

                Sub: issuer key ID(sub 16)(8 bytes)
                        Key ID - 0xD7447ADF906B1C98
        Sub: issuer key ID(sub 16)(8 bytes)
                Key ID - 0x2E9493F0BADB7C37

>

Win OS – Error – “An unhandled win32 exception occurred in spoolsv.exe”

Background

Have a few MS Windows 2003 computers running in our LAB.

Error

When I do bother to use them there is an arresting error that I have been receiving.

Error – “An unhandled win32 exception occurred in spoolsv.exe”

Image

spool.20190210.png

Textual


An unhandled win32 exception occurred in spoolsv.exe

Trouble Shooting

Control Panel

Printers and Faxes

Outline

  1. Accessed Control Panel
    • Reviewed Printers and Faxes

Images

controlPanel.printersAndFaxes.20190210.png

Event Viewer

Event Viewer \ System

Outline

  1. Launched Event Viewer
    • Review System Events
      • Event ID :- 7031
        • Event #1
          • Source :- Service Control Manager
          • Event ID :- 7031
          • The Print Spooler service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 60000 milliseconds: Restart the service.

Images

eventViewer.system.20190210.png

 

Remediation

We have an HP LaserJet computer that we have not used in a while.  It is currently turned off.

Outline

  1. Computer
    • Remove HP LaserJet Software installed on computer
    • MS Windows Registry Cleanup

 

Tasks

Remove HP LaserJet Software installed on computer

Removed any installed HP LaserJet software.

MS Windows Registry Cleanup

Outline

Cleanup MS Windows Registry using regedit :-

  1. Start regedit
  2. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Environments\Windows NT x86\Drivers
  3. Export Registry sub-key out to a file for safe keeping
  4. Under this key, there will be the keys Version-2 and Version-3
    • The sub-keys under these contain the printer driver configuration information
    • One or the other of these may be absent – not a problem
  5. Maintain each Sub-key
  6. But, search each sub-key for drivers no longer present on the computer
    • On each found sub-key, remove found sub-key
    • In our case
      • HP Laser Jet 2100
      • HP Laser Jet 2100 PCL6

Images

Image – Before

registry.noor.20190210.0159PM.png

Image – After

registry.noor.20190210.0308PM.png

Crediting

Crediting Mr. Shafique Cheena ( Profile )

Shafique Cheena

Event ID 7031 Print Spooler terminated unexpectedly

Link

credit.shafique.20190210

SQL Server :- “Cannot open database [database] version 852. Upgrade the database to the latest version.”

 

Background

Tried accessing a database and ran into an error.

Error

Error Text

Msg 946, Level 14, State 1, Line 1
Cannot open database 'WideWorldImportersDW_DBCCClone' version 852.
Upgrade the database to the latest version.

Error Image

error.2019020.0121PM

Metadata

sys.databases

Code


 declare @tblDatabaseInternalVersion TABLE
(
      [id] int
    , [version] varchar(60)
)

insert into @tblDatabaseInternalVersion
(
      [id]
    , [version]
)
select 515, '7'
union all
select 539, '2000'
union all
select 611, '2005'
union all
select 612, '2005'
union all
select 655, '2008'
union all
select 661, '2008-R2'
union all
select 663, '2008-R2'
union all
select 706, '2012'
union all
select 782, '2014'
union all
select 852, '2016'
union all
select 869, '2017'

select
          tblSD.[name]

        , [internalDatabaseVersion]
            = DATABASEPROPERTYEX
              (
                  tblSD.[name]
                , 'Version'
              )

        , tblDIV.[version]

        , [isClone]
            = DATABASEPROPERTYEX
            (
                  tblSD.[name]
                , 'IsClone'
            )

        , tblSD.[is_read_only]

        , tblSD.[snapshot_isolation_state]

        , tblSD.[recovery_model_desc]

        , tblSD.[is_cleanly_shutdown]

        --, tblSD.*

from   sys.databases tblSD

left outer join @tblDatabaseInternalVersion tblDIV

        on DATABASEPROPERTYEX
              (
                  tblSD.[name]
                , 'Version'
              ) = tblDIV.id

where  (

                ( tblSD.[database_id] <= 4 )
            or
                ( tblSD.[name] like 'Wide%' )

       )

order by

    lower(tblSD.[name]) asc

Output

sys.databases.20190209.0107PM

Explanation

  1. DatabasePropertyex
    • Version
      • Database Internal Version
        • v2017
          • All System Databases are v2017
          • WideWorldImportersDW is 2017
        • v2016
          • Cloned Database
            • WideWorldImportersDW_DBCCClone
    • isClone
      • Database was cloned using DBCC CLONE
  2. sys.databases
    • is_read_only
      • Cloned Database is readonly

Remediation

Outline

Cloned Databases are read only.

When we upgraded our SQL Server Instance from v2016 to v2017, read only databases such as cloned databases are skipped.

All other databases are brought up to the version of the SQL Server Instance.

If we really do need a cloned database, we will create it.

Create Cloned Database

SQL


DBCC CLONEDATABASE 

    (
          [WideWorldImportersDW]
        , [WideWorldImportersDW_DBCCClone_v2017]
    );   

GO

Output

Output – Text


Database cloning for 'WideWorldImportersDW' has started with target as 'WideWorldImportersDW_DBCCClone_v2017'.
Database cloning for 'WideWorldImportersDW' has finished. Cloned database is 'WideWorldImportersDW_DBCCClone_v2017'.
Database 'WideWorldImportersDW_DBCCClone_v2017' is a cloned database.
This database should be used for diagnostic purposes only and is not supported for use in a production environment.
DBCC execution completed. If DBCC printed error messages, contact your system administrator

Output – Image

dbcc.cloneDatabase.20190209.0231PM

 

Lineage

  1. SQL Server – Clone Database – Schema & Statistics
    Link

IIS/VBScript – GetObject – Error – 2147221020

Background

Stole some code and now I can’t get it to work.

Error

Error Image

error.2147221020.20190207.0152PM

Error Text

>cscript getWebService.vbs
Microsoft (R) Windows Script Host Version 5.812
Copyright (C) Microsoft Corporation. All rights reserved.

Enumerating websites on localhost

GetObject IIS://localhost/W3SVC
Error Number :- -2147221020
Error Source :-
Error Description :-

Code


OPTION EXPLICIT

ON ERROR RESUME Next

DIM CRLF, TAB
DIM strServer
DIM objWebService
Dim strPathName

TAB  = CHR( 9 )
CRLF = CHR( 13 ) & CHR( 10 )

IF WScript.Arguments.Length = 1 THEN
    strServer = WScript.Arguments( 0 )
ELSE
    strServer = "localhost"
END IF

WScript.Echo "Enumerating websites on " & strServer & CRLF

strPathName =  "IIS://" & strServer & "/W3SVC" 

WScript.Echo "GetObject " & strPathName

Err.Clear

rem SET objWebService = GetObject( "IIS://" & strServer & "/W3SVC" )

SET objWebService = GetObject( strPathName  )

If ( Err.Number  0 ) Then 

	Wscript.Echo "Error Number :- " + CSTR(Err.Number)

	Wscript.Echo "Error Source :- " + Err.Source

	Wscript.Echo "Error Description :- " + Err.Description

END IF

Remediation

 

Outline

  1. Please enable IIS 6 Metabase
    • Access Control Panel
    • Access Programs and Features
      • Within Programs and Features, choose Windows
    • Add Roles and Features Wizard
      • Web Server ( IIS )
        • Management Tools
          • IIS 6 Management Compatibility

 

ScreenShot

Add Roles and Features Wizard

Add Roles and Features Wizard – Server Roles

Add Roles and Features Wizard – Server Roles – Web Server

Management Tools – IIS 6 Management Compatibility – Adding Role – Management Service

iis.addRoles.after.20190207.0110PM.PNG

Management Tools – IIS 6 Management Compatibility – Confirm Installation Selections

iis.confirm.20190207.0110PM.PNG

Management Tools – IIS 6 Management Compatibility – Installation Progress

iis.installationCompleted.20190207.0115PM.PNG

Management Tools – IIS 6 Management Compatibility – Installation Completed

iis.installationCompleted.20190207.0115PM.PNG

Credit

David Wang

Link

David.Wang.20190207.0159PM

 

Win OS / Preparing Public Key from command Line

Batch

Sample DOS Batch file for importing partner public key, creating self public key, and exporting created key

Code


setlocal

	set "_folderBin=F:\PGP Corporation\PGP Command Line"
	set "_fileBin=pgp.exe"

	set "_folderKeyPublic=pgpkeys"
	set "%_fileKeyPublicPartner=Partner PGP key_PROD_public.asc"
	set "%_fileKeyPublicSelf=Self_PGP_Keys_Prod_public.asc"

	set "_privateKeyRealID=Self_PGP_Keys_Prod "
	set "_privateKeyType=RSA"
	set "_privateKeySize=2048"
	set "_privateKeyPassphrase=lovejones"

	REM Import Public Key Partner
	"%_folderBin%"\%_fileBin% --import "%_folderKeyPublic%\%_fileKeyPublicPartner%"

	REM List Keys
	"%_folderBin%"\%_fileBin%  --list-keys

	REM Generate Key
	"%_folderBin%"\%_fileBin% --gen-key "%_privateKeyRealID%" --key-type %_privateKeyType% --bits %_privateKeySize% --passphrase %_privateKeyPassphrase%

	REM Export Public Key Self
	"%_folderBin%"\%_fileBin% --export "%_privateKeyRealID%" --output "%_folderKeyPublic%\%_fileKeyPublicSelf%"

endlocal