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 Server 2005

  • Quick and Easy Windows Shortcuts to Common Server Applications

    The other day I was working on a Windows 2003 SP2 server that was no longer displaying anything other than the Windows desktop. I could not bring up the start menu or even see the bottom menu bar.  This naturally was a problem because I wanted to set up a new Web site on the…

  • ASP.NET Choosing Parameters.Add or Parameters.AddWithValue

    If you are adding parameters to a SqlCommand object then you can use either Parameters.Add or Parameters.AddWithValue. The Parameters.Add syntax requires you to explicitly specify the DataType of the parameter you are passing, while the Parameters.AddWithValue syntax implicitly attempts to convert the parameters you pass in. When choosing which method you want to use, you should be aware that…

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