LTRIM and RTRIM not removing white space
I was writing a query today and came across a set of data with an annoying leading space. Or what I thought was a leading space. My first instinct was to throw this around my field: LTRIM(RTRIM([SKU])) But the space was still there. OMGWTFBBQ! After a bit of googling, I started to wonder if this […]
Soft links, hard links, junctions, oh my! Symlinks on Windows, a how-to.
First, a quick definition of terms. There are three kinds of ”symlinks” on Windows. soft links (also called symlinks, or symbolic links) hard links junctions (a type of soft link only for directories) Soft links can be created for files or directories. Hard links can only be created for files. Both soft and hard links […]
Tableau Software and the New BI
What do Tableau Software, Business Intelligence and User Experience have in common? Combined, they represent the New Age of Data. More specifically, they push data visualization, data personalization and data emergence to higher levels of understanding. At the present moment, we are seeing a massive cultural shift in how we understand our corporate data, industrial […]
Fun with Cutting/Pasting
Hello from 25,000ft! Today I’m en route to Louisville, Kentucky, but yesterday I had a blast running the Warrior Dash along with 15-20 of the InterWorks crew. We all had a great time in the mud, and while we’re not necessarily out to win, everyone inevitably wonders how they stacked up, so here’s a quick […]
Troubleshooting intermittent SonicWALL SSO issues
I recently had a client who had received some new Dell computers with NVidia cards. The users were able to get authenticated and out through their proper CFS policy settings using their SSO Group membership in the SonicWALL. Then the users would randomly drop for a while and when we tried to troubleshoot it they […]
ESET NOD32 AV4 POP3, HTTP Error and Client Reinstall Problems
I recently ran into an issue on a computer that had ESET NOD32, with an error message for being unable to scan POP3 or HTTP. During the troubleshooting process for this error we uninstalled the client and tried to re-install it. We ran into issues saying that there was another installation already in progress and […]
Teach Yourself Guitar with Tableau
Creating visualizations in Tableau that are out of the ordinary are always fun. If you visit the Visual Gallery at Tableau’s website you can see great examples of this. My personal favorite is “An Analysis with Teeth” Like the analysis with teeth, I leveraged the Pages feature in Tableau to build a visualization that you […]
Creating Calendar Views in Tableau
On the walls, in our emails, or on our desks, the calendar is everywhere. We use calendars to book events or meetings, remember birthdays, verify bandwidth for client coverage, etc… Making something that looks like a calendar in Tableau is as simple as putting the right pieces on the correct shelves. If you have a […]
Display public facebook posts on your website
A straightforward way to get your facebook public posts onto another website without requiring your guests to have a facebook account. Log into the facebook account you want to display the posts of Go to https://developers.facebook.com/apps, it will ask you for your password again On the top right of the next screen, click on the […]
Outlook 2010 Additional Mailbox Will Not Close
Overview This article describes how to close a mailbox out of Outlook by removing it from: Removing it from the Outlook interface by adjusting your mail settings How to identify and remove the related registry entry. Summary I recently ran across an issue where I could not remove a mailbox from my Outlook profile. For […]