- ozdotnet - codify.mailman3.com

DataDude.com.au domain name available
by Greg Harris Dec. 8, 2022

Dec. 8, 2022

Some years ago, I purchased the domain name DataDude.com.au I was thinking that I would pivot to being more of a data dude I am never going to use it, I am open to suggestions. Greg Harris Harris Consulting Group Pty Ltd Greg(a)HarrisConsultingGroup.com www.HarrisConsultingGroup.com <http://harrisconsultinggroup.com/home.htm> phone: (international) +61 407 942 982 phone: (within Australia) 0407 942 982 Sydney Australia

1 0

[OT] Creating logins/users/roles/permissions in Visual Studio sqlproj projects
by Tom P Dec. 8, 2022

Dec. 8, 2022

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

2 3

Random server slowdowns
by Craig vN Dec. 2, 2022

Dec. 2, 2022

We have a problem that is plaguing us and hoping someone can give some guidance. Our website (ASP.NET MVC, Azure VM) fairly regularly (daily) experiences some random slowdowns. Here is a typical instance from our APM software. [image: 2022-12-03 09_43_50-Site24x7.png] The problem is it is proving very hard to find the source of the slowdowns, I suspect some kind of lock is happening, but when delving into the trace it doesn't really show anything other than everything slowing down, until I restart the server, which is becoming annoying at 5am. The only thing I can delve from the APM tool is it happening in the MVC layer somewhere. Does anyone know of any tools or instrumentation that can help diagnose these kind of problems. It is random, sometimes doesn't happen for days, then three times in one day. Thanks Craig

2 1

Friday complaint about configuration
by Greg Keogh Dec. 1, 2022

Dec. 1, 2022

In the .NET Core world most configuration has gone "fluent". The idea is elegant enough, in that you write an extension method for some basic class of config options and it joins the other ones that are available (if you have the right usings). There's a terrible side effect of the lovely fluent elegance ... I can't find any friggin' option without a Google search. It just took me 20 minutes fumbling with intellisense and searching to find this single statement. The option I wanted was obsolete and didn't appear in intellisense, so I had to F12 into the source and discover it had been renamed. builder.Services.Configure<JsonOptions>(jopts => jopts.JsonSerializerOptions.DefaultIgnoreCondition = JsonIgnoreCondition.WhenWritingNull); And this is just a simple case. Sometimes the fluency is nested so A => B => C.Foo deep that you've got more chance of finding a gold nugget than finding the option you want. Here endeth the rant, but I could go all day if you want. *Greg K*

1 0

Visual Studio 2022 cannot add existing project
by Greg Keogh Nov. 26, 2022

Nov. 26, 2022

Folks, I've had an intermittent problem in previous weeks where adding an existing csproj to a solution produces the message box: *The operation could not be completed.* It was occasional, but today I'm getting the error everywhere. I've made empty solutions, added A to B and B to A, deleted all the .vs .user and binary outputs (some searches suggest that), but absolutely nothing works. Web searches produce no modern useful results. I'm basically dead in the water. Has anyone else had this and solved it? I'm even running a repair now, which is pretty desperate (and slow). I know it won't work, but I do it anyway, which is a standard 21st century software development procedure. *Greg Keogh*

1 1

[OT] Finding duplicate rows in Sql Server
by Tom P Nov. 17, 2022

Nov. 17, 2022

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

4 4

Visual Studio 17.4.0 side effects
by Greg Keogh Nov. 11, 2022

Nov. 11, 2022

Folks, I accepted the major update yesterday, and this morning some odd things are happening. I noticed that .NET SDK 6 was gone and 7 was installed. I had to manually reinstall SDK 6 to get going again (this didn't happen to a colleague). A WebApi project produced a huge slab of NU1106 compile errors. I removed every reference of every type and it made no difference. After 2 hours I discovered that if I removed one of my own rather innocuous project references then it all came good. That reference has been there for the last 6 months. Now all of my existing Blazor projects stall and produce something like this: Failed to launch debug adapter. Additional information may be available in the output window. Unable to launch browser: "Could not open ws://localhost:56709/_framework/debug/ws-proxy?browser=wsAFF127.0.0.1A59317FdevtoolsFbrowserF4fe90d5b-f3d4-4f84-950c-2cc9af15b95c" The program '' has exited with code 4294967295 (0xffffffff). I've now spent 2 hours on this, and it's not looking helpful. A brand new app runs okay. I've run out of ideas. I started work at 06:30 but I haven't done any real work yet. *Greg Keogh*

4 12

Fwd: Fw: [Announcements] Mailman3.com servers upgrade
by David Connors Nov. 8, 2022

Nov. 8, 2022

FYI. ------------------------------ *From:* New IT via Announcements <announcements(a)mailman3.com> *Sent:* Tuesday, 8 November 2022 6:25 PM *To:* announcements(a)mailman3.com <announcements(a)mailman3.com> *Subject:* [Announcements] Mailman3.com servers upgrade Dear Mailman3.com users! In the last few days, all the servers have been upgraded to the latest code. The upgrade is aligned with the latest releases of the Mailman 3 components, see https://docs.mailman3.org/projects/mailman/en/latest/src/mailman/docs/NEWS.… https://docs.mailman3.org/projects/postorius/en/latest/news.html https://docs.mailman3.org/projects/hyperkitty/en/latest/news.html If you experience glitches in the Postorius/Hyperkitty UI, please perform a hard refresh of the page in your browser. Danil Smirnov New IT

1 0

Fwd: Platform x64 argument
by Greg Keogh Oct. 13, 2022

Oct. 13, 2022

> > Do you actually support/ship your app to run on x86-only or ARM > environments? If not, it probably doesn’t matter and I would probably give > this one and save the battles for other things. > All machines involved everywhere are x64. I will not concede defeat in this battle!! -- *Greg*

1 0

Platform x64 argument
by Greg Keogh Oct. 13, 2022

Oct. 13, 2022

Folks, one of my colleagues insists on compiling everything as platform x64 mainly because he thinks "it's an x64 world and it creates a better impression". For a year I've tried to convince him that for managed code that it's a complete waste of time. I've told him that ildasm.exe shows that for x64 and AnyCPU the generated IL and the manifests are identical, I even told him that dumpbin.exe shows the only non trivial difference in the PE headers is a couple of flags that show x86/x64 and PE32/PE32+, but they don't affect the loading and running of a PE containing IL and metadata. Does anyone have paradigm-shattering evidence I can give my colleague to break his habit? (I'm hoping I'm right of course!!) *Greg*

7 6