The latest articles on DEV Community by Ganesh Chandrasekaran (@gchandra). https://dev.to/gchandra https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F445443%2Fd02d2aaa-eb3c-46bb-bbf7-91cc6444066c.jpg https://dev.to/gchandra en Ganesh Chandrasekaran Mon, 05 Oct 2020 11:22:39 +0000 https://dev.to/gchandra/upgrade-visual-studio-code-on-linux-ib0 https://dev.to/gchandra/upgrade-visual-studio-code-on-linux-ib0 <p>VS Code is a great IDE with new features released every other week. Its advisable to keep up with the updates.</p> <p><a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fb6j6181edh8kqp6wv4x9.jpeg" class="article-body-image-wrapper"><img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fi%2Fb6j6181edh8kqp6wv4x9.jpeg" alt="Alt Text"></a></p> <p>If you are using Windows / Mac VS Code is smart enough to update itself on click of a button.</p> <p>For Linux (debian/ubuntu) users Upgrading VS Code is a two step process.</p> <p><strong>Step 1 : Download .deb file to you local folder (~/Downloads)</strong></p> <p>code.visualstudio.com</p> <p>Step 2 : Open Terminal<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ cd ~/Downloads $ sudo dpkg -i code_1.filename_amd64.deb </code></pre> </div> <p>Example latest version as of today is<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ dpkg -i code_1.49.3-1601661857_amd64.deb </code></pre> </div> <p><strong>If you are using RHEL / CENTOS</strong><br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ sudo dnf install &lt;file&gt;.rpm </code></pre> </div> <p><strong>For upgrade</strong><br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>sudo rpm -U &lt;file&gt;.rpm </code></pre> </div> vscode ubuntu debian Ganesh Chandrasekaran Mon, 05 Oct 2020 11:12:04 +0000 https://dev.to/gchandra/how-to-sort-tuples-in-python-11bk https://dev.to/gchandra/how-to-sort-tuples-in-python-11bk <p>Tuples are immutable, but there is a simple way to sort them.</p> <p>Convert the Tuple to List by using sorted function<br> then cast the List to Tuple.</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--xL_YdG8q--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/i/7wy8fz6a40gskuzqn0pb.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--xL_YdG8q--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/i/7wy8fz6a40gskuzqn0pb.png" alt="Alt Text" width="608" height="564"></a></p> <p>Source : with lambda examples</p> <div class="ltag__link"> <a href="https://medium.com/@gchandra/how-to-sort-tuples-in-python-9ace22a06893" class="ltag__link__link"> <div class="ltag__link__pic"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7zemOvq4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://miro.medium.com/fit/c/96/96/1%2Aix86Zu6tIb3l7qklfr3KeA.png" alt="Ganesh Chandrasekaran"> </div> </a> <a href="https://medium.com/@gchandra/how-to-sort-tuples-in-python-9ace22a06893" class="ltag__link__link"> <div class="ltag__link__content"> <h2>How to sort tuples in Python ?. Tuples are immutable, but there is a… | by Ganesh Chandrasekaran | Medium</h2> <h3>Ganesh Chandrasekaran ・ <time>Oct 3, 2020</time> ・ <div class="ltag__link__servicename"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--hnDHPsJs--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/medium-f709f79cf29704f9f4c2a83f950b2964e95007a3e311b77f686915c71574fef2.svg" alt="Medium Logo"> Medium </div> </h3> </div> </a> </div> python tuples Ganesh Chandrasekaran Tue, 08 Sep 2020 01:59:40 +0000 https://dev.to/gchandra/how-to-find-sql-server-database-restore-and-recovery-time-1ihh https://dev.to/gchandra/how-to-find-sql-server-database-restore-and-recovery-time-1ihh <p>Easy to way to determine Restore and Recovery time.</p> <p>Simple query to find out SQL Server Database restore time and percentage of completion.<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code> SELECT percent_complete as percentageComplete ,estimated_completion_time/60000 as timeToComplete ,status FROM sys.dm_exec_requests WHERE command like '%restore%' </code></pre> </div> <p>Simple query to find out SQL Server Database recovery time and percentage of completion.<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code> SELECT percent_complete as percentageComplete ,estimated_completion_time/60000 as timeToComplete ,status FROM sys.dm_exec_requests WHERE command like '%recovery%' </code></pre> </div> <p>Source : </p> <div class="ltag__link"> <a href="https://medium.com/@gchandra/how-to-find-sql-server-database-restore-and-recovery-time-dffde87d4631" class="ltag__link__link"> <div class="ltag__link__pic"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7zemOvq4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://miro.medium.com/fit/c/96/96/1%2Aix86Zu6tIb3l7qklfr3KeA.png" alt="Ganesh Chandrasekaran"> </div> </a> <a href="https://medium.com/@gchandra/how-to-find-sql-server-database-restore-and-recovery-time-dffde87d4631" class="ltag__link__link"> <div class="ltag__link__content"> <h2>How to find SQL Server database Restore and Recovery time ? | by Ganesh Chandrasekaran | Medium</h2> <h3>Ganesh Chandrasekaran ・ <time>Sep 8, 2020</time> ・ <div class="ltag__link__servicename"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--hnDHPsJs--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/medium-f709f79cf29704f9f4c2a83f950b2964e95007a3e311b77f686915c71574fef2.svg" alt="Medium Logo"> Medium </div> </h3> </div> </a> </div> sql database Ganesh Chandrasekaran Sun, 06 Sep 2020 03:25:41 +0000 https://dev.to/gchandra/how-to-fix-ssis-test-connection-failed-ssl-provider-3a4n https://dev.to/gchandra/how-to-fix-ssis-test-connection-failed-ssl-provider-3a4n <div class="ltag__link"> <a href="https://medium.com/@gchandra/ssis-test-connection-failed-ssl-provider-40009429b012" class="ltag__link__link"> <div class="ltag__link__pic"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7zemOvq4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://miro.medium.com/fit/c/96/96/1%2Aix86Zu6tIb3l7qklfr3KeA.png" alt="Ganesh Chandrasekaran"> </div> </a> <a href="https://medium.com/@gchandra/ssis-test-connection-failed-ssl-provider-40009429b012" class="ltag__link__link"> <div class="ltag__link__content"> <h2>SSIS — Test connection failed SSL Provider | by Ganesh Chandrasekaran | Medium</h2> <h3>Ganesh Chandrasekaran ・ <time>Sep 6, 2020</time> ・ <div class="ltag__link__servicename"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--hnDHPsJs--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/medium-f709f79cf29704f9f4c2a83f950b2964e95007a3e311b77f686915c71574fef2.svg" alt="Medium Logo"> Medium </div> </h3> </div> </a> </div> ssis ssdt database tls Ganesh Chandrasekaran Sun, 06 Sep 2020 01:06:42 +0000 https://dev.to/gchandra/easy-way-select-the-right-column-as-primary-key-for-a-given-table-496p https://dev.to/gchandra/easy-way-select-the-right-column-as-primary-key-for-a-given-table-496p <div class="ltag__link"> <a href="https://medium.com/analytics-vidhya/easy-way-select-the-right-primary-key-for-a-given-table-f87ae1aae048" class="ltag__link__link"> <div class="ltag__link__pic"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7zemOvq4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://miro.medium.com/fit/c/96/96/1%2Aix86Zu6tIb3l7qklfr3KeA.png" alt="Ganesh Chandrasekaran"> </div> </a> <a href="https://medium.com/analytics-vidhya/easy-way-select-the-right-primary-key-for-a-given-table-f87ae1aae048" class="ltag__link__link"> <div class="ltag__link__content"> <h2>Easy way select the right column as Primary Key for a given table | by Ganesh Chandrasekaran | Analytics Vidhya | Medium</h2> <h3>Ganesh Chandrasekaran ・ <time>Apr 19, 2020</time> ・ <div class="ltag__link__servicename"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--hnDHPsJs--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/medium-f709f79cf29704f9f4c2a83f950b2964e95007a3e311b77f686915c71574fef2.svg" alt="Medium Logo"> Medium </div> </h3> </div> </a> </div> database mysql sqlserver keys Ganesh Chandrasekaran Sun, 06 Sep 2020 01:02:10 +0000 https://dev.to/gchandra/install-libreoffice-7-in-1-minute-3b8 https://dev.to/gchandra/install-libreoffice-7-in-1-minute-3b8 <div class="ltag__link"> <a href="https://medium.com/@gchandra/install-libreoffice-7-easily-57e80ca1d311" class="ltag__link__link"> <div class="ltag__link__pic"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7zemOvq4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://miro.medium.com/fit/c/96/96/1%2Aix86Zu6tIb3l7qklfr3KeA.png" alt="Ganesh Chandrasekaran"> </div> </a> <a href="https://medium.com/@gchandra/install-libreoffice-7-easily-57e80ca1d311" class="ltag__link__link"> <div class="ltag__link__content"> <h2>Install LibreOffice 7 easily. It takes less than a minute to install… | by Ganesh Chandrasekaran | Medium</h2> <h3>Ganesh Chandrasekaran ・ <time>Aug 12, 2020</time> ・ <div class="ltag__link__servicename"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--hnDHPsJs--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/medium-f709f79cf29704f9f4c2a83f950b2964e95007a3e311b77f686915c71574fef2.svg" alt="Medium Logo"> Medium </div> </h3> </div> </a> </div> libreoffice linux opensource office Ganesh Chandrasekaran Sun, 06 Sep 2020 01:00:36 +0000 https://dev.to/gchandra/integration-services-catalogs-101-17fo https://dev.to/gchandra/integration-services-catalogs-101-17fo <div class="ltag__link"> <a href="https://medium.com/analytics-vidhya/integration-services-catalogs-101-2c43a1df890" class="ltag__link__link"> <div class="ltag__link__pic"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7zemOvq4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://miro.medium.com/fit/c/96/96/1%2Aix86Zu6tIb3l7qklfr3KeA.png" alt="Ganesh Chandrasekaran"> </div> </a> <a href="https://medium.com/analytics-vidhya/integration-services-catalogs-101-2c43a1df890" class="ltag__link__link"> <div class="ltag__link__content"> <h2>Integration Services Catalogs — 101 | by Ganesh Chandrasekaran | Analytics Vidhya | Medium</h2> <h3>Ganesh Chandrasekaran ・ <time>Sep 3, 2020</time> ・ <div class="ltag__link__servicename"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--hnDHPsJs--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/medium-f709f79cf29704f9f4c2a83f950b2964e95007a3e311b77f686915c71574fef2.svg" alt="Medium Logo"> Medium </div> </h3> </div> </a> </div> sqlserver ssis ssdt Ganesh Chandrasekaran Sun, 06 Sep 2020 00:58:47 +0000 https://dev.to/gchandra/install-pyodbc-on-centos-rhel-3je4 https://dev.to/gchandra/install-pyodbc-on-centos-rhel-3je4 <p><a href="https://medium.com/analytics-vidhya/install-pyodbc-on-centos-rhel-ae5062830a2b">https://medium.com/analytics-vidhya/install-pyodbc-on-centos-rhel-ae5062830a2b</a></p> python linux pip pyodbc Ganesh Chandrasekaran Thu, 20 Aug 2020 12:20:09 +0000 https://dev.to/gchandra/sql-injection-cheat-sheet-2l0 https://dev.to/gchandra/sql-injection-cheat-sheet-2l0 <p><a href="https://hackersonlineclub.com/sql-injection-cheatsheet/">https://hackersonlineclub.com/sql-injection-cheatsheet/</a></p> sql sqlinjection Ganesh Chandrasekaran Thu, 13 Aug 2020 01:30:36 +0000 https://dev.to/gchandra/install-libreoffice-7-2gpf https://dev.to/gchandra/install-libreoffice-7-2gpf <p>Install LibreOffice on Ubuntu in less than 1 minute.</p> <div class="ltag__link"> <a href="https://medium.com/@gchandra/install-libreoffice-7-easily-57e80ca1d311" class="ltag__link__link"> <div class="ltag__link__pic"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--7zemOvq4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://miro.medium.com/fit/c/96/96/1%2Aix86Zu6tIb3l7qklfr3KeA.png" alt="Ganesh Chandrasekaran"> </div> </a> <a href="https://medium.com/@gchandra/install-libreoffice-7-easily-57e80ca1d311" class="ltag__link__link"> <div class="ltag__link__content"> <h2>Install LibreOffice 7 easily. It takes less than a minute to install… | by Ganesh Chandrasekaran | Medium</h2> <h3>Ganesh Chandrasekaran ・ <time>Aug 12, 2020</time> ・ <div class="ltag__link__servicename"> <img src="https://res.cloudinary.com/practicaldev/image/fetch/s--hnDHPsJs--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev.to/assets/medium-f709f79cf29704f9f4c2a83f950b2964e95007a3e311b77f686915c71574fef2.svg" alt="Medium Logo"> Medium </div> </h3> </div> </a> </div> Ganesh Chandrasekaran Mon, 10 Aug 2020 00:32:46 +0000 https://dev.to/gchandra/understand-data-structure-algorithms-easily-388f https://dev.to/gchandra/understand-data-structure-algorithms-easily-388f <p>This website helps you to understand Data Structure algorithms (like Linked List, Hash, Binary Search and so on..) in the easiest way possible</p> <p><a href="http://btechsmartclass.com/data_structures/introduction-to-algorithms.html">http://btechsmartclass.com/data_structures/introduction-to-algorithms.html</a></p> stepbystep algorithms datastructure Ganesh Chandrasekaran Sun, 02 Aug 2020 19:55:17 +0000 https://dev.to/gchandra/linux-podcasts-5dhb https://dev.to/gchandra/linux-podcasts-5dhb <p>Image Courtesy : itsfoss.com</p> <p>Podcasts help you to learn something new as well as multi task. If you are looking for awesome Linux podcasts, the collection is <a href="https://itsfoss.com/linux-podcasts/">here</a></p> <p>My favorites are Jupiter, its available via YouTube also.</p> <p><strong>Jupiter</strong><br> <a href="https://www.jupiterbroadcasting.com/142307/linux-arm-wrestling-linux-unplugged-364/">https://www.jupiterbroadcasting.com/142307/linux-arm-wrestling-linux-unplugged-364/</a></p> <p>Good to great discussion on various Linux topics.</p> <p><strong>Linux Headlines</strong></p> <p><a href="https://linuxheadlines.show/182">https://linuxheadlines.show/182</a></p> <p>2 to 3 minute headlines on whats happening that day.</p>