Detecting SQL code smells using code analysis
Watch out, watch out, there's a NOLOCK hint about. And probably a few other SQL code smells.
2018-07-02
384 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
One law for me, another for EU
Phil Factor notes that the EU's approach to the GDPR seems to be "do as I say, not as I do".
2018-06-04
61 reads
An Unlikely Taste for Documentation and Archiving
So, in general, what information (Scripts, configuration information, lists and documents) ought DBAs to retain about the databases and servers they are responsible for?
2018-05-31 (first published: 2014-11-10)
200 reads
The Technology Journey to Disaster
Phil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.
2018-05-07
307 reads
Stumbling over Words
Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.
2018-04-09
108 reads
Troublesome Names
Building a name-and-address database sounds a disarmingly simple task, but if your name happens to be D'Arcy Join, then you probably know, from painful experience, that most programmers don't get it right.
2018-03-12
326 reads
Database Taming
Sometimes a database can seem to be as willful as a colt. Taming it requires an iron nerve, and unflinching eye contact. Occasionally though, you need to know when to jump the fence and regroup.
2018-02-12
74 reads
Data-driven Prototypes
Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.
2018-01-15
196 reads
The Appearance of the Flat File Wizard.
After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.
2017-12-04
88 reads
A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
2017-11-27
66 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
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!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
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