MongoDB 1.8.0 Release Candidate introduces key features like write-ahead journaling for durability, sparse indexes, and enhanced Map/Reduce.
Announcement for the MongoUK 2011 conference in London, covering MongoDB topics like schema design, indexing, and scalability.
SQL Southampton User Group announces a room change to a larger hall within the same venue for its upcoming meetings.
Explains the GROUPING SETS operator in SQL Server for flexible data aggregation, comparing it to UNION ALL and WITH CUBE approaches.
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.
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.
