tag:blogger.com,1999:blog-28999356198294882942024-03-10T12:49:52.836-05:00LazyJeffThese fixes are things we've discovered to save time or resolve error messages and problems.
LazyJeff LLC is an IT Company focusing on Small Businesses in the St Louis and Southern Illinois Areas.Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.comBlogger225125tag:blogger.com,1999:blog-2899935619829488294.post-78444754823523725592023-12-17T15:13:00.001-06:002023-12-17T15:13:14.466-06:00HOW TO - Share a password<p> q: With password complexity on the rise, what is a quick way to securely share a password without trying to spell it over the phone?</p><p>a: Password Pusher - https://pwpush.com/<br />You can provide your own data to share, or let the site generate a string for you.<br />You can control expiration by Day and View count.<br />You can even require a password, to access this string.<br />You can also share files & URLs securely. </p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjxpKNUej9sb6M8TEWynTzy_t25_I6480yDMM5l8za4Dwnj41KUhkcVXALBbUFE_rYENORn8FGHAldMAFNxCypcm-AqsvULBYDsCrTfvdaMTunrTgHvx8Dvih-1j3LGawfmiNrn7Fl1aiBi3U1xODHnxenwDxbbfzAMrnhHygJB1DwwnBJTbvXv76TCtiM" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="600" data-original-width="883" height="217" src="https://blogger.googleusercontent.com/img/a/AVvXsEjxpKNUej9sb6M8TEWynTzy_t25_I6480yDMM5l8za4Dwnj41KUhkcVXALBbUFE_rYENORn8FGHAldMAFNxCypcm-AqsvULBYDsCrTfvdaMTunrTgHvx8Dvih-1j3LGawfmiNrn7Fl1aiBi3U1xODHnxenwDxbbfzAMrnhHygJB1DwwnBJTbvXv76TCtiM" width="320" /></a></div><br /><br /><p></p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-37120929963551224872023-12-16T09:29:00.004-06:002023-12-16T09:29:45.080-06:00WINRM cannot process the request | Kerberos authentication | unknown security error<div style="text-align: left;">q: A user tries to send a command to SERVER1 via PowerShell over WinRM and gets an error.</div><div style="text-align: left;"> PS > Invoke-Command -ComputerName SERVER1 -ScriptBlock {net localgroup administrators}</div><div><br /></div><div>*[SERVER1] Connecting to remote server SERVER1 failed with the</div><div>following error message : WinRM cannot process the request. The following</div><div>error with errorcode 0x80090322 occurred while using Kerberos</div><div>authentication: An unknown*security error occurred.</div><div>Possible causes are:</div><div>-The user name or password specified are invalid.</div><div>-Kerberos is used when no authentication method and no user name are</div><div>specified.</div><div>-Kerberos accepts domain user names, but not local user names.</div><div>-The Service Principal Name (SPN) for the remote computer name and port</div><div>does not exist.</div><div>-The client and remote computers are in different domains and there is no</div><div>trust between the two domains.</div><div>After checking for the above issues, try the following:</div><div>-Check the Event Viewer for events related to authentication.</div><div>-Change the authentication method; add the destination computer to the</div><div>WinRM TrustedHosts configuration setting or use HTTPS transport.</div><div>Note that computers in the TrustedHosts list might not be authenticated.</div><div>-For more information about WinRM configuration, run the following</div><div>command: winrm help config. For more information, see the</div><div>about_Remote_Troubleshooting Help topic.</div><div>+ CategoryInfo : OpenError: (SERVER1:String) [],</div><div>PSRemotingTransportException</div><div>+ FullyQualifiedErrorId : -2144108387,PSSessionStateBroken</div><div><br /></div><div>a: From the client machine, create this Reg Key and try again.</div><div>Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WSMAN\Client</div><div>Value type: REG_SZ (string)</div><div>Value name: spn_prefix</div><div>Value data: WSMAN</div>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-24063790099151877082023-10-16T11:51:00.006-05:002023-10-16T11:51:59.498-05:00Google Workspace - We couldn’t verify it’s you<p>q: Customer called with Google Workspace blocking their access to log into a user account via webmail.<br /><span> </span>Google<br /><span> </span>We couldn’t verify it’s you<br /><span> </span>We want to make sure it’s really you trying to complete this action.<br /><span> </span>To help us verify it’s really you<br /><span> </span>Use a device and browser you’ve signed in on before<br /><span> </span>Use a familiar Wi-Fi network, such as at home or work<br /><br />a: Simply disable login challenge and it will let you through.<br /><span> </span>Log into Google Workspace Admin https://admin.google.com/<br /><span> </span>Click users<br /><span> </span>Click the user / username affected<br /><span> </span>Click the ‘Security’ section<br /><span> </span>Click ‘Login challenge’ - Turn off identity questions for 10 minutes after a suspicious attempt to sign in<br /><span> </span>Click <TURN OFF FOR 10 MIN><br /><span> Then try to log in as that user again.</span><br /></p><div><br /></div>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-48688475888082648912023-10-15T08:35:00.006-05:002023-10-15T08:35:59.141-05:00Azure Arc Setup<p>q: Customer called because they had a new Azure Arc Setup utility in their system tray.<br />a: This is apparently a server feature to be removed through Server Manager. Uncheck the box & don't forget to reboot when it finishes. <br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXEPKCF8PpdvUBlbvV7976BYZgOEco7bFcJjTq29OKsDPt4akjGmRqYI1ndWm6XaL_44xukWR4JRy30MRtoSoqRTP4rVTzi5xxT9K6epZEEXAJ2gri-vya_X7KKUtC3Yul5ciavF2mnamqJoTRj5Mjy5qZkWmUzttpSktVlkk0br2refEPAFmucxx721s/s544/202310-azure-arc-setup.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="235" data-original-width="544" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXEPKCF8PpdvUBlbvV7976BYZgOEco7bFcJjTq29OKsDPt4akjGmRqYI1ndWm6XaL_44xukWR4JRy30MRtoSoqRTP4rVTzi5xxT9K6epZEEXAJ2gri-vya_X7KKUtC3Yul5ciavF2mnamqJoTRj5Mjy5qZkWmUzttpSktVlkk0br2refEPAFmucxx721s/s320/202310-azure-arc-setup.png" width="320" /></a><br /></div><p></p><div class="separator" style="clear: both; text-align: left;">C:\Windows\AzureArcSetup\ArcSetup\AzureArcSetup.exe</div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: left;">C:\Windows\AzureArcSetup\Systray\AzureArcSysTray.exe</div><div style="text-align: left;"><br /></div></div><br />Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-10163003454172268512023-10-13T10:46:00.003-05:002023-10-13T10:56:56.259-05:00HOW TO - Curl from Task Scheduler in Windows<p>q: A customer requested to run a curl command on a regular schedule from a windows computer.<br /><br />a: Within Windows, create a Scheduled Task that runs as system, using Powershell and Invoke-WebRequest</p><p>General tab: Use the following user account: SYSTEM<br />Trigger tab: At system startup - After triggered, repeat every 5min<br />Action tab: Start a program - C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe <br />Add Arguments: "Invoke-WebRequest -uri '"https://www.google.com/"' -usebasicparsing"</p><p>notes: <br />a) running an invoke-webrequest as system fails without the trailing switch -usebasicparsing<br />b) we ended up putting the entire argument within double quotes and then the URL nested within double quotes inside single quotes - single quote, double quote, URL, double quote, single quote.</p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-83610343744421034122023-10-13T07:59:00.002-05:002023-10-13T07:59:38.417-05:00HOW TO - Scrape an old htm / html website<p>q: Customer called requesting a method to download their htm based website to their local computer.<br /><br />a: We recommended <a href="https://www.httrack.com/" target="_blank">HTTrack</a> - We tried a few different applications and none of them got every single site file. Some missed image files because they were configured as background images. HTTrack got every single file and folder. Download here: <a href="https://www.httrack.com/page/2/en/index.html">https://www.httrack.com/page/2/en/index.html</a><br />notes: <br />The application will rewrite an .htm site to all .html renaming files and updating hyperlinks.<br />The application will inject a line into each .html at the top and bottom of the file explaining that it was downloaded by httrack from the original URL.<br /><br />Wikipedia: HTTrack is a free and open-source Web crawler and offline browser, developed by Xavier Roche and licensed under the GNU General Public License Version 3. HTTrack allows users to download World Wide Web sites from the Internet to a local computer.</p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-41984133639298249582023-10-05T10:48:00.000-05:002023-10-05T10:48:04.030-05:00OneDrive 0x80070422 Something went wrong<p> q: Customer tried to sign into OneDrive and got a pop-up error. <br />Something went wrong<br />Please try again later<br />0x80070422<br />Send feedback<br /><br />We got this error within Microsoft Word as well.</p><p>a: We discovered the Microsoft Account Sign-in Assistant service was stopped & disabled.<br />We set it to automatic, started it, tried again & were prompted for the PIN associated with the account. </p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-15295033745391044332023-03-03T10:30:00.002-06:002023-03-03T10:30:29.166-06:00HOW TO - Search Windows Explorer for Folder Name<p> q: If you put a value in the search window it returns folders and files. How do you limit the results to ONLY folder names?</p><p>a: use this parameter in the Windows Explorer Search field to search for folders named testing:</p><p>kind:folder testing</p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-51710034305673367202022-10-25T14:54:00.003-05:002022-10-25T14:56:59.474-05:00Easy File Retention Enforcement<p></p><ol style="text-align: left;"><li>you have a folder d:\files, it has files in the root and in sub-folders</li><li>the first line will move all files over 90 days to d:\files\temp</li><li>the second line will delete d:\files\temp</li></ol><p></p><p>ROBOCOPY D:\files\ D:\files\temp /s /move /minage:90 </p><p>RD /S /Q D:\files\Temp</p><div><br /></div>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-44287303467235068112021-01-13T20:03:00.001-06:002021-01-13T20:03:12.109-06:00HOW TO - Audit MS SQL Sysadmin users<p>q: how can I query a Microsoft SQL Server to identify accounts granted the system level sysadmin role?</p><p><br /></p><p>a: try this script:</p><p><span id="docs-internal-guid-f33e242c-7fff-13cc-9dcc-536702df6e0e"><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">USE</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">master</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">GO</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">SELECT</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> p.name </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">AS</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> [loginname] ,</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">p.type ,</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">p.type_desc ,</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">p.is_disabled,</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">CONVERT</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">(</span><span style="background-color: #222222; color: #32aaee; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">VARCHAR</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">(</span><span style="background-color: #222222; color: #00cc66; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">10</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">),p.create_date ,</span><span style="background-color: #222222; color: #00cc66; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">101</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">) </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">AS</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> [created],</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">CONVERT</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">(</span><span style="background-color: #222222; color: #32aaee; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">VARCHAR</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">(</span><span style="background-color: #222222; color: #00cc66; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">10</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">),p.modify_date , </span><span style="background-color: #222222; color: #00cc66; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">101</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">) </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">AS</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> [</span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">update</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">]</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">FROM</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> sys.server_principals p</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">JOIN</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> sys.syslogins s </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">ON</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> p.sid = s.sid</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">WHERE</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> p.type_desc </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">IN</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> (</span><span style="background-color: #222222; color: #ffcc33; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">'SQL_LOGIN'</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">, </span><span style="background-color: #222222; color: #ffcc33; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">'WINDOWS_LOGIN'</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">, </span><span style="background-color: #222222; color: #ffcc33; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">'WINDOWS_GROUP'</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">)</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #444444; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">-- Logins that are not process logins</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">AND</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> p.name </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">NOT</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> </span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">LIKE</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> </span><span style="background-color: #222222; color: #ffcc33; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">'##%'</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #444444; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">-- Logins that are sysadmins</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">AND</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"> s.sysadmin = </span><span style="background-color: #222222; color: #00cc66; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">1</span><span style="background-color: #222222; color: #aaaaaa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;"><br /></span><span style="background-color: #222222; color: #6644aa; font-family: Consolas, sans-serif; font-size: 11pt; font-variant-east-asian: normal; font-variant-numeric: normal; vertical-align: baseline; white-space: pre-wrap;">GO</span></span></p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-47215319036922766522020-12-31T11:23:00.003-06:002020-12-31T11:23:13.768-06:00HOW TO - monitor a URL from CLI during a short outage<p> q: The customer rebooted a webserver and wanted to know how to monitor their URL so they would know when the server was back up. 10 years ago they would have used paping by Google but it does not seem to work anymore.</p><p>a: Nping. If you install <a href="https://nmap.org/" target="_blank">Nmap</a>, it includes the Nping utility. Open an elevated command prompt and run a command like this, replacing the URL and Port as needed. NOTE: It will open 100 connections to www.google.com over port 443 and display on the screen a SENT row and a RCVD row. When you start seeing RCVD rows, the site should be back up.</p><p>nping --tcp -c 100 www.google.com -p 443</p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-16730306391894127932020-12-29T16:22:00.002-06:002020-12-29T16:22:23.801-06:00HOW TO - Replace CR LR in a TXT file<p> q: The customer has a text file full of data, one value per row. They want them all in a single row separated by a comma.</p><p>a: Using Notepad++, click the Paragraph icon in the toolbar (this shows CR and LF at the end of each line). From the Menu click Search and Replace. Find what: \r\n replace with: , Then click Replace All. done!</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1J6l9cNyYdMPUwLK4CjiAsGRhmWBgR4fh8SlXglZWB9l-mrl0Y80OXZQ-Cxa1lMjfvlNRW6lTURKhN51NV7Kkod9byPNb9XLrhtTFODlpuGITmrcWGqoSyd6bK6UutMov7hAeAEIpVcs/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="166" data-original-width="410" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1J6l9cNyYdMPUwLK4CjiAsGRhmWBgR4fh8SlXglZWB9l-mrl0Y80OXZQ-Cxa1lMjfvlNRW6lTURKhN51NV7Kkod9byPNb9XLrhtTFODlpuGITmrcWGqoSyd6bK6UutMov7hAeAEIpVcs/" width="320" /></a></div><br /><br /><p></p>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-78516803932113285832020-07-14T16:46:00.002-05:002020-07-14T16:46:37.205-05:00HOW TO - lookup your external IP from command lineq: I am on a server with restricted browser security, how can I return my external IP address?<br />
a: Using OpenDNS's MYIP feature. Open a command line and run:<br />
nslookup myip.opendns.com. resolver1.opendns.comJeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-55643489582395346822020-06-16T12:11:00.000-05:002020-06-16T12:11:04.564-05:00Speed Testingq: How can I test my internet speed?<br />
a: There are a LOT of speed testing sites available now.<br />
<br />
Cloud Flare has one - <a href="https://speed.cloudflare.com/">https://speed.cloudflare.com/</a><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh91shLWf_gi3rGcsEWI9UKpP28JNhQmg4hbiveDWKATCHom2I0vDU9oC7S4Yb8IdbYpmTc9kbhiFUilb1fWW7NSySm9h1zz9BzeNGakuXmFrYNkkVSXVm7GO1GPCGOSnGhHhyphenhyphenMYi22nIQ/s1600/20200616-cloudflare.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="347" data-original-width="1058" height="130" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh91shLWf_gi3rGcsEWI9UKpP28JNhQmg4hbiveDWKATCHom2I0vDU9oC7S4Yb8IdbYpmTc9kbhiFUilb1fWW7NSySm9h1zz9BzeNGakuXmFrYNkkVSXVm7GO1GPCGOSnGhHhyphenhyphenMYi22nIQ/s400/20200616-cloudflare.png" width="400" /></a></div>
<br />
Netflix has one that focuses mostly on Download speed - <a href="https://fast.com/">https://fast.com/</a><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihjaH7sRtWUE4JyxeRJhtgS1B2kS46DF6WtL65fa3r8yUk-7d-3gKvXNUO30t5-QJEHw6HCHTSKv0zeDIS2RT04Ophw4RzpqxHiVj7zMHf_rx0cGNqxU3pU_lw8o7N-KtYwHGTNLgJEYY/s1600/20200616-netflix.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="445" data-original-width="651" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihjaH7sRtWUE4JyxeRJhtgS1B2kS46DF6WtL65fa3r8yUk-7d-3gKvXNUO30t5-QJEHw6HCHTSKv0zeDIS2RT04Ophw4RzpqxHiVj7zMHf_rx0cGNqxU3pU_lw8o7N-KtYwHGTNLgJEYY/s320/20200616-netflix.png" width="320" /></a></div>
<br />
Charter / Spectrum - <a href="https://www.spectrum.com/internet/speed-test">https://www.spectrum.com/internet/speed-test</a><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwLmSAxXuag1e1aJsrdCTiQLSEDrv4tsi8xS7deHrCrf9mMtLRkzpo05iT07iKLqm5Fpd6crgH9v0i5z2SJBmt8PfiiYvLsetAIsXuoSpT0Q0wYbFUHxkBp8amA4Yn6tJGzo13M3snrok/s1600/20200616-charter.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="241" data-original-width="560" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwLmSAxXuag1e1aJsrdCTiQLSEDrv4tsi8xS7deHrCrf9mMtLRkzpo05iT07iKLqm5Fpd6crgH9v0i5z2SJBmt8PfiiYvLsetAIsXuoSpT0Q0wYbFUHxkBp8amA4Yn6tJGzo13M3snrok/s320/20200616-charter.png" width="320" /></a></div>
<br />
The original by Ookla - <a href="https://www.speedtest.net/">https://www.speedtest.net/</a><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfCyG0SqdzKf5CvaTKZfFHqAbFfpW7aUmtvUv-QvQFhxYE_sNdcICkMkwa5OQp1Etl6qmCHbEzW9HEUSL8UX_B2vp2d1qRzoZoynLB4ZZWGFr7jIxfFqgeEicmw91JscYT_zw3l-QF2IM/s1600/20200616-speedtest.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="97" data-original-width="526" height="57" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfCyG0SqdzKf5CvaTKZfFHqAbFfpW7aUmtvUv-QvQFhxYE_sNdcICkMkwa5OQp1Etl6qmCHbEzW9HEUSL8UX_B2vp2d1qRzoZoynLB4ZZWGFr7jIxfFqgeEicmw91JscYT_zw3l-QF2IM/s320/20200616-speedtest.png" width="320" /></a></div>
<br />
You can even host your own - <a href="https://github.com/librespeed/speedtest">https://github.com/librespeed/speedtest</a><br />
<br />
<br />Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-2250618949173693162020-03-04T21:33:00.001-06:002020-03-04T21:33:36.090-06:00Temp email for receiving messagesq: What is the fastest way to receive email to a disposable account?<br />
<br />
a: If you have a Google/gmail account, it supports adding a plus sign then a descriptor between your name and the @ sign. And example would be yourname +bestbuy @ gmail.com for example (without spaces). Gmail will ignore anything after the plus sign and deliver it to your inbox, but you can sort/filter the messages by this custom recipient.<br />
<br />
Another alternative, completely protecting all of your email addresses, is a website called Temp Mail <a href="https://temp-mail.org/">https://temp-mail.org/</a> This amazing application will generate a Temporary Email Address and show you the inbox. This is great for testing email servers and email campaigns. When you close the site the email goes away. They also have an iOS app available here - <a href="https://apps.apple.com/us/app/temp-mail-temporary-email/id1214259095">https://apps.apple.com/us/app/temp-mail-temporary-email/id1214259095</a> <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQWpTDL1TQTa1Vmr-6POb7YJybmGKPyBjZFFZsJfd3ofbaExVFLOu2PWgwnpUaR3r7gJ3Crv5Fy8kSK5IoDjVeOFpy8BUWeDjLFmSJViq6Ydcjtu0ILCIXwItE6-UByfuQNAJd5L48M6E/s1600/20200304-temp-mail-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="274" data-original-width="572" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQWpTDL1TQTa1Vmr-6POb7YJybmGKPyBjZFFZsJfd3ofbaExVFLOu2PWgwnpUaR3r7gJ3Crv5Fy8kSK5IoDjVeOFpy8BUWeDjLFmSJViq6Ydcjtu0ILCIXwItE6-UByfuQNAJd5L48M6E/s320/20200304-temp-mail-1.png" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCfuD1hFSlOltnMcm-auvnIm8lGEsmmhaao-iZgkMvx1vi3Rxlly901aRCrfQ3rDwR-fHHmbkLGfJOA3CElOTovFyKtGBSKCRw4Qgui0IVy2zEFXjoHSNrlc3JeiQdUbChQbWd5XnXBNU/s1600/20200304-temp-mail-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="385" data-original-width="773" height="158" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCfuD1hFSlOltnMcm-auvnIm8lGEsmmhaao-iZgkMvx1vi3Rxlly901aRCrfQ3rDwR-fHHmbkLGfJOA3CElOTovFyKtGBSKCRw4Qgui0IVy2zEFXjoHSNrlc3JeiQdUbChQbWd5XnXBNU/s320/20200304-temp-mail-2.png" width="320" /></a></div>
<br />Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com1tag:blogger.com,1999:blog-2899935619829488294.post-30233448178690609462020-03-04T21:21:00.002-06:002020-03-04T21:22:39.886-06:00New Ad blocking extension for Chromeq: What is a good way to reduce ads and security concerns from within Chrome?<br />
<br />
a: We recently discovered uBlock Origin as a replacement for ABP, AdBlock Plus, etc.<br />
<a href="https://chrome.google.com/webstore/detail/ublock-origin/cjpalhdlnbpafiamejdnhcphjbkeiagm?hl=en">https://chrome.google.com/webstore/detail/ublock-origin/cjpalhdlnbpafiamejdnhcphjbkeiagm?hl=en</a><br />
We like the additional options and filter lists available.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKK5M1HMmYr7XJ6JGQwnCsHjuiosCfC0SfQMRTtNwl-9Ja-PGJnW6F-pBYKBBq5UXB7BPYuTWKqXc4s8yBDK-JkMGqY6RqUl0Ourg62bQJzEpaEdyrR2Ov31lxXS7UEb9caPjkop41EQU/s1600/20200304-ublock.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="556" data-original-width="509" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKK5M1HMmYr7XJ6JGQwnCsHjuiosCfC0SfQMRTtNwl-9Ja-PGJnW6F-pBYKBBq5UXB7BPYuTWKqXc4s8yBDK-JkMGqY6RqUl0Ourg62bQJzEpaEdyrR2Ov31lxXS7UEb9caPjkop41EQU/s400/20200304-ublock.png" width="365" /></a></div>
<br />
<br />Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-44160513484100713372020-01-30T23:50:00.003-06:002020-01-30T23:50:29.982-06:00Dell Laptop Windows Product KeyQ: We need to re-install the Windows Operating system on a Dell Latitude, but we cannot find the Windows Product Key sticker. Where is it?<br />
<br />
A: We found this on a Dell Support post:<br />
<br />
"The Product Key label, is situated in the battery compartment(for most of the laptops).. we would advise you to remove the battery and check.<br />
<br />
You can also check PC Settings, PC Info or activation wizard to check the product key."Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-86971039363961974172020-01-24T23:08:00.001-06:002020-02-04T11:04:05.587-06:00Best IPv6 Testing SiteQ: What is the best site to use for testing my IPv6 configuration?<br />
A: For a lightweight interface and quick results we like this site by <a href="https://twitter.com/testipv6com" target="_blank">@testipv6com</a><br />
<br />
<div style="text-align: center;">
<a href="https://test-ipv6.com/">https://test-ipv6.com/</a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjd7zNl3U6l_wEfgZhUXqNLKHbsF92NOpNml2PePkB_akWOeXsQf1B6uize8QywIUJhBbK1fmaRAzONP00mxC4-MMAO1RA1kg9E9_cPEztvnGNu9jP-XjQhGHsb3SSrwFywEIlg2GQKhRE/s1600/test-ipv6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="422" data-original-width="1026" height="131" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjd7zNl3U6l_wEfgZhUXqNLKHbsF92NOpNml2PePkB_akWOeXsQf1B6uize8QywIUJhBbK1fmaRAzONP00mxC4-MMAO1RA1kg9E9_cPEztvnGNu9jP-XjQhGHsb3SSrwFywEIlg2GQKhRE/s320/test-ipv6.png" width="320" /></a></div>
<br />Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-11653655266295543152019-05-14T08:06:00.000-05:002019-05-14T08:09:00.994-05:00Google Chrome is all darkq: What happened to Google Chrome? The address bar / omnibox is black instead of white and we do not have a theme installed.<br />
a: Microsoft released Light and Dark mode for Windows 10 and Chrome is inheriting it. Click Start, type dark mode, click 'Color Settings' from the search results, scroll to the bottom. Look for 'Choose your default app mode' and it is most likely set to (X) Dark mode. Click Light mode and Chrome will immediately switch back to white.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrTauc0cunvGeeMySgkimGwDdfK1GHihVQSBeybJLpZnhIe-Xqgj53wjds9e5F2NUrRnc2nu_smBjUzISTsHUx3GKbM-_izAz7Y0MPvSG_mNRmZkjmMILbMBb7JuvuE1mhHhogp9qgfw8/s1600/chrome-windows-dark-mode.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="137" data-original-width="262" height="167" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrTauc0cunvGeeMySgkimGwDdfK1GHihVQSBeybJLpZnhIe-Xqgj53wjds9e5F2NUrRnc2nu_smBjUzISTsHUx3GKbM-_izAz7Y0MPvSG_mNRmZkjmMILbMBb7JuvuE1mhHhogp9qgfw8/s320/chrome-windows-dark-mode.PNG" width="320" /></a></div>
Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-43550750979653679342018-04-02T15:17:00.000-05:002018-04-02T15:17:01.365-05:00HOW TO - Hash a file in Windowsq: The customer called and had two copies of a file. They wanted to identify if they matched exactly or not because the file dates were different.<br />
a: A simple hash should help with that.<br />
<br />
<ol>
<li>Open an elevated command prompt</li>
<li>Run this command</li>
<li>CertUtil -hashfile c:\path-to-file\filename.txt MD5</li>
<li>This will generate an MD5 of the file. Without the MD5 switch it will default to SHA1.</li>
<li>Run the same command on the other file and see if they match.</li>
</ol>
Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-49547105123277341032017-06-09T15:10:00.002-05:002017-06-09T15:10:58.340-05:00Windows 10 Upgrade can't resize windowq: Customer called saying they were clicking the middle button on the top right (restore / maximize) and it wasn't working.<br />
a: Windows 10 had recently upgraded the system and it was in Tablet mode. We clicked Tablet mode to disable it and everything went back to normal. NOTE: Most of the tray icons were missing and the desktop was the start menu open.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikp9y9aHX5DwN2vpHx40xjpbh8JY1JlBHbixavIJvvIIUT7212QbJX8g77m9FkxzZ5iVyNA963uv7CibXZgYkaXG4RHhL7VWaDObcRWJQt2ne7vStIj4wchx1ObwLyMlTClVAI2gn_jcg/s1600/20170609-cant-restore-resize-window-10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="245" data-original-width="351" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikp9y9aHX5DwN2vpHx40xjpbh8JY1JlBHbixavIJvvIIUT7212QbJX8g77m9FkxzZ5iVyNA963uv7CibXZgYkaXG4RHhL7VWaDObcRWJQt2ne7vStIj4wchx1ObwLyMlTClVAI2gn_jcg/s320/20170609-cant-restore-resize-window-10.png" width="320" /></a></div>
<br />Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-22799493861931704942017-03-17T20:39:00.004-05:002017-03-17T20:39:58.786-05:00Windows Server ftp.exe timesout q: When we're trying to use ftp.exe with Windows Server 2012 R2 it times out on this message:<br />
200 Port request OK.<br />
<div>
<br /></div>
<div>
a: We added c:\windows\system32\ftp.exe to the windows firewall and it immediately worked, since we did it while it was waiting.</div>
Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-63313766775227639462016-08-18T09:52:00.003-05:002016-08-18T09:52:29.525-05:00Primary Replica of SQL 2014 AlwaysOn Groupq: In SQL Server 2014, what is an easy way to determine which Availability Replica as the Primary Role (meaning they own the cluster at that time)?<br />
<br />
a: Here are two options. <br />
<i>' This command, returns all of the data in in sys.availability_replicas table:</i><br />
Select * from sys.availability_replicas;<br />
<br />
<i>' This query returns a single hostname if you're using an automated process to monitor the results.</i><br />
Select replica_server_name from sys.availability_replicas<br />
where owner_sid is not null;Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-63475176447420882852016-08-17T20:24:00.002-05:002016-08-17T20:24:22.887-05:00HOW TO - Establish a benchmarkQ: We have two computers and we want to determine which one is better/faster overall.<br />
A: We suggest running <a href="http://filehippo.com/download_novabench/" target="_blank">NovaBench</a> on each one then compare their NovaBench Score.<br />
<a href="http://filehippo.com/download_novabench/">http://filehippo.com/download_novabench/</a><br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhainr4u5_8qTH8B0oSkCxCMOowVOqvuos-DNToS-tiJduc7MGQqNB9DkisfVMM-GPO6DlKHsmZVAgG41AvbMC0MAjAzGGDCgqvq3c_fLkQiD-n-bI9rcvn3srY6B_VUCJWUgKMD5NP00Q/s1600/20160817-novabench.JPG" imageanchor="1"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhainr4u5_8qTH8B0oSkCxCMOowVOqvuos-DNToS-tiJduc7MGQqNB9DkisfVMM-GPO6DlKHsmZVAgG41AvbMC0MAjAzGGDCgqvq3c_fLkQiD-n-bI9rcvn3srY6B_VUCJWUgKMD5NP00Q/s1600/20160817-novabench.JPG" /></a>Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0tag:blogger.com,1999:blog-2899935619829488294.post-52096536002925595072016-08-05T13:37:00.000-05:002016-08-05T13:37:27.308-05:00Responsive HTML Photo Albumq: Customer called asking for a quick way to share photos with their users.<br />
It had to support folders/albums, and had to be responsive.<br />
<br />
a: KOKEN - http://koken.me/<br />
We were blown away by the ease of the deployment within their GoDaddy Hosting account.<br />
We were able to turn off some features (Essays, Timeline, etc).Jeff Kykerhttp://www.blogger.com/profile/02056984842353578755noreply@blogger.com0