Phil Factor

What’s in that database? Getting information about routines

There is a lot of information held in SQL Server metadata about your SQL Server procedures, triggers, views and functions. Some of it is valuable, other nuggets are useful and a few are rather dull but worthy. It really all needs to be tied together to tell the full story, especially if you are not able to, or do not want to, query the metadata directly.

2020-03-17

The Multi-skilled Developer

Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.

4 (1)

2019-09-25 (first published: )

549 reads

Blogs

Fixing the PoSh Hotkey in ADS

By

I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...

Capture Execution Plans Only For Long Running Queries

By

I love questions. Most of all, I love questions I can answer. I spotted...

Daily Coping 28 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Simple Python question...

By pietlinden

I have a table in SQL Server like this: CREATE TABLE #SymptomData (  ...

Regular expressions in script component

By sqlfriend

In one of our SSIS package we have a script component that validate a...

SSRS - Filtering data in a report

By dduensing

I have a dataset (Name, Product A Installed, Product B Installed, Product 3 Installed,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers