Microservices, SOA and Service Broker
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
2015-03-23
461 reads
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
2015-03-23
461 reads
Phil wonders whether it is our poor vocabulary about databases that has lead to the failure of developers and Operations people to understand each other on the topic of deployment.
2015-03-09
240 reads
In which Phil Factor casts doubts on 'programming policies'. For certain, any IT team development requires plenty of methods of working that maximise productivity, but coding standards and ‘best practices’ have to be treated with caution. Programming rules can’t replace professional judgement
2015-02-09
210 reads
Phil Factor on the sort of boring expertise that will help you thrive as a consultant.
2014-12-08
140 reads
Phil Factor argues that as terrorists and criminals exploit the new opportunities that open up as technology develops, technologists must work with Governments to ensure thoughtful custodianship of data, and sensitivity towards legitimate privacy.
2014-12-01
92 reads
2014-10-20
266 reads
2014-08-04
2,205 reads
There is little doubt that static code analysis can contribute to code quality and deliverability. As an aid to a developer, it seems increasingly essential, but can it ever deliver reliable metrics of code-quality? One shudders at the potential misuse of quality metrics in the wrong hands. My hope is that it remains just an aid to human judgement; and creativity.
2014-07-28
77 reads
Phil Factor explains that being a consultant in the latest IT hot topic is a worthy role. Someone has to do it, and Phil explains why.
2014-07-21
181 reads
2014-07-18
1,551 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers