A developer's rant about Excel's frustrating limitations, including the 31-character worksheet name limit and unexpected numeric storage quirks.
A tutorial on importing data from an Excel spreadsheet to create a new SharePoint list, highlighting its integration benefits.
A technical guide on using MongoDB's aggregation pipeline to convert problematic date strings into proper Date types for better querying and indexing.
A developer describes a .NET project to import personal Twitter archive data into ElasticSearch for better search and analysis.
Analyzing a coordinate conversion accuracy issue in an Ordnance Survey data import project using SQL Server and a third-party GeoCoordConversion library.
Update to a .NET tool for importing UK postcode geographic data from Ordnance Survey, fixing changes in the source file structure.
Updates to a .NET app for importing Ordnance Survey's 1:50000 Scale Gazetteer geographic dataset into SQL Server with spatial data support.
Updates to a .NET/SQL Server tool for importing and processing UK Ordnance Survey postcode and geographic boundary data.
A technical guide on converting and loading UK postcode geographic data into SQL Server using a .NET library for spatial queries.
