Change the server name of the SQL Server Instance
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,338 reads
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,338 reads
Below script will remove database encryption key, database certificate and master key on all the user databases.
For tempdb database, you need to restart the SQL Server Instance to complete the process.
Note: It is advisable to take transaction log backup before this activity is performed.
2018-02-08 (first published: 2018-01-29)
2,248 reads
2017-05-25 (first published: 2017-05-15)
1,684 reads
2017-03-30 (first published: 2017-03-16)
14,242 reads
The script below executes on the first of every month and moves files from source to destination location.
2014-07-24 (first published: 2014-06-16)
977 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Telp/WA 628217555651 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Telp/WA 62817825533 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers