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
123 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)
467 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
385 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,527 reads
2018-09-24
153 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
529 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,203 reads
The TSB disaster: Where were the grown-ups?
Phil Factor describes how TSB performed a major public disservice with micrsoservices.
2018-08-13
199 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
411 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
80 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers