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.
Compares two methods for bulk reloading SQL Server clustered columnstore indexes, recommending drop/recreate for best performance and packing.
Explores SQL Server's auto page repair feature in database mirroring and Availability Groups, its usefulness, limitations, and underlying storage issues.
A SQL Server developer criticizes poorly normalized databases with polymorphic columns like ObjectID/ObjectType, advocating for nullable specific columns instead.
Troubleshooting SQL Server error 'Failed to update the database because the database is read-only', caused by availability group failover and connection to wrong server.
Explores surprising SQL Server behavior where TRY_CAST and TRY_CONVERT return non-NULL values for empty strings when casting to certain types, with a type-by-type analysis.
Using SQL Server database snapshots to provide large unit testing data with quick restores, avoiding transaction rollback limitations.
Explore SQL Server's CONCAT and CONCAT_WS functions for concatenating column values with delimiters, handling NULLs, and simplifying string aggregation.
Debunking the myth that bit columns are useless in SQL Server indexes, emphasizing selectivity over value range.
