The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is
always a poignant, bitter-sweet experience. I was going through his most
precious books...
2009-06-18
1,985 reads
Going through one’s father’s belongings after his death is
always a poignant, bitter-sweet experience. I was going through his most
precious books...
2009-06-18
1,985 reads
Do CLR triggers really represent the most popular usage of CLR in enterprise SQL Servers? Phil Factor wants to know if this is the case, and if so, what on earth are they doing?
2009-06-08
503 reads
Phil Factor muses on security, bayonets, and databases, and somehow manages to pull it all together in this editorial.
2009-06-02
203 reads
One of the charming people who helped me register at Teched told me where we, who had registered, could get...
2009-05-10
1,704 reads
I spent a fascinating hour at the Teched Shop this afternoon. I was trying to get a feel for where...
2009-05-10
1,275 reads
The software industry is, just occasionally, more absurd than one would dare to imagine. Having spent most of his working life in its clutches, Phil Factor has pretty much "seen it all" and what's more he's prepared to tell what he knows. The second edition of Phil's "Confessions of an IT Manager" contains Phil's full repertoire of tales of institutional mayhem and software projects gone awry.
2009-05-07
2,520 reads
Steve Jones isn't usually the wild man of publishing, but on April 1st, a strangely
anarchic spirit breaks loose. Having...
2009-04-03
1,490 reads
Phil has a nasty surprise when a team of testers turn up to test an n-tier system
2009-03-30
108 reads
Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....
2009-03-18
3,881 reads
Most of the time, you want to have a SQL result in a particular order. Occasionally you just don't care....
2009-03-16
3,122 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers