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

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

This script creates 5 threads in the 'frm.threads' table.

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

set nocount on;
set xact_abort on;

begin transaction

/*create proc frm.api_threads_post
  @f_idint,
 ...

Regarding the MERGE statement in the frm.api_posts_reply_post procedure the major issue I saw is/was the target is the entire frm.posts table.  The Docs for MERGE is a litany of warnings,...

This script creates 3 stored procedures which create rows in the remaining 2 tables, 'frm.threads' and 'frm.posts' tables.  The proc to create new threads is a plain insert.  The proc...

Added N prefix to unicode strings.  Added time_zone to frm.Users.

set nocount on;
set xact_abort on;

begin transaction

/* create users */
declare @u        ...

Setup #2 Seed Data

This script inserts seed data into 5 of the 7 tables created by setup1.

7 users were created:

idemailusername
1admin@abc123.comSysAdmin
2stevej@abc123.comSteveJ
3stevec@abc123.comSteve Collins
4moderator1@abc123.comJose SQL
5moderator2@abc123.comJane5687
6member1@abc123.comAdamF
7member2@abc123.comBean When

8 claims were created:

            
April 29, 2021 at 2:19 pm
            
#3877390

            
            
                                                
        

Thanks, Pablo.

Content has been the biggest issue, so more bloggers and authors would be nice.

hint, hint 😉

Thanks for all the feedback and kind words. We aren't opposed to going back to 5, but for now we are trying this to see how it changes workloads and...

We went back to our normal schedule last week which is 1 day at home 4 days in office last week.  And while I miss having a dress...