This is daft

Advertisements

TFS Agent Setup

Troubleshooting

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:
https://github.com/Microsoft/azure-pipelines-agent/issues/1266

Use Elevated VS Command prompt instead works.

 

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

msbuild
visualstudio
vstest
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
.\config.cmd

 

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

General

 

 

 

SQL Azure cross database queries – evaluation

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

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-overview

https://ppolyzos.com/2016/07/30/cross-database-queries-in-azure-sql-databases/

Troubleshooting

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’

https://azure.microsoft.com/en-us/blog/querying-remote-databases-in-azure-sql-db/

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

Performance

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
My.Application.Log.DefaultFileLogWriter.Flush()
My.Application.Log.TraceSource.Flush()

 

 

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:

http://stackoverflow.com/questions/9284375/unable-to-apply-publish-properties-for-item-x

“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

 

http://www.howtogeek.com/howto/21106/how-to-enable-or-disable-tortoisesvn-menus-easily/

This works

Q&A BWT

 
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
BIDS – SSRS – SSIS – SSAS
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