.

• This reply was modified 9 months, 1 week 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

You need to provide an alias for the derived table in the query:

  from (select T0.ID,T1.SID,[dbo].[Planning](T1.Id,T0.SId) as Status
        ...

Instead of migrating, I'd just restore the database 6 times under 6 different names, then drop what isn't needed from each of them.

If you have foreign key constraints between tables...

Certification is a learning path that forces you out of your comfort zone.When I see someone with certs on their resume, I at least know they tried to get out...