Microservices in SQL Server
In SQL Server 2017 consuming or providing JSON data is so efficient that you can implement effective microservices right from the database, argues Phil Factor.
2017-11-13
2,025 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
Timing is Everything
Phil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.
2017-10-16
90 reads
The Achilles Heel
In a long career in IT, Phil Factor cannot recall a 'major incident', where the failure or breach was due to a single 'Achilles Heel', or even a single team of people. They are always due to a whole plethora of slack and ignorant practices.
2017-10-09
108 reads
The Worms-eye View
Even the most elaborate team-based development methodology won't compensate for the blinkered attitudes and tribal cultures that come from over-specialization in IT.
2017-10-02
72 reads
Avoiding the Hell of having to Remember DDL syntax
What's your favorite productivity tool when writing SQL? Phil Factor has has flirted with most of them, from templates and snippets to a programmer's clipboard and back again.
2017-09-18
120 reads
The struggle to renormalize data
You are given an export of a NoSQL database, in JSON, and asked to import it into a relational database. Sounds easy? It isn't and Phil Factor explain why.
2017-09-11
217 reads
The art of getting it right
Phil Factor advocates paying attention when it doesn't matter to prepare for when it does.
2017-08-14
101 reads
The Tethered Goat
Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".
2017-08-07
99 reads
The Forgotten Editorial
Phil Factor reflects on the occasional benefits of document loss, whether accidental or less so.
2017-06-26
69 reads
The Value of Surveys
Phil Factor on the perils of trying to squeeze good insights out of bad surveys.
2017-06-12
65 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers