Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
2020-10-17
49 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
176 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
208 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)
414 reads
2020-05-30
124 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
144 reads
The Panjandrum Conundrum
With progress thwarted by a committee of panjandrums, will T-SQL forever remain in the doldrums? So wonders Phil Factor.
2020-03-09 (first published: 2017-07-10)
341 reads
2020-02-22
86 reads
Towards an efficient interface between application and database
As JSON documents becomes increasingly widely used, as the interface between application and database, Phil Factor reckons it's about time JSON Schema was built-in to SQL Server, alongside XML Schema.
2020-01-25
242 reads
Blogs
Solve SQL Server Resource Database Crash
Based on Microsoft Documentation <The Resource database is a read-only database that contains all...
Daily Coping 20 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
sql server spatial data tutorial
Hello my fellas Sql Server experts... I have been a SQLDBA for over 15...
Poor peformance
I ran the update stats on a table by creating the indexes, when i...
SQL Server data file distribution
I am a newbie to SQL Server administration and config. Apologies if I appear...
Ask SSC