Robert Sheldon SQL Server System Views: The Basics When maintaining or refactoring an unfamiliar database, you'll need a fast way to uncover all sorts of facts about the database, its tables, columns keys... 27 January 2016 19 min read
Chris Hurley Catching Performance Issues in Development Refactoring code won't cause performance problems, right? This was the assumption when Chris Hurley and his team went out to improve some legacy code. They... 16 April 2015 7 min read
Alex Kuznetsov Painless Refactoring of SQL Server Database Objects Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive... 26 March 2015 25 min read
Thomas LeBlanc Defusing Database Time Bombs: Avoiding the Need to Refactor Databases Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases... 27 February 2015 23 min read
Dino Esposito Responsive Web Design: the Costs Responsive Web Design is devised to help you render your website or web-based application appropriately on different sizes and aspect ratios of browser windows. Adopting... 26 August 2014 13 min read
Michael Sorens A TDD Journey: 3- Mocks vs. Stubs; Test Frameworks; Assertions; ReSharper Accelerators Test-Driven Development (TDD) involves the repetition of a very short development cycle that begins with an initially-failing test that defines the required functionality, and ends... 01 August 2014 14 min read
Michael Sorens A TDD Journey: 2- Naming Tests; Mocking Frameworks; Dependency Injection Test-Driven Development (TDD) relies on the repetition of a very short development cycle Starting from an initially failing automated test that defines the functionality that is... 31 July 2014 13 min read
Alex Kuznetsov Lessons Learned from Six Years of Agile Database Development Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a reality, without disrupting users. He... 19 November 2013 26 min read
Edward Charbeneau Refactoring CSS with Sass and Compass CSS is still a valuable way of specifying the rendered style of HTML objects. By using a preprocessor to assist in generating the CSS, it... 16 April 2013 18 min read
Alex Kuznetsov Developing Low-Maintenance Databases Alex's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database... 12 June 2012 21 min read
Blogs Phil Factor in Blogs Database Migration Scripts: Getting from place A to place B We’ll be looking at a typical database ‘migration’ script which uses an unusual technique to migrate existing ‘de-normalised’ data into a more correct form. So,... 28 February 2012 8 min read
Nick Harrison A Developers’ Guide to Refactoring Databases When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to to easily coexist with Agile... 04 April 2011 15 min read
Nick Harrison Database Refactoring Although the methodology of refactoring code has been adopted enthusiastically, the same has not really been the case with databases. Nick argues that the reason... 01 February 2011 17 min read
Nick Harrison Exploring Smelly Code Bad Code Smells are similar in concept to Development-level Antipatterns. They don't describe bad programming aesthetics and you can't sniff them out precisely with code... 27 April 2009 12 min read
Scott W. Ambler and Pramod J. Sadalage Refactoring Databases: The Process Database refactoring can greatly improve the efficiency of your database code. However, even a seemingly simple database refactoring such as "Move Column" can be tricky... 09 January 2007 16 min read