Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

  • Home
  • About Andy
  • Stack Exchange Stuff
    • DBA Stack Exchange
    • Stack Overflow
    • Server Fault
    • Super User
  • GitHub Stuff
    • Profile
    • DBA Database
    • Data Blogger Resource Kit
    • Presentation Content
  • Legal Stuff

Month: February 2022

How to change the web browser used by SSMS when you hit Ctrl+Alt+R

February 15, 2022 Andy 0

Question When I am running: Ctrl+Alt+R will run the web browser in an SSMS tab. However, this now produces the message: I do have MS Edge installed but SSMS is not finding it. What should I do to help SSMS find MS Edge and use … [Read More]

Allow create table (dynamic name) and insert but nothing else

February 14, 2022 Andy 0

Question I’m trying to find a way to allow an application to create tables and insert data into them on a SQL Server 2019 while protecting from injection attacks in case the app credentials would leak. My experience is limited when it comes to writing … [Read More]

Add default rows to the query result if restrictions are not met

February 10, 2022 Andy 0

Question I have a SQL query that looks for values in a table on a range of dates. If no record is found, I would like to generate rows with default values. Example of one of the table existing records: DeviceId Time Context Value 1 … [Read More]

How to revoke SA permissions that seem to be “stuck” to a login?

February 2, 2022 Andy 0

Question Apologies in advance if I don’t use some terminology correctly here. I’m not a DBA but I’ve been temporarily forced into the role. I’ve inherited an application that runs on SQL Server 2016 Enterprise – one instance for PROD and another for TEST. These … [Read More]

github logo Github Profile
DBA Database
Data Blogger Resource Kit
Mastodon Logo Mastodon:
[email protected]
DBA.se profile
My Stack Exchange answers (mirror)

Subscribe via Email

Join 979 other subscribers

SSMS Shortcuts

Awards & Programs



Recent Posts

  • Consuming SQL Agent dates & durations
  • Migrating my Stack Overflow answers to blog posts (Sorry for the spam)
  • Not all stats should be auto-updated
  • T-SQL Tuesday: The last ticket I closed
  • Enforce a specific constraint to be checked first?

Archives

Categories

RSS RSS

  • Consuming SQL Agent dates & durations March 7, 2025
  • Migrating my Stack Overflow answers to blog posts (Sorry for the spam) November 11, 2024
  • Not all stats should be auto-updated August 29, 2024
  • T-SQL Tuesday: The last ticket I closed February 13, 2024
  • Enforce a specific constraint to be checked first? October 7, 2023
  • AG secondary is out of sync for hours after index maintenance February 21, 2023
  • Using OPENJSON, can’t get results to GROUP BY December 24, 2022
  • SQL Modulo Function gives the wrong value? November 18, 2022
  • Is SQL Server affected by OpenSSL 3.0 Vulnerabilities: CVE 2022-3786 and CVE 2022-3602 November 8, 2022
  • What’s the use case of disabling an index? September 25, 2022

Copyright © 2025 | Andy Mallon | am2.co