December 2022 - ozdotnet - codify.mailman3.com

[OT] Google font globally
by Greg Keogh 31 Dec '22

31 Dec '22

Folks (anyone working?!) I've finally decided there are some nice Google web fonts I'd like to use (there are far too many nearly identical ones to choose from). The docs recommend the following (blue) lines in the html of each page: <head> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=PT+Serif&display=swap" rel="stylesheet"> <style> @import url(' https://fonts.googleapis.com/css2?family=PT+Serif&display=swap'); </style> </head> This is okay for one page, but how can I use a font in the hundreds of pages in a site? The problem is factoring out the common statements. The preconnect lines are optional and I think they can be ignored. The @import can be placed in a global link'd css file. But I don't think the link href to the font can be factored out and it would have to be inserted into hundreds of pages. Are there HTML5 boffins here who know of a trick or technique to simply apply a Google font globally with minimal editing? Cheers, *Greg K*

1 1

DataDude.com.au domain name available
by Greg Harris 08 Dec '22

08 Dec '22

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 08 Dec '22

08 Dec '22

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 02 Dec '22

02 Dec '22

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 01 Dec '22

01 Dec '22

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