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

>

Gpg4Win

Background

Within the prism of intra and inter business communication there are needs for securing files transmission.

What is?

GNU Privacy Guard
Link

GnuPG

GnuPG is a complete and free implementation of the OpenPGP standard as defined by RFC4880 (also known as PGP). GnuPG allows you to encrypt and sign your data and communications; it features a versatile key management system, along with access modules for all kinds of public key directories. GnuPG, also known as GPG, is a command line tool with features for easy integration with other applications. A wealth of frontend applications and libraries are available. GnuPG also provides support for S/MIME and Secure Shell (ssh). ( Link )

Gpg4Win

Gpg4win is a Windows version of GnuPG featuring a context menu tool, a crypto manager, and an Outlook plugin to send and receive standard PGP/MIME mails.

The current version of Gpg4win is 3.1.5. ( Link )

Artifacts

Download artifact listing is available here.

Operating System

MS Windows

Our targeted OS is MS Windows and the installation package is available here.

Download

Downloaded the artifacts.

Installation

Outline

  1. Steps
    • Installer Language
    • Welcome
    • Choose Components
      • Added GPA
    • Choose Install Location
    • Installing
    • Installation Complete
    • Completing Wizard

 

Images

Installer Language

installerLanguage.20190211.1125AM.PNG

Welcome

welcome.20190211.1126AM.PNG

Choose Components

Choose Components – Default

chooseComponents.20190211.1127AM.PNG

Choose Components – Revised

chooseComponents.02.20190211.1128AM.PNG

Choose Components – Choose Install Location

chooseInstallLocation.02.20190211.1129AM.PNG

Choose Components – Installing

installing.20190211.1128AM.PNG

Installation Complete

installationComplete.20190211.1129AM.PNG

Completing Wizard

completingWizard.20190211.1130AM.PNG

Post Installation Review

Installed Apps

Review Installed Apps

  1. GUI Applications
    • GNU Private Assistant – Key Manager

 

 

Australian Druglords

Profile

  • Drug Lords is a series that blows the lid off Australia’s biggest-ever Class A Drug Busts. With exclusive, no-holds-barred and unprecedented access to the NSW Police Drug Squad’s criminal archive, Drug Lords provides a pacy inside view of key kingpin takedowns over the past five years. With actual surveillance footage, covert listening devices, secret phone taps and more.

 

Videos

  1. Drug Lords – Charlotte Lindstrom
    • Profile
    • Listing
      • AUSTRALIAN DRUGLORDS S1 • E10
    •  Participants
      • Stephen
      • Charlotte Lindstrom
      • Justice Stephen Rothman
    • Videos
      • Video #1
        Channel :- Reel Truth Crime – True Crime
        Published On :- 2018-June-29th
        Link
    • Quotes
      • Justice Stephen Rothman
        • Romanticize the relationship with her boyfriend
  2. Drug Lords – Nathan and Drew Baggaley
    • Profile
      • In this episode of Drug Lords, Nathan and Drew Baggaley, Nathan an Australian olympic hero and his younger brother Drew, another emerging rugby player, are exposed as underground drug lords.
    • Listing
      • AUSTRALIAN DRUGLORDS S1 • E2
    •  Participants
      • Nathan Baggaley
      • Drew Baggaley
    • Videos
      • Video #1
        Channel :- Reel Truth Crime – True Crime
        Published On :- 2018-June-15th
        Link
  3. Drug Lords – Richard Buttrose
    • Profile
      • Notorious drug dealer Richard Buttrose has fed the drug habits of actors and celebrities alike.
    • Listing
      • AUSTRALIAN DRUGLORDS S1 • E1
    •  Participants
      • Richard Buttrose
    • Videos
      • Video #1
        Channel :- Reel Truth Crime – True Crime
        Published On :- 2018-June-13th
        Link
  4. Drug Lords – Shayne Hatfield
    • Profile
      • This episode of Drug Lords focuses on Shane Hatfield, a former international surf champion, and an undercover notorious drug lord.
    • Listing
      • AUSTRALIAN DRUGLORDS S1 • E5
    •  Participants
      • Shayne Hatfield
    • Videos
      • Drug Lords – Shayne Hatfield | Full Documentary | True Crime
        Channel :- Reel Truth Crime – True Crime
        Published On :- 2018-June-10th
        Link
  5. Drug Lords – Samir Rafahi
    • Profile
      • Samir Rafahi doesn’t just sell drugs he steals them.
    • Listing
      • AUSTRALIAN DRUGLORDS S1 • E7
    •  Participants
      • Samir Rafahi ( Simon Raha )
      • Ghassan Khodr
    • Videos
      • Drug Lords – Samir Rafahi | Full Documentary | True Crime
        Channel :- Reel Truth Crime – True Crime
        Published On :- 2018-June-27th
        Link
  6. Drug Lords – Duc and Van Dang | Full Documentary | True Crime
    • Profile
      • Drug Lords – Duc and Van Dang | Full Documentary | True Crime
    • Listing
      • AUSTRALIAN DRUGLORDS S1 • E9
    •  Participants
      • Duc Dang
      • Van Dang
    • Videos
      • Drug Lords – Duc and Van Dang | Full Documentary | True Crime
        Channel :- Reel Truth Crime – True Crime
        Published On :- 2018-June-24th
        Link
    • Drug
      • Cocaine
      • Cannabis
  7. Drug Lords – John Griffiths
    • Profile
      • John Griffiths, a 70 year old former chemist is an unlikely drug dealer – acquitted of drug matters before, Australia’s best criminal investigators are on his tail.
    • Listing
      • AUSTRALIAN DRUGLORDS S1 • E8
    •  Participants
      • John Griffiths
      • Phillip Dodd
    • Videos
      • Drug Lords – John Griffiths | Full Documentary | True Crime
        Channel :- Reel Truth Crime – True Crime
        Published On :- 2018-June-22nd
        Link
    • Drug
      • PMA

 

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