Explains how to implement a queue processing system in SQL Server using table hints like UPDLOCK and READPAST to ensure reliable, concurrent processing.
A technical guide on safely converting a SQL Server primary key index from nonclustered to clustered (or vice versa) using a temporary unique constraint.
Announcement and preview of SQLBits VI, a free SQL Server conference in London focused on performance and scalability.
Explains why using explicit, meaningful names for SQL constraints is better than relying on autogenerated names for easier maintenance and safer deployments.
Explains how to use the SP:StmtCompleted SQL Profiler event to identify slow individual statements within a stored procedure.
A technical guide comparing SqlBulkCopy vs. SqlDataAdapter for high-speed data loading into SQL Server, demonstrating significant performance gains.
Compares three methods for passing multiple IDs to a SQL Server stored procedure: CSV lists, XML, and Table Valued Parameters.
A developer shares their anticipation and planned schedule for the QCon London 2010 conference, focusing on architecture, .NET, and scalability.
Explains the importance of clearing SQL Server's data and execution plan caches for fair query performance comparisons during tuning.
A C# and SQL Server developer explains his motivation for starting a technical blog to share coding challenges and solutions.
Highlights from Microsoft PDC 2009 keynote, focusing on the 'three-screen' cloud vision, Azure, and new developer tools releases.
A security vulnerability in SQL Server (2005-2008 R2) allows guest account impersonation to bypass database access controls, with a fix planned for a future version.
Introducing SQL Azure Manager, a community tool for connecting to and managing SQL Azure databases, addressing usability issues with SQL Server Management Studio.
Step-by-step guide to configure OBIEE on Unix/Linux to connect to and query a Microsoft SQL Server database using ODBC drivers.
A developer compares MySQL and MS SQL Server, listing syntax and usability advantages of MySQL based on personal experience.
A portfolio showcasing Andrew Bancroft's 15+ years of experience in software development, data analytics, and leading tech projects across various industries.
