lector de pgp files

 https://gpg4win.org/thanks-for-download.html

Crear llaves PGP publica y Privada

fue validado en ubuntu server y funciona sin problema :D 

#primero

gpg --full-generate-key

#para la llave publica

gpg --export -a --output Public_Key.asc tu correo

#para la llave privada acá te pide clave

gpg -a --export-secret-keys > private_secret_key.asc 

basado en https://docs.github.com/es/authentication/managing-commit-signature-verification/generating-a-new-gpg-key?platform=linux

https://unix.stackexchange.com/questions/481939/how-to-export-a-gpg-private-key-and-public-key-to-a-file

IP server desde SQL command

https://stackoverflow.com/questions/142142/sql-query-to-get-servers-ip-address

select @@version

SELECT  

   CONNECTIONPROPERTY('net_transport') AS net_transport,

   CONNECTIONPROPERTY('protocol_type') AS protocol_type,

   CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,

   CONNECTIONPROPERTY('local_net_address') AS local_net_address,

   CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,

   CONNECTIONPROPERTY('client_net_address') AS client_net_address 

Output

net_transport protocol_type auth_scheme local_net_address local_tcp_port

TCP                         TSQL     SQL         10.10.89.21         1433

Espacio utilizado por la tablas en SQL Server - table space already used into SQL server or TSQL

Query para conocer el detalle de espacio utilizado por las tablas

 SELECT 

t.NAME AS Tabla,

s.Name AS Esquema,

p.rows AS NumeroDeFilas,

CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalEspacio_MB,

CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS EspacioUtilizado_MB, 

CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS EspacioNoUtilizado_MB

FROM

sys.tables t

INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id

INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id

INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id

LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id

GROUP BY t.Name, s.Name, p.Rows

ORDER BY TotalEspacio_MB desc

post de : https://es.stackoverflow.com/questions/315885/espacio-utilizado-por-la-tablas-en-sql-server