Category: Howto

The Content of the Weekly Review and Planning

I’ve kept the habit of the Weekly Review and Planning for a good while now and for the most part have not changed it that much. It’s a solid habit from which I’ve benefited greatly. If you haven’t started this habit I highly recommend that you consider it for...
Read More

Set Boundaries with Your Time and Money

This post is part of the series The Best Tools and Techniques for Winning at Business and Life The Habits TIME BLOCKING The Covey organization does a fabulous job of describing life as boulders, rocks, pebbles, and sand. You’ve likely heard the analogy a dozen different ways, but it goes...
Read More

How to Round Up by Quarter Hour in T-SQL

If life should ever punish you by challenging you to round up decimals by a quarter of an hour – always up and never down – here’s a liferaft In a scenario where you wish for 2.04 to be rounded up to 2.25 instead of down to 2.00: [crayon-5d5f343118480200821434/]...
Read More

Weekly Review and Planning

This post is part of the series The Best Tools and Techniques for Winning at Business and Life For the past year I’ve kept a habit that has helped me significantly to grow professionally and to be more productive.  That habit is what I call the weekly review and planning pause.  This simple,...
Read More

Web Presence 101

I originally created this page because my sister asked me about creating a website, and it occurred to me that is considerably easier than many people realize, and is getting simpler every day.  Things have changed for the better since I published this post originally in 2010, so today...
Read More

T-SQL Query For Beginning And End of Any Month

I’ve used this technique many times to help grab the beginning and end of a month. It’s useful for queries where you need to use a BETWEEN. [crayon-5d5f34311a40f145007618/] Sample usage: [crayon-5d5f34311a41e775005567/] I hope this is helpful to you in your querying adventures. Got another way to accomplish the task?...
Read More

How To Write Better SQL Queries

Podcast: Play in new window | DownloadSubscribe: Android | RSSIn this audio session we talk about how strategic query formation can help you get exactly the information you’re looking for with a minimal amount of work Here’s a video of the technique I describe in the recording Key points...
Read More

An Often Overlooked Way to Protect Against Computer Crashes

There are tons of great applications and tools to help protect your PC from disastrous operating system failures, but I’d like to highlight one very simple way to protect your critical data in the event of a PC crash.  This solution won’t protect you from a hard drive failure...
Read More

Playing with oAuth on .NET web forms app

        Today is a day off for me… but i’m kind of geeking out the last couple of hours.  Got a call a little after 6am and one of the servers i manage was having an issue, so i coaxed it to life so my teammate...
Read More

Simple DIY: Create a Website Using WordPress

Many people in my circle have recently become interested in making a blog or website, so a few weeks ago I set out to document the process.  This is the second of two posts on the subject.  The first is geared toward those who are looking to quickly and...
Read More