Where's that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
2019-01-14
122 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Where Microsoft went wrong with SQL CLR
We database developers would, of course, like easy access to all the .NET delights, such as the excellent Regex library, but we don't want a Do-It-Yourself kit to achieve this. So argues Phil Factor.
2018-12-12 (first published: 2015-01-19)
466 reads
Data with Provenance
File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.
2018-12-03
384 reads
Naming Conventions for SQL Server Objects
Phil Factor feels that as a community we can do more to help people who are wrestling with SQL coding standards.
2018-10-22
2,499 reads
2018-09-24
152 reads
'Comedy Limited' with SQL Server
Phil Factor is not amused by SQL Server's handling of the comma-separated value (CSV) file format.
2018-08-27
527 reads
Using SQL Server Dynamic Online Catalog to Explore Keys and Relationships: Stairway to Exploring Database Metadata Level 4
This level introduces keys, constraints, and relationships.
2018-08-22 (first published: 2016-10-19)
3,197 reads
The TSB disaster: Where were the grown-ups?
Phil Factor describes how TSB performed a major public disservice with micrsoservices.
2018-08-13
196 reads
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
407 reads
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
77 reads
Blogs
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do...
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Forums
Developer edition cannot be connected from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Moving the Error Log
Comments posted to this topic are about the item Moving the Error Log
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers