November 3, 2019 Vignesh Sathiyanantham

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 AWS RDS offered a Database as a Service (DaaS). It removed the complete complexity of installing, configuring the database. All instance options exposed by AWS are configured on the RDS dashboard. Options such as license model, port number, domain membership, authentication mode, backup settings etc….

November 3, 2019 Vignesh Sathiyanantham

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 in the Ignite 2018 event, on September 24th. However, this was just a preview edition. A more technically advanced and detail picture of SQL Server 2019, was submitted only in the PASS Summit, which happened later in November, in the same year. The newer version…

May 9, 2019 Vignesh Sathiyanantham

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 for MS SQL database server, Log backups are not possible with the simple recovery model, so I executed a small PowerShell script which changes all the databases to the FULL recovery model from the simple recovery model Get-SqlDatabase -ServerInstance NW1\CLUST2 The above Powershell command gets…

April 12, 2019 Vignesh Sathiyanantham

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 the below code and run it. If you want to have Data files (.mdf ) and Log Files (.ldf) in the same volume, set the volume1 and volume2 with same value If you want to create data and log files on different volume, set different…