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
T-SQL Books: Performance Tuning Books: Specialized Topics:
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 »
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 »
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
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)
It basically requires cleaning the value of PendingFileRenameOperations (replacing the multi-string value with an empty string) under the registry key
To run an SSIS package with specific permissions, you can create a service account and configure the package to inherit the run as account. This way, developers won’t need to know the password. However, proxies can also be used for any SQL job step, not just SSIS packages. To create a new proxy, follow these… Leer más »
https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/create-a-database-mail-profile?view=sql-server-ver16
To assign permissions to a schema in SQL Server, you must first create a security role and assign permissions to the role. Then, assign the role to the desired user or group of users. Here is an example of code to assign SELECT permissions to a «test_schema» schema: sqlCopy code– Create a security role CREATE… Leer más »