The harsh reality of charitable IT work
At work in IT, we can wander around looking important with no apparent useful skills whatsoever. When working outside the bubble of the industry, things are different.
2019-12-14
242 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Human frailty and the custodianship of data
Until you open the box your data is, like Schrödinger's cat, both safe and breached.
2019-11-16
126 reads
Protecting Data from the Inside
Phil Factor on the difficult task of guarding against the theft of data from within an organization.
2019-10-19
182 reads
The Multi-skilled Developer
Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.
2019-09-25 (first published: 2015-06-08)
554 reads
Using Big Data to Improve Health
With the help of a database that provides fully representative data, we can do a great deal more to advance medical and pharmaceutical science. Phil Factor explains what stands in our way.
2019-09-21
179 reads
SQL Tamagotchi! Mini-Servers as Database Pets
If you've ever stuffed SQL Server onto a Raspberry Pi 4 and given it a pet name, don't worry, you're not alone…
2019-08-24
262 reads
Muting the Immutable
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
311 reads
The Sequel to SQL
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
2019-08-10
446 reads
Data Transfer Strategies between MongoDB and SQL Server
There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.
2019-07-22
7,235 reads
Over-thinking Database Build Scripts
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
2019-06-29
300 reads
Blogs
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...
Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
Forums
"Home PC" SQL instance
This may be a bit non-typical, but I am currently running SQL 2019 Developer...
Interview question about CPU
Hello SSC friends, I am a SQL Developer who is learning how to be...
Ask SSC