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 Tips

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

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

  • T-SQL – Compare Stored Procedure Versions Between Two Databases

    If you have several different versions of the same database then you will want to be able to check for differences in the objects between the databases. You can quickly and easily do so using SQL Server’s sys.objects or if you are specifically looking up stored procedures, SQL Server’s sys.procedures system views. Let’s take an example use case…