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

How to get data in a DataFrame via .NET for Apache Spark

By

When I first started working with Apache Spark, one of the things I struggled...

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Read the latest Blogs

Forums

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

SSMS & Excel - Copy Paste - DateTime Columns

By AMCiti

Dear Group: I am not sure if this is a T-SQL / SSMS issue,...

Linked Server Insert error

By natigsqlserver

Hello i have linked server one server in cloud one is local from local...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers