December 2021 - Andy M Mallon

Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)

December 17, 2021 Andy 1

I’m not going to beat around the bush. I hate the SERVERPROPERTY() and DATABASEPROPERTYEX() system functions. Loathing The thing I hate the most about these two functions is that you need to know the right magic spells to make them work. Let’s look at SERVERPROPERTY() … [Read More]

Which install kit installs sqlcmd.exe?

December 12, 2021 Andy 0

Question I recently had to uninstall Visual Studio 2012 and DTS, then install VS 2017 and DTS again. Afterwards, The directory containing sqlcmd.exe was not in my PATH variable. I installed the following. Should either of these kits install sqlcmd.exe? If not, which tool will … [Read More]

Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

Month: December 2021

Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)

Which install kit installs sqlcmd.exe?