Moving Data from Teradata to SQL Server
Update – December 2016 I wrote this article back in 2013, based on my current experiences working between SQL Server & Teradata. With the benefit of time (and learning more!), there are probably better ways I could have achieved what I’ve outlined below. Most notably using Integration Services. That said, it was a good learning experience,
Finding the Difference Between Two Dates in SQL
In this post, I’m going to talk about finding the difference between 2 dates in SQL. However, I’m going to cover it across multiple applications. The Problem Statement is simple: How many days are there between two dates? What we want is an integer value back of how many days there are. The solution will
Quick Way to Look Up Contacts in Outlook
This post will cover a small, but really useful feature in Outlook (2010+, poss 2007). Ever been reading an email, seen someone’s name mentioned, and wondered who they were? Sure, you could type their name into the Address Book, it doesn’t take long. But, there is an even quicker way. Highlight the name. Right Click,
Inline-Replies, and Why Outlook 2013 Has Gone Blue
For many years, Office has followed a consistent colour scheme for its applications – Blue for Word, Green for Excel, Red/Pink for Access etc. And Outlook was always a yellow/orange colour. 2010 & 2007 2003 2000 ’95 Well, you get the idea. And the application itself would also follow this same yellow hue.
Boot to the Desktop with Windows 8.1
As mentioned in my previous post, I’m playing around with the Windows 8.1 Preview. One of the other minor, yet significant, changes made, is the ability to boot directly to the desktop, rather than to the Start Screen we previously had to go through. The location of this option isn’t obvious though, but easy enough
Site Changes
I’ve had great fun getting this Blog up & running – both in terms of the technical side of setting it all up, and writing all the posts. I’ve made a few tweaks to the site, to allow greater participation and sharing (after all, that’s what it’s all about!) As promised, you can now subscribe
Optimise Your Outlook Panes Layout
Outlook is a great, powerful email Client – especially when hooked up to Exchange within a corporation – everything integrates very well. However, it’s easy for Outlook to get very cluttered with various panes for one thing of another – particularly if you’re using a laptop / small screen / low-res screen. This post will
Showing the Desktop in Windows 7 & 8
Another simple one today In Windows XP (whilst that may sound like ‘a long time ago’, there are still a lot of corporations using, or not long moved away from, XP), you will have likely had a little icon in your Quick Launch which, when clicked, would minimize all your applications to show you your
Using Excel Sparkline Charts
Sorry for yet another Excel post – what can I say? I like Excel! Another feature introduced with Excel 2010, is Sparklines / Spark Charts There are tiny charts that sit inside a cell, and used to show trend data for many areas at once. They’re simple to use, and helps visualize your trend data.