tag:blogger.com,1999:blog-27055382765065329902024-02-18T23:49:19.428-05:00SAYHAMArticles by SAYHAM for fellow coffee lovers.Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.comBlogger81125tag:blogger.com,1999:blog-2705538276506532990.post-3347779475746136572021-08-15T11:50:00.029-04:002021-08-15T15:46:25.293-04:00Checked Checkbox Values In Array With jQuery<div><span style="font-size: 14pt;"><p>Lets use jQuery. If we want to get selected checkbox values, we can do it easily with jQuery. We use checkboxes many times in JavaScript, and in many cases we find the need to get all the checkboxes values. We can store these values in many ways, we will use array this time. We will use jQuery <span class="vsKeyWord">each loop</span> to store the checked checkbox values.</p></span></div>
<head>
<title>Get Checked Checkbox Values In Array With jQuery on sayham.com</title>
</head>
<body>
<span style="font-size:14pt"><h3 style="text-align:center">CheckBoxes...</h3></span><div style="clear:both;padding-top:10px"></div><div style="font-size:14pt"><div class="vsTable" id="vsPosts" style="margin:auto"><div class="vsTableRow"><div class="vsTableCell"><input type="checkbox" value="CheckBox 1"><label>CheckBox 1</label></div></div><div class="vsTableRow"><div class="vsTableCell"><input type="checkbox" value="CheckBox 2"><label>CheckBox 2</label></div></div><div class="vsTableRow"><div class="vsTableCell"><input type="checkbox" value="CheckBox 3"><label>CheckBox 3</label></div></div><div class="vsTableRow"><div class="vsTableCell"><input type="checkbox" value="CheckBox 4"><label>CheckBox 4</label></div></div><div class="vsTableRow"><div class="vsTableCell"><input type="checkbox" value="CheckBox 5"><label>CheckBox 5</label></div></div></div></div><div><div style="clear:both;padding-top:10px"></div><div style="text-align:center"><input type="button" id="btnClick" value="Result" class="btnVS"> <input type="button" id="btnCbArrReset" value="Reset" class="btnVS"></div><div style="clear:both;padding-top:10px"></div><div id="cbArrRslt" class="vsResultPlate" style="text-align:center"><label style="text-align:center!important" for="ckbArrResult" id="ckbArrResult" title="Check boxes and array elements will be displayed here.">Check boxes and array elements will be displayed here.</label></div></div></body><a href="https://www.sayham.com/2021/08/checked-checkbox-values-in-array.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-23005982909633662752020-09-28T00:31:00.001-04:002020-09-28T23:50:44.010-04:00Rename Git Branch<div><span style="font-size: 14pt;"><p>You are working on a project and the team has defined a naming convention for git branches. You have created a branch and pushed all your changes then realized that your branch name has Uh o in it. You have to rename the branch. Git made it very easy for you to rename the branch using <span class="vsKeyWord">-m</span> command. Follow these steps_</p></span></div>
<div class="separator" style="clear: both; text-align: center;"><img alt="Rename Git Branch" border="0" data-original-height="380" data-original-width="910" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtAL7JIJx6G7VUN0Uhxd544vZqvCDKmnJsd-B3xRPTwbpo-2jSCH9SwjIoXIUQPf8bdFRxh6D6rNUe6T6a89LT8pQ_FzxnK1skRUrJzRaHrhlDIIkWfAglJPOvVYTcvEa8IziPSRmVdmQ/s400/Git-Logo-1788C.png" title="Rename Git Branch" width="400" style="background: transparent;"></div>
<div><span style="font-size: 14pt;">Checkout the branch.</span></div>
<pre class="vsCodeBG"><div id="highlighter_300645" class="syntaxhighlighter powershell"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2"> </div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="powershell SelectorGit">git </code><code class="powershell keyword">checkout</code> <code class="powershell color2">Old_BranchName</code></div></div></td></tr></tbody></table></div></pre>
<div><span style="font-size: 14pt;">Rename the local branch.</span></div><a href="https://www.sayham.com/2020/09/rename-git-branch.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-89782499833680420222020-09-21T00:36:00.005-04:002020-09-21T00:44:53.604-04:00Narrow Down Remote Git Branch Search<div><span style="font-size: 14pt;"><p>When you are working on a large scale application code base, it is very likely that you will get too many remote branches with similar names.</p></span></div>
<div class="separator" style="clear: both; text-align: center;"><img alt="Git-Branch is Ahead of origin/master By n Commits" border="0" data-original-height="380" data-original-width="910" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtAL7JIJx6G7VUN0Uhxd544vZqvCDKmnJsd-B3xRPTwbpo-2jSCH9SwjIoXIUQPf8bdFRxh6D6rNUe6T6a89LT8pQ_FzxnK1skRUrJzRaHrhlDIIkWfAglJPOvVYTcvEa8IziPSRmVdmQ/s400/Git-Logo-1788C.png" title="Git Version" width="400" style="background: transparent;"></div>
<div><span style="font-size: 14pt;">You can easily narrow down the search by piping <span class="vsKeyWord">grep</span> with the below command_</span></div>
<pre class="vsCodeBG"><div id="highlighter_300645" class="syntaxhighlighter powershell"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2"> </div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="powershell SelectorGit">git </code><code class="powershell keyword">grep</code> <code class="powershell color2">{regexp}</code></div></div></td></tr></tbody></table></div></pre>
<div><span style="font-size: 14pt;">To search branches that includes <span class="vsKeyWord">WTH_Bug</span>, use the below command_</span></div><a href="https://www.sayham.com/2020/09/NarrowDownRemoteGitBranchSearch.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0Hatfield, PA 19440, USA40.279827399999988 -75.299341711.969593563821142 -110.4555917 68.590061236178826 -40.1430917tag:blogger.com,1999:blog-2705538276506532990.post-30797875897661265142020-09-13T16:12:00.017-04:002020-09-14T23:21:10.203-04:00Get URL Parameters with JavaScript<div>
<span style="font-size: 14pt;">
<p>URL parameters are also called query string parameters. These carry so many important information, such as user preferences, search queries, link referrals, and many more. Use this tool to parse the parameters of a URL. Put the URL into the box and hit click to get parameters on the result section.</p>
</span>
</div>
<head>
<style type="text/css">
.rstUrlParam{font-size:12pt;width:90%;background:#e5eff5;border:1px solid #0066a4;padding:10px 0px;}#tblUrlStr tr:first-child td{font-weight:700;font-size:14pt;border:0;padding:10px;color:red}#tblUrlStr td{padding:2px 10px;border-bottom:1px solid #d5dbdb;vertical-align:top}#inputUrlPrm{min-width:40%;width:80%;padding:10px;font-size:11pt;background:transparent;border:1px solid teal;font-family:Times}#tdParamKey{width:40%;word-break:break-all}#tdParamValue{width:60%;word-break:break-all;color:#0066a4}.vsTableCell{padding:5px;vertical-align:top;}.placeholder-UrlParam:focus::-webkit-input-placeholder{color:transparent}.placeholder-UrlParam:-moz-placeholder,.placeholder-UrlParam:focus::-moz-placeholder{color:transparent}
</style>
</head>
<center>
<span style="font-size:14pt; line-height: 1.4em;">
<div class="vsTable" style="width: 90%;">
<div class="vsTableRow">
<div class="vsTableCell" style="width: 5%;">URL</div>
<div class="vsTableCell">
<textarea class="placeholder-UrlParam" name="Text1" id="inputUrlPrm" rows="3" placeholder="Enter the URL..."></textarea>
</div>
</div>
</div>
</span>
<div style="clear: both; height: 10px;"></div>
<div>
<button id="btnVS" onclick="getUrlParam()">CLICK</button>
<button id="btnVS" type="reset" onclick="resetUrlParam()">CLEAR</button>
<button id="btnVS" type="reset" onclick="resetAll()">RESET</button>
</div>
<div style="clear: both; height: 10px;"></div>
<div id="rstPreMsg" class="rstUrlParam"><span>Result will display here.</span></div>
<div id="urlParamResult" style="display:none;">
<table id="tblUrlStr" class="rstUrlParam" style="visibility: collapse;">
<tbody>
<tr>
<td style="width: 40%;">Parameter Key</td>
<td style="width: 60%;">Parameter Value</td>
</tr>
<tr>
<td id="hide"><span>Result will be here.</span></td>
</tr>
</tbody>
</table>
</div>
</center><a href="https://www.sayham.com/2020/09/GetURLParameterswithJavaScript.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-64913793581288701382020-07-16T00:45:00.002-04:002020-07-16T00:45:38.189-04:00Git Command to Discard All Local Changes/Commits<span style="font-size:14pt;"><p>If you are wondering how you can discard all your local changes easily, this post will show you how to do that in your git repository..</p></span>
<div class="separator" style="clear: both; text-align: center;"><img alt="Git-Branch is Ahead of origin/master By n Commits" border="0" data-original-height="380" data-original-width="910" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtAL7JIJx6G7VUN0Uhxd544vZqvCDKmnJsd-B3xRPTwbpo-2jSCH9SwjIoXIUQPf8bdFRxh6D6rNUe6T6a89LT8pQ_FzxnK1skRUrJzRaHrhlDIIkWfAglJPOvVYTcvEa8IziPSRmVdmQ/s400/Git-Logo-1788C.png" title="Git Version" width="400" style="background: transparent;"></div>
<span style="font-size:14pt;">First, use <span class="vsKeyWord">git clean</span> command to remove all the untracked directories or untracked files.</span><a href="https://www.sayham.com/2020/07/git-command-to-discard-local-changes.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-22312278916375912742020-07-14T16:08:00.015-04:002020-07-15T01:10:39.152-04:00Online Dog Year Calculator<head><style>#dgYr,#hmYr,#inYr{min-width:20px;padding:10px;font-size:11pt;background:0 0;border:1px solid teal;font-family:Times;color:#000}#dgYr,#hmYr{cursor:not-allowed}.trContentStyle{font-size:14pt;padding:10px}.btnVsWidth{width:140px!important}.placeholder-inYr:focus::-webkit-input-placeholder{color:transparent}.placeholder-inYr:focus::-moz-placeholder{color:transparent}.placeholder-inYr:-moz-placeholder{color:transparent}</style></head><br />
<script type="text/javascript">
function HmnDgYr(r){var d=r.inYr.value;dy=d>=21?(d-21)/4+2:d/10.5;var e=0;e=d>=2?21+4*(d-2):10.5*d;var l=Math.round(100*dy)/100,a=Math.round(100*e)/100;isNaN(l)?(r.dgYr.value="Check input!",r.dgYr.style.border="1px solid #ff0000"):(r.dgYr.value=l,r.dgYr.style.border="1px solid #008080"),isNaN(a)?(r.hmYr.value="Check input!",r.hmYr.style.border="1px solid #ff0000"):(r.hmYr.value=a,r.hmYr.style.border="1px solid #008080")}
function rstDgYrCalc(){document.getElementById("inYr").value="";var e=document.getElementById("hmDgYr");e.dgYr.style.border="1px solid #008080",e.hmYr.style.border="1px solid #008080"}
</script>
<center><div class="separator" style="clear: both; text-align: center;"></div><img alt="Akita on sayham.com" border="0" data-original-height="200" data-original-width="250" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqadu97C75coQvzeFBM039exPMdzwE6uNR677TW9cpeF_pYOqEiHS50c7z4wZYhvkqMIblrpPUKJZJnibZwKlHQhCHoqOZV543ZS11CoLnBtdLvyuXF_8BgK9SlY9nF09zHFNvzmCzIU0/s400/Akita.png" title="Akita on sayham.com" width="250" /><div class="separator" style="clear: both; text-align: center; height: 10px;"></div><table style="width: 90%;"><tbody><tr align="center"><td><form class="vsBox" id="hmDgYr"><table border="0"><tbody><tr style="padding: 10px;"></tr><tr><td><span class="trContentStyle">Enter your/your dog's age in years:</span></td><td><span style="font-size: 12pt;"><input class="placeholder-inYr" id="inYr" type="text" placeholder="Enter Age..." /></span></td></tr><tr class="vsAltRow"><td><span class="trContentStyle">If you are a human, your age in dog years:</span></td><td><span style="font-size: 12pt;"><input id="dgYr" type="text" disabled /></span></td></tr><tr><td><span class="trContentStyle">If you are a dog, your age in human years:</span></td><td><span style="font-size: 12pt;"><input id="hmYr" type="text" disabled /></span></td></tr></tbody></table><table border="0"><tbody><tr><td style="padding: 10px;"><button id="btnVS" class="btnVsWidth" onclick="HmnDgYr(hmDgYr)" type="button">CALCULATE</button><button id="btnVS" class="btnVsWidth" onclick="rstDgYrCalc()" type="reset">RESET ALL</button></td></tr></tbody></table></form></td></tr></tbody></table></center>
<br /><i class="fa fa-link" style="padding-right:5px;color:blue;font-size:14pt;"></i><span style="font-size:14pt;">Check out this post on <a href="https://www.sayham.com/2018/06/dog-year-calculator.html">Dog Year</a>.</span>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-37835213425808664042020-07-02T01:29:00.008-04:002020-07-15T23:42:17.872-04:00Your Git Branch is Ahead of origin/master By n Commits<span style="font-size:14pt;"><p>You are a friend of <span class="vsKeyWord">git</span>, you might get following error by running <span class="vsKeyWord">git status</span> at some point in your friendship journey.</p></span>
<center><pre class="vsCodeBG" style="color:#ff0000;">Your branch is ahead of 'origin/master' by n commits.</pre></center>
<span style="font-size:14pt;">Not cool! <br>Let's fix it.</span>
<div class="separator" style="clear: both; text-align: center;"><img alt="Git-Branch is Ahead of origin/master By n Commits" border="0" data-original-height="380" data-original-width="910" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtAL7JIJx6G7VUN0Uhxd544vZqvCDKmnJsd-B3xRPTwbpo-2jSCH9SwjIoXIUQPf8bdFRxh6D6rNUe6T6a89LT8pQ_FzxnK1skRUrJzRaHrhlDIIkWfAglJPOvVYTcvEa8IziPSRmVdmQ/s400/Git-Logo-1788C.png" title="Git Version" width="400" style="background: transparent;"></div>
<span style="font-size:14pt;">Run this to check the very last changes on master.</span>
<pre class="vsCodeBG"><div id="highlighter_361155" class="syntaxhighlighter powershell"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2"> </div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="powershell SelectorGit">git </code><code class="powershell keyword">diff</code> <code class="powershell color2">origin/master</code></div></div></td></tr></tbody></table></div></pre>
<span style="font-size:14pt;">The issue is pretty simple though. <br>The warning is saying that the local master has more stuff than the local copy of the remote master branch <span class="vsKeyWord">origin/master</span>. Your local master branch must have new commits and you need to push your commits to the origin. You did your job, made some changes and now its time to <span class="vsKeyWord">git push origin</span> those changes. Run</span><a href="https://www.sayham.com/2020/07/git-your-branch-is-ahead-of-origin-master.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-68691188390803923992020-06-29T01:37:00.004-04:002020-06-29T11:42:30.615-04:00DesignEvo Is The Best Logo Maker for Startups<span style="font-size: 14pt;"><p>Regardless of the field, every professional needs a set of tools to get their job done. One of the most important tools of that set is the logo maker. Logo maker comes really handy to help you make a unique and compelling logo for your business, blog, or website. I love <a href="https://www.designevo.com/" target="_blank">DesignEvo</a> because I know that entrepreneurs have always wanted to keep startup costs low and stretch their dollars further. Try DesignEvo. It has lots of free templates, free design layouts with inspirations, and free finalized designs.</p></span>
<head>
<style type="text/css">#faIconDesignEvo{padding-right:5px;color:#4ecfa3;font-size:12pt}.vsTable{margin-left:10px}.vsTableCell{padding:5px}</style>
</head>
<div class="separator" style="clear: both; text-align: center;"><a href="https://www.designevo.com/" target="_blank"><img alt="DesignEvoOnSayhamFrontPage" border="0" data-original-height="1530" data-original-width="2834" height="346" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-gXALCJR1XjVOMMm5F5BoiAo6ov7houa98afRPZT9BkC0KUVks7RQvoVqSssNIi2Hj8NL4bnQbDsRAV4wvJjUzPrXdd7ykRtdCIy5nXPHnIAx0XEzVqdf7OPzsc3NcZASQWwCdq2OxRI/w640-h346/DesignEvoOnSayhamFront.png" title="DesignEvoOnSayhamFrontPage" width="640"></a></div><br><a href="https://www.sayham.com/2020/06/designevo.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-52834799283556547322020-05-17T19:04:00.004-04:002020-07-16T10:08:34.253-04:00How to Upgrade Git on Mac OSX<div class="separator" style="clear: both; text-align: center;"><img alt="Git Version" border="0" data-original-height="380" data-original-width="910" height="166" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtAL7JIJx6G7VUN0Uhxd544vZqvCDKmnJsd-B3xRPTwbpo-2jSCH9SwjIoXIUQPf8bdFRxh6D6rNUe6T6a89LT8pQ_FzxnK1skRUrJzRaHrhlDIIkWfAglJPOvVYTcvEa8IziPSRmVdmQ/s400/Git-Logo-1788C.png" title="Git Version" width="400" style="background: transparent;"></div>
<span style="font-size: 14pt;">Lets start by checking current version.</span>
<pre class="vsCodeBG"><div id="highlighter_894164" class="syntaxhighlighter powershell"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2"> </div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="powershell SelectorGit">git </code><code class="powershell keyword">--version</code></div></div></td></tr></tbody></table></div></pre>
<span style="font-size: 14pt;">Install <a href="http://brew.sh/" target="_blank">Homebrew</a> if needed.</span>
<pre class="vsCodeBG"><div id="highlighter_36313" class="syntaxhighlighter powershell"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2"> </div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="powershell plain">/bin/bash </code><code class="powershell keyword">-c</code> <code class="powershell string">"$(curl -fsSL <a href="https://raw.githubusercontent.com/Homebrew/install/master/install.sh">https://raw.githubusercontent.com/Homebrew/install/master/install.sh</a>)"</code></div></div></td></tr></tbody></table></div></pre>
<span style="font-size: 14pt;">If Homebrew exists on your machine, update it.</span><a href="https://www.sayham.com/2020/05/how-to-upgrade-git-on-mac-osx.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-47010429047917233992020-05-11T18:57:00.001-04:002020-07-15T16:14:40.896-04:00Online Temperature Converter<span style="visibility:hidden;">Find Online Temperature Converter on sayham.com </span><head><script>function CelConvert(){ TmpCvtr.inFah.value = (TmpCvtr.inCel.value * 9 / 5) + 32 + (' \xB0F'); TmpCvtr.inKel.value = TmpCvtr.inCel.value * 1 + 273.15 + (' K'); } function FahConvert(){ TmpCvtr.inCel.value = (TmpCvtr.inFah.value - 32) * 5 / 9 + (' \xB0C'); TmpCvtr.inKel.value = ((TmpCvtr.inFah.value - 32)*5/9)+273.15 + (' K'); } function KelConvert(){ TmpCvtr.inCel.value = TmpCvtr.inKel.value - 273.15 + (' \xB0C'); TmpCvtr.inFah.value = ((TmpCvtr.inKel.value - 273.15)*9/5)+32 + (' \xB0F'); } </script><style>#inCel, #inFah, #inKel {min-width:50px;padding:10px;font-size: 14pt;background: transparent;border: 1px solid #008080;font-family: Times} </style></head>
<div class="separator" style="clear: both; text-align: center;"> <img alt="Temp_sayham.com" border="0" data-original-height="362" data-original-width="177" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgah7eAXOHut0adtTRxzECwsgNhND1a7crlFOvsAUIl5omq7CB8X2i8gSMIN5_O5ZKfXSTJhiFbHAclvY3S3srk4UrCFYnWHTp_bG0sbevk6dBkmOFUiQi_39A5J2OvqlGJnELu2ytQiOM/s320/temperature_low-512.png" title="Temp_ sayham.com" width="156" /></div><br /><span style="font-size:14pt;text-align:justify;"><center> <table style="width: 90%;"> <tbody> <tr align="center"> <td> <form id="TmpCvtr" style="box-shadow: 0 0 10px #003220; padding: 30px 5px;"> <table border="0"> <tbody> <tr style="padding: 10px;"></tr><tr> <td> <span>Temperature in Celsius:</span> </td><td> <span> <input id="inCel" onchange="CelConvert()" type="text"/> </span> </td></tr><tr> <td> <span>Temperature in Fahrenheit:</span> </td><td> <span> <input id="inFah" onchange="FahConvert()" type="text"/> </span> </td></tr><tr> <td> <span>Temperature in Kelvin:</span> </td><td> <span> <input id="inKel" onchange="KelConvert()" type="text"/> </span> </td></tr></tbody> </table> <table border="0"> <tbody> <tr> <td style="padding: 10px;"> <input id="btnVS" type="button" value="CONVERT"/> <input id="btnVS" type="reset" value="RESET ALL"/> </td></tr></tbody> </table> </form> </td></tr></tbody> </table></center></span>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-14119016795948112232020-05-05T01:34:00.000-04:002020-07-10T15:34:53.502-04:00Online Email Extractor<div><span style="font-size:14pt;"><p>This Email Extractor is a little tool that will help you find email addresses hidden in the content. Just copy, paste and hit Extract button for extracting. <br> Please use this tool responsibly. <span style="color:#ff0000;"><i class="faIcons faExclamation-triangle"></i> DO NOT</span> use this tool for spamming.</p> </span></div>
<head>
<script>
function extrAllEmails(inputExtrEmText) {
return inputExtrEmText.match(/([a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.[a-zA-Z0-9._-]+)/gi);
}
var jQueryExtEml = jQuery.noConflict();
jQueryExtEml(function() {
jQueryExtEml('#btnEmExtr').click(function() {
jQueryExtEml('#extrEmList').html('');
emails = extrAllEmails(jQueryExtEml('#extrEmTxtArea').val());
emlsCount = 0;
jQueryExtEml.each(emails, function(index, email) {
jQueryExtEml('#extrEmList').html(jQueryExtEml('#extrEmList').html() + '<i class="far fa-envelope" style="color:#0066a4;"></i>' + " " + email + "<br>");
emlsCount++;
});
jQueryExtEml('#showEmlCnt').text(emlsCount);
});
jQueryExtEml('#btnEmRst').click(function() {
jQueryExtEml('#extrEmTxtArea').val('');
jQueryExtEml('#extrEmList').html('Email(s) will be displayed here.');
jQueryExtEml('#showEmlCnt').text('^..^');
});
});
</script>
<style type="text/css">.placeholder-fix:focus::-webkit-input-placeholder{color:transparent}.placeholder-fix:focus::-moz-placeholder{color:transparent}.placeholder-fix:-moz-placeholder{color:transparent}#extrEmTxtArea{height:300px;width:90%;background:transparent;border:1px solid #0066a4;font-size:11pt;font-family:Times;padding:5px;max-width:90%;min-width:90%;}#extrEmList{width:70%;border:1px solid #0066a4;background:#e5eff5;padding:10px 30px;line-height:1.7em;text-align:left;font-size:12pt;}</style>
</head>
<div><span style="font-size:14pt;"> <strong>Paste your text here and click extract button.</strong> </span><br><center><p><textarea class="placeholder-fix" id="extrEmTxtArea" placeholder="Paste your text here and click extract button."></textarea></p><p> <button id="btnEmExtr" class="btnVS">Extract</button> <button id="btnEmRst" class="btnVS">Reset</button></p></center><p></p></div><a href="https://www.sayham.com/2020/05/online-email-extractor.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-38292024575084991122020-04-24T14:00:00.002-04:002020-06-26T15:53:57.300-04:00What Happens When You Type in a URL<head> <style type="text/css"> #faIconPS{padding-right: 5px; color: #0066a4; font-size: 12pt}.vsTable{margin-left: 10px;}.vsTableCell{padding:5px;}</style></head><div> <span style="font-size: 14pt; line-height: 1.4em;"> <p>There is a commonly asked deceptive question in tech interviews “What happens when you type in a URL?”. It is always good to have a basic understanding of what are the background processes between the browser and the information that is transferred over the internet. This is how it can be explained in short:</p><div class="vsTable"> <div class="vsTableRow"> <div class="vsTableCell"><i class="fa fa-window-maximize" id="faIconPS"></i></div><div class="vsTableCell">We enter a URL into a web browser.</div></div><div class="vsTableRow vsAltRow"> <div class="vsTableCell"><i class="fa fa-window-maximize" id="faIconPS"></i></div><div class="vsTableCell">The browser checks the cache for a DNS record to look up the IP address for the domain name. It checks four caches if needed (<span class="vsKeyWord">Browser cache > OS cache > Router cache > ISP cache</span>).</div></div></div></span></div><a href="https://www.sayham.com/2020/04/what-happens-when-you-type-in-url.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-20470986895868868702020-03-19T00:39:00.000-04:002020-04-28T10:26:33.612-04:00Font Awesome Icons With CSS<span style="font-size:14pt;"><p>A CSS <a href="https://developer.mozilla.org/en-US/docs/Web/CSS/Pseudo-elements" target="_blank">pseudo-element</a> is a keyword added to a selector that lets us style a specific part of the selected element(s). Font Awesome has leveraged the <span class="vsKeyWord">::before</span> pseudo-element to add icons to a page since the very beginning. These icons are used throughout <a href="https://www.sayham.com">sayham.com</a>.</p></span>
<div class="vsParHeader">Font Awesome 5.12.1</div>
<head>
<style type="text/css">.rightArrowDown{float:right;font-size:10pt;color:#0066a4;padding-top:5px;}.rightArrowDown:hover{float:right;font-size:10pt;color:#ff0000;padding-top:5px;}</style>
<link href='https://use.fontawesome.com/releases/v5.12.1/css/all.css' rel='stylesheet' type='text/css'>
</head>
<br>
<div>
<div style="font-size: 14pt;"><span class="faIcons faRSS"></span> - <a href="https://fontawesome.com/icons/rss?style=solid" target="_blank">RSS</a><span class="rightArrowDown faLevel-down-alt"></span></div>
<pre class="vsCodeBG"><div id="highlighter_473319" class="syntaxhighlighter css"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div><div class="line number3 index2 alt2">3</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="css keyword">font-family</code><code class="css plain">: </code><code class="css string">"Font Awesome 5 Free"</code><code class="css plain">;</code></div><div class="line number2 index1 alt1"><code class="css keyword">content</code><code class="css plain">: </code><code class="css string">"\f09e"</code><code class="css plain">;</code></div><div class="line number3 index2 alt2"><code class="css keyword">font-weight</code><code class="css plain">: </code><code class="css value">900</code><code class="css plain">;</code></div></div></td></tr></tbody></table></div></pre>
</div><a href="https://www.sayham.com/2020/03/font-awesome-icons-with-css.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-38920517186599372632020-03-02T01:19:00.000-05:002020-07-10T15:34:59.041-04:00Online Password Generator With Strength Validation<span style="visibility:hidden;">Online Password Generator With Strength Validation | Virtual Species</span><div class="separator" style="clear: both; text-align: center;"><img border="0" data-original-height="168" data-original-width="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjTCfvDtB93fHpNjRzFQmoejD6XKu2hJ6MHwq1JFOdM4fl2G1TB-pMv6-taiT8IWvBhfJoGRRkxYOPXXaxp2Zgtpr6jnAWuYAyjM63sIpbGSBJ673_DH-3in7_2w0pKuPv2ispM-HCx9g/s1600/PasswordGenerator_Post.png" style="background: transparent;"></div><script>var jQueryClick1 = jQuery.noConflict();</script><script type="text/javascript">jQueryClick1(document).ready(function(e){e("#btnReset").on("click",function(){e("#msgDIV").load("https://www.sayham.com/2020/03/online-password-generator-with-strength.html #message")})}); function getRandomPgNum(a,b){return Math.floor(Math.random()*(b-a))+a}function getRandomPgChar(a,b,c,d,e){var f=e;return!0===a&&(f+="0123456789"),!0===b&&(f+="abcdefghijklmnopqrstuvwxyz"),!0===c&&(f+="ABCDEFGHIJKLMNOPQRSTUVWXYZ"),!0===d&&(f+="[{(@$!%*#?&.)_+=;:~`^<,>'\"\\|/} "),f.charAt(getRandomPgNum(0,f.length))}function getPassword(a,b,c,d,e,f,g,h,i,j){var k="";a<=0&&(a=12),a>0&&(k+=getRandomPgChar(c,d,e,f,b));for(var l=1;l<a;++l)k+=getRandomPgChar(g,h,i,j,b);return k}function btnPgClr(){document.getElementById("passLen").value="",document.getElementById("exChar" ).value="",document.getElementById("nwPass" ).value=""}function validPWD(){var b=document.getElementById("nwPass" ),c=document.getElementById("lCase" ),d=document.getElementById("uCase" ),e=document.getElementById("number" ),f=document.getElementById("spChar" ),g=document.getElementById("len12" ),h=document.getElementById("minLC" ),i=document.getElementById("minUC" ),j=document.getElementById("minNUM" ),k=document.getElementById("minSC" ),l=document.getElementById("minMC" ),m=document.getElementById("message" ),n=/[A-Z]/g,o=/[a-z]/g,p=/[0-9]/g,q=/[[{(@$!%*#?&.)_+=;:~`^<,>'\"\\|\/} ]/g;b.value.match(o)?(c.style.color="#008000",h.className="fas fa-check-circle"):(c.style.color="#FF0000",h.className="fas fa-times-circle"),b.value.match(n)?(d.style.color="#008000",i.className="fas fa-check-circle"):(d.style.color="#FF0000",i.className="fas fa-times-circle"),b.value.match(p)?(e.style.color="#008000",j.className="fas fa-check-circle"):(e.style.color="#FF0000",j.className="fas fa-times-circle"),b.value.match(q)?(f.style.color="#008000",k.className="fas fa-check-circle"):(f.style.color="#FF0000",k.className="fas fa-times-circle"),b.value.length>=12?(g.style.color="#008000",l.className="fas fa-check-circle"):(g.style.color="#FF0000",l.className="fas fa-times-circle"),m.className=b.value.match(o)&&b.value.match(n)&&b.value.match(p)&&b.value.match(q)&&b.value.length>=12?"greenStatus":"redStatus"} <style>.separator {clear: both;text-align: center;padding-top: 30px;}.placeholder-inputPWD:focus::-webkit-input-placeholder {color: transparent;}.placeholder-inputPWD:focus::-moz-placeholder {color: transparent;}.placeholder-inputPWD:-moz-placeholder {color: transparent;}#passLen,#exChar,#nwPass{font-family: Times;font-size: 12pt;padding: 10px;background: transparent;border: 1pt solid #008080;}.placeholder-inputPWD {border: 1pt solid #008080;}.showHideIcon {width: 60px;box-shadow: 0 0 0 1px rgba(56,60,67,.05),0 1px 3px 0 rgba(56,60,67,.15);border: none;cursor: pointer;}#message {position: relative;padding: 5px 30px;margin-top: 5px;}#message p {padding: 0 35px;font-size: 14pt;}#minLC,#minUC,#minNUM,#minSC,#minMC {position: relative;left: -20px;}.msgContent {color: red;}.greenStatus {background-color: #e9f9ee;border: 1px solid green;transition: all .2s ease-out;}.redStatus {background-color: #f9e9ec;border: 1px solid red;transition: all .2s ease-out;}.orangeStatus {background-color: #ffeac4;border: 1px solid #e69500;transition: all .2s ease-out;} </style><center><table style="width: 90%;"><tbody><tr align="center"><td><form id="vsBox" name="pgForm"><table border="0"><tbody><tr><td><span style="font-size: 12pt;">Select First Character:</span></td><td><span style="font-size: 12pt;"><input checked="" name="firstPgNum" type="checkbox">Number <input checked="" name="firstPgLow" type="checkbox">Lowercase <input checked="" name="firstPgUp" type="checkbox">Uppercase <input checked="" name="firstPgOther" type="checkbox">Other</span></td></tr><tr><td><span style="font-size: 12pt;">Select Next Characters:</span></td><td><span style="font-size: 12pt;"><input checked="" name="nxtPgNum" type="checkbox">Number <input checked="" name="nxtPgLow" type="checkbox">Lowercase <input checked="" name="nxtPgUp" type="checkbox">Uppercase <input checked="" name="nxtPgOther" type="checkbox">Other</span></td></tr><tr><td><span style="font-size: 12pt;">Password Length:</span></td><td><span style="font-size: 12pt;"><input class="placeholder-inputPWD" id="passLen" placeholder="Default Length is 12..." name="passwordLength" size="40" type="text"></span></td></tr><tr><td><span style="font-size: 12pt;">Extra Password Characters:</span></td><td><span style="font-size: 12pt;"><input class=".placeholder-exChar" id="exChar" name="extraPgChar" size="40" type="text"></span></td></tr><tr><td><span style="font-size: 12pt;">New Password:</span></td><td><span style="font-size: 12pt;"><input class=".placeholder-nwPass" id="nwPass" name="genPassOut" onclick="select();" onkeyup="validPWD(this.value);" size="40" type="text""></span></td></tr></tbody></table></form></td></tr><tr align="center"><td style="padding:10px"> <button onclick="document.pgForm.genPassOut.value = getPassword(document.pgForm.passwordLength.value, document.pgForm.extraPgChar.value, document.pgForm.firstPgNum.checked, document.pgForm.firstPgLow.checked, document.pgForm.firstPgUp.checked, document.pgForm.firstPgOther.checked, document.pgForm.nxtPgNum.checked, document.pgForm.nxtPgLow.checked, document.pgForm.nxtPgUp.checked, document.pgForm.nxtPgOther.checked); validPWD(this.value);" id="btnVS">GENERATE</button> <button href="#" class="btnVS" id="btnReset" onclick="btnPgClr(); return false;">CLEAR ALL</button></td></tr></tbody></table></center><a name='more'></a><span style="font-size:14pt;">Password <span class="vsKeyWord">SHOULD</span> meet the following conditions:</span></a;++l)k+=getRandomPgChar(g,h,i,j,b);return></script><a href="https://www.sayham.com/2020/03/online-password-generator-with-strength.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-22779671740009074522020-02-20T00:17:00.000-05:002020-04-12T18:20:41.052-04:00SQL Table Row Count<span style="font-size: 14pt;"><p>There are couple ways to count row of a SQL table. Below is the quickest script to do that.</p></span><pre class="vsCodeBG"><div id="highlighter_506157" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">USE </code><code class="sql plain">[YourDatabaseName]</code></div><div class="line number2 index1 alt1"><code class="sql keyword">SELECT</code> <code class="sql color2">COUNT</code><code class="sql plain">(*) </code><code class="sql keyword">AS</code> <code class="sql string">"TotalRow"</code> <code class="sql keyword">FROM</code> <code class="sql plain">[YourTableName]</code></div></div></td></tr></tbody></table></div></pre><a href="https://www.sayham.com/2020/02/sql-table-row-count.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-36243608634673572842020-02-19T00:33:00.000-05:002020-04-12T18:20:48.876-04:00SQL Server Version From Backup File<span style="font-size: 14pt;"><p>We can easily find out the database version by checking the important server details of the backup files using the below script.</p></span><pre class="vsCodeBG"><div id="highlighter_164073" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">USE </code><code class="sql plain">msdb</code></div><div class="line number2 index1 alt1"><code class="sql keyword">RESTORE HEADERONLY </code><code class="sql keyword">FROM</code> <code class="sql keyword">DISK = </code><code class="sql string">'C:\MicrosoftSQLServer\MSSQL\Backup\DatabaseBackup.bak'</code></div></div></td></tr></tbody></table></div></pre><a href="https://www.sayham.com/2020/02/sql-server-version-from-backup-file.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-50277654533732299702020-02-17T16:13:00.000-05:002020-04-12T18:21:07.007-04:00SQL Database Backup History<span style="font-size: 14pt;"><p>Below is the script to get information about the each type of the successful backups for each databases.</p></span><pre class="vsCodeBG"><div id="highlighter_700815" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div><div class="line number3 index2 alt2">3</div><div class="line number4 index3 alt1">4</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">USE </code><code class="sql plain">msdb</code></div><div class="line number2 index1 alt1"><code class="sql keyword">SELECT</code> <code class="sql plain">name</code><code class="sql plain">, user_name, first_lsn, last_lsn, database_backup_lsn,</code></div><div class="line number3 index2 alt2"><code class="sql plain">backup_start_date, backup_finish_date, type, database_name,</code></div><div class="line number4 index3 alt1"><code class="sql plain">server_name, machine_name, compressed_backup_size </code><code class="sql keyword">FROM</code> <code class="sql plain">backupset</code></div></div></td></tr></tbody></table></div></pre><a href="https://www.sayham.com/2020/02/sql-database-backup-history.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-15091977884638950662020-02-01T10:50:00.000-05:002020-05-13T01:27:42.535-04:00Search Puzzle With Letters And Numbers<span style="visibility:hidden;">Search Puzzle With Letters And Numbers | Virtual Species</span><head><style>#tblRandCharDigit td{border:1px solid #000;padding:4px;text-align:center;vertical-align:middle;width:20px;height:20px}#tblRandCharDigit{border-collapse:collapse;border-spacing:0;padding:5px;width:400px;height:300px} </style><script>function RandomCharDigit(){ var table = []; for(var j = 0; j < 10; j++) { var column = ""; for (var i = 0; i < 10; i++){ var charDigit = 'ABCDEFGHIJKLMNOPQRSTUVXYZ0123456789'; var randCharDigit = charDigit.charAt(parseInt(Math.random() * charDigit.length)); var cell = '<td>' + randCharDigit + '</td>'; column += cell; } table.push('<tr>' + column + '</tr>'); } document.getElementById('tblRandCharDigit').innerHTML = table.join(""); } function reset(){ document.getElementById('tblRandCharDigit').innerHTML = ""; } </script></head><body><span style="font-size:14pt;"><p>We can create a search puzzle with a grid of random letters and numbers. Below is a 10x10 puzzle board. Use generate button to get the puzzle and find script at the end of this page.</p></span><center><div id="vsBox" style="width:60%;height:300px;"><table id="tblRandCharDigit"> <tbody id="tbPuzzle" ></tbody></table></div><br><div style="clear:both;"></div><button class="btnVS" onclick="RandomCharDigit(); return false;" type="button" style="width:130px;">Generate</button><button class="btnVS" onclick='reset(); return false;' style="width:130px;">Reset</button></center></body><a href="https://www.sayham.com/2020/02/search-puzzle-with-letters-and-numbers.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-42875719119601180112020-01-04T00:51:00.001-05:002020-06-03T15:00:08.281-04:00SQL Server TRUNCATE TABLE<div><span style="font-size: 14pt;"><p>We can use the <span class="vsKeyWord">TRUNCATE TABLE</span> statement to remove all the records or specified partition of a table. This statement in SQL Server is similar to the <span class="vsKeyWord">DELETE</span> statement without <span class="vsKeyWord">WHERE</span> Clause.</p></span></div><pre class="vsCodeBG"><div id="highlighter_731679" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2"> </div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">TRUNCATE</code> <code class="sql keyword">TABLE</code> <code class="sql plain">[YourDBName].[YourTableName]</code></div></div></td></tr></tbody></table></div></pre><div><span style="font-size: 14pt;">OR</span></div><a href="https://www.sayham.com/2020/01/sql-server-truncate-table.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-74318475931080148092019-12-22T12:24:00.000-05:002020-03-02T13:13:11.126-05:00Free Crypto<head><style>.btnFreeCrypto { font-size: 12pt; font-weight: bold; text-align: center; text-decoration: none; border-radius: 3px; padding: 6px 20px 6px 20px; background-image: none; margin: 5px; cursor: pointer !important; width: 210px; } #OXT, #EOS { color: #ffffff !important; background: #5f4ab7; border: 1px solid #5f4ab7; } #EOS { color: #fff !important; background: #000; border: 1px solid #000; } #XLM { color: #000 !important; background: #fff; border: 1px solid #000; } #Coinbase { color: #fff !important; background: #1d58ec; border: 1px solid #1d58ec; } #Robinhood { color: #fff !important; background: #30cd9a; border: 1px solid #30cd9a; } #Celsius { color: #fff !important; background: #32335c; border: 1px solid #32335c; } #OXT:hover, #EOS:hover, #XLM:hover, #Coinbase:hover, #Robinhood:hover, #Celsius:hover { color: #F00 !important; text-decoration: none; background: #fff } </style></head><center><br/><br/><button class="btnFreeCrypto" id="OXT" onclick="window.open('https://coinbase.com/earn/oxt/invite/qr3djsc1')" type="button">Orchid (OXT)</button><br/><button class="btnFreeCrypto" id="EOS" onclick="window.open('https://coinbase.com/earn/eos/invite/3fd5jq0v')" type="button">EOS</button><br/><button class="btnFreeCrypto" id="XLM" onclick="window.open('https://coinbase.com/earn/xlm/invite/n95b8fpm')" type="button">Stellar Lumens (XLM)</button><br/><br/><br/><button class="btnFreeCrypto" id="Coinbase" onclick="window.open('https://www.coinbase.com/join/chowdh_dk')" type="button">Coinbase</button><br/><button class="btnFreeCrypto" id="Robinhood" onclick="window.open('https://join.robinhood.com/sayhamc')" type="button">Robinhood</button><br/><button class="btnFreeCrypto" id="Celsius" onclick="window.open('https://celsiusnetwork.app.link/110827092f')" type="button">Celsius</button></center>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-63898002350338119152019-12-21T02:34:00.000-05:002020-04-12T18:21:20.140-04:00SQL Check Database Replication Status<div><span style="font-size: 14pt;"><p>A database can not be dropped if there is replication enabled for it. We can use the below stored procedure to check whether a database has a Publisher that enabled for replication.</p><pre class="vsCodeBG"><div id="highlighter_296933" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">EXECUTE</code> <code class="sql plain">sys.sp_helpreplicationdb @dbname = [YourDBName], </code><code class="sql comments">-- sysname</code></div><div class="line number2 index1 alt1"><code class="sql spaces"> </code><code class="sql plain">@type = pub </code><code class="sql comments">-- sysname</code></div></div></td></tr></tbody></table></div></pre></span></div><a href="https://www.sayham.com/2019/12/sql-check-database-replication-status.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-28817262150291538042019-10-14T08:23:00.000-04:002020-04-12T18:21:26.171-04:00SQL Check Database Restore Start Date<div><span style="font-size: 14pt;"><p>We have seen the behavior in SSMS that nothing happens when we go to <span class="vsKeyWord">Tasks/Restore/Database</span>. It means that the backup/restore history for the database is very long, and the wizard will take longer to come up since it reads the entire history first. We need to truncate the history. We can run the script below to determine the backup start date.</p></span></div><pre class="vsCodeBG"><div id="highlighter_522866" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div><div class="line number3 index2 alt2">3</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">SELECT</code> <code class="sql keyword">TOP</code> <code class="sql plain">1 backup_start_date </code><code class="sql keyword">AS</code> <code class="sql string">'BackUp Start Date'</code></div><div class="line number2 index1 alt1"><code class="sql keyword">FROM</code> <code class="sql plain">msdb.dbo.backupset </code><code class="sql keyword">WITH</code> <code class="sql plain">(NOLOCK)</code></div><div class="line number3 index2 alt2"><code class="sql keyword">ORDER</code> <code class="sql keyword">BY</code> <code class="sql plain">backup_set_id </code><code class="sql keyword">ASC</code></div></div></td></tr></tbody></table></div></pre><a href="https://www.sayham.com/2019/10/sql-check-database-restore-start-date.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-57686397468421630892019-09-18T09:52:00.000-04:002020-04-12T18:21:33.180-04:00SQL Column Names From Table<div><span style="font-size: 14pt;"><p>Below is the effective query to get column names from a SQL table. We will use <span class="vsKeyWord">INFORMATION_SCHEMA</span> to get the task done.</p></span></div><pre class="vsCodeBG"><div id="highlighter_559869" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div><div class="line number3 index2 alt2">3</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">SELECT</code> <code class="sql plain">COLUMN_NAME</code></div><div class="line number2 index1 alt1"><code class="sql keyword">FROM</code> <code class="sql plain">INFORMATION_SCHEMA.COLUMNS</code></div><div class="line number3 index2 alt2"><code class="sql keyword">WHERE</code> <code class="sql plain">TABLE_NAME = N</code><code class="sql string">'TableName'</code></div></div></td></tr></tbody></table></div></pre><div><span style="font-size: 14pt;">In the alternate example below, we will use <span class="vsKeyWord">sys.columns</span> to get the task done.</span></div><a href="https://www.sayham.com/2019/09/sql-column-names-from-table.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-46941645380646595002019-09-10T14:20:00.003-04:002020-09-13T15:59:37.680-04:00SQL Retrieve Email Domains<div><span style="font-size: 14pt;text-align:justify;"><p>If we need to retrieve all the email domains from a SQL table, we can easily pull up result using below script. The <span class="vsKeyWord">SUBSTRING</span> function is used to extract and display the part of a string. In this case, we have retrieved email domains after the <span class="vsKeyWord">@</span> symbol in each record.</p></span></div><pre class="vsCodeBG"><div id="highlighter_610822" class="syntaxhighlighter sql"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td class="gutter"><div class="line number1 index0 alt2">1</div><div class="line number2 index1 alt1">2</div><div class="line number3 index2 alt2">3</div></td><td class="code"><div class="container"><div class="line number1 index0 alt2"><code class="sql keyword">SELECT</code> <code class="sql keyword">DISTINCT</code> </div><div class="line number2 index1 alt1"><code class="sql color2">SUBSTRING</code><code class="sql plain">(Email, CHARINDEX(</code><code class="sql string">'@'</code><code class="sql plain">,Email) + 1, LEN(Email) - CHARINDEX(</code><code class="sql string">'@'</code><code class="sql plain">,Email)) </code></div><div class="line number3 index2 alt2"><code class="sql keyword">FROM</code> <code class="sql plain">dbo.EmailRecord</code></div></div></td></tr></tbody></table></div></pre><span style="font-size: 14pt;text-align:justify;">Even better with the script below, we will be able to count how many of each domains are existed in the given table.</span><a href="https://www.sayham.com/2019/09/sql-retrieve-email-domains.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0tag:blogger.com,1999:blog-2705538276506532990.post-7048229832139422182019-05-02T01:35:00.000-04:002020-04-13T10:36:28.286-04:00Essential Keyboard Functions<p><span style="font-size: 14pt; text-align: justify;">Keyboard functions have a great impact on our productivity, greatly speed up the outcome and save a whole lot of time. It also can reduce wrist strain. Remembering these functions can be overwhelming at first but you will get used to it. Below are some most frequently used keyboard functions_</span></p><div class="separator" style="clear: both; text-align: center;"><img alt="KeyBoard on virtualspecies.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKFKs9yojB0PnVxaL8NpwHgKWsmob8szBSdz37z9CO4QcoppCSGqBBNHXC1KDGhVRVQR1_4kSd4dJGj0Uok_KP562njXNb0_am9HImad9QolVjckQNnax0iZs_3ylZxHqmOBj4ftYusf4/s400/KwyBoard.png" title="KeyBoard on virtualspecies.com" width="400" height="250" data-original-width="300" data-original-height="250"></div><span style="font-size: 14pt; text-align: justify;"> <i aria-hidden="true" class="far fa-keyboard" style="color: green; padding-right: 5px;"></i><b>_F1</b>: It is help key. It is used to get help with the computer or with any software. It displays or hides the ribbon menu bar in Word and Excel.<br></span><a href="https://www.sayham.com/2019/05/essential-keyboard-functions.html#more">Read more »</a>Sayhamhttp://www.blogger.com/profile/02199405436986397621noreply@blogger.com0