A quick-start guide to setting up and using MongoDB with C# and the .NET framework, covering installation and basic database operations.
Announcement and details for SQLBits 8, a SQL Server conference in Brighton in April 2011.
Announcement for the January 2011 SQL Server Southampton UserGroup meeting, featuring a talk on SQL Server architecture and a networking supper.
A summary of the first SQL Server Southampton UserGroup meeting, covering sessions on SQL CLR and community discussions.
Announcement that session videos from the SQLBits 6 conference are now available for viewing online.
Blogger returns from paternity leave and discusses interest in forming a new local SQL Server User Group in Hampshire, UK.
SQL Azure requires a clustered index on every table. This article provides a query to identify tables missing one.
Explains how to pass a TABLE variable into a dynamic SQL statement in SQL Server, including code examples.
A developer reflects on learning new tech like NoSQL databases, daily stand-ups, and contributing to communities to advance their career.
A personal recap of attending SQLBits VI, covering sessions on SQL Server performance tuning, parallel query execution, and the query optimizer.
Announcement and preview of SQLBits VI, a free SQL Server conference in London focused on performance and scalability.
Explains how to optimize SQL query performance by avoiding functions in WHERE clauses, using date filtering as a key example.
A technical guide comparing SqlBulkCopy vs. SqlDataAdapter for high-speed data loading into SQL Server, demonstrating significant performance gains.
Explains the removal of the Meta.using option in Django's multiple database support and the search for a better, more reusable API.
An update on the progress and remaining challenges for implementing multiple database support in the Django web framework.
A technical deep dive into refactoring Django's ManyToManyField to eliminate raw SQL and improve code structure for multi-database support.
A developer compares MySQL and MS SQL Server, listing syntax and usability advantages of MySQL based on personal experience.
A recap of a panel discussion on Object-Relational Mappers (ORMs) in Python, covering selection criteria and unanswered questions.
A request for open-source backup solutions that use a database for tracking incremental backups, avoiding inefficient hard-link directory trees.
Explains how to implement polymorphic behavior for Django model inheritance, allowing base class querysets to return subclass instances.
