'At-Rest Data-Leakage': The Euphemism
If you let working drives leave the building in a readable state, you’re unintentionally in the publishing business.
2012-12-31
97 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
The SQL Server Pro Awards
Phil Factor is pleasantly surprised by the SQL Server Pro awards, and talks about the thinking behind Down Tools Week.
2012-11-23
178 reads
The Small Print
In today's guest editorial, Phil Factor issues a stark warning against cunning salesmen and hidden costs in cloud computing.
2012-11-21
128 reads
A Tool for the Job
Phil Factor is puzzled by reading how difficult a relatrional database is to use for certain tasks.
2012-11-20
213 reads
A Tale of Broken BI
Graphs and charts are dangerous in the wrong hands, and if built on data that is carelessly gathered will mislead as often as they lead. Phil Factor speaks from hard experience.
2012-10-29
130 reads
Your Password has Failed the Test
Your data is in the public domain and as a DBA you need to be very familiar with what it is possible for the sinner to do with a handy password, and how easily that sinner can get hold of it.
2012-10-08
154 reads
The Longevity of the Relational Database
Waves of NoSQL hysteria come and go but the relational database remains, and Phil Factor admires its sheer ubiquity, and ability to provide data integrity and accessibility for a vast tapestry of data categories.
2012-09-17
275 reads
Document First, Code Later
Phil Factor on the many advantages of building the code from the documentation. For one, it forces us to learn the language and concepts of the business processes before designing the schema.
2012-09-10
299 reads
Windows Server 2012, ReFS and No SQL Server
ReFS, the new file system with Windows Server 2012, should be good news, but its apparent lack of support for SQL Server is a serious concerned for Phil Factor.
2012-08-06
495 reads
What to look for in an employer
A Job interview for a database Developer is, or should be, a two-way process. They are sussing you out, and you are sussing them out.
2012-07-23
218 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