Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: SQL

  • Example of Encrypting and Decrypting a String into a SQL Table Using ASP.NET

    I’ve put together this article because even after a lot of searching, I wasn’t able to find a simple, working example of how to encrypt and then decrypt a string that you are saving in your database in ASP.Net. Sure, there are some partial examples, but partial code usually doesn’t answer the question properly. Added to that,…

  • T-SQL to Enforce Proper Case Capitalization

    This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make…

  • SSRS: Simple Code Examples of Handling Null or Blank Date Fields

    If you are looking for either null or blank values for a date field in SQL Server Reporting Services (SSRS) you will find that checking for IsNothing only identifies the Null values, but ignores the blank values. So what’s the quickest and easiest way to do this?