Jeremy D. Miller -- The Shade Tree Developer

Browse by Tags

• Continuous Integration
• Design Patterns
• Legacy Code
• Test Driven Development

• Don't know about "CodeBetter," but I'm with Ayende

  Right off the bat, the "CodeBetter" guys did not give any sort of collective "seal of approval" to the Linq to Entities Framework -- and why the hell would it matter even if we did? I found the Entities Framework to be intriguing for... Posted Apr 10 2007, 09:04 PM by Jeremy D. Miller with | with 6 comment(s) Filed under: Database and Persistence, Ranting

• Interacting with a Strange Database

  I relearned a couple of lessons today about working with database intensive applications. Fortunately, I was merely writing test automation code and I caught my problems fairly quickly, but... You should get the System DateTime.Now in a consistent manner... Posted Nov 15 2006, 11:02 AM by Jeremy D. Miller with | with 1 comment(s) Filed under: Database and Persistence, Ranting

• Why I do not use Stored Procedures

  I promised myself that I wouldn't ever make another post about stored procedures , but Eric's post on sproc's hit a few of my hot buttons on the subject. Four years ago the pre-Agile, VB6/ASP coding me would have fervently agreed with Eric's pro-sproc... Posted May 25 2006, 02:45 PM by Jeremy D. Miller with | with 29 comment(s) Filed under: Database and Persistence, Ranting

• Unit Testing Business Logic without Tripping Over the Database

  A fairly common topic with TDD practitioners, both newbie and experienced, is how the heck to unit test business logic with a database hanging around. I’ve had several conversations lately about this so I thought I’d get a post about it. Before I try... Posted Oct 12 2005, 01:57 PM by Jeremy D. Miller with | with 25 comment(s) Filed under: Database and Persistence, Design Patterns, Ranting, Test Driven Development

• Exposing a Connection String as a Public Property is a Huge Design Smell

  Pure diatribe ahead: Take a look at this code and ignore any concerns over security just at the moment: public class MyConfiguration { public static string ConnectionString { get { // lookup the connection string wherever it is string connectionString... Posted Sep 28 2005, 09:27 AM by Jeremy D. Miller with | with 8 comment(s) Filed under: Database and Persistence, Ranting

• Database per Developer and Environment

  Our Continuous Integration talk Monday got a bit rushed at the end and I missed an important point when we talked about CI with databases. For the love of all that is good and holy in the world create a separate database/schema for: Each development workstation... Posted Sep 21 2005, 04:03 PM by Jeremy D. Miller with | with 13 comment(s) Filed under: Continuous Integration, Database and Persistence, Ranting, Test Driven Development

• Journey into the Heart of Darkness

  My poor colleague (martyr) is trying to debug a production issue with some system generated emails today. If I can get the facts straight, the chain of calls goes: ASP "Classic" page calling into a... Stored Procedure that calls... Another Stored Procedure... Posted Sep 12 2005, 04:56 PM by Jeremy D. Miller with | with 1 comment(s) Filed under: Database and Persistence, Ranting

• Don't play with strange databases...

  ...you don't know where they've been, or who's been touching them. I've been burned pretty badly in the past by making assumptions about existing databases. Database documentation isn't always helpful either, because it is out of date or just wrong to... Posted Jul 11 2005, 07:02 PM by Jeremy D. Miller with | with 3 comment(s) Filed under: Database and Persistence, Legacy Code, Ranting

• Quarantine the ADO.NET Contagion in your Code

  From my perspective the .Net world is clearly becoming more sophisticated in our approach to persistence. Reusable persistence solutions like NHibernate or NEO are starting to become more popular, reducing the need or desire to work with ADO.NET directly... Posted Jul 07 2005, 07:00 PM by Jeremy D. Miller with | with 5 comment(s) Filed under: Database and Persistence, Ranting

• Good and Evil in the Garden of Stored Procedures

  Periodically I see or engage in an argument over the usage of stored procedures. I think a lot of these types of arguments are somewhat unproductive because the combatants are thinking and talking about radically different things. Besides, I think the... Posted Jul 05 2005, 06:58 PM by Jeremy D. Miller with | with 5 comment(s) Filed under: Database and Persistence, Ranting

• The Worst Possible Way to use a Stored Procedure

  Rant time... Repeat after me please, I will not put any business logic into a stored procedure. I will not put any business logic into a stored procedure. I will not put any business logic into a stored procedure. I will not put any business logic into... Posted Jun 09 2005, 06:01 PM by Jeremy D. Miller with | with 11 comment(s) Filed under: Database and Persistence, Ranting