In this video demo I'm going to show you how concatenate strings, as well as the functions LEFT, MID, RIGHT, FIND, TRIM, and LEN, and then how to use them together to get what it is you're looking for. At the end of the demo, we'll touch on the IF function and show you how you can manipulate the table based on some set …

I was fortunate enough this year to be able to take a considerable amount of time off and explore some absolutely stunning regions in Europe. This wasn't one of those "disconnect from the world" trips, however. While I did remove my office mail profile, Microsoft Lync, and my work OneDrive from my phone, I still stayed …

I wrote the following PowerShell script so that I could easily watch my GPO changes replicate around the globe, letting me know when I could have someone at a specific site update policy when new policies or changes were rolled out. To use, just replace $gpoGUID = "{12345678-1234-5678-9123-ABCDEFEDCBA0}" with the GUID …

After upgrading to Windows 10, all of my VMWare Professional v10.x guest machines lost their connection to the network. Taking a look at their network connections, I found that I'd lost the default vmnet0 network, and trying to add it back as a bridged network threw the error "There are no un-bridged host network …

Just shy of a week ago, a few days after Microsoft released Windows 10 to the public, I downloaded and installed it. I had run some pre-release versions in Virtual Machines and on a test laptop over the last few months, but this was my first venture into upgrading with my everyday machine, and the one I'm writing from …

WinDirStat, by the company of either the same name or of no name, is in my opinion one of the best tools for quickly understanding where all the space on your hard disk has gone. After scanning your disk, it graphically reports back to you a Windows Explorer like view of your directory structure sorted by space …

When I purchased my first Sonos device back in 2012, I had been looking for something like this system for at months. I didn't seem to think that my requirements were that out of the ordinary, but I had a hard time finding something that met all my needs at a price that I considered reasonable. What I'm looking for is …

While using shared Google calendars is great way to keep yourself, your family, or your groups organized, they lack any type or real auditing at the event level. Specifically, I often need to find out when an event was created or modified. While this isn't available today through the GUI, it is available under the …

I recently wrote the following SQL Query to help identify which browsers are installed across our environment. A straight Add/Remove Programs (v_AddRemovePrograms) query didn't really return the data in such a way that made it easy to determine major version of Firefox or Chrome, and doesn't include Internet Explorer …

I frequently use this trick to manage collections of computers in SCCM where the original list comes from Excel, or from a query of another system that I can dump into Excel. Doing it this way, you don't have to rely on adding computers one at a time to a collection query or dumping systems into tools like the the …