Re: [OT] VPN

c > On 13/10/21 4:41 pm, Tom P wrote: > > Hi folks > > What VPN provider are some of you using at home and are happy with? There > are many and mixed reviews. ExpressVPN, Nord… etc. > > Cheers > Tom > > -- > Thanks > Tom > > -- Thanks Tom

Ping

Ping

Re: [OT] Creating logins/users/roles/permissions in Visual Studio sqlproj projects

SQL logins. If it’s an app connecting to a DB, in many > cases, a user-assigned managed identity would be a better option. > > > > Regards, > > > > Greg > > > > Dr Greg Low > > > > 1300SQLSQL (1300 775 775) office | +61 419201410 mobile > > SQ

[OT] Creating logins/users/roles/permissions in Visual Studio sqlproj projects

Hello I'm fairly new to Visual Studio sqlproj projects and was wondering what the normal practice is for managing database security scripts (user logins, users, roles, permissions). I have seen some other projects here where the previous developers had the create login SQL code for example in

Re: [OT] Finding duplicate rows in Sql Server

l records, > > SELECT * FROM WHERE ID NOT IN (SELECT MAX(ID) FROM > GROUP BY NAme,Desc,Date,Etc) > > On Thu, 17 Nov 2022 at 16:02, Tom P via ozdotnet > wrote: > >> Apologies if this is basic for probably most of you but I just can't get >> my head around it. >> >

[OT] Finding duplicate rows in Sql Server

Apologies if this is basic for probably most of you but I just can't get my head around it. I have a flat table in sql server which contains lots of duplicates, differing only by one column. Id,Name,Desc,Date,Etc 1,abc,abc abc,2022-11-17,a 2,abc,abc abc,2022-11-17,a 5,def,def def,2022-11-17,a

Re: [OT] "Shrinking" IDs in SQL Server

The converting back was just a nice to have so I could validate things like a unit test. I'll look into hashing though. Thanks Tom On Tue, 14 Mar 2023 at 10:17, Greg Keogh via ozdotnet wrote: > Hi Tom, I think this is a maths problem more than a SQL one. Good fun! > > At first I thought "just

Re: [OT] VPN

ave been using NordVPN for a couple of years now with no issues > > Dr Grant Castner > BCom(Hons) LLB(Hons) PhD > 0458 770 749 > http://twitter.com/grantcastner > https://au.linkedin.com/in/grantcastner > -- > *From:* ozdotnet-boun...@ozdotne

[OT] "Shrinking" IDs in SQL Server

Hello I was hoping some of the SQL experts here could help with a problem I am facing. Currently have covid too so perhaps I'm not thinking clearly... Long story short, is there a way in SQL Server to convert strings (varchars) of any length to exactly 32, keeping uniqueness? It would also be

[OT] Angular training

Hi folks Can anyone here recommend a good one on one in person Angular accelerated training program? Cheers Tom -- ozdotnet mailing list To manage your subscription, access archives: https://codify.mailman3.com/

[OT] Contracting PAYG vs ABN

Hi all, I’m getting asked by a recruiter whether I want to do PAYG or use a personal ABN for a contracting position. I never really understood why one would use an ABN as you’d need to get your own insurances etc. Can anybody explain? Cheers Tom -- ozdotnet mailing list To manage your

Re: Web app large uploads and downloads

I assume you have a client Blazor wasm app that uploads the file to a server app (ie web api) which would then upload to azure or wherever. Is this what you are asking? Thanks Tom On Sun, 31 Dec 2023 at 10:19, Craig vN via ozdotnet wrote: > I don't know Blazor, but there are a ton of pure Js

Re: [OT] Angular training

Melbourne but we decided to go with online training Cheers Tom On Tue, 28 Nov 2023 at 22:27, DotNet Dude via ozdotnet < ozdotnet@ozdotnet.com> wrote: > What city? > > On Thu, 2 Nov 2023 at 12:28, Tom P via ozdotnet > wrote: > >> Hi folks >> >> Can

<    1   2