Why I Don't Like Infographics
For almost 6 years, one of my primary roles at work has been data visualization. I like data visualization for a lot of reasons, but the primary reason is because if done right, the end user will actually look at the data, think about the data, and use the data. One form of data visualization that I have tried to not hate is the ever-more common "Infographic." To be fair, I have seen good infographics but they are few and far between. So rare in fact, that I can't even find one that I liked again. Bummer.
2013 - Year In Review
Well, it's almost the end of the year and I want to recap some of what I have done and learned. Since I didn't have a blog at this time last year, I can't say that I did or didn't do what I said I was or wasn't going to do. So, I'll just go over a few highlights that come to mind quickly.
Using SYSTEM_USER to Filter Data
In this post I want to show a cool trick I discovered recently that has made my life much easier. I build a lot of database systems with SQL server holding the data and a variety of technologies used for the front-end interface, mainly MS Access (unfortunately!). Sometimes I have a need to filter the data based on who is viewing it, and using SYSTEM_USER has made this much easier with just a little bit of prep work. The system I'm building right now will be used to distribute surveys to our call centers so their employees can call the appropriate people with this survey.
Before getting into the details, let's see what SYSTEM_USER actually does:
The above screenshot shows the domain (one of my development VMs) followed by a slash ( \ ) and the username I log in with. Because we use Windows Authentication with Active Directory, I assume this is fairly hard to bypass but I do not know that for certain. Regardless, it's much more secure than putting the similar code inside VBA in Access where anyone with a clue can fiddle with it. Alright... now to the real work...
Long Road - My Site Backup Process
Warning: This post is outdated. It is here for reference purposes only.
This post is part of the series Long Road to the Right Solution and gives an overview of how I have setup our backup collection process for all client sites.
Distractions At Work
At 3:00 PM today I finally started my music and put on my headphones. That is not normal for me, but was a casualty of the office environment today.
Mastodon