Home » Archive by categoryUncategorized

Get MSSQL Server Top Queries

Open MSSQL Server, then New Query. Paste below query and right click -> Execute.   SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.total_logical_writes, qs.last_logical_writes, qs.total_worker_time, qs.last_worker_time, qs.total_elapsed_time/1000000 total_elapsed_time_in_S, qs.last_elapsed_time/1000000 last_elapsed_time_in_S, qs.last_execution_time, qp.query_plan FROM sys.dm_exec_query_stats qs CROSS...
Continue reading

Windows IIS Application Request Routing (ARR)

IIS Application Request Routing (ARR) 3 enables Web server administrators, hosting providers, and Content Delivery Networks (CDNs) to increase Web application scalability and reliability through rule-based routing, client and host name affinity, load balancing of HTTP server requests, and distributed disk caching. With ARR, administrators can optimize resource...
Continue reading

How to Convert PPK to PEM

sudo apt-get install putty-tools puttygen file.ppk -O private-openssh -o file.pem   Note:- You can also install the same package on REDHAT/CENTOS/FEDORA and run 2nd command in order to convert PPK to PEM.
Continue reading

How to convert text to PDF in Linux

CentOS/RedHat yum install enscript a2ps ghostscript -y Ubuntu sudo apt install enscript a2ps ghostscript -y How to Convert enscript -p output.ps imtextfile.txt ps2pdf output.ps imtextfile.pdf   Git:- https://raw.githubusercontent.com/NavdeepD2/wiki/master/How_to_convert_text_to_PDF_in_Linux.md
Continue reading

How to Delete Zimbra Emails in Bulk Date Wise

Open Zimbra Admin -> https://x.x.x.x:7071/zimbraAdmin/ Go to Manage (on left side) Search Email account (on right top corner) Right click on Email address -> View Mail Click on Search Magnifier For e.g (1) You want to delete all Mails from beginning to till 30th April In Advance Filter...
Continue reading

How to Check Magento Version

Go to public_html OR pub dir For e.g:- /home/the-d2/public_html OR /var/www/html/ 2. Run below command via SSH (CLI) php -r "require 'app/Mage.php'; echo Mage::getVersion(); "
Continue reading

[Solved] TeamViewer + Ubuntu Dependencies Problem libc6-i386 lib32asound2 lib32z1 ia32-libs

Issue #1 [email protected]:/home/navdeepd2# teamviewer Init… CheckCPU: SSE2 support: yes XRandRWait: No value set. Using default. XRandRWait: Started by user. Checking setup… /opt/teamviewer/tv_bin/script/tvw_exec_legacy: line 9: /opt/teamviewer/tv_bin/wine/bin/wineserver: No such file or directory /opt/teamviewer/tv_bin/script/tvw_profile_legacy: line 127: /opt/teamviewer/tv_bin/wine/bin/wine: No such file or directory Issue #2 dpkg: dependency problems prevent configuration of teamviewer:...
Continue reading

Files modified in last 60 minutes or so

Command:- find . -mmin -60 Change value 60 accordingly Examples:- find /etc/ -mmin -10 Find files which have modified in past 10 minutes inside /etc dir find /home/the-d2/public_html/ -mmin -25 Find files which have modified in past 25 minutes inside “/home/the-d2/public_html/” dir
Continue reading