Excel Tip: Helpful Keyboard Shortcuts

It has been a while since my last post because I’ve been pretty busy with LBC, but I thought I’d throw together a quick note on some helpful shortcuts in Excel. Excel is a great tool for working with spreadsheets. If you work with it every day, you know that it’s not perfect (ahem, date handling) but it has a lot of very powerful features for working with data. There’s even an online version if you have a Microsoft account.

Read the rest of this entry »

Windows 10 Announced – New Features Abound

Windows 10 New Start Menu

Today, Microsoft announced Windows 10. In addition to the offline media conference and blog post, they also released a video discussing the Windows 10 Tech Preview which highlights some of the new features.

The video features Joe Belfiore, the Vice President of Windows at Microsoft, with a trendy, hip haircut (Is that really his hair?), trying to explain to people that this is essentially a beta test and not to be treated like the final product. He then goes on to show some of the new features in Windows 10. I’m pretty excited about this so I thought I’d outline a few here.

The video and feature details are in the full post, so click on!

Read the rest of this entry »

Enable or Disable Torrent / P2P Traffic in IPFire

IPFire P2P Protocol List

If you’re a geek like me, you may already be using IPFire as your main router software. It’s pretty powerful and allows you total control over your network. I recently had some troubles with it blocking my torrent traffic, so I thought I’d share the quick fix for enabling/disabling torrent and other P2P networks.

Read the rest of this entry »

Remotely List and Disconnect Users in Windows

Remotely List and Disconnect Users

If you’ve ever had to connect to a server via remote desktop and got a message stating “The Terminal Server has exceeded the maximum number of connections.” Then you know how I feel whenever I see this. It’s a pain because in order to log them off, you need to log in yourself. Or do you?

Read the rest of this entry »

Git + Stash: Set up Self-Signed SSL Certificate in Windows

Trusted SSL Certificate in a Browser

As I mentioned in a recent post that I use Atlassian Stash to manage my git repositories. It has some great features especially when it comes to setting up user permissions. It also integrates with JIRA and SourceTree since they’re also Atlassian products.

I wanted to be able to use my repositories while I was on the go so, naturally, I wanted the transmission to be encrypted HTTPS/SSL. Stash uses an Apache Tomcat server to serve up both the admin pages and the repositories themselves. It’s not totally clear on how to set up a self-signed SSL certificate on Windows (their documentation focuses on Mac’s, mostly) and there are a couple issues that they don’t even discuss.

This post covers how I generated the certificate, got Windows to trust it and set up git so that it could connect to both my Stash server, and externally hosted servers such as github.

Let’s get to it.

Read the rest of this entry »

Latest Posts

Post Calendar

July 2024