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…

May 2, 2019 Vignesh Sathiyanantham

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 the list of databases and takes the backup except the system databases https://gist.github.com/asvignesh/9c2f275c9418b038022ceffa94ba2152 Run the script with Server name and the backup directory as parameters .\BackupAllDatabases.ps1 -serverName NW\CLUST -backupDirectory c:\backupdir

April 20, 2019 Vignesh Sathiyanantham

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 https://gist.github.com/asvignesh/ae5a1ad1cf036f2481ef26f67816242d

April 19, 2019 Vignesh Sathiyanantham

  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. What i did is, i wrote a small powershell script which connects to all the nodes in my test bed and run diskshadow command  delete shadows all  For that, First i need to enable the PowerShell Remoting on all the nodes ( My nodes are connected to active directory and all are part of Windows Failover clustering ) Enable-PSRemoting -Force…

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…

April 10, 2019 Vignesh Sathiyanantham

Copy and Paste the following command to install this package using PowerShellGet Install-Module -Name VMware.PowerCLI If you are getting any error related to the privilege PS C:\Users\asvig> Install-Module -Name VMware.PowerCLI Install-Module : Administrator rights are required to install modules in ‘C:\Program Files\WindowsPowerShell\Modules’. Log on to the computer with an account that has Administrator rights, and then try again, or install Run with adding -Scope CurrentUser Install-Module -Name VMware.PowerCLI -Scope CurrentUser

January 2, 2019 Vignesh Sathiyanantham

Deploying a virtual machine from a template is an easy task but cloning a virtual machine will maintain its computer name, serial number and the license information and deploying multiple Virtual machines for dev test is also a painful job We can achieve it more easily using vSphere powercli, modify the below script according to your lab details and run it Change the vCenter HostCredentials ( username and password )Number of VM to deployFrom which template you want to create a cloneOS Custom specificationTo which datastore you want to clone the virtual machinesTo which ESXi node you want to attach…

May 10, 2018 Vignesh Sathiyanantham

With vSphere 6.7 web services SOAP API  includes the creation date of a Virtual Machine and will be persisted with the life-cycle of the VM itself. You can get it from Virtual Machine -> Config -> createDate. Earlier to 6.7, we can track the VM Creation Time using EventManager. We should create an EventFilterSpec to filter the events by Virtual Machine creation or deployed, Registered or Cloned Events. new String[]{“VmCreatedEvent”, “VmBeingDeployedEvent”, “VmRegisteredEvent”, “VmClonedEvent”} Get Virtual Machine Creation Time earlier to vSphere 6.7 Java https://gist.github.com/asvignesh/fd97f4cbc41ac55e5b289c3424c0f09a vSphere Power CLI https://gist.github.com/asvignesh/327169f8456bbd613eebfad3d9768fa8

April 10, 2018 Vignesh Sathiyanantham

To fetch the querystring parameters in Controller we usually use request().queryString() Map<String, String[]> queryString = request().queryString(); If we have multiple query-string keys and want to use a POJO to use query-string instead of parsing everything in Controller we can use QueryStringBindable If you have take a look in your project you will see just simple parameters as argument ( Path argument ) in your GET method controller, In order to use Java POJO as input for query string i implements QueryStringBindable<T> in my POJO Here is my sample POJO and my controller method https://gist.github.com/asvignesh/911ff1b6dd4b96a5368e9d113a6591d0 Added a entry in routes, GET…

January 28, 2018 Vignesh Sathiyanantham 29Comment

AWS Lambda lets you run code without provisioning or managing servers. You pay only for the compute time you consume – there is no charge when your code is not running. With Lambda, you can run code for virtually any type of application or backend service – all with zero administration. Just upload your code and Lambda takes care of everything required to run and scale your code with high availability. You can set up your code to automatically trigger from other AWS services or call it directly from any web or mobile app. In my last post, i wrote…