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

  • Notes on Securing your Web Application Database Calls (Part 1)

    A common part of writing a Web-based application in any programming  language is setting up a SQL query and adding parameters to it. Although most of us have been doing this in one form or another for many years now, there are serious consequences involved that every developer should be aware of. I’m planning this…

  • An Overview of Returning XML from an MS SQL Server T-SQL Query

    There are times when using the XML data type in Microsoft SQL Server can be of great help. For example the XML data type is very useful when you want to return data in a hierarchical structure rather than a simple tabular structure. There are several options for going about and returning XML from your queries…

  • How to Query SQL Server System Tables for Text in Stored Procedures

    It is often very useful to be able to query the SQL Server system tables to find data about stored procedures. Rather than running visual searches through the GUI or scripting the stored procedures, the fastest way to find what you are looking for is a direct query via SSMS (SQL Server Management Studio). Specifically,…