Benchmarks comparing the CPU performance overhead of SQL Server Extended Events vs. SQL Trace under high CPU load.
Explores SQL Server privilege escalation from CONTROL SERVER to sysadmin, debunking myths and comparing to Oracle's security model.
Guide to securely connect SQL Server Management Studio to an Azure IaaS SQL Server instance by configuring endpoints and enabling encrypted connections.
Compares file sizes between SQL Server Extended Events and deprecated SQL Trace, finding XML format adds ~29% overhead.
Fixing a SQL Server 2008 R2 in-place upgrade error related to service account logon format (UPN vs. Down-Level Name).
A database expert reflects on the 2013 Frankfurt Database Days conference, comparing SQL Server and Oracle features like isolation levels and security.
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.
