TFS Agent Setup


PowerShell ISE .\config.cmd gets stuck at Connect:

Documentation suggests that you can run .\config.cmd from elevated PowerShell ISE.
This appears to get stuck at Connect:

Use Elevated VS Command prompt instead works.


Build: No agent found in pool Default which satisfies the specified demands:

Agent.Verion -gtVersion 2.115.0

Solution: Install Visual Studio.
Then I used a VS command prompt elevated as administrator to reconfigure the agent by using:
.\config.cmd remove


Build Failed: Failed to retrieve information about ‘NETStandard.Library’ from remote source ‘\\<old-server>’

Resolution was not to install .Net Core SDK
It was that the domain had changed and NuGet could no longer see the old packages UNC
Short-term resolution:
Include the packages in source control explorer
Remove the unavailable location from nuget.config

Long-term resolution:
Would be to move the packages to a new accessible location



Power BI Notes





SQL Azure cross database queries – evaluation

Existing documentation to create external database seems fine. Links include:


Error: “The option ‘IDENTITY’ is not supported with external tables for sharded data”
Remove the IDENTITY from the CREATE EXTERNAL TABLE id column


Using a different name in target

If the target is already using the external name you may want to use a different name. See this article. Add following to the with statement.

SCHEMA_NAME = ‘Sales’, OBJECT_NAME = ‘Quote’

One option is to create a view in the source with the desired name. Then in the target reference that. Works.


Slightly slower than using the source database, but pretty good – certainly usable in most cases.

Logging in .Net and My.Application.Log.WriteEntry does not write until flush

In app.config you need to remove the default listener:

<remove name=Default/>

Documentation on MSDN is ok, when testing you need to remember that the log will not write until either the application is closed, or the log is flushed. So:

My.Application.Log.DefaultFileLogWriter.AutoFlush = True



Loading WPF User Control at runtime

Need to place the user control in a control that accepts content. My current favourite is a “ContentControl”.

Me.ContentCanvas.Content = userControlValue
Me.ContentCanvas.Content = Nothing

Some other controls require Add.

Beware that a StackPanel will expand to fit all content, so if you put a DataGrid and possibly a ListBox in there, there will be no scroll bar.

Unable to apply publish properties for item “ApplicationCode\SystemNames.xml”

Solved with thanks to:

“It appears that the issue is related to ClickOnce. Navigate to the project, right click on it and click on properties. Go to the Publish tab and click on Application Files. Check the ‘Show all files’ checkbox and scroll through the list of files. Eventually, you will come across the file that has a yellow exclamation point on it. This file is orphaned and needs to be removed. Right click on the file and there should be a remove option.

Now build the solution and the warning should be gone.”

Subversion Windows Explorer Add-In Enable/Disable

This works


Help system ?
UML or other design documentation
SQL manipulate from where ? SSMS or VS
Certification – Too difficult – too much detail on individual subjects. MCTS 70-433 SQL Server Development
Any experience of T4 v CodeDom
Grog Talk interactive idea – How Visual Studio could be better
Naming Conventions
Data access technologies – Datasets – Directly coded – LINQ to SQL – Entity Framework ?
LINQ – Lambda

My Other Blog Start

Technorati Tags: ,

This blog is intended for non-IT posts.
Not certain of content at the moment