Re: [OT] VPN
Is the speed ok with Proton? Reviews indicate speed is not as good as Nord for example. On Wed, 13 Oct 2021 at 19:30, Grant Maw wrote: > Using Proton. Paid version. Very happy with it, works on Linux, PC and my > Android tablet. > > Has never let me down, has plenty of endpoints etc > 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
Thanks for the advice, Greg. Unfortunately, the setup is "legacy" using SQL logins and AD auth is not an option here. Deployment strategies are currently being investigated but it looks like they may be going with the old TFS pipelines. I guess the actual logins and assignment to roles would need to be managed separately to the DB projects it sounds like. Regards Tom On Thu, 8 Dec 2022 at 10:11, Dr Greg Low wrote: > Hi Tom, > > > > For roles and permissions, they should just go directly in the DB > projects. Nothing special about them. > > > > Users/logins are different. > > > > Ideally, you’d have AD or AAD based groups that are added to the roles, > and again they can go right in the project. If you’re looking after the DB > or deploying it, you really shouldn’t be getting involved in who is in > those groups, and there’s nothing more for you to do. > > > > If you have to use SQL logins/users (and you really should now be trying > to avoid those), you can put them in the projects but you don’t want > passwords there. It then depends how you are deploying the projects. If > it’s something like Azure Pipelines or GitHub Actions, then you should put > the credentials that must be there into Azure Key Vault or similar, and > retrieve them from there during deployment. > > > > If you are in an environment like Azure, then you should be reassessing > why you need the 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 > > SQL Down Under | Web: https://sqldownunder.com | About Greg: > https://about.me/greg.low > > > > *From:* Tom P via ozdotnet > *Sent:* Thursday, 8 December 2022 9:58 AM > *To:* ozDotNet > *Cc:* Tom P > *Subject:* [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 post-deployment scripts, however, I > see this being a problem since different environments (different publish > profiles in the project) would require different logins and different > security altogether. On top of that I'm not even sure how the passwords > would be managed in this case as they would need to be hardcoded in the > scripts. > > > > In the past I'm sure I've only ever seen the security purely managed by > the DBAs in external scripts (or manually) and not in the Visual Studio > project itself. > > > > Any thoughts or recommendations would be much appreciated. > > > Regards > > Tom >
[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 post-deployment scripts, however, I see this being a problem since different environments (different publish profiles in the project) would require different logins and different security altogether. On top of that I'm not even sure how the passwords would be managed in this case as they would need to be hardcoded in the scripts. In the past I'm sure I've only ever seen the security purely managed by the DBAs in external scripts (or manually) and not in the Visual Studio project itself. Any thoughts or recommendations would be much appreciated. Regards Tom
Re: [OT] Finding duplicate rows in Sql Server
Yikes looks so simple once the answer is here haha. I’ll check in the morning if the Id is unique across the board. Thanks I appreciate the help. Regards Tom On Thu, 17 Nov 2022 at 17:27, Alan Ingleby via ozdotnet < ozdotnet@ozdotnet.com> wrote: > If the ID is unique across all 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. >> >> 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 >> 4,abc,abc abc,2022-11-17,a >> 3,def,def def,2022-11-17,a >> 6,xyz,def def,2022-11-17,a >> >> I'm trying to write a query that finds all duplicates *excluding the >> ones with the highest Id*. So for the above example it would return the >> following: >> >> Id,Name,Desc,Date,Etc >> 1,abc,abc abc,2022-11-17,a >> 2,abc,abc abc,2022-11-17,a >> 3,def,def def,2022-11-17,a >> >> There are many millions of rows to process so looking for something >> efficient. Any advice would be appreciated. >> >> Regards >> Tom >> >> -- >> ozdotnet mailing list >> To manage your subscription, access archives: >> https://codify.mailman3.com/ > > > > -- > Alan Ingleby > -- > ozdotnet mailing list > To manage your subscription, access archives: https://codify.mailman3.com/ -- Thanks Tom
[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 4,abc,abc abc,2022-11-17,a 3,def,def def,2022-11-17,a 6,xyz,def def,2022-11-17,a I'm trying to write a query that finds all duplicates *excluding the ones with the highest Id*. So for the above example it would return the following: Id,Name,Desc,Date,Etc 1,abc,abc abc,2022-11-17,a 2,abc,abc abc,2022-11-17,a 3,def,def def,2022-11-17,a There are many millions of rows to process so looking for something efficient. Any advice would be appreciated. Regards Tom
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 MD5 hash the original string to 16 bytes and > store the 32 hex chars". > > Then you said you'd like to convert back, which sank my idea. The only > option left is compression, but I'll bet it would be a miracle if all of > your original strings could be roundtripped via 32 compressed characters. > > *Greg K* > -- > ozdotnet mailing list > To manage your subscription, access archives: https://codify.mailman3.com/
Re: [OT] VPN
Hi folks Any current recommendations for a VPN provider? I procrastinated on this but would like to get one now after some privacy updates by my ISP that I interpret as bad news. NordVPN still ok? Any new recommendations? Cheers Tom On Thu, 14 Oct 2021 at 23:40, Grant Castner wrote: > I have 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...@ozdotnet.com on > behalf of Tom P > *Sent:* Thursday, October 14, 2021 7:53:09 PM > *To:* ozDotNet > *Subject:* Re: [OT] VPN > > Is the speed ok with Proton? Reviews indicate speed is not as good as Nord > for example. > > > On Wed, 13 Oct 2021 at 19:30, Grant Maw wrote: > > Using Proton. Paid version. Very happy with it, works on Linux, PC and my > Android tablet. > > Has never let me down, has plenty of endpoints etc > 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 > -- Thanks Tom
[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 nice if I could convert them back to ensure I haven't lost information. Briefly, the reason I want to do this is my target is varchar(32) but the IDs I am dealing with are made up of composite business keys of larger length. I need to be able to use the current business keys and generate unique 32 character equivalents in a deterministic way. Appreciate any advice. Thanks Tom
[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 subscription, access archives: https://codify.mailman3.com/
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 file uploaders. One I > like is https://www.dropzone.dev/ which should be able to be configured > to upload directly to blog storage, ie not have to send the files to your > webserver first > https://stackoverflow.com/questions/35456197/upload-file-directly-to-azure-blob-storage-with-sas-using-dropzone-js > > On Sat, Dec 30, 2023 at 8:59 AM Greg Keogh via ozdotnet < > ozdotnet@ozdotnet.com> wrote: > >> Folks (anyone working?) >> >> I've been asked to add a feature to a Blazor Webassembly app to allow >> uploads and downloads of possibly large numbers of files between the local >> file system and Blob storage. I'm not sure how to implement this feature in >> a browser hosted app. >> >> I wrote a WPF tool for "managers" which does high-performance bulk >> uploads and downloads with nice progress (the code is trivial on the >> desktop), but now they want the same feature for "normal" users in the >> Blazor app. Given how dumb and restricted browser hosted apps are, I don't >> know how to code this, or if it's even feasible. >> >> Are there some tools, techniques or tricks I can apply? Any ideas or >> suggestions anyone? >> >> Thanks, >> *Greg Keogh* >> > -- >> ozdotnet mailing list >> To manage your subscription, access archives: >> https://codify.mailman3.com/ > > -- > ozdotnet mailing list > To manage your subscription, access archives: https://codify.mailman3.com/ -- ozdotnet mailing list To manage your subscription, access archives: https://codify.mailman3.com/
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 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/ > > -- > ozdotnet mailing list > To manage your subscription, access archives: https://codify.mailman3.com/ -- ozdotnet mailing list To manage your subscription, access archives: https://codify.mailman3.com/