MongoDB is a cross-platform, document oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on concept of collection and document. Database Database is a physical container for collections. Each database gets its own set of files on the file system. A single MongoDB server typically has multiple databases. Collection A collection…
AWS offers two main options for deploying SQL Server in the cloud – Elastic Compute Cloud and Relational Database Service. I lately read a few blogs and did some searches with both the types of deployment of SQL Server and learnt a few things, in this blog, I am sharing my findings Relational Database Service…
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 of SQL Server 2017, which is the SQL server 2019. This was announced and introduced…
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. That user wanted to do POC of Nimesa Application-aware backup and Point in time recovery…
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 ) the databases from Adventure Works backup file Change the total and volume drive letter in…