Ad hoc useful querries (SQL Server)

SELECT
        SERVERPROPERTY('MachineName') as Host,
        SERVERPROPERTY('InstanceName') as Instance,
        SUBSTRING(@@VERSION, 1,25) as Version,
        SERVERPROPERTY('Edition') as Edition, /*shows 32 bit or 64 bit*/
        SERVERPROPERTY('ProductVersion') AS 'Patch Level',
        SERVERPROPERTY('ProductLevel') as SP, /* RTM or SP1 etc*/
        Case SERVERPROPERTY('IsClustered')
        when 1     then 'CLUSTERED' else
                  'STANDALONE' end as ServerType

My MoSCoW education 2017

Must have:
1) Install VirtualBox - Jan
2) Install Oracle12c  - Jan
3) Clusterware & RAC - Jan-Feb
4) New Features Ora 12c - Jan-Feb
5) OEM Cloud Control - March
6) Performance labs - April
7) MSSQL AlwaysOn lab - May

Should have:
1) Postgresql install - Jan
2) RHEL 7 new features - Sept

Links:
1) Обучающие курсы, видео и учебники по Visio 2013

https://support.office.com/ru-ru/article/%D0%9E%D0%B1%D1%83%D1%87%D0%B0%D1%8E%D1%89%D0%B8%D0%B5-%D0%BA%D1%83%D1%80%D1%81%D1%8B-%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-%D0%B8-%D1%83%D1%87%D0%B5%D0%B1%D0%BD%D0%B8%D0%BA%D0%B8-%D0%BF%D0%BE-Visio-2013-93e93e94-0899-4530-aebb-c70fd39faee5

2) Updating your Database Management Skills to SQL Server 2014

 https://mva.microsoft.com/en-us/training-courses/updating-your-database-management-skills-to-sql-server-2014-8313?l=S3j693Yy_704984382  

If you change password of Oracle USER1 wrongly

Go to the previous backup or copy of database and select user's password hash

SQL> SELECT name, password  FROM sys.user$ WHERE name='USER1';

NAME
--------------------------------------------------------------------------------
PASSWORD
--------------------------------------------------------------------------------
USER1
48F7196FF1A87215

On the problem DB change password by issue:

SQL> alter user USER1 identified by values '48F7196FF1A87215';

User altered.