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 developer troubleshoots an ORA-01017 error in Oracle BI Applications (OBIA) despite valid credentials, exploring JDBC driver and case-sensitivity issues.
A developer's troubleshooting note on fixing Oracle's ORA-00845 error by resizing /dev/shm after reading the alert log.
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.
