You have defined a share on a remote server, and you cannot authorize the SQL Server service account on that share. You just have …
Read More »dbtut
How To Transfer a Database in the File System To ASM
This article describes how to move a database in the file system into ASM. First, Grid Infrastructure installation is required. We are creating two …
Read More »How To Restore Encrypted Backup To Another Instance On SQL Server
First you should restore your certificate to this instance. You can restore your certificate with the help of following script. You must write the …
Read More »Encrypted Backup On SQL Server
You can encrypt your backups with SQL Server’s own encryption method in order to avoid the risk of unauthorized access to the backup. You …
Read More »The Select permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’
When you see an error, such as in the following screenshot, you may consider why your database is trying to access a hidden system …
Read More »How To Install utl_mail and Configure smtp
You need the utl_mail package to send e-mail from the database. To use this package, the smtp_out_server parameter must be set. Also, “network acl” …
Read More »How To Split SQL Server Backup Files To Different Disks
If you are not using any backup software, you may not be able to back up large databases to a single disk. In such …
Read More »How To Detect Queries That Do Not Use Bind Variable
For the database, the use of bind variables in queries is quite important. The hard parsing process in the database will increase when bind …
Read More »How To Backup All Databases On an Instance On SQL Server
You can backup all databases on an Instance with the help of the following script (except tempdb) You should write the path you want …
Read More »Automatic Killing of Sniped Sessions
When you set the resource_limit parameter to true in the database and set the idle_time parameter in the profiles to a value other than …
Read More »