A blog about curiosity being a good habit
Here’s a simple script to add a random string to a SQL Update: update <dbname>set <field> = (SELECT SUBSTRING(CONVERT(VARCHAR(40), NEWID()),0,9)) This will update each row with a distinct 8 alphanumeric characters, e.g. C2552926 Breaking this down in terms of functionality: NEWID() – generates a UUID VARCHAR(40) – tells CONVERT() what string data type, max len… Continue reading Add random string to a field using SQL Update
No, some poor suckers are still using this overpriced and difficult to automate “Rapid Application Development” Java based platform. Don’t get me wrong, CF’s genius is in it’s ability to write some pretty simplistic markup code to create a form and CRUD. It has always been good at that. But is it worth the cost… Continue reading Is Adobe ColdFusion Dead?
Use Get-Content and Get-Item in Powershell Looking for the tail command on Windows? Get-Content will do the trick. Here’s a link to the command page. Open PowerShell: Show the last line/s: Get-Content C:\inetpub\logs\LogFiles\W3SVC1\u_ex200711.log -Tail 1 Or use get-item Get-Item -Path .\LineNumbers.txt | Get-Content -Tail 1 Stream the file like tail -f Get-Content path-to-file -wait Example:… Continue reading Linux tail -f replacement on Windows
This might work on Ubuntu 18, as well, but I have not tested it. Also, there is no official build release for it. You might need to compile it on your own. Note: if you are getting the “GLIBC_2.7′ not found” error, it could be that you need to uninstall and then reinstall a specific… Continue reading How to install WKHTMLTOPDF 0.12.1.4 on Ubuntu 16 Xenial
View all ports in use Get-NetTCPConnection | ? {$_.State -eq “Listen”} | sort LocalPort -Descending
Use this query in SQL Management Studio to directly search the Full Text Search index. select * from sys.dm_fts_parser(‘”search term”‘, 1033, NULL, 0) Note that there are upcoming changes to FTI, including many deprecated functions, so if you’re using it extensively you probably have some work to do.
I just did a fresh install of CentOS 6.10 today and needed to install PHP. It had been a while, so I needed a refresher. Note: PHP 5.6 is pretty much End Of Life, so you should be installing PHP 7.2, or higher at this point in time. That said, sometimes you have to support… Continue reading How to install PHP 5.6 on CentOS 6.10
Windows is slowly, but surely, catching up to the hundreds of useful utilities for reading file content that *nix have had for forever. As you know, opening a 1 gig log file in notepad is impossible. Even using Notepad++, which can open some pretty large files, will not open a 1 gig file. Thank you,… Continue reading How to use Tail in Windows Powershell
You’ve installed Vagrant and run vagrant up and then vagrant ssh successfully. You then start VirtualBox Manager and it shows that it is powered off: In order to see the actual status, press SHIFT then right-click on the icon for Virtual Box, then click Run as Administrator You will see that it reports the VM… Continue reading Vagrant status is “running” but VirtualBox shows “Powered Off” Windows 10
Microsoft Windows Powershell is a very useful tool that brought some sanity to managing Windows outside the GUI. To find the version you are running, open Powershell, paste and hit enter: $PSVersionTable.PSVersion Result: Windows PowerShell Copyright (C) 2015 Microsoft Corporation. All rights reserved. PS C:\Users\username> $PSVersionTable.PSVersion Major Minor Build Revision —– —– —– ——– 5 0… Continue reading How to get what version of Powershell you are using