Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

  • Home
  • About Me
    • About Me
    • Contact Andy
  • GitHub Stuff
    • Profile
    • DBA Database
    • Data Blogger Resource Kit
    • Presentation Content
  • Legal Stuff

Month: December 2021

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]

github logo Github Profile
DBA Database
Data Blogger Resource Kit
Mastodon:
[email protected]

Subscribe via Email

Join 3,536 other subscribers

SSMS Shortcuts

Awards & Programs



Recent Posts

  • Publishing a Code of Conduct isn’t enough
  • How do I prevent a trigger from firing for one process?
  • Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic)
  • What the heck is the SSISDB? Where does it come from?
  • T-SQL Tuesday #143: My favorite short scripts

Archives

Categories

RSS RSS

  • Publishing a Code of Conduct isn’t enough July 13, 2022
  • How do I prevent a trigger from firing for one process? March 8, 2022
  • Querying SERVERPROPERTY() and DATABASEPROPERTYEX() from a view (without knowing magic) December 17, 2021
  • What the heck is the SSISDB? Where does it come from? October 18, 2021
  • T-SQL Tuesday #143: My favorite short scripts October 12, 2021
  • What time is it in Oz? October 5, 2021
  • Stop using sp_hexadecimal & sp_help_revlogin July 6, 2021
  • FAQs about the dissolution of PASS December 28, 2020
  • Closing Time December 8, 2020
  • Multi-subnet availability group, with mixed MultiSubnetFailover support (Part 2) October 6, 2020

Copyright © 2023 | Andy Mallon | am2.co