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

Set a static IP Address on Raspberry Pi OS Bookworm

 

Set a static IP Address on Raspberry Pi OS Bookworm

desde https://www.abelectronics.co.uk/kb/article/31/set-a-static-ip-address-on-raspberry-pi-os-bookworm

sudo nmcli c mod "Wired connection 1" ipv4.addresses $IPLOCAL$/24 ipv4.method manual

reinicio IP

sudo nmcli c down "Wired connection 1" && sudo nmcli c up "Wired connection 1"

underclock ryzen 3 5300U

 https://ryzencontroller.com/#downloads

bajar la temperatura y controlar consumo

cambiar tamaño base de datos Azure por sql cmd

#cambiar tamaño base de datos Azure por sql cmd

 ALTER DATABASE AzureDB2 MODIFY (MAXSIZE= 50 GB)