How to Update 70 Projects to .Net 4.8 With Ease?
In this spring cleaning we had to update our last application to .Net 4.8. Unfortunately, the project is rather big:
Blog
What to Do if Azure DevOps Builds Don't Run in New Agent Pool
We created a new build agent pool for Visual Studio 2022 in Azure DevOps. To check if everything works, we temporarily switched jobs to the new agent pool. That worked for most jobs, but not for all. A few where stubborn and keep running on the old agent pool. How can that be?
As it turns out there are three and not just two places where we can choose the agent pool.
How to Disable JavaScript in Chrome for Just One Browser Tab
While debugging a strange problem with a web application, I wanted to turn of JavaScript for one single tab in Chrome. As it turns out, you can do that in the developer tools without disabling JavaScript for the whole browser.
Are You on the Blazor Train?
Blazor Train is a free, extensive course on Microsoft Blazor created by Carl Franklin. You may know Carl from the podcast .Net Rocks or from Music to Code By.
How to Import Data From Web Sites Into Excel
Did you ever need to put a table from a web site into an Excel file? If so, you probably used copy & paste and then fixed all the formatting errors and wasted a lot of time.
There is another way you may not be aware of: Excel has an import feature to load data from web sites (and many more formats like PDF files).
Little SQL Server Tricks: Get All Views or Tables in Your Database
While cleaning up a project, I needed a list of all the views in the database. SQL Server Management Studio provides a menu for this, but I needed a way to get this data in text form. In SQL Server, you can get this information from the INFORMATION_SCHEMA.TABLES view.
How to Get Rid of the Annoying Editor Movement in VS Code
The last update of VS Code has an annoying side effect: When you start typing in a file, the whole content moves one line down to give space for three dots on top of the editor:
Little Git Tricks: Put a Commit Back to the Staging Area
Sooner or later we all run into this situation with Git: We committed a change that should not be committed and we only found that out after we hit commit in out IDE. If we did not yet push this change to our centralised repository, we can use this command to undo our mistake:
Little SQL Server Tricks: CREATE OR ALTER Views
With SQL Server 2016 SP1 came a small but helpful new statement to create views: OR ALTER. If you add this to the create script for a view, SQL Server will figure out if it should run the CREATE or the ALTER statement:
Octopus Deploy & SSIS: Grant Permissions to the Correct User
I am a big fan of Octopus Deploy. This tool helps us to deploy our applications with ease and in a reliable way. In fact, it is so easy that I always forget the few important settings you need to have in place so that Octopus can do its magic.