Yep, apparently testing and copy/pasting doesn't work well.

answer edited.

with your permission set, if I grant that to a user, I get this error for the grant for a procedure:

Msg 15151, Level 16, State 1, Line...

A number of people have asked for more programmability, but the QO/QP team needs to support this. They tried functions, but the implementation wasn't good. Even with the changes in...

I've thought about that myself. Power is a big issue out here, but I was considering trying to make a zero energy space with solar, a few batteries, etc.

Honestly, use something like FlywayDB Community or a similar framework. No need to reinvent this stuff.

Mostly agree with the above. Use a SAN. VPNs tend to be fairly cheap and work well, but in the long term you might want some type of app. I'd...

If you don't want second alerts, what I might do is log alerts as they are sent based on a silo and time. If you have sent an alert in...

How can you tell if there is more data in the table? You can count rows, but if someone adds a row and deletes a row, you won't be alerted.

As...

This might also help: https://www.sqlservercentral.com/steps/stairway-to-xml-level-4-querying-xml-data

I like no/low code tools, like Power BI and others. Let some people start to solve problems, and when they find them working, take what they did and improve it...

That context switching is tough. It gets me, too, and so I try to batch together different types of work and areas so that I can focus better.

This script creates 2 procedures which return view models in JSON format.  The view models return the posts for a thread in either recent view (plain old normal view) or...

This script creates 7 posts in the 'frm.posts' table.  These are "indirect responses" to thread(s) or replies to (other) posts.  The variable declarations are repeated for each procedure execution (to...

Added statements to populate frm.posts_sv as well as frm.posts.

/*
delete frm.posts;
dbcc checkident ('frm.posts', reseed, 0) with no_infomsgs 

alter table frm.posts_sv set (system_versioning = off);
delete frm.posts_sv;
delete frm.posts_sv_history;
alter table frm.posts_sv...

This script creates 5 posts in the 'frm.posts' table.  These are direct responses to threads.

/*
delete frm.posts;
dbcc checkident ('frm.posts', reseed, 0) with no_infomsgs 
go
*/

set nocount on;
set xact_abort on;

begin...