Nov 4-8, back in Seattle.

Sorry you missed it, but I get the concerns over a shutdown. You missed a great event, but I bet next year is better. More people...

In SQL Server 2022, there is a container AG (https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/contained-availability-groups-overview?view=sql-server-ver16), but not in 2019.

You can back up master, but you aren't restoring it elsewhere, as this will also make...

Thanks for the note

I don't know if they will be. The conference recorded all sessions, but those are for people who attended to access. I think you can purchase access if you didn't...

I am very happy to work for a UK company. They definitely treat us well

Yep: https://monitor.red-gate.com/overviews/SQLMON-EC2-BM2/dbms/r1,4%3Abase,s36%3A260ca7e9-c6fa-4cc5-8de2-e05e68114e71,7%3ACluster,1,4%3AName,s21%3Assc-db-clus.ssc.local,9%3ASqlServer,1,4%3AName,s10%3Assc-db-n3%5C,?zoom=1700515717917%2C1700522917917&present=true#databases

Hard to tell if the IQP stuff helps us. The queries for WordPress aren't great, so it may...

That's really the point. I think some of these aren't things you'd know, but perhaps can guess. Would you think the low/high setting would be the extreme end or in...

Comparison tech is the way to do this. I'd suggest SQL Compare, but any tool that does this will help.

Disclosure: I work for Redgate Software

If diffs are every day, then this would cover things. If there is a break between the full and first diff, which is how I see people set things up...

I have habits to use plural, but I've come to think singular makes more sense, especially in cases like Aaron listed where you create a join table.

This should be fixed.

12am full to 2am diff is 26 hours for the first one, so no, not 24 hours.

In terms of your last question, changing logins makes changes in master. Changing users...

This help? Low memory? https://dba.stackexchange.com/questions/141236/failed-allocate-pages-fail-page-allocation-1

A few other links point to this.

It's such a wide platform now, I constantly find things that I've either forgotten were added, or never knew because of the changes.

Definitely an exciting time to work with data,...

You'd be wrong. You can change the data type of an identity property column to one of the types in the error. What you cannot do is remove the identity...