Tag Archives: list

Comparison list of various laptops and PCs

Leave a comment

Updated for 2024 Random PCs and laptops I have used in the past for work and play: Lenovo T14 Gen4 Processor AMD Ryzen™ 7 PRO 7840U Processor (3.30 GHz up to 5.10 GHz) selected upgrade Operating System Windows 11 Pro 64 selected upgrade Operating System Language Windows 11 Pro 64 English selected upgrade Microsoft Productivity Software  None Memory 32 GB LPDDR5X-6400MHz (Soldered) selected upgrade Solid State Drive 1 TB SSD M.2 2280 PCIe Gen4 Performance TLC Opal selected upgrade Display 14″ WUXGA (1920 x 1200), IPS, Anti-Glare, Non-Touch, 100%sRGB, 400 nits, 60Hz,

Read more Bought and Sold, Building, computer tips, Computers, Daily Updates, Gadgets and Tech

SQL Server: list all user defined functions in a database

Leave a comment

Recently I inherited a database project where many of the functions were not listed nor documented. Thankfully, with the help of the always useful stackoverflow, I was able to find the following snippet for displaying all user functions: select name, definition, type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id where type_desc like ‘%function%’ via sql server – SQL list of all the user defined functions in a database – Stack Overflow. Very cool! 🙂

Read more computer tips, Database tips, programming, Work