Phil Factor

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

SQLServerCentral Editorial

Divide and Conquer

Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.

(1)

You rated this post out of 5. Change rating

2014-03-24

215 reads

SQLServerCentral Article

Confessions of an IT Manager, 2nd Edition - Book

The software industry is, just occasionally, more absurd than one would dare to imagine. Having spent most of his working life in its clutches, Phil Factor has pretty much "seen it all" and what's more he's prepared to tell what he knows. The second edition of Phil's "Confessions of an IT Manager" contains Phil's full repertoire of tales of institutional mayhem and software projects gone awry.

2013-10-01

2,632 reads

Blogs

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

When SQL Server Central Went Down

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When SQL Server Central Went...

The String Distance I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The String Distance I

How Database Professionals Sent a Million Emails a Day from SQL Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Database Professionals Sent a...

Visit the forum

Question of the Day

The String Distance I

In SQL Server 2025, what is returned by this code:

SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled.

See possible answers