Phil Factor

  • Interests: Motorbikes, Beer, gardening, conservation, Local history.

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

Static Code Analysis: a necessary irritation.

There is little doubt that static code analysis can contribute to code quality and deliverability. As an aid to a developer, it seems increasingly essential, but can it ever deliver reliable metrics of code-quality? One shudders at the potential misuse of quality metrics in the wrong hands. My hope is that it remains just an aid to human judgement; and creativity.

5 (1)

2014-07-28

50 reads

Blogs

My 800th post!

By

It took me a little bit longer to get here than I expected but...

Azure Databricks to Power BI

By

A very common approach is to query data straight from Databricks via Power BI....

SQLSaturday #1000! Join Oregon Virtually this Saturday

By

Honored to be a part of not just SQLSaturday #1000, but the long proud...

Read the latest Blogs

Forums

SQL Server data file distribution

By soumyarani0317

I am a newbie to SQL Server administration and config. Apologies if I appear...

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct section to post my question. I...

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct forum to post my question. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers