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

Their point is clicking "trust server" without a CA cert means you are vulnerable to man in the middle attacks. You don't know if you're connecting to the correct server.

CamelCase would so much better for HorsesTakeWork

Without starting a huge discussion of incompetence at many many organizations, and excluding the politicians, how many completely unqualified individuals are holding positions where the decisions they make affect...

It's hit and miss. The reminder for missing low toner is something lots of people would like. Don't want to manage this, don't want a steady order, but a smart...

Be a person who doesn't just rest on intimate knowledge of their chosen technology path, but also has a serious grasp of the business logic driving the need for...