Sorry, but what?

So you're storing it twice, once as the automated column value and another time as something updated, trigger or what not? I'd go with the varbinary then.

If you're using rowversion, use the rowversion data type. Can you use others? Sure. Why? What functionality will you get that you don't already have? What functionality will you lose?...

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...