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.
Announcement for the January 2011 SQL Server Southampton UserGroup meeting, featuring a talk on SQL Server architecture and a networking supper.
A summary of the first SQL Server Southampton UserGroup meeting, covering sessions on SQL CLR and community discussions.
Announcement that session videos from the SQLBits 6 conference are now available for viewing online.
A review of the SSMS Tools Pack, a free productivity add-in for SQL Server Management Studio, highlighting its key features like snippets and connection coloring.
Blogger returns from paternity leave and discusses interest in forming a new local SQL Server User Group in Hampshire, UK.
Explains how to pass a TABLE variable into a dynamic SQL statement in SQL Server, including code examples.
A developer reflects on learning new tech like NoSQL databases, daily stand-ups, and contributing to communities to advance their career.
Explains using SET NOEXEC to validate SQL query syntax programmatically, noting a bug in SQL Server 2008 regarding object name validation.
