I’ve seen the implicit conversion issue in SSMS while looking over query execution plans and I found this blog about the topic: Are VARCHAR or CHAR Hurting Your Performance Due To Implicit Conversions? The developer’s […]
I ran across a question on StackOverflow, I did not understand the full scope of the question; however, I added my answer. We run into situations when migrating data when there is a table that […]
A question came across today regarding the Window’s Title caption not displaying the file name when viewing a PDF. Doing some hands-on investigating, I found these examples: PDF Properties Title Set (Tagged) I have this […]
Windows Mobile Device Center (WMDC) 6.1 may experience difficulty running on PCs using Windows 10. Connecting the Datalogic device may not cause WMDC to start and ActiveSync communications will not work. The following troubleshooting steps can be used to get WMDC working correctly.
In .Net we are familiar with Try/Catch blocks and you can do this in SQL Server running SQL transactions as well with the additional benefit of “undoing” what was started if something were to fail […]
1. Download and Install the PuTTY software https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html 2. Configure PuTTY to connect to the COM Port Source: http://www.chipkin.com/using-putty-for-serial-com-connections-hyperterminal-replacement/ Figure out the COM port number (if using a virtual serial port, look in Device Manager to […]
Even though Microsoft no longer supports WMDC you can install the software on Windows 8 or 10 to communicate with the remote barcode devices. 1. Download WMDC for 32-bit or 64-bit based on the […]
I wanted to produce a list of all the following functions calls in order to get a list of the parameters to cross-check the setting exists in the database: For Example: The function name: GetSetting […]
