CREATE STATISTICS ... WITH AUTO_DROP is only available on AzureSQLDB, Azure Managed, and SQL2022.

The package was created with the wrong target SQL Server version.

After booting them out of the ddl_admin role, you can GRANT and DENY permissions to them directly on the Schema, which will carry through all objects within the schema. Include...

Note: Availability Groups are Mirroring version 2.x; you can repurpose the mirrors into AGs that include an AG Listener that will redirect clients after a failover.

Convert the separate mirrors of...

.

• This reply was modified 1 year, 5 months ago by  Eddie Wuerch. Reason: Response was double-posted

There are a variety of actions you may take on a server that are prohibited in the documentation. I've dealt with several over the years in a VLDB world such...

The encrypted data isn't affected by the hashing algorithm change, the storage of the encryption key is.

Details of the issue are listed in the KB article that introduced the trace...

You can stop treating a normal condition as a failure that can be ignored by adding the check for primary into each step that does work that should only occur...

What was the login error, and on which of the two SQL Server instances was it recorded? The client will only receive error 18456 and no other details, but the...

You can use LIKE in natively-compiled procedures, and that's enough:

-- Declare 2 strings: one with a bad character, and one without
DECLARE @BadChar varchar(128) = 'A funky char...

"I have to say that I don't understand the "/SQLSVCACCOUNT" switch or why its needed, but that seems to work."

SQL Express does not run as a program like the application...

You are correct in that SQL Server cares not what the source of the certificate is - an X.509 cert is an asymmetric key pair in a specific format. It's...

A Data Space is either a Filegroup or a Partition Scheme. Everything showing in your result with a Data Space Name that isn't a filegroup (or has a data_space_id that...

Check the Licensing Guide for SQL server (https://download.microsoft.com/download/e/2/9/e29a9331-965d-4faa-bd2e-7c1db7cd8348/SQL_Server_2019_Licensing_guide.pdf)

That doc is for 2019, but the relevant section hasn't changed for several versions.

Search the Licensing Guide for 'Downgrade rights'. A...

You PIVOT to turn row values into column names.

SQL Server does not provide dynamic PIVOT, you must specify the names for the new columns you want returned.

Because 'Dry', 'Fine' ('Fines'...

Add the 'ALL' option to your WHERE clause:

WHERE @Daygroup = 'ALL' OR DayGroup = @Daygroup