Justin Cooney

Web Development Tips and Examples

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: System Objects

T-SQL – Compare Stored Procedure Versions Between Two Databases

2013-05-21

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…
T-SQL – Get a Historical Record of SQL Statements Hitting a Table

2013-05-09

Today I’ll review two useful queries that you can use to get information from SQL Server about what SQL statements are hitting one or more of your database tables. If you are interested in further T-SQL tips and tricks, please have a look through related articles I have written.
T-SQL – Search a Database for all Table Columns with a Text Value

2013-01-03

There are times when it comes in handy to be able to query all columns of all of the tables in a database for a particular text match. For example: if you have just taken over a project with a large database and are trying to find where values from the UI are coming from,…

recent posts

about

Category: System Objects

T-SQL – Compare Stored Procedure Versions Between Two Databases

T-SQL – Get a Historical Record of SQL Statements Hitting a Table

T-SQL – Search a Database for all Table Columns with a Text Value