A guide to using MiniProfiler for performance profiling and identifying bottlenecks in ASP.NET MVC applications, focusing on database queries and server-side timing.
Analyzing a coordinate conversion accuracy issue in an Ordnance Survey data import project using SQL Server and a third-party GeoCoordConversion library.
Explains when to use temporary tables instead of table variables in SQL Server for significant query performance improvements.
Explains how to exclude specific nodes from XML data in SQL Server using T-SQL's modify method, UDFs, or temp tables.
A developer's 2011 year-in-review covering tech conferences (SQLBits, Mongo UK), community contributions, job changes, and open-source projects.
Update to a .NET tool for importing UK postcode geographic data from Ordnance Survey, fixing changes in the source file structure.
Explains a behavioral change in sp_executesql between SQL Server 2005 and 2008 when executing parameterized stored procedure calls.
Announcement for the SQLSoton User Group meeting on July 6th, 2011, featuring talks on SQL Server and data automation.
A developer reflects on the value of participating in tech Q&A communities and shares the surprise of receiving the Microsoft Community Contributor Award 2011.
Updates to a .NET app for importing Ordnance Survey's 1:50000 Scale Gazetteer geographic dataset into SQL Server with spatial data support.
A summary of the March 2011 SQL Server Southampton UserGroup meeting, featuring a talk on SQL Server replication and announcements for future events.
Announcement for the SQLSoton User Group meeting on March 9th, 2011, featuring a talk on SQL Server replication.
A SQL Server developer shares their perspective on adopting MongoDB, comparing it to traditional SQL and highlighting its strengths for specific use cases.
SQL Southampton User Group announces a room change to a larger hall within the same venue for its upcoming meetings.
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.
Explores techniques for maximizing SQL Server bulk insert performance using SqlBulkCopy with parallel processing and the Task Parallel Library.
Explains the GROUPING SETS operator in SQL Server for flexible data aggregation, comparing it to UNION ALL and WITH CUBE approaches.
A SQL Server/.NET developer reflects on their first year of blogging, top technical posts, and community event participation in 2010.
Announcement and details for SQLBits 8, a SQL Server conference in Brighton in April 2011.
