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 […]

You rated this post out of 5. Change rating

2021-06-28 (first published: )

3,344 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)

You rated this post out of 5. Change rating

2014-07-28

53 reads

Blogs

Set-Based vs Row-Based Database Code

By

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...

A New Word: Nighthawk

By

nighthawk – n. a recurring thought that only seems to strike you late at...

Extended Events in Azure Data Studio

By

I know I can use extended events (xevents) in Azure SQL DB when in...

Read the latest Blogs

Forums

Reduction of installation time of sql server 2008 R2 Express

By IT researcher

The installation of SQL Server 2008 R2 Express on a virtual machine takes around...

Creating Aggregates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Aggregates

Getting Started with DDL statements of Cassandra Query Language

By Shivayan Mukherjee

Comments posted to this topic are about the item Getting Started with DDL statements...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers