2020-02-22
93 reads
editorial
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
281 reads
On Looking and Acting the Part
Phil Factor's offers tips for longevity in the world of IT consultancy: listen well, humiliate no-one and convince others that it was their expertise that solved the problem.
2020-01-18
290 reads
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
252 reads
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
138 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
192 reads
Soft Skills: Controlling your career
Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role. For some people soft skills come naturally. As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]
2021-04-23 (first published: 2019-09-19)
6,539 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
681 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
322 reads
Databases made for Ops, not 'Oops!'
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
2019-06-01
187 reads
Blogs
6 Best SQL Training Courses for Beginners (2024 Updated)
We all know that choosing the right basic SQL training is absolutely crucial if...
SQL Saturday Atlanta 2024
By DataOnWheels
Hey there happy coders! Last weekend I had the pleasure of speaking at the...
Test Data Management – 2024 is your year to do it
By HeyMo0sh
This blog post is about Test Data Management – or my take on it....
Forums
What does it mean when Query Store Tracked Queries shows the same Plan Id twice?
I'm investigating a query which sometimes performs badly and, when I locate one of...
Contained AGs user sync
Hello everybody, I've read that contained AGs create copys of the system dbs which...
How best to identify one (and only one) default row in a table?
We have a table with a numbers of rows in it. (Not that many...
Question of the Day
Reporting Services Editions
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers