Sunday, November 12, 2023

underclock ryzen 3 5300U

 https://ryzencontroller.com/#downloads


bajar la temperatura y controlar consumo

Tuesday, October 17, 2023

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)

Friday, August 25, 2023

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


Monday, July 31, 2023

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 

Wednesday, July 26, 2023

Ubuntu cargar teclado en español

ubuntu cargar teclado en español

 setxkbmap es

Thursday, June 1, 2023

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

Tuesday, May 23, 2023

SharePoint Designer 2013 Crash after install office 2021

 


https://social.msdn.microsoft.com/Forums/en-US/12a06282-e1a6-4ba2-aa30-b13b87b5d56a/sharepoint-designer-2013-continues-to-crash-in-quotfirst-things-firstquot-tab?forum=sharepointcustomization


The below steps worked for me, however my 'first things first' prompt only showed the licence agreement.

Open regedit.

Create Key:
Computer\HKEY_CURRENT_USER\Software\Policies\Microsoft\office\15.0\common\general

Add DWORD with value 1:
• OptInDisable
• shownfirstrunoptin

Create Key:
Computer\HKEY_CURRENT_USER\Software\Policies\Microsoft\office\15.0\Registration

Add DWORD with value 1:
AcceptAllEulas

I could then launch SharePoint Designer 2013 without the prompt, and it didn't crash.


otra opcion con windows 11

Equipo\HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\General