Tuesday, December 5, 2023
Set a static IP Address on Raspberry Pi OS Bookworm
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');
Wednesday, July 26, 2023
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
Thursday, March 2, 2023
How to Check the .NET Framework Version with PowerShell? - how to see max net framework installed
how to see max net framework installed
Get-ChildItem ‘HKLM:\SOFTWARE\Microsoft\NET Framework Setup\NDP’ -Recurse | Get-ItemProperty -Name version -EA 0 | Where { $_.PSChildName -Match ‘^(?!S)\p{L}’} | Select PSChildName, version
Monday, January 2, 2023
Pi-Hole Docket rpi4
https://pi-hole.net/
https://github.com/pi-hole/docker-pi-hole/#running-pi-hole-docker
sudo apt install docker
sudo apt install docker-compose
create este sh
#!/bin/bash | |
# https://github.com/pi-hole/docker-pi-hole/blob/master/README.md | |
PIHOLE_BASE="${PIHOLE_BASE:-$(pwd)}" | |
[[ -d "$PIHOLE_BASE" ]] || mkdir -p "$PIHOLE_BASE" || { echo "Couldn't create storage directory: $PIHOLE_BASE"; exit 1; } | |
# Note: FTLCONF_LOCAL_IPV4 should be replaced with your external ip. | |
docker run -d \ | |
--name pihole \ | |
-p 53:53/tcp -p 53:53/udp \ | |
-p 80:80 \ | |
-e TZ="America/Chicago" \ | |
-v "${PIHOLE_BASE}/etc-pihole:/etc/pihole" \ | |
-v "${PIHOLE_BASE}/etc-dnsmasq.d:/etc/dnsmasq.d" \ | |
--dns=127.0.0.1 --dns=1.1.1.1 \ | |
--restart=unless-stopped \ | |
--hostname pi.hole \ | |
-e VIRTUAL_HOST="pi.hole" \ | |
-e PROXY_LOCATION="pi.hole" \ | |
-e FTLCONF_LOCAL_IPV4="127.0.0.1" \ | |
pihole/pihole:latest | |
printf 'Starting up pihole container ' | |
for i in $(seq 1 20); do | |
if [ "$(docker inspect -f "{{.State.Health.Status}}" pihole)" == "healthy" ] ; then | |
printf ' OK' | |
echo -e "\n$(docker logs pihole 2> /dev/null | grep 'password:') for your pi-hole: http://${IP}/admin/" | |
exit 0 | |
else | |
sleep 3 | |
printf '.' | |
fi | |
if [ $i -eq 20 ] ; then | |
echo -e "\nTimed out waiting for Pi-hole start, consult your container logs for more info (\`docker logs pihole\`)" | |
exit 1 | |
fi | |
done; |
XRDP is not working
Based on
https://forums.raspberrypi.com/viewtopic.php?t=323471
Re: bullseye: xrdp not working for user "pi"
https://github.com/neutrinolabs/xrdp/issues/2060
Modify /etc/X11/xrdp/xorg.conf to use xrdp normally
sudo nano /etc/X11/xrdp/xorg.conf
and comment
#Option "DRMDevice" "/dev/dri/renderD128"
Option "DRMDevice" ""
ademas agregar esto al final para que ande mas rapido el xrdp
Section "Extensions"
Option "Composite" "Disable"
EndSection