Sadly, there's not a hard and fast rule on this, other than, leaving it at 0 is generally a poor choice. Setting it to 1 is actively a bad choice....

Otherwise, for pointers, look up my name and "Database Lifecycle Management." There's a free e-book out there somewhere. It's a bit long in the tooth, but still pretty applicable on...

Those are usually combination of needs from the app married with knowledge of the model. Models are insanely helpful when developing. It's just that most places have gone so hard...

When you create an Azure SQL Database, you also get a "server." However, it's not a server like if you were running on hardware or a VM. It's simply a...

Wow! Someone actually designing a database. Cool!

There are modeling tools out there that can do a relational diagram. I work for Redgate and we sell this one. The core...

Think of a stairway like a short book, consisting of chapters. If you think this qualifies, go for it. Steve generally makes the final decision on this stuff, but it's...

As long as you're meeting compliance needs, sure, why not? I mean, I'd look to educate the heck out of them so they're not running wildly inefficient queries, cartesian joins...

Thank you for all that you, Andy and Steve did. You didn't just build a web site and a community. You built a tool that people could use to enhance...

Our dog is 12 years old and has an orange sized tumor on this back right leg. He is not a candidate for surgery.

He still likes to walk and...

Changing the subject... Last week was fun. One of my cats ended up with a large bump suddenly appearing on her leg. As I've been through this before, I...

DB-300? Is that the code you mean. That's the cert for "Administering Relational Databases on Microsoft Azure."

As for recommendations, I haven't found certifications all that useful in my career. However,...

Thank you, Grant, for sharing what you're working on. My project during my holiday break, isn't as ambitious as yours, but I'm glad I finished it. I started a...

Ha! Yeah, I guess so. Still doing work on it this morning. I'm figuring out if I can get PostGIS installed and then do some additional web pages to show...

Having just successfully built a functional application using only prompts and agentic AI, dbRosetta if anyone is interested, I have to say, currently, this thing isn't going to replace...

Q1) You can. I wouldn't because, for most people, this thing is back there running and they never know. It's the hyper-rare workload that will see actual interference from this....