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 […]
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.
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. http://www.infoq.com/presentations/Why-I-Chose-MongoDB-for-Guardian They compare concepts between traditional relational databases and MongoDB. Although specific to MongoDB, most NOSQL solutions have equivalent concepts, including RavenDb. Have you […]
June 9, 2009
A neat and simple way to put dynamic styling into your reports.
September 16, 2008
A possible fix to slow performance in SQL 2008 integrated full text search.
September 4, 2008
Question on Full Text Search Word Breaker for Gemany
April 29, 2008
This is direct from MSDN but I was asked about this specifically so I thought I’d post about it. If anyone has used full text search you will know that the default way it ranks results is pretty good. It uses a known method called Jaccard Coefficient. However, there are times when you might want […]
October 18, 2012
0