Network Ports, LCIDs and SQL ParseName

Here’s an Excel spreadsheet illustrating network ports used by Microsoft products. The spreadsheet shows what network ports are used by the system services utilized by the Microsoft Windows Server System products.

And there’s a List of Locale ID (LCID) Values as Assigned by Microsoft. It lists the locales/languages with an assigned LCID. The purpose of the document is to help developers who are defining NLS services (sorting, time/date formatting, and keyboards/IMEs) for locales that do not yet have native support in Windows to avoid conflict.

Also, came cross a new article by Damian Maclennan on using the PARSENAME function to split delimited data in TSQL.