Run apt-key Using the apt-key utility we can display all the known keys.apt-key list To quickly find the expired keys, search for “expired:” apt-key list | grep “expired:” Update the key We can now use the key gathered in step…
Changing the individual database recovery model is very simple with the Microsoft SSMS. But recently in one of our Nimesa customer environments, he had 200 databases in a non-production instance and all the databases are in the simple recovery model.…
Failure rate depends more on the number of disk blocks modified since the last snapshot of the EBS volume than the total size of the volume. EBS has a listed failure rate of 0.1% – 0.4% annually, compared to a…
Creating a full backup in the SQL server using SSMS is very simple, but if you have 10’s of databases you find bit difficult to backup all databases in one go. So i write a small Powershell script which gets…
To Disable UAC on the Windows Server, change the registry value EnableLUA to 0, to change it using the powershell Set-Itemproperty -path ‘HKLM:\Software\Microsoft\Windows\CurrentVersion\policies\system’ -Name ‘EnableLUA’ -value 0 Below is the script to change on multiple Windows Machines using RemotePS
We got a support case user created a backup of the Virtual Machines with MS SQL running but he cannot see the databases running on the machine We checked the added credential, it was Windows Active Directory user added to…
While testing our product Nimesa with Microsoft SQL Server 2016 on Microsoft Windows 2019 i hit with some scenarios my nodes in SQL cluster has some shadows, i wanted to check in all the machine and delete the shadows.…
To do some testing of the on going release of Nimesa which do the application aware ( AppAware ) Backup of Microsoft SQL Server Cluster on SQL 2016 i created a small powershell scripts which create ( actually restores )…
PS C:\WINDOWS\system32> Set-ExecutionPolicy RemoteSigned PS C:\WINDOWS\system32> Set-PowerCLIConfiguration -InvalidCertificateAction Ignore PS C:\WINDOWS\system32> Connect-VIServer -Server servername Get-VM -name vignesh-VM-1 | Get-AdvancedSetting -Name ‘disk.EnableUUID’ If that command returns no result or the value is false, you won’t see the disk serial number inside…
