Html5 Blogs & News @CODEKICKER

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 | 224 2 | 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 | 139 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 | 222 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 | 107 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 | 328 5 | Code-Inside Blog

5

SQL Server, Named Instances & the Windows Firewall

The problem “Cannot connect to sql\instance. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating ...

01.08.2019 | 236 3 | Code-Inside Blog

7

Jint: Invoke Javascript from .NET

If you ever dreamed to use Javascript in your .NET application there is a simple way: Use Jint. Jint implements the ECMA 5.1 spec and can be use from any .NET implementation (Xamarin, .NET Framework, .NET Core). Just use the NuGet package and has no dependencies to other stuff - it’s a single .dll and you are done! Why should integrate Javascript in my application? In our product ...

01.07.2019 | 148 0 | Code-Inside Blog

7

Build Windows Server 2016 Docker Images under Windows Server 2019

Since the uprising of Docker on Windows we also invested some time into it and packages our OneOffixx server side stack in a Docker image. Windows Server 2016 situation: We rely on Windows Docker Images, because we still have some “legacy” parts that requires the full .NET Framework, thats why we are using this base image: FROM ...

01.06.2019 | 276 5 | Code-Inside Blog

5

Update OnPrem TFS 2018 to AzureDevOps Server 2019

We recently updated our OnPrem TFS 2018 installation to the newest release: Azure DevOps Server The product has the same core features as TFS 2018, but with a new UI and other improvements. For a full list you should read the Release Notes. *Be aware: This is the OnPrem solution, even with the slightly missleading name “Azure DevOps Server”. If you are looking for the Cloud solution ...

01.05.2019 | 272 5 | Code-Inside Blog

9

Load hierarchical data from MSSQL with recursive common table expressions

Scenario We have a pretty simple scenario: We have a table with a simple Id ParentId schema and some demo data in it. I have seen this design quite a lot in the past and in the relational database world this is the obvious choice. Problem Each data entry is really simple to load or manipulate. Just load the target element and change the ParentId for a move action etc.. A more complex ...

01.04.2019 | 173 0 | Code-Inside Blog

6

Check Scheduled Tasks with Powershell

Task Scheduler via Powershell Let’s say we want to know the latest result of the “GoogleUpdateTaskMachineCore” task and the corresponding actions. All you have to do is this (in a Run-As-Administrator Powershell console) : Get-ScheduledTask where TaskName -EQ 'GoogleUpdateTaskMachineCore' Get-ScheduledTaskInfo The result should look like this: LastRunTime : ...

27.02.2019 | 431 27 | Code-Inside Blog

8

Office Add-ins with ASP.NET Core

The “new” Office-Addins Most people might associate Offce-Addins with “old school” COM addins, but since a couple of years Microsoft pushes a new add-in application modal powered by HTML, Javascript and CSS. The cool stuff is, that these add-ins will run unter Windows, macOS, Online in a browser and on the iPad. If you want to read more about the general aspects, just checkout the ...

01.02.2019 | 336 0 | Code-Inside Blog

4

How to use TensorFlow with AMD GPU's

How to use TensorFlow with AMD GPU’s Most machine learning frameworks that run with a GPU support Nvidia GPUs, but if you own a AMD GPU you are out of luck. Recently AMD has made some progress with their ROCm platform for GPU computing and does now provide a TensorFlow build for their gpus. Since I work with tensorflow and own a AMD GPU it was time to give it a try. I stumpled upon these ...

05.12.2018 | 603 29 | Code-Inside Blog

6

Make your WCF Service async

Oh my: WCF??? This might be the elephant in the room: I wouldn’t use WCF for new stuff anymore, but to keep some “legacy” stuff working it might be a good idea to modernize those services as well. WCF Service/Client compatibility WCF services had always close relationships with their clients and so it is no suprise, that most guides show how to implement async operations on the server ...

03.12.2018 | 543 0 | Code-Inside Blog

11

HowTo: Run a Docker container using Azure Container Instances

Azure Container Instances There are (at least) 3 diffent ways how to run a Docker Container on Azure: Using the Web App for Containers Using Azure Kubernetes Service (AKS) Using Azure Container Instances In this blogpost we will take a small look how to run a Docker Container on this service. The “Azure Container Instances”-service is a pretty easy service and might be a good first ...

13.11.2018 | 302 4 | Code-Inside Blog

7

How to fix ERR_CONNECTION_RESET & ERR_CERT_AUTHORITY_INVALID with IISExpress and SSL

This post is a result of some pretty strange SSL errors that I encountered last weekend. The scenario: I tried to setup a development environment for a website that uses a self signed SSL cert. The problem occured right after the start - especially Chrome displayed those wonderful error messages: ERR_CONNECTION_RESET ERR_CERT_AUTHORITY_INVALID The “maybe” solution: When you ...

01.11.2018 | 750 12 | Code-Inside Blog

9

Be afraid of varchar(max) with async EF or ADO.NET

Last month we had changed our WCF APIs to async implementations, because we wanted all those glorious scalability improvements in our codebase. The implementation was quite easy, because our service layer did most of the time just some simple EntityFramework 6 queries. The field test went horribly wrong After we moved most of the code to async we did a small test and it worked quite ...

27.09.2018 | 376 1 | Code-Inside Blog

3

Migrate a .NET library to .NET Core / .NET Standard 2.0

I have a small spare time project called Sloader and I recently moved the code base to .NET Standard 2.0. This blogpost covers how I moved this library to .NET Standard. Uhmmm… wait… what is .NET Standard? If you have been living under a rock in the past year: .NET Standard is a kind of “contract” that allows the library to run under all .NET implementations like the full .NET Framework ...

31.08.2018 | 308 0 | Code-Inside Blog

4

Improving Code

Improving code TL;DR; Things I learned: long one-liners are hard to read and understand split up your code into small, easy to understand functions less “plumping” (read infrastructure code) is the better get indentation right “Make it correct, make it clear, make it concise, make it fast. In that order.” Wes Dyer Why should I bother? Readable code is: easier to debug fast to fix ...

03.08.2018 | 334 3 | Code-Inside Blog

7

Easy way to copy a SQL database with Microsoft SQL Server Management Studio (SSMS)

How to copy a database on the same SQL server The scenario is pretty simple: We just want a copy of our database, with all the data and the complete scheme and permissions. 1. step: Make a back up of your source database Click on the desired database and choose “Backup” under tasks. 2. step: Use copy only or use a full backup In the dialog you may choose “copy-only” backup. With this option ...

01.08.2018 | 329 2 | Code-Inside Blog

14

DbProviderFactories & ODP.NET: When even Oracle can be tamed

Oracle and .NET: Tales from the dark ages Each time when I tried to load data from an Oracle database it was a pretty terrible experience. I remember that I struggle to find the right Oracle driver and even when everything was installed the strange TNS ora config file popped up and nothing worked. It can be simple… 2 weeks ago I had the pleasure to load some data from a Oracle database and ...

01.06.2018 | 749 26 | Code-Inside Blog

9

CultureInfo.GetCultureInfo() vs. new CultureInfo() - what's the difference?

The problem The problem started with a simple code: double.TryParse("1'000", NumberStyles.Any, culture, out _) Be aware that the given culture was “DE-CH” and the Swiss use the ‘ for the separator for numbers. Unfortunately the Swiss authorities have abandoned the ‘ for currencies, but it is widly used in the industrie and such a number should be parsed or displayed. Now ...

29.05.2018 | 728 0 | Code-Inside Blog

6

.editorconfig: Sharing a common coding style in a team

Sharing Coding Styles & Conventions In a team it is really important to set coding conventions and to use a specific coding style, because it helps to maintain the code - a lot. Of course has each developer his own “style”, but some rules should be set, otherwise it will end in a mess. Typical examples for such rules are “Should I use var or not?” or “Are _ still OK for private fields?”. ...

01.05.2018 | 1107 0 | Code-Inside Blog

11

Did you know that you can run ASP.NET Core 2 under the full framework?

This post might be obvious for some, but I really struggled a couple of month ago and I’m not sure if a Visual Studio Update fixed the problem for me or if I was just blind… The default way: Running .NET Core AFAIK the framework dropdown in the normal Visual Studio project template selector (the first window) is not important and doesn’t matter anyway for .NET Core related projects. ...

01.04.2018 | 974 0 | Code-Inside Blog

6

Windows Fall Creators Update 1709 and Docker Windows Containers

Who shrunk my Windows Docker image? We started to package our ASP.NET/WCF/Full-.NET Framework based web app into Windows Containers, which we then publish to the Docker Hub. Someday we discovered that one of our new build machines produced Windows Containers only half the size: Instead of a 8GB Docker image we only got a 4GB Docker image. Yeah, right? The problem with Windows ...

28.02.2018 | 420 0 | Code-Inside Blog

11 Mitglieder	online
2322 Gäste	online
3 neue Beiträge heute
Antwortzeit 23,8 Minuten

	How to Activate Norton usin...
	Office 365 Migration
	www.norton.com/setup ,Norto...
	Incentivierter Traffic