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.

Author: Justin Cooney

  • SQL Server: Query All Clustered & NonClustered Indexes

    A great way to review all of the Clustered and NonClustered Indexes set up for a particular database is to query the SQL Server system tables. The sys.tables table contains the full list of tables for your database, and the sys.indexes table contains the full list of indexes. Simply join the two on their object_id…

  • SQL Server: How to List the Full Properties of all Linked Servers

    What is the best way to see the full properties of all of the Linked Servers in SQL Server in one go? A SQL query is naturally the best way using SQL Server’s system tables! UI-Based Solutions: The properties view in the SSMS UI does not show sufficient information about the set-up and history of…

  • TwentyFeet Review – Useful Tool for Twitter and Social Media Statistics

    For the past few weeks I have been trying out the free version of the online social media statistics reporting service provided by TwentyFeet. I like monitoring my social media statistics, and was quite happy when I came across this tool. I have tried quite a few tools, but I like the comprehensiveness and ease of…