The Content of the Weekly Review and Planning

The Content of the Weekly Review and Planning

Howto, Self-help
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 yourself. The content hasn't so much changed for me as it has matured.  The basic idea here is taking 15 to 30 minutes to step back from the work and consider the impact you're having. Did you accomplish what you set out to do this week?  Were you effective in communicating with your team?  Do you need to make any adjustments next week?  Do you need to seize the opportunity to reach out and tell someone thanks for a great job?…
Read More
Set Boundaries with Your Time and Money

Set Boundaries with Your Time and Money

Howto, Self-help, Technology
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 something like this. Picture your life as a jar and things to do like things you put inside the jar. Fill the jar halfway with sand then try putting in 20 large rocks and you’ll run out of jar before your run out of rocks. Start with the rocks, however, and you’ll find that the sand just finds a place to live inside the jar. It’s a great analogy for life. If we prioritize the things that are most important, the…
Read More

How to Round Up by Quarter Hour in T-SQL

Howto, Technology
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-5bf08753de473265541776/] This solution is based on the solution posted in 2001 on VBForums - props to original poster MartinLiss! http://www.vbforums.com/showthread.php?64997-Rounding-to-nearest-25&s=c6a62b3deef741b3d7aaf8d10e8a9032&p=292208&viewfull=1#post292208  
Read More
Weekly Review and Planning

Weekly Review and Planning

Howto, Self-help, Technology
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, 30 minute appointment is on my calendar toward the end of each week for the purpose of helping me assess what I did, whether or not I'm proud of what I did, and what I'm going to do next week to do as well as or better than I did this week. The goods with this one are in the repetition.  A wise guy once said to me "perfect practice makes for perfect performance," and I believe it.  What we practice…
Read More
Web Presence 101

Web Presence 101

Howto, Technology
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 it gets a refresh.  Let's get started. Today's guide will get you up and running with a web presence so that all you have to do is remember to add content.  I hope you find this guide helpful. Please let me know by posting a comment at the end of the post. Name your brand.  It can be your personal name, your company, an idea... really anything goes.  The most important thing to do here is to choose something that doesn't…
Read More
T-SQL Query For Beginning And End of Any Month

T-SQL Query For Beginning And End of Any Month

Howto, Technology
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-5bf08753dfd52379715967/] Sample usage: [crayon-5bf08753dfd62335700822/] I hope this is helpful to you in your querying adventures. Got another way to accomplish the task? I'd love to hear from you. Post a comment below.
Read More
How To Write Better SQL Queries

How To Write Better SQL Queries

Howto, Technology
[powerpress]http://www.darrentaff.com/wp-content/uploads/2014/07/How-To-Write-Better-SQL-Queries.m4a[/powerpress] In 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 http://www.youtube.com/watch?v=OFDMUdj0xCg Key points from this lesson: Start with the end in mind Alias the tables Let SSMS do the heavy lifting Start With The End In Mind What is the main body of information we wish to find?  Where does that information live in the database?  This is the table we're going to query first.  All other data we use to enhance the dataset will appear in the form of joins, subqueries, and all the usual suspects.  Starting with the FROM portion of the query will get things set up so…
Read More
An Often Overlooked Way to Protect Against Computer Crashes

An Often Overlooked Way to Protect Against Computer Crashes

Howto, Products I Love, Technology
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 -- you'll need other tools for that -- but what we're talking about here will make it significantly simpler to recover in the event something goes wrong with Windows.  There are similar techniques available for Mac OS, but in this post we'll only be covering Windows. Keep Your Information Separate That's the secret.  I suggest creating a partition on your hard drive to store your critical data.  The system files run in one place, and your information stays in another.  That way…
Read More
Playing with oAuth on .NET web forms app

Playing with oAuth on .NET web forms app

Howto, Technology
        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 could get some work done.  no big.  didn't take long.  back on track for the morning. saw the wife and kids off to school and work as i from the cup of joe my wife had so lovingly delivered to me just moments earlier, and thought, well since the laptop is already fired up and connected to the vpn... why not tinker just a bit with oAuth. Why not indeed.  This was magical.  within minutes our little starter app was connected…
Read More

Simple DIY: Create a Website Using WordPress

Howto
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 easily set up a personal blog to share experiences or advice.  This post is directed toward those who want to use the simplicity of a powerful blog format to help them easily create a website for their business or organization.  Let's get started. For this project we'll be using WordPress.com. The first step is to pick a name for your blog.  Just like the first post I have chosen Bullfrog Song. Success!  The name I want is available.  Save it using…
Read More