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

  • Get All Linked Servers Modify Date in SQL Server

    This is a short post that extends on a concept that I talked about in a previous article about querying linked server information in SQL Servers 2005, 2008, & 2012 using T-SQL. Specifically, I will give an example of how to check the last modified date for each linked server residing on your database server.

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

  • Notes on Writing T-SQL LDAP Queries Using ADSI OPENQUERY

    When you are working with Active Directory on your network, then it can be difficult to get a clear picture for how your particular instance of Active Directory is structured. I’ve been writing T-SQL LDAP queries using ADSI OPENQUERY and have been having fun trying to find where some of the values I’m looking for are…