Archivo de la categoría: SQL Server

Bitacora de SQL Server

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

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 »

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