A mix of things. Traffic has declined lately, which is weird.

We depend a log on Google, so we are competing with SO and other places in that sense. Part of...

My basic thoughts:

1. yes, clearly to me, but is it worth the cost/resources expended.
2. no idea
3. there needs to be some management company. This cannot be completely run over time...

Use the Extended Events profiler to do this.

 

You cannot get around this. When your batch is compiled, the UPDATE statement checks for object existence. This will cause an error. Not even in a TRY..CATCH

June 18, 2020 at 2:04 pm

#3764163

Mostly doesn't matter, but if you're tuning, it's nice to have this tidbit to check

Nice, Drew. Moving well with the knee braces.

 

The group moving, flowing, and switching is somewhat hypnotizing. Neat to see.

 

Thanks

Tik tok, baby, let's see the Drewster compete with these girls: https://www.youtube.com/watch?v=_Zq9z6HHTak

Wait, dancing? Are we getting a video posted somewhere?

What Grant noted. Nothing from the source db is missing from the backup. The only chance for something not included is that it is in a transaction that does not...

Glad that many of you have enjoyed them. I'll keep them going for July.

Feel free to submit something

Thanks, Scott....

you can setup Kerberos: https://docs.microsoft.com/en-us/sql/azure-data-studio/enable-kerberos?view=sql-server-ver15

Otherwise, you have to use sql auth

Yeah, I forgot about Dragon. completely inconsistent, one time it would work perfectly and I'd feel like I was living in the future. Then it would be complete trash...

If you run RESTORE MASTER KEY, you need the password from the BACKUP MASTER KEY statement in the "decryption by password" options.

The password used in the "encryption by" is what...