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
1,889 reads
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
1,889 reads
Phil Factor on the wise habit of timing your database routines, to avoid relying on received wisdom about performance.
2017-10-16
80 reads
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
94 reads
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
63 reads
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
98 reads
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
185 reads
Phil Factor advocates paying attention when it doesn't matter to prepare for when it does.
2017-08-14
84 reads
Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".
2017-08-07
75 reads
Phil Factor reflects on the occasional benefits of document loss, whether accidental or less so.
2017-06-26
57 reads
Phil Factor on the perils of trying to squeeze good insights out of bad surveys.
2017-06-12
50 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers