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.
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.
