Subscribe:
RSS feed
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
CUBE was introduced in SQL Server 2005. When you use the CUBE operator it generates a result set of every possible combination from your set of columns; much like a CUBE would be generated if you were using analysis services. the CUBE operator isn’t something I’ve had to use much so I’ll show you an example. […]
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 […]
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 22, 2012
I’ve recently put together an article on using SQL Test/tSQLt, which you can find here. However, I wanted to briefly talk about the alternatives as I see them. Before any commercial testing tools were around we could just use a combination of manual scripts that called procedures and used temporary tables to hold data. It […]
August 22, 2012
Any software/web developer worth hiring would tell you that Test Driven Development is important. Although it takes time to do properly, It can increase productivity as features tend to be developed with a clearer understanding of the problem and make changing business requirements much easier to implement. Importantly, your code quality will improve and there […]
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 13, 2012
I’ll be providing a more detailed post on this shortly, in the meantime please check out http://www.red-gate.com/products/sql-development/sql-test/. SQL Test internally uses tSQLt, a popular open source framework, combined with Redgate’s expert knowledge of providing add-ons to management studio means that we now have an integrated toolset for test driven development in the SQL world. Why […]
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 […]
May 25, 2011
A colleague mentioned this the other day and I noticed it wasn’t advertised much on the web so here it is, an easy way to remember the ASP.Net page life cycle. S – Start. (OnPreInit) I – Initialize. (OnInit, InitComplete, OnPreLoad) L – Load. (OnLoad) V – Validation. (Validate) E – Event Handling. (OnLoadComplete, OnPreRender, OnSaveStateComplete) R – Render. (Render) Oh […]
April 20, 2011
Let’s say you have a table that is ordered by a column but also contains a sequence number used for overiding the order sequence. This table may look something like this Now, this initially is populated in sequence like so: You can see I deliberately left a gap for item ‘D’. If I was to […]
Barry King 
December 28, 2012
0