I stumbled across an interesting article about how your digital life will follow you whether you want it to or not. (Read: I Called Off My Wedding. The Internet Will Never Forget). My rule has always been, be mindful of what you post; assume that everyone will read it and that it will exist forever. … Continue reading The Internet: friend or foe?
Have you ever needed to find a free IP address in a given range? Or, have you ever needed to find out which IP addresses in a range are in use? Sure, you can type a bunch of PING commands and note the results. Or, you can loop it...
In her commentary on speech recognition software ("Speech Recognition Tech Is Yet Another Example of Bias", Scientific American, Oct 2020), author Claudia Lopez-Llorenda derides the limits of technology because of her need to alter her speech pattern to a non-accented version of her own voice in order to be recognized fluently. In her words, "[changing] … Continue reading Limitations of technology and resources are not “inherently cruel”
After all these years, users still love their drive letters. And inevitably, I still hear the complaint, "My X: drive has disappeared!" Which makes me wonder a few things. What does the X: drive point to?Why are we still using drive letters? It's not my place to change the world, but we can make it … Continue reading Create a Windows shortcut to map and open a network drive
Sometimes, you work within the constraints of an existing application, trying to change as little as possible. So when a client had a very simple (two field) form, that showed up as a Bootstrap modal, and I needed to make sure the user didn't click the submit button until they filled out all the fields, … Continue reading Simple required field validation using jQuery
You've had your existing application running for years, relying on DEFAULT constraints to set DATETIME fields to the current date using GETDATE(). Everything was great until you migrated to Azure SQL Database - and realized that your SQL Server is now set to UTC, and you can't change it. Fortunately, you can change your DEFAULT … Continue reading Specifying time zone in SQL DATETIME DEFAULTs
Windows (and, it seems, Microsoft in general) does not like filenames that start with a space. You can't even create them in Windows Explorer -- go ahead and try! If you start the name of a file or folder with a space, Windows will remove the space for you -- automatically. Frustrating, eh? Regardless, there's … Continue reading OneDrive sync fails because filename starts with a space
While working with DropBox today, I created shared links to a file, and the links looked like this: https://www.dropbox.com/s/abcxyz123/filename.zip?dl=0 This link goes to a nice DropBox web page that provides a lot of information -- information that would confuse a less-sophisticated user. Why can't we just get them right to the download? You can. In … Continue reading Force a direct download from a shared DropBox file
Exception handling in .Net (and other languages) is very powerful - and I've often seen it misused. Here are my six rules for exception handling. Always have a global exception handler to catch, report, and re-throw unhandled exceptions in your code. Always be sure to include the stack trace in your exception report. The easy way to … Continue reading Six rules for effective exception handling
All databases on one SQL instance shares only one tempdb. System internal processing (such as sorting) also uses tempdb. Excessive usage of temporary tables incurs heavy traffic to tempdb and the underlying disc I/O. Consider the following when using temporary tables. Creating temp tables and then dropping them incurs system overhead and unnecessary disc I/Os. It is … Continue reading MSSQL’s tempdb and performance