2020-12-12
157 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Presenting the Facts about Data Breaches
If you're faced by an investigation team, after a data breach, it is no use putting on your 'Mr. Sincerity' face and making vague statements. They want documented facts.
2020-11-14
106 reads
Responding to the Call of the Wild
Phil Factor's manual for taming machines, applications, and other wild beasts.
2020-10-17
81 reads
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
196 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
236 reads
2020-06-27
162 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)
442 reads
2020-05-30
133 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
146 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)
347 reads
Blogs
How to get data in a DataFrame via .NET for Apache Spark
By Ed Elliott
When I first started working with Apache Spark, one of the things I struggled...
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Forums
Nested loop/HashJoin and left/right/full join
1. What is the difference among nested loop?hash join and merge join? 2. what...
SSMS & Excel - Copy Paste - DateTime Columns
Dear Group: I am not sure if this is a T-SQL / SSMS issue,...
Linked Server Insert error
Hello i have linked server one server in cloud one is local from local...
Ask SSC