CSS Blogs & News @CODEKICKER

11

How to use IE proxy settings with HttpClient

Internet Explorer is - mostly - dead, but some weird settings are still around and “attached” to the old world, at least on Windows 10. If your system administrator uses some advanced proxy settings (e.g. a PAC-file), those will be attached to the users IE setting. If you want to use this with a HttpClient you need to code something like this: string target ...

29.03.2022 | 362 3 | Code-Inside Blog

8

Redirect to HTTPS with a simple web.config rule

The scenario is easy: My website is hosted in an IIS and would like to redirect all incomming HTTP traffic to the HTTPS counterpart. This is your solution - a “simple” rule: ?xml version "1.0" encoding "UTF-8"? configuration system.webServer rewrite rules rule name "Redirect to https" stopProcessing "true" match url ".*" / conditions logicalGrouping "MatchAny" add input ...

06.01.2022 | 548 4 | Code-Inside Blog

8

Select random rows

Let’s say we have a SQL table and want to retrieve 10 rows randomly - how would you do that? Although I have been working with SQL for x years, I have never encountered that problem. The solution however is quite “simple” (at least if you don’t be picky how we define “randomness” and if you try this on millions of rows): ORDER BY NEWID() The most boring way is to use the ORDER BY NEWID() ...

07.12.2021 | 571 2 | Code-Inside Blog

6

SQL collation problems

This week I deployed a new feature and tried it on different SQL databases and was a bit suprised that on one database this error message came up: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. This was strange, because - at least in theory - all databases have the same schema and I was sure that ...

25.11.2021 | 589 4 | Code-Inside Blog

6

Microsoft Build 2021 session recommendations

To be fair: Microsoft Build 2021 was some month ago, but the content might still be relevant today. Sooo… it took me a while, but here is a list of sessions that I found interesting. Some sessions are “better” and some “lighter”, the order doesn’t reflect that - that was just the order I watched those videos. The headline has a link to the video and below are some notes. Build ...

25.09.2021 | 760 3 | Code-Inside Blog

8

Today I learned (sort of) 'fltmc' to inspect the IO request pipeline of Windows

The headline is obviously a big lie, because I followed this twitter conversation last year, but it’s still interesting to me and I wanted to write it somewhere down. Starting point was that Bruce Dawson (Google programmer) noticed, that building Chrome on Windows is slow for various reasons: Based on some twitter discussion about source-file length and build times two months ...

31.05.2021 | 873 4 | Code-Inside Blog

8

How to self host Google Fonts

... Google Fonts consistes of the actual font file (e.g. woff, ttf, eot etc.) and some CSS , which points to those font files. In one of our applications, we used a HTML/CSS/JS - ... everything. After some research we discovered this tool: Google-Web-Fonts-Helper Pick your font, select your preferred CSS option (e.g. if you need to support older browsers etc.) and download a complete .zip ...

29.04.2021 | 810 7 | Code-Inside Blog

9

Microsoft Graph: Read user profile and group memberships

In our application we have a background service, that “syncs” user data and group membership information to our database from the Microsoft Graph. The permission model: Programming against the Microsoft Graph is quite easy. There are many SDKS available, but understanding the permission model is hard. ‘Directory.Read.All’ and ‘User.Read.All’: Initially we only synced the ...

01.02.2021 | 1004 1 | Code-Inside Blog

5

How to get all distribution lists of a user with a single LDAP query

In 2007 I wrote a blogpost how easy it is to get all “groups” of a given user via the tokenGroup attribute. Last month I had the task to check why “distribution list memberships” are not part of the result. The reason is simple: A pure distribution list (not security enabled) is not a security group and only security groups are part of the “tokenGroup” attribute. After some thoughts and ...

31.12.2020 | 1237 7 | Code-Inside Blog

9

Update AzureDevOps Server 2019 to AzureDevOps Server 2019 Update 1

... itself don’t use the Windows Certificate Store. To resolve this, the root certificate from our Domain controller must be stored on the agent. [Environment]::SetEnvironmentVariable(“NODE_EXTRA_CA_CERTS”, “C:\SSLCert\root-CA.pem”, “Machine”) Summary The update itself was easy, but it took us some hours to configure our Build Agents. After the initial hiccup it went ...

30.11.2020 | 890 4 | Code-Inside Blog

6

DllRegisterServer 0x80020009 Error

Last week I had a very strange issue and the solution was really “easy”, but took me a while. Scenario For our products we build Office COM Addins with a C based “Shim” that boots up our .NET code (e.g. something like this. As the nature of COM: It requires some pretty dumb registry entries to work and in theory our toolchain should “build” and automatically “register” the output. ...

01.11.2020 | 743 3 | Code-Inside Blog

7

How to share an Azure subscription in a team

We at Sevitec are moving more and more workloads for us or our customers to Azure. So the basic question needs an answer: How can a team share an Azure subscription? Be aware: This approach works for us. There might be better options. If we do something stupid, just tell me in the comments or via email - help is appreciated. Step 1: Create a directory We have a “company directory” with a ...

30.09.2020 | 894 3 | Code-Inside Blog

7

How to run a legacy WCF .svc Service on Azure AppService

Last month we wanted to run good old WCF powered service on Azures “App Service”. WCF… what’s that? If you are not familiar with WCF: Good! For the interested ones: WCF is or was a framework to build mostly SOAP based services in the .NET Framework 3.0 timeframe. Some parts where “good”, but most developers would call it a complex monster. Even in the glory days of WCF I tried to avoid it ...

01.09.2020 | 992 6 | Code-Inside Blog

8

EWS, Exchange Online and OAuth with a Service Account

This week we had a fun experiment: We wanted to talk to Exchange Online via the “old school” EWS API, but in a “sane” way. But here is the full story: Our goal We wanted to access contact information via a web service from the organization, just like the traditional “Global Address List” in Exchange/Outlook. We knew that EWS was on option for the OnPrem Exchange, but what about Exchange ...

01.08.2020 | 913 8 | Code-Inside Blog

10

Can a .NET Core 3.0 compiled app run with a .NET Core 3.1 runtime?

Within our product we move more and more stuff in the .NET Core land. Last week we had a disussion around needed software requirements and in the .NET Framework land this question was always easy to answer: .NET Framework 4.5 or higher. With .NET Core the answer is sligthly different: In theory major versions are compatible, e.g. if you compiled your app with .NET Core 3.0 and a .NET ...

01.07.2020 | 1063 5 | Code-Inside Blog

11

SqlBulkCopy for fast bulk inserts

Within our product OneOffixx we can create a “full export” from the product database. Because of limitations with normal MS SQL backups (e.g. compatibility with older SQL databases etc.), we created our own export mechanic. An export can be up to 1GB and more. This is nothing to serious and far from “big data”, but still not easy to handle and we had some issues to import larger ...

01.06.2020 | 933 1 | Code-Inside Blog

6

Blazor for Office Add-ins: First look

Last week I did some research and tried to build a pretty basic Office Addin (within the “new” web based Addin model) with Blazor. Side note: Last year I blogged about how to build Office Add-ins with ASP.NET Core. Why Blazor? My daily work home is in the C# and .NET land, so it would be great to use Blazor for Office Addins, right? A Office Add-in is just a web application with a ...

30.04.2020 | 1576 3 | Code-Inside Blog

7

Escape enviroment variables in MSIEXEC parameters

Problem Customers can install our product on Windows with a standard MSI package. To automate the installation administrators can use MSIEXEC and MSI parameters to configure our client. A simple installation can look like this: msiexec /qb /i "OneOffixx.msi" ... CACHEFOLDER "D:/OneOffixx/" The “CACHEFOLDER” parameter will be written in the .exe.config file and our program ...

28.03.2020 | 960 3 | Code-Inside Blog

5

TLS/SSL probelems: 'Could not create SSLTLS secure channel'

Problem Last week I had some fun debugging a weird bug. Within our application one module makes HTTP requests to a 3rd party service and depending on the running Windows version this call worked or failed with: 'Could not create SSLTLS secure channel' I knew that older TLS/SSL versions are deprecated and that many services refuse those protocols, but we still didn’t finally ...

01.03.2020 | 1117 5 | Code-Inside Blog

9

Accessibility Insights: Spot accessibilities issues easily for Web Apps and Windows Apps

Accessibility Accessibility is a huge and important topic nowadays. Keep in mind that in some sectors (e.g. government, public service etc.) accessibility is a requirement by law (in Europe the European Standards EN 301 549). If you want to learn more about accessibility in general this might be handy: MDN Web Docs: What is accessibility? Tooling support In my day to day job for ...

01.02.2020 | 1018 4 | Code-Inside Blog

9

T-SQL Pagination

The problem This is pretty trivial: Let’s say you have blog with 1000 posts in your database, but you only want to show 10 entries “per page”. You need to find a way how to slice this dataset into smaller pieces. The solution In theory you could load everything from the database and filter the results “in memory”, but this would be quite stupid for many reasons (e.g. you load much more ...

31.12.2019 | 1569 36 | Code-Inside Blog

6

Did you know that you can build .NET Core apps with MSBuild.exe?

The problem We recently updated a bunch of our applications to .NET Core 3.0. Because of the compatibility changes to the “old framework” we try to move more and more projects to .NET Core, but some projects still target “.NET Framework 4.7.2”, but they should work “ok-ish” when used from .NET Core 3.0 applications. The first tests were quite successful, but unfortunately when we ...

01.12.2019 | 835 1 | Code-Inside Blog

10

IdentityServer & Azure AD Login: Unkown Response Type text/html

The problem Last week we had some problems with our Microsoft Graph / Azure AD login based system. From a user perspective it was all good until the redirect from the Microsoft Account to our IdentityServer. As STS and for all auth related stuff we use the excellent IdentityServer4. We used the following configuration: services.AddAuthentication() ...

13.10.2019 | 1004 2 | Code-Inside Blog

7

Enforce Administrator mode for builded dotnet exe applications

The problem Let’s say you have a .exe application builded from Visual Studio and the application always needs to be run from an administrator account. Windows Vista introduced the “User Account Control” (UAC) and such applications are marked with a special “shield” icon like this: TL;DR-version: To build such an .exe you just need to add a __“application.manifest” and request ...

30.09.2019 | 951 1 | Code-Inside Blog

6

Check installed version for ASP.NET Core on Windows IIS with Powershell

The problem Let’s say you have a ASP.NET Core application without the bundled ASP.NET Core runtime (e.g. to keep the download as small as possible) and you want to run your ASP.NET Core application on a Windows Server hosted by IIS. General approach The general approach is the following: Install the .NET Core hosting bundle and you are done. Each .NET Core Runtime (and there are ...

01.09.2019 | 1102 10 | Code-Inside Blog

0 Mitglieder	online
14 Gäste	online
0 neue Beiträge heute
Antwortzeit 0,0 Minuten

	How to Repair a Leaking Lau...
	Zeile hinzufügen
	How can i get a blank atm c...
	VB.NET Outlook.SelectNamesD...