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.
Guide to using the new Geolocation field in SharePoint 2013, including setup, Bing Maps integration, and prerequisites.
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.
Troubleshooting SQL Server 2012 Reporting Services and SharePoint 2010 integration error with BI Semantic Model Connection fix.
Troubleshooting SSRS 2012 and SharePoint 2010 integration error, focusing on missing Reporting Services Add-in on WFE nodes.
Author shares personal achievement of earning the Microsoft Certified Master SQL Server 2008 certification, the highest technical certification from Microsoft.
A developer shares their motivation for starting a tech blog to explain programming and data topics from the ground up.
A tech blogger shares their motivation for starting a blog to explain programming and data topics from the ground up.
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.
