Browsing All Posts filed under »Article«

Inserting the results of a stored procedure into a table

October 18, 2012


Recently, I needed to find out the schema of a resultset returned by a Stored Procedure so I could pass some failing SQL Unit Tests. I needed to know the columns, the column order and exact datatypes. Without access to a client to run the procedure I needed a way to do this with just […]

The Systemico Model

August 23, 2012


Originally posted on Barry O'Reilly:
Manage value not cost One of the foremost challenges we constantly encounter on development projects is the focus of teams and product managers on managing cost rather than value. In its most basic form this manifests itself daily in user stories where teams tend to concentrate on prioritisation, scope…

August 15, 2012


I think it depends on your requirements, I’ve used a similar flag to indicate “active” records but this also had an automated process to move inactive records into a separate table so those operations could batched.

RDBMS vs MongoDB concepts

August 12, 2011


I highly recommend this video about how the Guardian has implemented MongoDB; it talks about the history of their site’s development and the common evolution most large scale sites go through. They compare concepts between traditional relational databases and MongoDB. Although specific to MongoDB, most NOSQL solutions have equivalent concepts, including RavenDb. Have you […]

Dynamic styling for Reports

June 9, 2009


A neat and simple way to put dynamic styling into your reports.

SQL Server 2008 Full Text slowness

September 16, 2008


A possible fix to slow performance in SQL 2008 integrated full text search.

SQL 2008 Training Material

September 9, 2008


Good training resource for SQL 2008