Archives
All published articles since 2003
Australian Post Codes
Wednesday, 1 July 2026
A free, public domain database of Australian post codes and geo data, collated from public sources and the community. XLS, XLSX, JSON, CSV, XML. Includes Long/Lat and over 18,000 entries.
New Zealand Post Codes
Wednesday, 1 July 2026
A free, public domain database of New Zealand post codes and geo data, collated from public sources and the community. XLS, XLSX, JSON, CSV, XML. Includes Longitude and Latitude values.
Worldwide City Data
Saturday, 28 August 2021
Downloadable world cities databases. Includes latitude, longitude, province, country and and more. CSV Format.
SQL Tips #41 - Listing the Restore Progress of Databases
Wednesday, 23 October 2019
SQL Tips #40 - Finding Queries with Missing Indexes in the Query Store
Saturday, 21 September 2019
SQL Tips #39 - Listing All Keys in a Database
Tuesday, 20 August 2019
SQL Tips #38 - Finding All Dependencies of a Stored Procedure
Friday, 19 July 2019
SQL Tips #37 - Listing All Stored Procedures Using a Specific Table
Monday, 17 June 2019
SQL Tips #36 - Listing All Stored Procedures or Tables
Thursday, 16 May 2019
SQL Tips #35 - Finding Tables with Missing Identity Fields
Sunday, 14 April 2019
SQL Tips #34 - Finding Tables with Missing Primary Keys
Wednesday, 13 March 2019
SQL Tips #33 - Generating a Comma Separated List of Fields per Table
Saturday, 9 February 2019
SQL Tips #32 - Listing Recent Deadlock Victims
Tuesday, 8 January 2019
SQL Tips #31 - Deleting Duplicate Entries While Keeping the Original
Friday, 7 December 2018
SQL Tips #30 - Listing Databases and Their CPU Usage
Monday, 5 November 2018
SQL Tips #29 - A Function to Generate Random Numbers
Thursday, 4 October 2018
SQL Tips #28 - Generating Random Numbers for Non-Crypto Usage
Sunday, 2 September 2018
SQL Tips #27 - Finding Which Indexes Are Not Used
Wednesday, 1 August 2018
SQL Tips #26 - Getting the Field Types of Fields in a Table
Saturday, 30 June 2018
SQL Tips #25 - Rebuilding All Fragmented Table Indexes
Tuesday, 29 May 2018
SQL Tips #24 - Listing All Indexes and Their Fragmentation Percentage
Friday, 27 April 2018
SQL Tips #23 - A Function to Strip Numeric Characters
Monday, 26 March 2018
SQL Tips #22 - A Function to Split a String
Thursday, 22 February 2018
SQL Tips #21 - Listing All Table Columns and Their Default Values
Sunday, 21 January 2018
SQL Tips #20 - Showing All Table Data for a Specified User
Wednesday, 20 December 2017
SQL Tips #19 - Listing All SQL Jobs on the Server
Saturday, 18 November 2017
SQL Tips #18 - Listing All Tables Without Any Indexes
Tuesday, 17 October 2017
SQL Tips #17 - Table Row Counts and Sizes in Gb
Friday, 15 September 2017
SQL Tips #16 - Looping Through Records using Cursors
Monday, 14 August 2017
SQL Tips #15 - How to use Coalesce
Thursday, 13 July 2017
SQL Tips #14 - Clearing the Query Store
Sunday, 11 June 2017
SQL Tips #13 - Finding the Domain from an Email Address
Wednesday, 10 May 2017
SQL Tips #12 - Making a Default Date Rounded to an Hour
Saturday, 8 April 2017
SQL Tips #11 - Rebuilding the Query Cache and Statistics
Tuesday, 7 March 2017
SQL Tips #10 - Rebuilding Table Indexes Across Databases
Friday, 3 February 2017
SQL Tips #9 - Listing Stored Procedures by Change Date
Monday, 2 January 2017
SQL Tips #8 - List Read and Write Counts per Table
Thursday, 1 December 2016
SQL Tips #7 - Which tables or stored procedures were updated recently
Wednesday, 16 November 2016
SQL Tips #6 - Looking for tables with specific fieldtypes
Friday, 16 September 2016
SQL Tips #5 - Listing the recovery model for each database
Saturday, 16 July 2016
SQL Tips #4 - Listing all SQL databases with their file locations and sizes
Monday, 16 May 2016
SQL Tips #3 - Searching for a keyword in a stored procedure
Wednesday, 16 March 2016
SQL Tips #2 - Searching for a specific field name in a SQL table
Saturday, 16 January 2016
Skype Web SDK - Audio, Video and Conferencing
Thursday, 24 December 2015
A deep dive tutorial on how to add Audio, Video and Conferencing capabilities into your web site or application, using JavaScript and the Skype Web SDK.
SQL Tips #1 - Table Row Counts & Sizes
Saturday, 12 December 2015
Using the Skype Web SDK from any language or framework
Saturday, 12 December 2015
Extracting Email Addresses from Outlook Mailboxes using C#
Wednesday, 18 November 2015
Building a Skype for Business Auto Responder using the Skype Web SDK
Tuesday, 3 November 2015
Exporting Lync or Skype for Business Contacts with the Skype Web SDK
Tuesday, 27 October 2015
Extracting Attachments from Outlook Mailboxes using C#
Friday, 16 October 2015
Skype for Business Presence Dashboard Revisited
Wednesday, 16 September 2015
Skype Web SDK Troubleshooting - Part 2
Monday, 7 September 2015
Is it time to hang up the telephone?
Tuesday, 1 September 2015
Do we really need telephones anymore? Has Unified Communications removed the need for the traditional handset?
Skype Web SDK Troubleshooting
Monday, 31 August 2015
Skype Web SDK Sending an Instant Message - Part 2
Monday, 3 August 2015
Pluralsight Course - Skype Web SDK: Getting Started
Friday, 24 July 2015
Learn about the new Skype Web SDK, how it works, how to starting use it, and how the SDK can help enhance your web site or application with Skype functionality.
Becoming a Pluralsight author
Monday, 13 July 2015
I’ve recently been accepted as a Pluralsight Author, and am busily creating the first of a series of courses on how to develop Skype-enabled applications using the Skype Web SDK.
Skype Web SDK Sending an Instant Message
Sunday, 21 June 2015
Skype Web SDK Tutorials
Wednesday, 3 June 2015
Creating a Presence Dashboard using the Skype Web SDK
Saturday, 16 May 2015
Skype Web SDK Prerequisites
Monday, 4 May 2015
Skype Web SDK Useful Links
Thursday, 30 April 2015
Useful links for developing with the new Skype Web SDK
Introducing the Skype Web SDK
Thursday, 30 April 2015
Developing rich unified communication applications using the Skype Web SDK
Kilimanjaro Climb 2015
Saturday, 4 April 2015
Kilimanjaro is the tallest freestanding mountain in the world, one of the highest volcanoes and Africa s highest mountain, reaching 5,895m (~19,345ft).
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 7 - Millenium Camp to Mweka Gate
Monday, 30 March 2015
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 6 - Stella Point down to Millenium Camp
Sunday, 29 March 2015
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 6 - Uhuru Peak - the very top of Kilimanjaro
Sunday, 29 March 2015
Ascent to the Summit of Kilimanjaro
Sunday, 29 March 2015
Tonight at midnight, we begin our ascent to the peak of Kilimanjaro, Uruhu Peak at an altitude of 5,895m. It will take us around 8 hours to complete the climb.
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 6 - School Hut to Stella Point
Sunday, 29 March 2015
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 5 - 3rd Cave Camp to School Hut
Saturday, 28 March 2015
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 4 - Moir Hut to 3rd Cave Camp
Friday, 27 March 2015
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 3 - Shira 1 Camp to Moir Hut
Thursday, 26 March 2015
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 2 - Mti Mkubwa to Shira 1 Camp
Wednesday, 25 March 2015
Kilimanjaro 2015 - Lemosho (Northern Route) - Day 1 - Lemosho Gate to Mti Mkubwa
Tuesday, 24 March 2015
We're on our way to Kilimanjaro!
Saturday, 21 March 2015
In a little over 48hrs we begin our climb of the world's largest freestanding mountain, Kilimanjaro, in the northern plains of Tanzania, Africa.
All to raise funds for the Telco Together Foundation!
Lync Link List
Monday, 16 March 2015
JSON to C# class conversion using Paste Special in Visual Studio
Wednesday, 25 February 2015
Presentation on the Internet of Things and Microsoft Lync
Wednesday, 11 February 2015
A presentation and discussion about various Lync and Skype for Business development frameworks (UCMA, UCWA, Skype API, 3rd party) and how they can be used as a pathway to implementing IoT (Internet of Things) communication to Lync and Skype users.
Send an IM with UCWA - Hints, Tips & Extra Goodies - Learn More
Sunday, 1 February 2015
A few small tricks and techniques for improving your UCWA application and user experience.
Send an IM with UCWA - Setting Presence - Online, Away, Busy
Saturday, 31 January 2015
UCWA can be used to dynamically control the presence of an online Lync account.
Send an IM with UCWA - Step 3 - Sending the IM
Friday, 30 January 2015
UCWA, or the Unified Communications Web API, lets your send IMs easily using a simple HTTP RESTful API hosted on your Lync environment.
Send an IM with UCWA - Step 2 - Creating the Application
Thursday, 29 January 2015
The first step when creating a new UCWA is to initialise an Application - a two way modality between your Lync user account and an intended recipient.
Send an IM with UCWA - Step 1 - Prerequisites
Wednesday, 28 January 2015
Learn some of the important prerequisites for installing and configuring UCWA on your Lync 2013 environment.
An introduction to Sending an IM with UCWA
Tuesday, 27 January 2015
Microsoft Unified Communications Web API (UCWA) is a REST API that exposes Lync Server 2013 Instant Messaging and Presence capabilities.
The Lemosho Route - Kilimanjaro Climb 2015
Monday, 12 January 2015
The Lemosho Route is widely considered to be the best route on Mount Kilimanjaro. Lemosho, a relatively new route, is favoured due to its beauty, remoteness and success rate.
Exploring the Internet of Things (IoT) with Lync (& Skype for Business) and .Net Gadgeteer
Tuesday, 6 January 2015
Today, most people think of Lync and Skype as tools for Unified Communications – why not use the as tools to explore the Internet of Things?
Building PlanetFall, a LunarLander-inspired game for Windows Phone 8
Tuesday, 16 December 2014
An overview of building a Windows Phone 8 Silverlight Game using XAML, C# and Visual Studio 2013.
Skype for Business Announced
Tuesday, 11 November 2014
The convergence of Lync and Skype continues with the announcement of Skype for Business
Lync Agent DNS Checker
Saturday, 25 October 2014
Lync Agent DNS Checker is a very simple tool to remotely test DNS records against those required for Lync 2013, Lync Online, Exchange 2013 and/or Office 365.
Sending PRTG notifications via Lync
Friday, 24 October 2014
Just in case you don't get that SMS, get those PRTG alerts via Lync or Skype IM
Zork for Lync - Part 1
Saturday, 12 July 2014
You are standing in an option field west of a white house, with a boarded front door. There is a small mailbox here.
Hosted Lync vs Office 365 or Lync Online
Monday, 19 May 2014
What's the best option for your organisation? Advantages and disadvantages of all three options.
Monitoring Lync 2013 with MRTG
Saturday, 1 March 2014
Microsoft's Lync Server 2013 includes a number of reporting options, but no references on using Open Source technologies.
Wasteland 2 - inXile Entertainment
Sunday, 22 December 2013
Wasteland 2 is the direct sequel to 1988's Wasteland, the first-ever post-apocalyptic computer RPG
Telecommunications company grows cloud business with Windows
Sunday, 15 December 2013
By moving to Windows Server we've saved around 80% on licensing costs and dramatically reduced provisioning times for new virtual machines.
Book Review - Windows Phone 8 Game Development, by Marcin Jamro
Thursday, 14 November 2013
Windows Phone 8 Game Development offers readers a great introduction to Windows Phone development, using MVVM methodologies.
Kilimanjaro GPS Data Set
Sunday, 10 November 2013
Using a Garmin Forerunner 210 & 220, I tracked my recent trips to Kilimanjaro.
My Kilimanjaro Adventure
Monday, 4 November 2013
Jambo! At around 9am on 28th October 2013, with a team of excited but exhausted adventurers, we successfully reached Uhuru Peak, the top of Mount Kilimanjaro, Tanzania, Africas highest point, and the worlds highest free-standing mountain.
Kilimanjaro - Arrival in Arusha
Sunday, 20 October 2013
1 week to go to Kilimanjaro!
Sunday, 13 October 2013
Public Speaking Tips
Tuesday, 25 June 2013
Speaking more and more both as part of my job with M2, as well as guest panelist or presenter at various technology events, there are a number of online resources out there to help solidify the process in your mind.
1,000 Steps to Kilimanjaro
Tuesday, 18 June 2013
Or how I went from 29 minutes to 12 minutes…Every step becomes a little easier, the more you climb and the more you focus.
Kilimanjaro Charity Challenge - Our Causes
Monday, 22 April 2013
The Telco Together Kilimanjaro Charity Challenge
Friday, 12 April 2013
Microsoft Exchange Server 2013 in 60 Minutes
Saturday, 19 January 2013
As I travel quite frequently, managing my person mail on a legacy POP3/IMAP based mail server has always proven to be frustrating and inefficient.
Bolo8 - Retro Gaming revisited on Windows Phone, Windows 8 and XBLA
Thursday, 18 October 2012
Building a Windows Phone App
Saturday, 22 September 2012
A study of the impact localized maximum temperatures has on the usage of business-grade fixed line calls usage in Australia.
Saturday, 25 August 2012
Anecdotally it is common to hear, within the telecommunications industry, that telephone call volumes decrease during hot days, colloquially when everyone goes outside to the beach!Naturally, where temperatures are lower, it is believed that consumers and business people are more likely to remain in the homes or place or work, resulting in more telephone calls being made.
Carly's Voice - inspiration beyond expectation
Sunday, 12 August 2012
NSLookup from ASP.Net
Sunday, 5 August 2012
Today I found myself writing code to review the validity of the many, err, dozens of domain names that I oversee.
WiFi Everywhere
Thursday, 19 July 2012
I recently spent a few weeks in North America attending conferences and technology workshops.
NBN B2B Certification Achieved
Thursday, 22 March 2012
Primus Australia becomes first retail service provider to receive B2B interoperability certification from NBN Co Melbourne, Australia: Primus Australia, a part of PTGi (Primus Telecommunications Group, Inc.
Australia’s Government Data Centre Facilities Panel now includes Primus Australia, offering services from its Melbourne facilities
Wednesday, 16 November 2011
Today we announced that we have been included in the Federal Government’s Data Centre Facilities panel! This is an exciting opportunity, and many thanks to my team who have helped secure this membership!A huge thanks to Bruce, Jason and Emily for their work on this! Oh, and to Zac for knowing how to use a printer…— Press Release Follows —MELBOURNE 16th November 2011: Primus Australia, a part of PTGi (Primus Telecommunications Group, Inc.
A few nights at the Chelsea
Sunday, 17 July 2011
Before it closed for renovations in August, I was lucky enough to stay at the bohemian, boutique Hotel Chelsea, on West 22rd Street in Manhattan.
STS-135 Launch
Friday, 8 July 2011
Beauty in Electrons (aka Porsche 918 Spyder)
Friday, 16 April 2010
An exciting new chapter is opening in Porsche Motorsport history, with the launch of the 918 Spyder plug-in hybrid concept car.
Play Tron’s Fake Arcade Game, Space Paranoids
Tuesday, 9 March 2010
Imagineering Technology
Saturday, 6 September 2008
New x800 HP Series Optimizes Data Center and Enterprise WAN Environments
Monday, 12 March 2007
MIS Magazine - The new horizons
Tuesday, 7 June 2005
There is still plenty of ‘cool factor’ technology filtering through to the enterprise space, savvy CIOs just have to pick the studs from the duds.
Jetstar, Virgin Blue Web sites crash
Thursday, 26 February 2004
Aust IT industry insurance soars
Wednesday, 11 June 2003
Written by Patrick Gray, ZDNetSoaring professional indemnity and public liability insurance costs have sparked outrage among IT contractors, employers and employment agencies.
