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…

October 30, 2019 Vignesh Sathiyanantham

Microsoft SQL Server is one of the most popular enterprise database, a lot of enterprises run MS SQL Server for their mission-critical applications SQL Server database management engine is fast and stable, available on both Linux and Windows platforms and can work on cloud-based servers and local servers simultaneously. It’s owned by Microsoft and is ideal for companies that work with a range of Microsoft products as it works well with many of them. It’s market share increased fast because Microsoft pushed SQL Server with their Windows Servers and also included AI over Azure. SQL Server also has some great…

September 17, 2019 Vignesh Sathiyanantham

In today’s data center industry there is a misconception about the storage snapshot as a Backup. The main one is storage snapshots are not backup, they are just point-in-time copies. It’s unclear from where the idea came from. Backup is a collection of data stored on (usually removable) non-volatile storage media for purposes of recovery in case the original copy of data is lost or becomes inaccessible; also called a backup copy. To be useful for recovery, a backup must be made by copying the source data image when it is in a consistent state. – The SNIA ( Storage…

August 18, 2019 Vignesh Sathiyanantham

In my previous blog, I discussed how to set up the ZFS File system in Ubuntu 18.04 and setup ZVOL for Microsoft SQL Server Databases In this post let’s discuss on how to set up the Disaster recovery plan for the Microsoft SQL Database with the ZFS replication, For that, I set up the Ubuntu 18.04 Instance in us-east-1 in availability zone us-east-1c , and ssh into the instance using the pem file Then I followed my post on ZVOL for MS SQL Database to install the ZFS on the AWS Linux Instance And then with the new volume, I…

December 25, 2018 Vignesh Sathiyanantham

Storage capacity consumed by multiple unnecessary data copies costs businesses as much as $44 billion annually, according to IDC. It estimates that redundant copies of the same data ( copy data) account for more than 60% of enterprise disk storage capacity. The redundant copies are compounded by rational practices intended to protect the business with multiple separate copies of production data like full backups, disaster recovery copy, test and dev, data analytics All the extra storage comes at a cost, data storage isn’t cheap, businesses have to waste more money on unnecessary storage expenses. There are many Copy Data management…