SQL top 10 largest tables

Query returns TOP 10 largest db tables

  

select top 10 schema_name(tab.schema_id) + '.' + tab.name as [table],

    cast(sum(spc.used_pages * 8)/1024.00 as numeric(36, 2)) as used_mb,

    cast(sum(spc.total_pages * 8)/1024.00 as numeric(36, 2)) as allocated_mb

from sys.tables tab

    inner join sys.indexes ind 

        on tab.object_id = ind.object_id

    inner join sys.partitions part 

        on ind.object_id = part.object_id and ind.index_id = part.index_id

    inner join sys.allocation_units spc

        on part.partition_id = spc.container_id

group by schema_name(tab.schema_id) + '.' + tab.name

order by sum(spc.used_pages) desc

Check GPO polices status by categories

 Run in DC admin console command:

auditpol /get /category:*

Exceeded the Maximum Number of Computer Accounts Allowed to Create in this Domain

 It happens because of default AD ms-DS-MachineAccountQuota value which is 10.

The workaround is to delegate custom rights for specific account:

1. Open the Active Directory Users and Computers snap-in.

2. Right-click the container under which you want the computers added, and press Delegate Control.

3. Press Next.

4. Press Add.

5. After adding all the users and/or groups, press Next.

6. Select Create custom task to delegate and press Next.

7. Select Only the following objects in the folder, check Computer objects, check the Create selected objects in this folder box, and press Next.

8. Check the Create all child object box and press Next.

9. Press Finish.

 Source: community.spiceworks.com

Show old Procurve LLDP

 In CLI use command: show lldp info remote-device

Reset MySQL root password on Windows

Stop MySQL service
Give user full access to /data folder

Command line:

mysqld --skip-grant-tables
mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') where USER='root'; 

mysql> FLUSH PRIVILEGES;

HPE advanced CLI

_cmdline-mode on

1910 password: 512900

1920 password: Jinhua1920unauthorized

Delete windows recovery partitions

Run PowerShell as admin
Run DISKPART.

Find disk ID:
DISKPART> list disk

Select disk you want to modify:
DISKPART> select disk 1

Find partition ID:
DISKPART> list partition

Select partition you want to delete:
DISKPART> select partition 5

Delete selected partition:
DISKPART> delete partition override
DISKPART> exit

Source: www.lifewire.com