Phil Factor

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

SQLServerCentral Article

Reading and Writing your Database's Documentation using JSON

One of the problems to which I keep returning is finding the best way to read and apply documentation for databases. As part of a series of articles I'm doing for Redgate's Product Learning, I've been demonstrating how to maintain a single source of database documentation, in JSON, and then add and update the object […]

2021-06-28 (first published: )

3,224 reads

External Article

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

SQLServerCentral Article

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

51 reads

Blogs

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Typing with Your Tongue Part 2: Voice Access

By

A few months ago, I wrote a post on how I use voice technology...

Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up

By

William, right, 11 years ago the morning of our college tour Hello Dear Reader! When...

Read the latest Blogs

Forums

Login failures while connecting from Linux to SQL on windows

By ramana3327

Hi all, The app server is running on Linux. SQL server is running on...

Being Responsible for Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Being Responsible for Data

Contained Availability Groups

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Contained Availability Groups

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers