A guide to database sharding, explaining what it is, why it's needed, and how to implement logical and physical shards for scaling.
Explains Drupal's node access system, covering the node_access table, grant records, and module hooks for implementing role-based access control.
A developer shares his approach to writing clean, readable SQL with practical examples and best practices for structuring queries.
A tutorial on using PostgreSQL array fields within Django models to simplify data structures like tags, improving performance and code clarity.
Explains why MySQL's 'utf8' charset is incomplete and how to use 'utf8mb4' for full Unicode support, including emojis.
Explains how to implement schemaless data storage in Django using PostgreSQL's hstore extension as an alternative to MongoDB.
A detailed exploration of advanced PostgreSQL features like concurrent indexing, transactional DDL, and foreign data wrappers.
A detailed list of technical advantages and features that make PostgreSQL a powerful and versatile database choice for developers.
Explains how to instrument OBIEE database connections for improved performance diagnostics and user session tracking.
Fixing Oracle tnsping error 'Message 3513 not found' on Windows by adjusting the PATH variable order after installing a new Oracle version.
Oracle releases OBIEE 11g for HP-UX Itanium, surprising the author who doubted it would happen.
Explains the importance of defining CLIENT_ID in OBIEE for user query tracking and troubleshooting database calls.
A technical guide on integrating MongoDB, a NoSQL document database, with the Spring Data framework for Java applications.
Explains the concept of 'working set' in databases, its importance for performance, and how to manage it, with examples focused on MongoDB.
A technical guide on configuring Django to force SSL connections to a PostgreSQL database server.
Analysis of HP's marketing claims against Oracle Exadata, focusing on technical FUD and balanced system design for data warehousing.
A technical guide on generating and downloading CSV files from an ASP page by querying a SQL database and setting HTTP headers.
MongoDB 1.8.0 Release Candidate 2 is now available for download, featuring several updates and changes.
Announcement for the SQLSoton User Group meeting on March 9th, 2011, featuring a talk on SQL Server replication.
