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 1 month, 2 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;

Is there a DDL Trigger on the CREATE LOGIN event that's blocking you, either intentionally or because of a bug in the trigger code?

SELECT * FROM sys.server_triggers

https://learn.microsoft.com/en-us/sql/relational-databases/triggers/ddl-triggers?view=sql-server-ver16

TDE certificates don't expire (from the docs for CREATE CERTIFICATE - EXPIRY_DATE entry at https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver15): "However, expiration is not enforced when the certificate is used for database encryption...

IOCP = I/O (disk) Completion Port - After SQL Server makes an asynchronous storage request to the host OS, the OS will return data and notifications through the I/O Completion...