Click here to monitor SSC

Phil Factor


Phil Factor

De-duplicating Delimited Lists in SQL Server

5 comments

/* In a recent article 'Removing Duplicates from Strings in SQL Server', Aaron Bertrand comes up with the interesting problem of removing duplicates from lists of strings. The example he gives is … 'Bravo/Alpha/Bravo/Tango/Delta/Bravo/Alpha/Delta'… and you want to make each word unique in the list… ‘Alpha/Bravo/Delta/Tango’. … You want just one occurrence of Bravo, for […]

19 January 2016 6:24 pm by
Phil Factor

The SQL of the Feast Days of Western Christendom

7 comments

I've been intrigued for a long time by the Christian feasts. Nowadays, we start getting excited about Christmas around July, and it is considered by commerce to be fair-game as a de-walletizing activity from Halloween onwards. I would like far more feast days to get excited about. Our ancestors had so many feast days that […]

24 November 2015 12:30 pm by
Phil Factor

Late in the Day for a DBA

8 comments

I first met Joe when I went to Woodworking evening classes several years ago. I saw him from across the room. He was at the lathe, turning a bowl. There was something about the careful, diligent way he was working that activated my DBA-dar. I approached him. “You’re a DBA, aren’t you?” I asked. He […]

5 November 2015 1:53 pm by
Phil Factor

Soft Skills for the Developer

20 comments

(Guest Editorial for the Simple-Talk newsletter) In the rush to recruit a developer to fill a gaping void in a development project, it is sometimes easy to forget the relative importance of the skills you need. We were building a complex middleware architecture based on SOA principles with distributed transactions. The task was daunting, and […]

11 September 2015 10:54 am by
Phil Factor

Typoglycemia: The PowerShell and the SQL

16 comments

Typoglycemia is the ironic name, (derived from Hypoglycemia) given to the phenomenon that many readers can understand the meaning of words in a sentence even when the interior letters of each word are scrambled. They appear to recognize words by the outermost letters, the length, the letters used and the context.  As long as all […]

30 August 2015 9:37 am by
Phil Factor

SQL Server: The Neglected Features

12 comments

Have you ever experienced that moment in an exam, frantically scribbling your answer to the final question, when the invigilator looks sternly across the room and says “time’s up, now cease writing and put down your pens”? I sometimes imagine this happening to the developers in the server division of Microsoft. SQL Server has several […]

28 August 2015 11:23 am by
Phil Factor

Can Code Review Be Automated?

7 comments

I was scanning the API of DacFx, the ‘engine’ of SSDT, and became interested in the facility it contains for automating SQL code reviews. DacFx allows you to parse the SQL code sufficiently to do static code analysis, to scan for heresies, deprecated code and code that doesn’t ‘conform to corporate policy’. Dave Ballantyne has […]

17 July 2015 11:38 am by
Phil Factor

UWP: The Platform Formerly Known as Metro

7 comments

Three years ago, I listened to a keynote at a developer conference. The man from Microsoft beamed confidently at the vast auditorium and said “I can tell you confidently that in a year’s time, you will all be writing Metro applications for a huge marketplace”. We clapped, but as the keynote proceeded and we saw […]

21 May 2015 12:46 pm by
Phil Factor

Spinach and Database Development

1 comment

A little while ago Phil got to thinking about his garden, and the myths and misinformation that forced inferior food down the gullets of children. This was an example of bad data, and Phil wants it gone. Below is a video (and transcript) that Phil gave as the keynote of SQL Saturday Exeter. The Transcript […]

14 May 2015 4:16 pm by
Phil Factor

The Database Neighbours From Hell

5 comments

In the Windows environment, there seems little safer for application design than a rather staid single-tiered architecture making ODBC/JDBC calls to the RDBMS. I can say this with years of experience in developing applications ranging from the dull but worthy, to the esoteric. However there is an interesting long-term cost to taking the easy route […]

9 April 2015 5:16 pm by
Older posts

Blog archive