Our C# developers (who know just enough SQL to be dangerous) write code using Entity Framework and I have trust that Microsoft will generate good SQL. So far so...

@Grant ,

Awesome... I don't know...

@Grant ,

Awesome... I don't know how...

Thanks for all the feedback everyone. Appreciated.

Me, I love tuning queries.

Yes Jeff, working on the new book. Chapter 20 right now, Graph data.

Have fun with the baseball. Most fun I've had is going to the games with Allen White. I like watching him watch the game. Far more fun than the game...

Thanks Rick, but I'm not actually going to Gettysburg this trip. Sorry for the confusion. This time it's Pea Ridge and Vicksburg.

Uh oh. All the shame.

Thanks Steve.

Appreciate it Luther. I plan to hit the Virginia battlefields someday.

Tom, not sure, but I had a blast tromping around the Gettysburg battlefield with the...

Yep. Pretty much.

Ha!

The optimizer will absolutely rearrange your WHERE clause. It's part of how it works. It'll also rearrange and reorder your JOINs. So, from the most simplistic approach, WHERE & JOIN...

Just piling on with @ratbak

Every object in your queries should be qualified with the schema owner. If for no other reason, it reduces, in ever so tiny an amount, the...

Thanks everyone for the feedback so far. All jives with my understanding. I've just never heard the phrase "healthy deadlocks" before, so I was curious what others thought.

Question for the smart people, and the rest of you.

Would you endorse or get behind the statement:

Some deadlocks are healthy.

or

Some level of deadlocks is healthy.

Or is more something like:

Some level...

Backups should be run serially. I tried running them in parallel. It's a great way to bring down a server. So yes, most tools, software and suggested solutions, show backing...

If you're just looking at hosting a container, all the cloud vendors do it. Amazon ECS is one option. Azure Container Hosting is another. Pricing-wise, they're pretty similar. Better to...

If you're looking for truly legit certification courses, I'd suggest starting with Microsoft. There, they list a bunch of partners that offer up-to-date training. If you want online, Pluralsight...