Point-in-time data
Phil Factor explains why data detached from its temporal context often loses all meaning.
2016-08-15
85 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
2016-08-01
66 reads
Delivering Rapid Improvements to SSMS
SSMS has spent years being neglected, merely being kept compatible with SQL Server and its features: But now we have, instead, the promise of monthly delivery of new functionality
2016-07-18
51 reads
2016-06-06
124 reads
Mentors and Professional Groups
When wrestling with technical problems or ideas, it is good to discuss with, argue against, present ideas to, and listen to your colleagues. This is true of anyone working in IT, but really important for the likes of database professionals who are engaged in a very rapidly-developing engineering specialism that demands that you keep up […]
2016-05-30
48 reads
The Information Schema and Cross-RDBMS Working
A look at the ODBC standard and how valuable it has been, unlike the Information Schema implementations.
2016-05-09
67 reads
A nice whistle and flute
Phil Factor recounts the most important lesson of his early IT career: try not to burst into giggles when you get to look at the client's IT system.
2016-04-25
119 reads
Hunting in Packs
Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.
2016-04-11
123 reads
Code smells versus transgressions
The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?
2016-04-04
157 reads
2016-03-28
178 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
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...
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