After the availability of SQL Server 2019 and Windows Server 2019, I decided to play around with that in my lab. Microsoft, owing to the new demands and other technological advancements in the software industry, has released the upgraded version…
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.…
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…