In this case, tooling did this for me. No typing involved. This makes it clear where the column is located, and if there were joins, this is required.

We often alias...

I think those local environments are tough, though I'd made sure they were VMs. Helps with replacing hardware and DR. I think this is one reason Azure and AWS moved...

Yes,...

We have a physical 3 node WSFC with 6 SQL FCIs. We are using cross-site AGs for DR. We built this in 2017; running MSSQL 2016. Pretty much everything...

New physical nodes installed with Windows Server 2019, and hooked up to FiberChannel & SAN shared storage; setup MSSQL...

In SQL Server, we have more databases on a service more easily than some other RDBMS. For the sake of argument, whether there is a separate db or schema isn't...

In SQL Server, we have more databases on a service more easily than some other RDBMS. For the sake of argument, whether there is a separate db or schema isn't...

IS_MEMBER() might work for you: https://learn.microsoft.com/en-us/sql/t-sql/functions/is-member-transact-sql?view=sql-server-ver16

I don't think most apps need everything in RAM, but some might need certain sections. That's one reason the In-Memory OLTP tables came about, though those have too many restrictions...

Yes, but do...

I have some fond memories of getting out the screwdriver to deal with the big pile of boxes from Compaq.  Was never officially my job, but the server build...

We are still running a "classic" WSFC with a two-node FCI, sitting atop a rock-solid SAN, all on-prem.

MSSQL Server 2019 running perfectly, without issues.

Yes we have the admin overhead...

modify_date can be used if the principal wasn't changed. For example, a password change updates this.

What I'd do is this. Grab the current identity, then reseed to that + the number you need. So if the current identity is 1100, and you need 5000, then...

https://www.redhat.com/en/topics/devops/what-is-gitops#:~:text=GitOps%20uses%20Git%20repositories%20as,set%20for%20the%20application%20framework.

Really all the XOps stuff is using code to do things instead of humans clicking (or typing in real time). Store your infrastructure stuff in Git and then use...