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 2008

  • T-SQL Programmatically Script Modified Stored Procedures

    In this example I will show how to write a T-SQL routine that scripts any stored procedures in your database that have been modified in the past three days. You should, of course, modify this time filter as you see fit. This T-SQL routine is useful to extend the scripting option built into SQL Server…

  • .NET – Write A File to Disk from your Database

    In this example I will review and give examples in C# and VB.NET how to get and save a file stored in an Image datatype in a SQL Server table. Here is a link to a list of other articles I have written about using .NET with SQL Server.

  • T-SQL – Find Where Table Data is Stored

    In this article  I will expand on an article I wrote earlier about how to search through all of the columns in each table in your database for a particular piece of information. In the example in this article I have: Modified my previous example query to search through columns of all datatypes rather than…