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)

actualizar Raspberry desde buster a bullseye

Actualizar Raspberry desde buster a bullseye

lsb_release -a

sudo apt update

sudo apt dist-upgrade -y

sudo rpi-update

sudo nano /etc/apt/sources.list

#cambiar donde dice buster por bullseye

sudo apt update && sudo apt upgrade -y

sudo apt autoclean

How to drop a SQL Server user with db owner privilege

The error

The database principal owns a schema in the database, and cannot be dropped.

Query to identify users:

SELECT s.name

FROM sys.schemas s

WHERE s.principal_id = USER_ID('user');

Query Executed

ALTER AUTHORIZATION ON SCHEMA::db_owner TO dbo;

ALTER AUTHORIZATION ON SCHEMA::db_datareader TO dbo;

ALTER AUTHORIZATION ON SCHEMA::db_datawriter TO dbo;

finally

drop user usertobeDeleted

based https://stackoverflow.com/questions/35434389/how-to-drop-a-sql-server-user-with-db-owner-privilege 

Ubuntu cargar teclado en español

ubuntu cargar teclado en español

 setxkbmap es

Error HRESULT E_FAIL has been returned from a call to a COM component vs 2019

 Error HRESULT E_FAIL has been returned from a call to a COM component vs 2019

basado en :

https://developercommunity.visualstudio.com/t/add-a-reference-raise-error-error-hresult-e-fail-h/260196

la solucion

C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools\x64\gacutil.exe /i "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\PublicAssemblies\Microsoft.VisualStudio.Shell.Interop.11.0.dll"

posterior a eso reiniciar el DevEnv.exe y listo