A personal recap of attending SQLBits VI, covering sessions on SQL Server performance tuning, parallel query execution, and the query optimizer.
How to resolve ORA-13757 error when deleting an active SQL Tuning Set in Oracle, including diagnostic queries and cleanup steps.
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 technical guide on extending the QUERY_TEXT column length in OBIEE usage tracking to prevent SQL truncation errors.
Fixing ORA-28001 and ORA-01017 errors when changing expired passwords on Oracle 11g using 10g clients.
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.
Django 1.1 introduces F() expressions for database queries, enabling field comparisons and arithmetic in filter() and update() methods.
Explains the new aggregate and annotate query syntax for Django 1.1, detailing how to perform calculations like MAX, MIN, and COUNT on data.
Fixing a duplicate key error in Trac 0.10.3 when importing SVN history due to path length limits in the database index.
Announcing a new database backup feature for daloRADIUS, focusing on portable INSERT-based backups for compatibility across database types.
A developer troubleshoots an NHibernate error when switching to SqlClient, explaining the mapping issue and solution.
Explains how to perform efficient batch database operations by integrating raw ADO.NET commands within an NHibernate transaction to avoid ORM overhead.
