A developer questions when a software issue is labeled a 'design decision' instead of a bug, using an Oracle and Informatica case study.
SQL Azure requires a clustered index on every table. This article provides a query to identify tables missing one.
A technical guide on implementing and testing Oracle Database Resource Manager for CPU allocation and performance monitoring in a data warehouse environment.
A technical analysis of how an expired database password caused Informatica to spawn excessive connections, crashing an Oracle server.
Troubleshooting a BI Publisher error when creating Quartz scheduler tables due to insufficient database privileges.
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.
