I’m a software development and technology manager – so why did I get a PMP certification?

Last week, I earned my Project Management Professional (PMP) certification. It wasn't easy. The Project Management Body of Knowledge (PMBOKĀ® Guide) is about a thousand pages of material, and it is dense. And frankly, it includes some stuff that is not directly relevant to my current position. I am in the software development and technology management … Continue reading I’m a software development and technology manager – so why did I get a PMP certification?

Programming Zealots

I was reading a blog post the other day -- well, it was more of a rant, actually -- about the evils of using regions in your .NET code. The guy had joined a team that used regions as one of their programming conventions, and he refused (rudely, I thought) to abide by the team's … Continue reading Programming Zealots

How to Set a Default Value on a Configurable Variable in a SQL Server Stored Procedure Using IsNull()

The Situation You have a SQL Server stored procedure that needs variable for use in a query, but you don't want to pass it into the stored procedure as a parameter, and you don't want to hard-code it. Instead you have the value stored in a table and want to retrieve it from there. There … Continue reading How to Set a Default Value on a Configurable Variable in a SQL Server Stored Procedure Using IsNull()

How To Extend the Timeout Period on an Entity Framework Query

The Situation: You have a long running Entity Framework query that often creates a "System.Data.SqlClient.SqlException" with the message "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." A Solution: As near as I can find, the default timeout for EF queries using the SQL Server 2008 … Continue reading How To Extend the Timeout Period on an Entity Framework Query