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

  • SQL Server: Search Stored Procedure Create/Modify Date or Text using tSQL

    SQL Server Management Studio (SSMS) is a great tool for managing instances of your SQL Server databases. Sometimes, though, the fastest way to retrieve information you are looking for isn’t through the SSMS GUI, but through direct SQL queries. Case in point: if you want to search for specific information about stored procedures in your…

  • No-SQL vs Relational Databases Overview

    There is a lot of hype around No-SQL databases, even to the point where people are saying that the relational database (RDBMS) model is obsolete. I develop corporate applications and use relational databases to do this, so the talk about how relational databases are obsolete has prompted me to look further into both technologies. At the most…

  • SQL OpenRowSet Excel Query Returns Null Values

    In an earlier article I reviewed how to query an Excel spreadsheet from SQL Server Management Studio (SSMS). I’ve found that this functionality is very useful, especially when working with data maintained by business users outside of a database system. For an overview of how to connect SSMS with an Excel WorkSheet, please see my detailed article covering…