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: Database

  • TSQL Search for the Last Record in a Group

    In this article I’ll show how to get the most recent record for a group of records in a SQL Server table. There are a number of ways to do this including CTEs and nested subqueries. Since nested subqueries are the most widely supported across the different versions of SQL Server, I consider them the…

  • Steps Restore a SQL Server Database into a New Database and Rename it

    If you want to create a working backup of one of your production databases that you can use without jeopardizing the production data, you’ll need to copy the database in its entirety to a new name. In this article I’ll review the steps you need to use to do this (in SQL Server Management Studio…

  • 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,…