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,965 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
80 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
94 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
63 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
106 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
195 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
85 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
77 reads
The Forgotten Editorial
Phil Factor reflects on the occasional benefits of document loss, whether accidental or less so.
2017-06-26
57 reads
The Value of Surveys
Phil Factor on the perils of trying to squeeze good insights out of bad surveys.
2017-06-12
50 reads
Blogs
Grinding Away: Brent Ozar
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
Monday Monitor Tips: Am I Patched?
By Steve Jones
One of the things that I think is neat is that Redgate Monitor helps...
Big Queries, Big Money
By Steve Jones
I had been meaning to post this, so as I finished a piece that...
Forums
Download Aol Desktop Gold +1 (858) 333 4611 Install Aol Desktop Gold or Update
AOL Desktop Gold Download+1 (858) 333 4611 : A Step-by-Step Guide AOL Desktop Gold...
Peer review SQL Central articles
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
Question of the Day
Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers