Devin Manno 
March 3, 2014When performing calculations in T-SQL, I found myself having to deal with zeros in division operations. While zeros in the numerator pose no threat, denominators of zero will cause your query to blow up. In order to fix divide by zero errors, I began writing CASE statements. However, this got old very quickly. The stored Continue reading →
Devin Manno January 2, 2014As a New Year’s present to myself, I recently signed up for free SSL certificates through startssl.com for my personal websites. Since these are not production websites, I did not want to pay for an SSL certificate that covers multiple domains. Instead, I hoped to use multiple (free!) SSL certificates within IIS 8 to encrypt Continue reading →
Devin Manno November 15, 2013If you need to import data from a Microsoft Access database to SQL Server, one simple way is to setup the Access file as a Linked Server. You can add the linked server using the SQL Server Management Studio GUI, or through T-SQL commands. Run the sp_addlinkedserver procedure to add a Linked Server. Follow that Continue reading →
Devin Manno August 28, 2013As the number of mobile Internet-connected devices continues to rise, so does the number of public-WiFi access points. “WiFi” window stickers are all over the place, advertising a “bonus” reason to stop by your local coffee shop, bookstore or Home Depot. While this may make multi-task shopping easier, it also exposes your activities to anyone Continue reading →
Devin Manno July 1, 2013While working with Microsoft’s Open XML SDK 2.5, I came across some difficulties writing dates to an Excel workbook. When writing dates to an existing Excel file used as a template, I noticed that the dates I was passing to my writeToCell() method did not match the dates I found when I opened up the Continue reading →