How do you explain anything to the chiefs? Use their language.

MONEY

There are costs associated with both your approach and the one taken.

There are financial benefits to be realized from both...

The contents of "attributes" is an array, so you must further shred each row by passing the "attributes" array into another OPENJSON call through OUTER APPLY. This produces one row...

from https://techcommunity.microsoft.com/blog/azuresqlblog/hosting-ssrs-databases-in-azure-sql-managed-instance/1700197

If your SSRS reports are pulling the data from databases hosted on Azure SQL Managed Instance, consider hosting report server databases on the same instance, thus minimizing...

To pull off multiple aggregations in a single pivot, just code it yourself:

WITH CountsAndSums AS (
  SELECT County, DiagnosisGroup, 
      ...

Any connection accessing a database will, at the very least, hold an S (Share) lock on the database. That S lock prevents others from taking exclusive control of the DB...

• This reply was modified 4 months, 3 weeks ago by  Eddie Wuerch. Reason: added BOL link to sys.dm_tran_locks

Upgrading a cryptographic provider can be accomplished without restarting the instance or dropping the provider, with the key provision that this only works if the name of the provider file...

When you declare @id, its initial value is NULL. When you concat NULL to any other string, the default CONCAT_NULL_YIELDS_NULL connection setting will result in a NULL string.

Initialize @id with...

Also check what the product is doing - I've been places where threat scanning involved a product throwing a laundry list of known exploits at each of the SQL Servers...

There's a free SQL database option: https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

100,000 vCPU minutes/month, 32GB max DB size. You can set the "Behavior when free limit reached" option to 'Auto-pause the database until...

You're working too hard. You can do decimal math on datetime values; 1.0 = one full day, 0.5 = 12 hours, etc:

SELECT getdate() AS [Now], getdate() +...

ADF feels like 'the next version of SSIS, but in the cloud', IMHO. SSIS/SSDT are free; if you have access to materials to help you learn the on-prem tools, then...

1. Kick off a restore
2. SELECT * FROM sys.dm_tran_locks WHERE request_session_id = the @@SPID of the restoring connection.

During restore, the restoring thread will take an X lock on the whole...

I previous worked for a very large SaaS software company. Here's the approach they took, which works to solve the A vs B problem:

1. Management clearly dictates in writing and...

With the exception of adding a step #0 to start the session, I repeated your posted steps on SQL2022 in the same order, Viewing Target Data after the CREATE DATABASE...

Did you start the session?

ALTER EVENT SESSION [testsession] ON SERVER
STATE=START;