I'm not sure the cone placers are driving. They are protesting cars in general, and assuming autonomous cars are adding to the problem, not solving them.

Personally, I think Zip cars...

I do that far too often. It always makes me think how Star Trek would work in practice, with all the touch screens and being in battle.

Yep, different. Thought I might have typo'd, but they are different.

You can increase the timeout for connections, but honestly, to me this is a proactive things DBAs need to do. VLFs are less of a problem in modern versions, but...

...

The 1st thing I do when I start my wife's Skoda is to turn off the lane assist function.  It's dangerous.  It either doesn't work when you expect it...

Little background. Apologies if you know this stuff.

A symmetric key is encrypted by one or more other methods. You can have one method (cert) that encrypts multiple symmetric keys.

At the...

OK, that looks good. I know that the cert formats are a little strange. The challenge I think is a lot of certs from authorities are formatted for the web,...

William, might be good to have a new post, but did you use the CREATE CERTIFICATE syntax in SQL Server? Can you post what that did and the error?

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql?view=sql-server-ver16

The...

The SELECT needs a schema-lock because it has a plan to read the table. The table structure cannot change while the SELECT is reading, hence the lock.

As Johan says, kill...

I'd script out the db, make sure you know the default filegroup and files are set up correctly. Likely this is either something you've missed when checking, or as Johan...

I'm not sure what you want here. There are examples on that page. The top has a TOC with links, like this one for examples: https://learn.microsoft.com/en-us/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16#examples

This was added to...

Please post details of the versions, code if any, and the error log portions. You're assuming we know what "they" or "these errors" are.

For the first part, using AWS instead of some server, I think this makes sense. The idea of FaaS type environments is this particular scenario: you don't want to manage...

I don't have time to test, but I assume this would work fine. The read-only prevents changes to the publisher, but replication reads the log, as a separate job from...

hasn't disappeared. It's here: https://www.microsoft.com/en-us/sql-server/sql-server-2019-resources

The default SQL Server page is always the current version. In the past their web teams haven't gotten good at removing the old version and...