Oracle 11g - How to force a sql_id to use a plan_hash_value using SQL Baselines
A guide to forcing Oracle 11g to use a specific execution plan for a problematic SQL query using SQL Plan Baselines.
A guide to forcing Oracle 11g to use a specific execution plan for a problematic SQL query using SQL Plan Baselines.
A tutorial on implementing dependency injection in ASP.NET MVC 3 applications using Castle Windsor IoC container for controller and service registration.
Explains a behavioral change in sp_executesql between SQL Server 2005 and 2008 when executing parameterized stored procedure calls.
Explains the HTML ETAGO delimiter, its theoretical impact on <style> and <script> tags in HTML4, and how HTML5 standardized browser behavior.
A detailed account of the challenges faced when attempting to upgrade a mid-2009 MacBook Pro with an SSD, including hardware compatibility issues.
Explains the concept of 'working set' in databases, its importance for performance, and how to manage it, with examples focused on MongoDB.
A recap of a Community Day 2011 session on integrating ASP.NET MVC 3, MEF, and NuGet to create loosely coupled, easy-to-use software architectures.
Announcement for the SQLSoton User Group meeting on July 6th, 2011, featuring talks on SQL Server and data automation.
A reminder to cancel free tech event registrations if you can't attend, freeing up spots for others on waiting lists.
A quick tip explaining how to pinch on an Android home screen to see an overview of all screens for faster navigation.
A tutorial on creating a Tic Tac Toe game using only CSS, with hidden checkboxes and pseudo-classes for game logic.
Analysis of why daily deal sites like Groupon and LivingSocial are unsustainable, highlighting their negative impact on small businesses and legal complexities.
Explores issues with DBMS_STATS.COPY_TABLE_STATS in Oracle, focusing on incorrect high/low value propagation for partitioned table statistics.
Explores advanced techniques for using Windows Azure Queues, including back-off polling, handling large messages, and implementing state machines.
Guide on connecting SharePoint 2010 to SQL Azure using BCS and Secure Store Service for cloud data integration.
A review of Ethan Marcotte's influential book 'Responsive Web Design', praising its approach to flexible web layouts and thoughtful design philosophy.
Explains the rules and pitfalls of using unquoted attribute values in HTML, including when it's valid and how it interacts with CSS/JS selectors.
Overview of Office 365, its benefits for organizations, and included services like SharePoint, Exchange, and Lync.
Step-by-step guide to signing up and getting started with Office 365 beta, including account creation and service setup.
A technical guide on implementing point-to-point message queues for interprocess communication on Windows CE using the .NET Compact Framework.