Archivo de la categoría: Windows
Linux last equivalent for windows: last logged in user on a Windows PC
last logged in user on a Windows PC
How to run Microsoft SQL on Apple silicon Macs using Docker Desktop
docker pull mcr.microsoft.com/mssql/server:2022-latest docker run -e «ACCEPT_EULA=Y» -e «MSSQL_SA_PASSWORD=VeryStr0ngP@ssw0rd» \ -p 1433:1433 –name sql1 –hostname sql1 \ –platform linux/amd64 \ -v /Users/mymacuser/sqlserver:/var/opt/mssql \ -d \ mcr.microsoft.com/mssql/server:2022-latest
Recommended SQL server books
T-SQL Books: Performance Tuning Books: Specialized Topics:
How to monitor encryption or decryption Progress. SQL Server
SELECT DB_NAME(database_id) AS DatabaseName, encryption_state, encryption_state_desc = CASE encryption_state WHEN ‘0’ THEN ‘No database encryption key present, no encryption’ WHEN ‘1’ THEN ‘Unencrypted’ WHEN ‘2’ THEN ‘Encryption in progress’ WHEN ‘3’ THEN ‘Encrypted’ WHEN ‘4’ THEN ‘Key change in progress’ WHEN ‘5’ THEN ‘Decryption in progress’ WHEN ‘6’ THEN ‘Protection change in progress (The certificate… Leer más »
Remove Transparent Data Encryption (TDE) from SQL Server user databases
Transparent Data Encryption is getting popular these days because every business owner is serious about protecting their data. Everybody wants to use the latest encryption technologies to make sure their systems are more secure and stable. SQL Server also offers some encryption features to protect client’s data like TDE (Transparent Data Encryption), Always Encrypt, etc. Sometimes, business wants… Leer más »
buscarv excel
** NOTA IMPORTANTE: SELECCIONAR LA MATRIZ COMPLETA INCLUYENDO TODAS LAS COLUMNAS QUE SE DESEEN REFERENCIAR, DE LO CONTRARIO MARCA ERROR DE !REF, ES DECIR POR EJEMPLO DE LA $A1 HASTA LA $E99 ** Lo básico: Cotiza ahora cursos Ninja Excel para tu empresa Paso 1: Entendiendo la función BUSCARV BUSCARV encuentra datos hacia la derecha… Leer más »
SSIS Package Excel file could not be saved.
Error: HRESULT: 0x800A03EC E To solve this create a folder Create a folder called «Desktop» in «C:\Windows\System32\config\systemprofile\» and It should work This issue can be resolved by adding a Desktop folder to the following directories: https://documentation.solarwinds.com/en/success_center/taskfactory/content/excel.htm
Stuck on «Let’s connect to a network» setup page windows 11
Open cmd (shift + f10). Type this command, oobe\bypassnro It will reboot, then you can continue without internet.
master key in the database error SSISDB
Please create a master key in the database or open the master key in the session before performing this operation. (Microsoft SQL Server, Error: 15581)