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: May 2020

Find the SQL Server service account with sys.dm_server_services

May 12, 2020 Andy 3

SQL Server 2005 introduced Dynamic Management Views(DMVs). Technically, there are both views & functions–DMVs & DMFs, but colloquially they’re often simply referred to as just “DMVs”. DMVs simply return information about the state of the server or database and can be used for monitoring and … [Read More]

Making non-SARGable queries seek, without changing the query

May 6, 2020 Andy 3

We’ve all been there. You’ve got a query where the JOIN or WHERE predicate is not SARGable. You’ve read about how this can be a problem, and how bad it is for performance. Alas, you cannot change the query. Sometimes this reason is political, sometimes … [Read More]

Replication latency when an Availability Group replica is offline

May 4, 2020 Andy 2

Assume you have configured a transactional replication publisher, which is part of an availability group (AG). Now, you have an asynchronous secondary AG (or mirroring) replica that is offline. Perhaps this is a DR node, and you are doing patching or other planned maintenance on … [Read More]

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

Subscribe via Email

Join 3,540 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