SDU Tools: Tools View

Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. A while back, we added the ability to retrieve the version of the toolset programmatically, but an interesting request that we had, asked for the ability to query the toolset for the tools themselves. The Tools view now does that.

The view returns the following columns:

ToolName ToolTypeCode ToolType Category Description VideoURL

Each tool in our toolset now has extended properties that describe it. The view returns that information.

Find out more

You can see it in action in the main image above, and in the video here. The full current version of the code is also shown below:

You can use our tools as a set or as a great example of how to write functions like these.

Access to SDU Tools is one of the benefits of being an SDU Insider, along with access to our other free tools and eBooks. Please just visit here for more info:

http://sdutools.sqldownunder.com

Latest version of the code

Note: the code might wrap when displayed below.

SELECT o.[name] AS ToolName,
       o.[type] AS ToolTypeCode,
       o.[type_desc] AS ToolType,
       MAX(CASE WHEN ep.[name] = N'SDUToolsCategory' THEN ep.[value] END) AS Category,
       MAX(CASE WHEN ep.[name] = N'SDUToolsDescription' THEN ep.[value] END) AS [Description],
       MAX(CASE WHEN ep.[name] = N'SDUToolsVideoURL' THEN ep.[value] END) AS VideoURL
FROM sys.extended_properties AS ep
INNER JOIN sys.objects AS o
ON o.object_id = ep.major_id
WHERE SCHEMA_NAME(o.schema_id) = N'SDU_Tools'
GROUP BY o.[name], o.[type], o.[type_desc];
GO

2025-02-03