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

another complication for me personally is that amongst my officemates there are some vaccine refuseniks, with some presumably never having covid and at the same time being in...

If you use Profiler, and you hit enter after entering a value for database name, you get another box.

However, you should start to look at Extended Events, as Scott listed...

It could be someone internal, or someone that helps a hacker.

It could also be someone that gets access internally through social engineering, poor security, or another backdoor. While certainly someone...

I constantly think ASCII gives me A as well.

Not sure about this being a problem, after all a number is valid. More, I think they built the wrong function names...

Here's a bit of theory: https://www.online-tech-tips.com/cool-websites/what-is-checksum/

HASHBYTES can use SHA1.

This is a quick check, but not necessarily an absolute one.

I miss adult contact and discussions, debates, etc. I get to work with lots of kids still, as a coach, but I miss conferences, the office, even random talks about...

I've had a few Kindle devices and I read almost exclusively with the Kindle app on my phone/iPad. I bought one of the first Kindle devices, and have likely read...

I'm not completely sure what you mean, but DNS is a central system, somewhat like your local network. you can't have cname1 as the same machine name. You can have...

There are SRV records, but I don't think the drivers look up these records.

As Jeffrey mentioned, you need to include the port, or have the instances listen on 1433. You...

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the...