Matthew Proctor - Coder, Blogger, Pluralsight Author, Writer and Entrepreneur

Kilimanjaro Climbs - Are you ready for the adventure of a lifetime?

Australian Postcode Database - Open Source & Free

An up-to-date downloadable database of Australian Postcodes and Localities, including accurate longitude and latitude values, sourced by and supported by the community.

Updated 4-6 times per year (sometimes more often), the database includes Australian Post Codes, Latitude and Longitudes, Delivery Classifications, SA3 and SA4 Classifications, Designated Regional Area codes, Local Government Areas (LGA), Electoral Designations, and more.

View Data

Other Databases: New Zealand Postcodes World City Data

Kutamo Studios - Enterprise Application & Web Design Services

kutamo Studios is a Melbourne based application and web design studio - our team have build hundreds of web sites and applications over the years, from small static brochure sites to global eCommerce systems.

Kutamo - Making Meetings Matter Again

Kutamo is an online tool designed to help you and your teams manage your meetings and outcomes, simply and efficiently!

Most outcomes and ideas from meetings today are forgotten - we write them down and never read them again, or file them away and forget where they are.

Kutamo aims to solve that problem by helping people track meetings in more detail and to document decisions, outcomes and objectives online. No more pen & paper!

ErrLog.IO - C# and Javascript Error Logging & Reporting

ErrLog.IO is a hosted error logging and reporting platform for .Net and Javascript - a single portal that collects your errors, categorizes them, and helps you get to the bottom problems and issues within your application or systems.

Australian Post Codes 1-Jul-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 1-Jul-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 28-Aug-2021
	Downloadable world cities databases. Includes latitude, longitude, province, country and and more. CSV Format.

SQL Tips #41 - Listing the Restore Progress of Databases 23-Oct-2019
	Useful SQL tips - how to list the restore progress of databases

SQL Tips #40 - Finding Queries with Missing Indexes in the Query Store 21-Sep-2019
	Useful SQL tips - how to find queries with missing indexes in the Query Store

SQL Tips #39 - Listing All Keys in a Database 20-Aug-2019
	Useful SQL tips - how to list all keys in a database

SQL Tips #38 - Finding All Dependencies of a Stored Procedure 19-Jul-2019
	Useful SQL tips - how to find all dependencies of a specific stored procedure

SQL Tips #37 - Listing All Stored Procedures Using a Specific Table 17-Jun-2019
	Useful SQL tips - how to list all stored procedures using a specific table

SQL Tips #36 - Listing All Stored Procedures or Tables 16-May-2019
	Useful SQL tips - how to list all stored procedures or tables in a database

SQL Tips #35 - Finding Tables with Missing Identity Fields 14-Apr-2019
	Useful SQL tips - how to find tables with missing identity fields

SQL Tips #34 - Finding Tables with Missing Primary Keys 13-Mar-2019
	Useful SQL tips - how to find tables with missing primary keys

SQL Tips #33 - Generating a Comma Separated List of Fields per Table 9-Feb-2019
	Useful SQL tips - how to generate a comma separated list of fields per table

SQL Tips #32 - Listing Recent Deadlock Victims 8-Jan-2019
	Useful SQL tips - how to list any queries that were recent deadlock or blocking victims

SQL Tips #31 - Deleting Duplicate Entries While Keeping the Original 7-Dec-2018
	Useful SQL tips - how to delete duplicate entries in a table while keeping the original

SQL Tips #30 - Listing Databases and Their CPU Usage 5-Nov-2018
	Useful SQL tips - how to list databases and their CPU usage

SQL Tips #29 - A Function to Generate Random Numbers 4-Oct-2018
	Useful SQL tips - a user-defined function to generate random numbers in a range

SQL Tips #28 - Generating Random Numbers for Non-Crypto Usage 2-Sep-2018
	Useful SQL tips - how to generate good random numbers for non-crypto usage

SQL Tips #27 - Finding Which Indexes Are Not Used 1-Aug-2018
	Useful SQL tips - how to find which indexes are not being used

SQL Tips #26 - Getting the Field Types of Fields in a Table 30-Jun-2018
	Useful SQL tips - how to get the field types of fields in a table

SQL Tips #25 - Rebuilding All Fragmented Table Indexes 29-May-2018
	Useful SQL tips - how to rebuild all fragmented table indexes

SQL Tips #24 - Listing All Indexes and Their Fragmentation Percentage 27-Apr-2018
	Useful SQL tips - how to list all indexes and their fragmentation percentage

SQL Tips #23 - A Function to Strip Numeric Characters 26-Mar-2018
	Useful SQL tips - a user-defined function to strip numeric characters from a string

SQL Tips #22 - A Function to Split a String 22-Feb-2018
	Useful SQL tips - a user-defined function to split a delimited string

SQL Tips #21 - Listing All Table Columns and Their Default Values 21-Jan-2018
	Useful SQL tips - how to list all table columns and their default values

SQL Tips #20 - Showing All Table Data for a Specified User 20-Dec-2017
	Useful SQL tips - how to show all table data for a specified user

SQL Tips #19 - Listing All SQL Jobs on the Server 18-Nov-2017
	Useful SQL tips - how to list all SQL Agent jobs on the server

SQL Tips #18 - Listing All Tables Without Any Indexes 17-Oct-2017
	Useful SQL tips - how to list all tables without any indexes

SQL Tips #17 - Table Row Counts and Sizes in Gb 15-Sep-2017
	Useful SQL tips - how to list all tables with row counts and file sizes in gigabytes

SQL Tips #16 - Looping Through Records using Cursors 14-Aug-2017
	Useful SQL tips - how to loop through records using SQL cursors

SQL Tips #15 - How to use Coalesce 13-Jul-2017
	Useful SQL tips - how to use COALESCE to concatenate row values into a single string

SQL Tips #14 - Clearing the Query Store 11-Jun-2017
	Useful SQL tips - how to clear the Query Store of a SQL database

SQL Tips #13 - Finding the Domain from an Email Address 10-May-2017
	Useful SQL tips - how to extract the distinct domain names from a column of email addresses

SQL Tips #12 - Making a Default Date Rounded to an Hour 8-Apr-2017
	Useful SQL tips - how to create a default date value rounded to the nearest hour

SQL Tips #11 - Rebuilding the Query Cache and Statistics 7-Mar-2017
	Useful SQL tips - how to update statistics for every table and rebuild the query cache

SQL Tips #10 - Rebuilding Table Indexes Across Databases 3-Feb-2017
	Useful SQL tips - how to rebuild the indexes of every table across one or more databases

SQL Tips #9 - Listing Stored Procedures by Change Date 2-Jan-2017
	Useful SQL tips - how to list all stored procedures ordered by the date they were last changed

SQL Tips #8 - List Read and Write Counts per Table 1-Dec-2016
	Useful SQL tips - how to list read and write counts for every table in a database

SQL Tips #7 - Which tables or stored procedures were updated recently 16-Nov-2016
	Useful SQL tips - how to list all stored procedures or tables updated recently

SQL Tips #6 - Looking for tables with specific fieldtypes 16-Sep-2016
	Useful SQL tips - how to a specific type of field in a SQL table

SQL Tips #5 - Listing the recovery model for each database 16-Jul-2016
	Useful SQL tips - how to list the SQL Recovery Model of all your databases

SQL Tips #4 - Listing all SQL databases with their file locations and sizes 16-May-2016
	Useful SQL tips - How to list all your SQL databases with their file locations and sizes

SQL Tips #3 - Searching for a keyword in a stored procedure 16-Mar-2016
	Useful SQL tips - how to list all stored procedures that have column names that match a keyword

SQL Tips #2 - Searching for a specific field name in a SQL table 16-Jan-2016
	Useful SQL tips - how to list all tables that have column names that match a keyword

Skype Web SDK - Audio, Video and Conferencing 24-Dec-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 12-Dec-2015
	Useful SQL tips - how to list all tables and retrieve their row counts and file sizes

Using the Skype Web SDK from any language or framework 12-Dec-2015
	Let's build a wrapper around the Skype Web SDK to allow any language or framework to quickly and easily send an Instant Message.

Extracting Email Addresses from Outlook Mailboxes using C# 18-Nov-2015
	Sometimes it's handy to be able to easily extract a list of email addresses from your Outlook PST or OST file. This application uses C# to extract email addresses from Microsoft Outlook.

Building a Skype for Business Auto Responder using the Skype Web SDK 3-Nov-2015
	Sometimes you need to change your Lync or Skype for Business email address (or SIP address), and as a result it would be helpful to be able to respond to people trying to contact you at your old address!

View the full archives of articles since 2003

Acknowledgement

I acknowledge and pay respect to the past and present Traditional Custodians and Elders of this land and the continuation of cultural, spiritual and educational practices of Aboriginal and Torres Strait Islander peoples. I would also like to extend my acknowledgment and thanks to the Indigenous people from countries overseas & recognise their respective cultures, strength, wisdom and creativity.