SQL Server: Current Date Function

Need the current date in your SQL statement? The GETDATE() function is what you're looking for. For example, if you're writing a SELECT statement and you'd like to only return those records in which the field EventDate is in the past, you can write:

WHERE EventDate < GETDATE()
Read More

Surviving Online University

Doing a university degree online isn't easy, but I've found that there are some things that you can do to improve the experience overall. Here are some tips for getting the most out of your online studies, based on the time that I spent earning my undergraduate degree in computing.

Make a weekly schedule and stick to it.
It's great having flexibility in terms of when you want to study, but set yourself some goals to accomplish each week. If your school doesn't have specific deadlines for assignments, set some for yourself and stick to them as though they weren't arbitrary. This will help you to stay on track so that you don't suddenly find yourself with a ton of work to do right at the end.

Take notes (yes - on paper)!
This might sound old-fashioned or just plain crazy, but trust me when I say that there is something to be gained when you write out notes on a piece of paper. Even if you don't plan on reading them again, you will find it easier to remember what you're learning if you write it down. Scientific American has an interesting article that explains the science behind this..

Take advantage of message boards and online student communities.
Just because you're studying over the Internet doesn't mean that you have to be isolated. Look for fellow students through your school's web site and through other social media channels. It's great having support from other people, even if it's just to commiserate with them while you're gearing up for a stressful exam. Some schools even organize in-person events in different cities where students can meet.

Change up the scenery a bit.
Studying in your pyjamas at home can be super cozy but I recommend heading out and studying in some different places every now and then. There can be lots of distractions at home and you just might find it easier to get into the right frame of mind for working if you go somewhere like a public library. I used to enjoy studying at local university campuses for this reason.

Don't be afraid to get external help.
One thing that non-online students might take for granted is the amount of assistance that you can get from fellow students. Sometimes it can be tricky studying alone and you need someone to talk to about a particular subject. Whether it's chatting with a friend about some readings or hiring a tutor to get help with some difficult homework problems, I suggest seeking out other people for help when you need it.

Keep track of your progress.
Sometimes graduation can feel like an unreachable goal, especially if you choose to study on a part-time basis while you work a full-time job. I found it really satisfying to keep a list of all of the courses I was going to take and to cross them off as I finished them. Marking that last course as complete after I wrote my last exam was an amazing feeling.

Talk about your experience during job interviews.
An interesting part about studying online is that it demonstrates a certain set of skills that are attractive to employers. While you might be battling the stigma that is sometimes associated with pursuing a degree through distance education, tell interviewers about how you've managed to balance work from multiple courses without having anyone push you along in-person. Talk about how you're able to effectively manage your time and succeed in your studies despite having distractions at home. Finally, explain to them your success at proctored examinations. This helps to clear up the common misconception that online students do absolutely everything online and that their skills are never truly tested.

And there you have it! As always, feel free to leave a comment here or send me an e-mail if you have any questions.
Read More