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.

  • 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 most robust/straightforward way to get the job done, so in this article I will show you how to solve this problem using a nested subquery in either your WHERE or your FROM clause.

    At the end of this article I’ll give the full working example Pet shop table and query that you can copy and paste into a SQL Server Management Studio (SSMS) session to try out the code for yourself.

    If you find this article useful, be sure to check out my other SQL Server related articles for more tips.

    (more…)

  • CSS Examples of Two Ways to Position a Button at the Top Right of a Table

    Top Right Positioning
    Top Right Positioning

    A cool effect you can do with CSS/HTML is to position a button (or any element really) at the top right hand side of a table. For example you could use this to refresh the contents of the table when the button is clicked. It’s intuitive to the user and is a subtle way to add functionality that is only apparent when it is needed. (more…)

  • 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 2014).
    Also, if you find this article helpful, feel free to check out the other articles on my site covering various SQL examples at: https://jwcooney.com/category/sql/

    (more…)