A technical guide on using SQL Server Extended Events for tracing and monitoring Analysis Services (SSAS) performance, replacing SQL Profiler.
A bug in SQL Server Management Studio's Table Designer can cause filtered unique indexes to lose their WHERE clause when altering a table, leading to duplicate key errors.
A guide on connecting to and working with Windows Azure SQL Database directly within the PhpStorm IDE, covering setup, queries, and database management.
Analyzes SQL Server locking behavior for tables on READONLY filegroups vs. READONLY databases, debunking common myths.
Author shares personal achievement of earning the Microsoft Certified Master SQL Server 2008 certification, the highest technical certification from Microsoft.
Guide on configuring the Azure Storage Emulator to use a custom SQL Server instance instead of the default local SQL Express.
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.
