Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
2020-10-17
65 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Coping with a working life as an imposter
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
2020-09-19
180 reads
Of Hedgehogs and Database Design
One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
2020-08-22
209 reads
Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3
This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.
2020-08-05 (first published: 2016-09-28)
4,111 reads
2020-06-27
146 reads
Falling Over our Assumptions
There's a saying about what it says about a person to assume something. However it's something we all do every day. Phil Factor brings us a guest editorial about assumptions in SQL code.
2020-06-25 (first published: 2009-04-08)
416 reads
2020-05-30
125 reads
Representing uncertainty in difficult times
The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?
2020-05-02
145 reads
Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6
Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.
2020-04-15 (first published: 2016-12-21)
9,471 reads
Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script
Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.
2020-03-19
437 reads
Blogs
Using Write-Debug
By Steve Jones
I wrote a post about PoSh output recently, noting that in general we ought...
T-SQL Tuesday Retrospective #002: A Puzzling Situation
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...
Daily Coping 28 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Building Quality In
Comments posted to this topic are about the item Building Quality In
Setting Rows to Odd and Even Values
Comments posted to this topic are about the item Setting Rows to Odd and...
Ask SSC