RE: [OT] Windows Server install problems

[Dr Greg Low via ozdotnet]

+1 vote for just running the Win servers in VMs on Windows 11.

Works well.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Greg Keogh via ozdotnet 
Sent: Sunday, March 17, 2024 11:15 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Re: [OT] Windows Server install problems

They took a lot of device support out of server along the way and that is when 
I stopped running it in my laptop. I'd install windows 11 and turn on hyper v 
and run server in a vm

I guess this means I must shop around for a hardware combination (or a whole 
box) that specifically runs the latest Windows servers. The price of that is 
worrying, and I need do the research. I've been lucky for the last 20 years 
because old work PCs could be rebranded as home servers without any hiccups at 
all -- Greg
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: AI

[Dr Greg Low via ozdotnet]

Worse, in the baseball umpiring exam I mentioned, someone said to me “isn’t 
that what you’d get if you just asked a whole lot of fans about the rules 
rather than asking umpires?”

There’s probably something important about that. How does it know which of the 
material it was trained on is valid?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: mike smith via ozdotnet 
Sent: Friday, February 23, 2024 12:19 PM
To: ozDotNet 
Cc: mike smith 
Subject: Re: AI

"old system views"

That makes me wonder if it has any way of differentiating between something it 
found from a decade ago to more recent data.

Mike
On Fri, 23 Feb 2024, 11:43 Dr Greg Low via ozdotnet, 
mailto:ozdotnet@ozdotnet.com>> wrote:
Hi Tom,

For me, it depends what you want it to do. It certainly can appear to help 
someone who’s new to an area.

For most code writing, I’ve been pretty underwhelmed. As an example, if I ask 
it to write SQL, I get a very poor outcome. It will use old deprecated views 
instead of the current system views (that have been around for a decade), and 
often does things in a convoluted way.

What I have been impressed with, is how it can help you understand acronyms, 
etc. Quite amazing. I’ve also been pretty impressed with using it go generate 
some test data, including in multiple languages. And the test data is fairly 
believable. If I ask it for family names, and I also ask for Chinese, it does 
pick common Chinese family names in the test output. That’s pretty impressive.

It can do a reasonable job of things like “here’s some DAX code, can you 
simplify it?” It often can. Or “here’s a regular expression, can you explain 
what it does?” and it does that just fine. I’ve seen people happily using it to 
explain code that they don’t understand, or to (sort of) document some code.

But it also is so confident on things, yet so wrong. I gave it a 25 question 
baseball umpire test the other day. It was 100% confident sounding, but 40% 
correct. The weird thing is that some of the questions that it got right, are 
things that new human umpires often get wrong. Yet for simpler questions, it 
would say that something legal is illegal.

It’s certainly interesting, but it’s very much a work in progress. It will be 
part of our futures.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Tom Gao via ozdotnet mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, February 23, 2024 11:58 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Tom Gao mailto:t...@tomgao.com>>
Subject: AI

Hi guys, I haven't posted in a few years and haven't been on the tools for a 
long time now as well. I'm on a panel on a digital conference coming up in 
march. We had a pre meeting today and the topic of AI came up. Two of the 
panelist said cited CBA and Westpac using AI and were able to save 30% on 
development effort.

Personally I just finished an AI course my view is quite the opposite. My 
personal opinion of the generative AI space and AI in general having spent time 
with the academics is that the benefits are significantly over inflated.

I want to get some other opinions if you are seeing any significant benefit and 
that I may be just out of touch or not aware.

Thanks,
Tom
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: AI

[Dr Greg Low via ozdotnet]

There were other things I should have mentioned.

The new PowerPoint co-pilot where you just say “Prepare me a presentation about 
what’s in xyz.docx” is pretty amazing.

I’ve used ChatGPT to rewrite marketing blurb for various things. It does that 
very well. However, I’ve asked it to improve a paragraph of writing, and find 
that something like the Hemmingway editor does a far superior job.

In Teams, having the AI tool write a summary of what just happened in a meeting 
is pretty stunning.

We are going to just be using these tools all day long.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Dr Greg Low
Sent: Friday, February 23, 2024 12:11 PM
To: ozDotNet 
Cc: Tom Gao 
Subject: RE: AI

Hi Tom,

For me, it depends what you want it to do. It certainly can appear to help 
someone who’s new to an area.

For most code writing, I’ve been pretty underwhelmed. As an example, if I ask 
it to write SQL, I get a very poor outcome. It will use old deprecated views 
instead of the current system views (that have been around for a decade), and 
often does things in a convoluted way.

What I have been impressed with, is how it can help you understand acronyms, 
etc. Quite amazing. I’ve also been pretty impressed with using it go generate 
some test data, including in multiple languages. And the test data is fairly 
believable. If I ask it for family names, and I also ask for Chinese, it does 
pick common Chinese family names in the test output. That’s pretty impressive.

It can do a reasonable job of things like “here’s some DAX code, can you 
simplify it?” It often can. Or “here’s a regular expression, can you explain 
what it does?” and it does that just fine. I’ve seen people happily using it to 
explain code that they don’t understand, or to (sort of) document some code.

But it also is so confident on things, yet so wrong. I gave it a 25 question 
baseball umpire test the other day. It was 100% confident sounding, but 40% 
correct. The weird thing is that some of the questions that it got right, are 
things that new human umpires often get wrong. Yet for simpler questions, it 
would say that something legal is illegal.

It’s certainly interesting, but it’s very much a work in progress. It will be 
part of our futures.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Tom Gao via ozdotnet mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, February 23, 2024 11:58 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Tom Gao mailto:t...@tomgao.com>>
Subject: AI

Hi guys, I haven't posted in a few years and haven't been on the tools for a 
long time now as well. I'm on a panel on a digital conference coming up in 
march. We had a pre meeting today and the topic of AI came up. Two of the 
panelist said cited CBA and Westpac using AI and were able to save 30% on 
development effort.

Personally I just finished an AI course my view is quite the opposite. My 
personal opinion of the generative AI space and AI in general having spent time 
with the academics is that the benefits are significantly over inflated.

I want to get some other opinions if you are seeing any significant benefit and 
that I may be just out of touch or not aware.

Thanks,
Tom
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: AI

[Dr Greg Low via ozdotnet]

Hi Tom,

For me, it depends what you want it to do. It certainly can appear to help 
someone who’s new to an area.

For most code writing, I’ve been pretty underwhelmed. As an example, if I ask 
it to write SQL, I get a very poor outcome. It will use old deprecated views 
instead of the current system views (that have been around for a decade), and 
often does things in a convoluted way.

What I have been impressed with, is how it can help you understand acronyms, 
etc. Quite amazing. I’ve also been pretty impressed with using it go generate 
some test data, including in multiple languages. And the test data is fairly 
believable. If I ask it for family names, and I also ask for Chinese, it does 
pick common Chinese family names in the test output. That’s pretty impressive.

It can do a reasonable job of things like “here’s some DAX code, can you 
simplify it?” It often can. Or “here’s a regular expression, can you explain 
what it does?” and it does that just fine. I’ve seen people happily using it to 
explain code that they don’t understand, or to (sort of) document some code.

But it also is so confident on things, yet so wrong. I gave it a 25 question 
baseball umpire test the other day. It was 100% confident sounding, but 40% 
correct. The weird thing is that some of the questions that it got right, are 
things that new human umpires often get wrong. Yet for simpler questions, it 
would say that something legal is illegal.

It’s certainly interesting, but it’s very much a work in progress. It will be 
part of our futures.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Tom Gao via ozdotnet 
Sent: Friday, February 23, 2024 11:58 AM
To: ozDotNet 
Cc: Tom Gao 
Subject: AI

Hi guys, I haven't posted in a few years and haven't been on the tools for a 
long time now as well. I'm on a panel on a digital conference coming up in 
march. We had a pre meeting today and the topic of AI came up. Two of the 
panelist said cited CBA and Westpac using AI and were able to save 30% on 
development effort.

Personally I just finished an AI course my view is quite the opposite. My 
personal opinion of the generative AI space and AI in general having spent time 
with the academics is that the benefits are significantly over inflated.

I want to get some other opinions if you are seeing any significant benefit and 
that I may be just out of touch or not aware.

Thanks,
Tom
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Private Apple App distribution

[Dr Greg Low via ozdotnet]

And even more changes from Apple:

https://www.macrumors.com/2024/01/16/us-app-store-alternative-purchase-option/?utm_source=tldrwebdev

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Dr Greg Low
Sent: Wednesday, January 17, 2024 5:21 PM
To: 'ozDotNet' 
Cc: Greg Keogh 
Subject: RE: Private Apple App distribution

Are you in the Apple Developer program? I’m guessing there might be a test 
option there.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Wednesday, January 17, 2024 4:46 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Greg Keogh mailto:gfke...@gmail.com>>
Subject: Re: Private Apple App distribution

So you're all telling me that there is no "side load" feature for iPhone apps?! 
This is a dreadful obstacle to getting the app onto company staff phones. 
Luckily I have an Apple account that was recently renewed (for 150 goddamn $), 
but I'll have to fill-in all the store compliance documentation and make keys 
and fumble through their cryptic alien processes, and so on and on. Goddammit 
again.

GK
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Private Apple App distribution

[Dr Greg Low via ozdotnet]

Are you in the Apple Developer program? I’m guessing there might be a test 
option there.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Greg Keogh via ozdotnet 
Sent: Wednesday, January 17, 2024 4:46 PM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Re: Private Apple App distribution

So you're all telling me that there is no "side load" feature for iPhone apps?! 
This is a dreadful obstacle to getting the app onto company staff phones. 
Luckily I have an Apple account that was recently renewed (for 150 goddamn $), 
but I'll have to fill-in all the store compliance documentation and make keys 
and fumble through their cryptic alien processes, and so on and on. Goddammit 
again.

GK
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Private Apple App distribution

[Dr Greg Low via ozdotnet]



I like the lateral thinking.

I wonder if it will be based on the user’s home location, or where the phone is.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: mike smith via ozdotnet 
Sent: Wednesday, January 17, 2024 3:11 PM
To: ozDotNet 
Cc: mike smith 
Subject: Re: Private Apple App distribution

So the "way" will be to use a VPN, and set your Apple devices up in Europe?

I'm wondering if any other countries will jump on board.

Mike
On Wed, 17 Jan 2024, 14:29 Dr Greg Low via ozdotnet, 
mailto:ozdotnet@ozdotnet.com>> wrote:
Interesting that there’s been a discussion going on with the EU about this. 
They’re insisting that Apple allow “side-loading” of apps. In response, Apple 
has apparently said they’re splitting their app store with one for EU, and one 
for the rest of the world.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Wednesday, January 17, 2024 2:46 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Greg Keogh mailto:gfke...@gmail.com>>
Subject: Private Apple App distribution

Folks,

We're planning a MAUI app to be installed on company Android and Apple phones. 
For Android I can just generate the APK file and side-load it (after the 
security settings are relaxed). I don't know how to do the same for iPhones. We 
don't want the app in the store. Assuming there is a convention for 
"side-loading" Apple apps, what's the technique? Is anyone doing this?

A few years ago we published a Xamarin app, but it was for the public and was 
published in both stores. This time the app's private to the company.

Thanks,
Greg Keogh
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Private Apple App distribution

[Dr Greg Low via ozdotnet]

Interesting that there’s been a discussion going on with the EU about this. 
They’re insisting that Apple allow “side-loading” of apps. In response, Apple 
has apparently said they’re splitting their app store with one for EU, and one 
for the rest of the world.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Greg Keogh via ozdotnet 
Sent: Wednesday, January 17, 2024 2:46 PM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Private Apple App distribution

Folks,

We're planning a MAUI app to be installed on company Android and Apple phones. 
For Android I can just generate the APK file and side-load it (after the 
security settings are relaxed). I don't know how to do the same for iPhones. We 
don't want the app in the store. Assuming there is a convention for 
"side-loading" Apple apps, what's the technique? Is anyone doing this?

A few years ago we published a Xamarin app, but it was for the public and was 
published in both stores. This time the app's private to the company.

Thanks,
Greg Keogh
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Web app large uploads and downloads

[Dr Greg Low via ozdotnet]

I notice that the Azure Storage Explorer desktop app nowadays defaults to using 
azcopy under the covers to copy files. That’s a much better option for files of 
any size. Probably need a component that does that but azcopy has a few 
dependencies.

It’s on GitHub as open source so you could probably check out how it does what 
it does. It’s sure fast and filesize isn’t an issue. I’ve used azcopy on 
multi-terabyte files without issue. (Apart from the hosting provider for the 
site calling to find out what was going on, given the way it worked in parallel 
and flooded their network)

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: DotNet Dude via ozdotnet 
Sent: Wednesday, January 3, 2024 4:17 PM
To: ozDotNet 
Cc: DotNet Dude 
Subject: Re: Web app large uploads and downloads

Yep we usually do this sort of thing with a batch process, particularly if 
there are large files. I don’t see any web app being used just to upload a 
bunch of files.

For fun try asking ChatGPT or one of the others to see where they go.

On Wed, 3 Jan 2024 at 11:13, Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
Folks (welcome to the distant future of 2024)

I'm pretty sure that there is no sensible way to provide a bulk Azure Blob 
upload facility in a web hosted app (Wasm, JS or whatever). There could be 
thousands of files with a total size up to hundreds of MB. Managers are 
currently using a WPF program I created for uploads and it feels like a 
perfectly natural process on the desktop, and it's pretty fast using streams on 
multi cores (I also optionally check for new or changed so only diffs are 
uploaded which often saves a lot of time).

None of the components or controls I've seen are designed for huge uploads, and 
in any case, I've reported that it's technically and usability questionable to 
have "normal" users of the browser app doing this sort of thing. The boss of 
the app suite is now considering the bigger picture and the bulk upload feature 
may be delayed or moved to somewhere else in the flow, or the desktop program 
will suffice. So I'm happy the issue is on-hold for now.

I think this is a good example of how the web browser should never have evolved 
into a host for business apps. I think the web browser, HTML, HTTP, REST, css 
and JS have diseased 21st century IT.

Greg K
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Web app large uploads and downloads

[Dr Greg Low via ozdotnet]

Hi Greg,

Are you using any Blazor frameworks? Several of them seem to have pretty good 
file upload components. That might give the best experience.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: 
https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc=>
 | About Greg:  
https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low=DwMFAg=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk=>

From: Greg Keogh via ozdotnet 
Sent: Saturday, December 30, 2023 8:58 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Web app large uploads and downloads

Folks (anyone working?)

I've been asked to add a feature to a Blazor Webassembly app to allow uploads 
and downloads of possibly large numbers of files between the local file system 
and Blob storage. I'm not sure how to implement this feature in a browser 
hosted app.

I wrote a WPF tool for "managers" which does high-performance bulk uploads and 
downloads with nice progress (the code is trivial on the desktop), but now they 
want the same feature for "normal" users in the Blazor app. Given how dumb and 
restricted browser hosted apps are, I don't know how to code this, or if it's 
even feasible.

Are there some tools, techniques or tricks I can apply? Any ideas or 
suggestions anyone?

Thanks,
Greg Keogh
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

Re: AEC form

[Dr Greg Low via ozdotnet]

:-)

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me


From: David Connors via ozdotnet 
Sent: Friday, September 15, 2023 8:51:52 PM
To: ozDotNet 
Cc: David Connors 
Subject: Re: AEC form

I didn't think the government was handing IBM any more contracts ...

On Fri, 15 Sept 2023 at 19:39, Dr Greg Low via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
It almost makes sense but there was no visible control on the form saying that. 
And after fixing the captcha error and resubmitting, it just worked. So the 
other one wasn't an error anyway.

Bizarre.

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me


From: Dr Greg Low via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, September 15, 2023 7:32:04 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Dr Greg Low mailto:g...@sqldownunder.com>>
Subject: AEC form

Whoever develops code for the AEC really needs to take a long hard look at 
themselves. Second error is the Captcha failing even though it didn't ask for 
it in the first place. It wasn't visible on the form.

And I'm not sure what attempt at English the other error is meant to be.

Does anyone review this?

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me

--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

Re: AEC form

[Dr Greg Low via ozdotnet]

It almost makes sense but there was no visible control on the form saying that. 
And after fixing the captcha error and resubmitting, it just worked. So the 
other one wasn't an error anyway.

Bizarre.

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me


From: Dr Greg Low via ozdotnet 
Sent: Friday, September 15, 2023 7:32:04 PM
To: ozDotNet 
Cc: Dr Greg Low 
Subject: AEC form

Whoever develops code for the AEC really needs to take a long hard look at 
themselves. Second error is the Captcha failing even though it didn't ask for 
it in the first place. It wasn't visible on the form.

And I'm not sure what attempt at English the other error is meant to be.

Does anyone review this?

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me

-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Blazor popularity and use

[Dr Greg Low via ozdotnet]

Thanks David. I’ve got a meeting today with a guy who’s the Principal Software 
Engineering Manager for Learn.

I’ll see how that goes and report back.

I suspect a key issue is that you still can’t have an M365 email address for 
your certification profile and that only MSAs work. If so, that would continue 
to be crazy stuff, and should have been resolved long ago.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Kean 
Sent: Friday, September 8, 2023 11:02 PM
To: ozDotNet 
Cc: David Connors ; Dr Greg Low 
Subject: RE: Blazor popularity and use

Greg can you forward me some context? Can’t promise anything, but I probably 
have a better chance of landing on the right person’s desk.

From: Dr Greg Low via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, September 8, 2023 2:24 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Connors mailto:da...@connors.com>>; Greg Low 
mailto:g...@sqldownunder.com>>
Subject: RE: Blazor popularity and use

Agreed, but being one of the people who periodically need to consume many 
Microsoft internal apps and web sites, I will just have to differ on how 
effective I find them I’ve been so frustrated by some of the ones I need to 
use, that I’ve volunteered to help fix them. It would be quicker for me to fix 
the app for them, than to need to interact with it.

But it’s Friday so:

My biggest issues are still around identity. I’m having yet another week 
struggling to work out how to sort out issues with Microsoft identities. I do 
not understand why this needs to be so hard.

I’ve dealt with Amazon for a very long time. To this day, I still use the same 
identity I created when I first used them, and it works for all services that I 
purchase from them.
Same with Google. Same with Apple, etc.

But with Microsoft, I’ve been pushed into needing a string of identities over 
the years, with incompatible identity systems, incompatible Microsoft service 
requirements for identity, etc.

Why does this have to continue?

And the support for this in many areas has moved to forum-based support that is 
extremely poor. Here’s a fine example of “support” that I received yesterday:


[cid:image001.png@01D9E30B.B6BC9D20]

I’ve been trying to work out if that’s the worst “support” response I’ve ever 
received.

So, I then guessed that I needed to contact MCP support, instead of MCT support 
(as clearly they don’t have a clue, even though they are closely associated), 
and today I woke up to:

A moderator has deleted a thread you were following, How do I change my email 
address on my certification profile?. It's possible that the thread was off 
topic, violated the Code of Conduct, or was just a duplicate thread.


I have no idea what the issue was as they’d already deleted the thread. It 
might be because I’m asking how to change the email address, and they assume 
that’s a duplicate. But I can’t find any previous discussion now, apart from 
changing it via the Learn profile, which clearly doesn’t work.

I don’t get why there isn’t some Microsoft VP screaming at people to fix it. I 
know I want to, and I’m a calm person.

It’s gone on way too long.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Connors via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, September 8, 2023 1:55 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Connors mailto:da...@connors.com>>
Subject: Re: Blazor popularity and use

On Fri, 8 Sept 2023 at 13:44, Dr Greg Low 
mailto:g...@sqldownunder.com>> wrote:
Yep, we talk about browsers like there’s consistency there. There still isn’t. 
And it’s a huge hit on productivity. I see so much lost effort trying to align 
pixels across different browsers, different versions of browsers, etc. It’s 
just silly.

I remember being on a web app project. I was doing the data bits, and there 
were 10 devs doing the web parts.

After 6 months, I looked at what the other 10 had produced and knew I could 
have built that myself in a winform app in a fortnight, by myself.

This is probably more down to approach. If they were building from scratch by 
themselves, then I agree, productivity will be terrible; however on the flip 
side, you have to remember that 80+% of the cost of software is after the code 
is written and in the support phase. For our internal apps, we use a commercial 
off the shelf theme and a couple of other components and stick with those. The 
consistency of UI layout, responsiveness across form factors etc is all done 
very cost effectively by using something like: 
https://angular-material.fusetheme.com/dashboards/project - best $700 you'll 
ever spe

RE: Blazor popularity and use

[Dr Greg Low via ozdotnet]

Yep, but the request that I raised was closed overnight.
A moderator has deleted a thread you were following, How do I change my email 
address on my certification profile?. It's possible that the thread was off 
topic, violated the Code of Conduct, or was just a duplicate thread.
Now they might think that’s a duplicate question, and it would be, if there was 
any way to see the outcome from other people who asked the same question. But 
every time, they take it off to a private discussion, and don’t report back on 
what was required.

So duplicate or not, any previous thread isn’t helpful. Apart from that, I 
really don’t understand why they would have deleted it. I did have one that I 
asked the MCT support people, instead of the MCP support people, but they made 
it clear, they have no clue on how to help. So that can’t be a duplicate either.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tony Wright 
Sent: Friday, September 8, 2023 2:38 PM
To: ozDotNet 
Cc: David Connors ; Dr Greg Low 
Subject: Re: Blazor popularity and use

Hi Greg, you need to raise a generic request for a fix to your mcid on the 
certifications forum. I am dealing with it right now, and they are switching 
email addresses for me. After I raised the issue, they opened up a private 
message to get private info about my accounts. It's pretty much a 3 day process.
On Fri, 8 Sep 2023, 2:30 pm Dr Greg Low via ozdotnet, 
mailto:ozdotnet@ozdotnet.com>> wrote:
Agreed, but being one of the people who periodically need to consume many 
Microsoft internal apps and web sites, I will just have to differ on how 
effective I find them I’ve been so frustrated by some of the ones I need to 
use, that I’ve volunteered to help fix them. It would be quicker for me to fix 
the app for them, than to need to interact with it.

But it’s Friday so:

My biggest issues are still around identity. I’m having yet another week 
struggling to work out how to sort out issues with Microsoft identities. I do 
not understand why this needs to be so hard.

I’ve dealt with Amazon for a very long time. To this day, I still use the same 
identity I created when I first used them, and it works for all services that I 
purchase from them.
Same with Google. Same with Apple, etc.

But with Microsoft, I’ve been pushed into needing a string of identities over 
the years, with incompatible identity systems, incompatible Microsoft service 
requirements for identity, etc.

Why does this have to continue?

And the support for this in many areas has moved to forum-based support that is 
extremely poor. Here’s a fine example of “support” that I received yesterday:


[cid:image001.png@01D9E25F.6ED9FA90]

I’ve been trying to work out if that’s the worst “support” response I’ve ever 
received.

So, I then guessed that I needed to contact MCP support, instead of MCT support 
(as clearly they don’t have a clue, even though they are closely associated), 
and today I woke up to:

A moderator has deleted a thread you were following, How do I change my email 
address on my certification profile?. It's possible that the thread was off 
topic, violated the Code of Conduct, or was just a duplicate thread.


I have no idea what the issue was as they’d already deleted the thread. It 
might be because I’m asking how to change the email address, and they assume 
that’s a duplicate. But I can’t find any previous discussion now, apart from 
changing it via the Learn profile, which clearly doesn’t work.

I don’t get why there isn’t some Microsoft VP screaming at people to fix it. I 
know I want to, and I’m a calm person.

It’s gone on way too long.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Connors via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, September 8, 2023 1:55 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Connors mailto:da...@connors.com>>
Subject: Re: Blazor popularity and use

On Fri, 8 Sept 2023 at 13:44, Dr Greg Low 
mailto:g...@sqldownunder.com>> wrote:
Yep, we talk about browsers like there’s consistency there. There still isn’t. 
And it’s a huge hit on productivity. I see so much lost effort trying to align 
pixels across different browsers, different versions of browsers, etc. It’s 
just silly.

I remember being on a web app project. I was doing the data bits, and there 
were 10 devs doing the web parts.

After 6 months, I looked at what the other 10 had produced and knew I could 
have built that myself in a winform app in a fortnight, by myself.

This is probably more down to approach. If they were building from scratch by 
themselves, then I agree, productivity will be terrible; however on th

RE: Blazor popularity and use

[Dr Greg Low via ozdotnet]

Agreed, but being one of the people who periodically need to consume many 
Microsoft internal apps and web sites, I will just have to differ on how 
effective I find them I’ve been so frustrated by some of the ones I need to 
use, that I’ve volunteered to help fix them. It would be quicker for me to fix 
the app for them, than to need to interact with it.

But it’s Friday so:

My biggest issues are still around identity. I’m having yet another week 
struggling to work out how to sort out issues with Microsoft identities. I do 
not understand why this needs to be so hard.

I’ve dealt with Amazon for a very long time. To this day, I still use the same 
identity I created when I first used them, and it works for all services that I 
purchase from them.
Same with Google. Same with Apple, etc.

But with Microsoft, I’ve been pushed into needing a string of identities over 
the years, with incompatible identity systems, incompatible Microsoft service 
requirements for identity, etc.

Why does this have to continue?

And the support for this in many areas has moved to forum-based support that is 
extremely poor. Here’s a fine example of “support” that I received yesterday:


[cid:image001.png@01D9E25F.6ED9FA90]

I’ve been trying to work out if that’s the worst “support” response I’ve ever 
received.

So, I then guessed that I needed to contact MCP support, instead of MCT support 
(as clearly they don’t have a clue, even though they are closely associated), 
and today I woke up to:

A moderator has deleted a thread you were following, How do I change my email 
address on my certification profile?. It's possible that the thread was off 
topic, violated the Code of Conduct, or was just a duplicate thread.


I have no idea what the issue was as they’d already deleted the thread. It 
might be because I’m asking how to change the email address, and they assume 
that’s a duplicate. But I can’t find any previous discussion now, apart from 
changing it via the Learn profile, which clearly doesn’t work.

I don’t get why there isn’t some Microsoft VP screaming at people to fix it. I 
know I want to, and I’m a calm person.

It’s gone on way too long.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Connors via ozdotnet 
Sent: Friday, September 8, 2023 1:55 PM
To: ozDotNet 
Cc: David Connors 
Subject: Re: Blazor popularity and use

On Fri, 8 Sept 2023 at 13:44, Dr Greg Low 
mailto:g...@sqldownunder.com>> wrote:
Yep, we talk about browsers like there’s consistency there. There still isn’t. 
And it’s a huge hit on productivity. I see so much lost effort trying to align 
pixels across different browsers, different versions of browsers, etc. It’s 
just silly.

I remember being on a web app project. I was doing the data bits, and there 
were 10 devs doing the web parts.

After 6 months, I looked at what the other 10 had produced and knew I could 
have built that myself in a winform app in a fortnight, by myself.

This is probably more down to approach. If they were building from scratch by 
themselves, then I agree, productivity will be terrible; however on the flip 
side, you have to remember that 80+% of the cost of software is after the code 
is written and in the support phase. For our internal apps, we use a commercial 
off the shelf theme and a couple of other components and stick with those. The 
consistency of UI layout, responsiveness across form factors etc is all done 
very cost effectively by using something like: 
https://angular-material.fusetheme.com/dashboards/project - best $700 you'll 
ever spend.

If ease of development was our primary concern we would all be building 
Microsoft Access apps.

-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Blazor popularity and use

[Dr Greg Low via ozdotnet]



Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh 
Sent: Friday, September 8, 2023 1:54 PM
To: Dr Greg Low 
Cc: ozDotNet ; David Connors 
Subject: Re: Blazor popularity and use

I'm glad I'm not the only grumpy old fart in here! -- GK

On Fri, 8 Sept 2023 at 13:44, Dr Greg Low 
mailto:g...@sqldownunder.com>> wrote:
Yep, we talk about browsers like there’s consistency there. There still isn’t. 
And it’s a huge hit on productivity. I see so much lost effort trying to align 
pixels across different browsers, different versions of browsers, etc. It’s 
just silly.

I remember being on a web app project. I was doing the data bits, and there 
were 10 devs doing the web parts.

After 6 months, I looked at what the other 10 had produced and knew I could 
have built that myself in a winform app in a fortnight, by myself.

But, no, they didn’t have to deal with “DLL-hell” from the thick clients.

Yet now, every time I open a VS project that I haven’t touched for a few 
months, I totally cringe. Instead of DLL-hell on deployment, I now usually have 
“dependency-hell” with multiple inconsistent updates to dependent frameworks. 
Sometimes I can’t even work out how to resolve it and must reimplement part of 
the code.

What we as an industry have done to productivity is tragic.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, September 8, 2023 1:30 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Connors mailto:da...@connors.com>>; Greg Keogh 
mailto:gfke...@gmail.com>>
Subject: Re: Blazor popularity and use

Sure, deploying a web app to a server is easier than distributing thick client 
updates to many recipients, but that's a lucky side-effect. I stand by my claim 
that the web browser is a woefully inadequate host for business applications. I 
even have an example from today ...

A Blazor app version update was published, with some small fixes and UI tweaks 
which required css changes. I get a report that some clients are seeing parts 
of the page squashed or the text is ugly mixed sizes. After some back-and-forth 
with suggested quick fixes, the only fix was to clear the browser cache and 
restart the browser, which is really irritating for non-technical clients. I'm 
sure there are ways around this problem, with special meta tags or similar 
tricks, but it's more hoops to jump through and a good example of just how 
crappy the web browser is for business use.

 -- Greg

On Fri, 8 Sept 2023 at 13:08, David Connors via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:


On Fri, 8 Sept 2023 at 12:06, Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote
I must end on a sad note. ASP.NET<http://ASP.NET>, Blazor, JS, or whatever, all 
finish-up rendering in a web browser. It's tragic that the ancient dumb web 
browser is now the only host for web apps, and that we must attempt to present 
serious business applications using HTML, CSS and JS. The web browser was 
invented so we could have flame wars and look at pictures of cats and porn, 
it's barely evolved since then and it's completely inadequate for rendering 
business applications. Sure it can, but look at the flaming hoops and all the 
weird quirks you have to jump through. Web development is in a lamentable state.

You have a short memory of what it was like deploying apps back when thick 
clients were the only option. Modern web has done more to streamline ops than 
anything else and reduced application deployment to pushing code to an app 
service and end-user deployment to pasting a link in an e-mail or IM.


--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Blazor popularity and use

[Dr Greg Low via ozdotnet]

Yep, we talk about browsers like there’s consistency there. There still isn’t. 
And it’s a huge hit on productivity. I see so much lost effort trying to align 
pixels across different browsers, different versions of browsers, etc. It’s 
just silly.

I remember being on a web app project. I was doing the data bits, and there 
were 10 devs doing the web parts.

After 6 months, I looked at what the other 10 had produced and knew I could 
have built that myself in a winform app in a fortnight, by myself.

But, no, they didn’t have to deal with “DLL-hell” from the thick clients.

Yet now, every time I open a VS project that I haven’t touched for a few 
months, I totally cringe. Instead of DLL-hell on deployment, I now usually have 
“dependency-hell” with multiple inconsistent updates to dependent frameworks. 
Sometimes I can’t even work out how to resolve it and must reimplement part of 
the code.

What we as an industry have done to productivity is tragic.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Friday, September 8, 2023 1:30 PM
To: ozDotNet 
Cc: David Connors ; Greg Keogh 
Subject: Re: Blazor popularity and use

Sure, deploying a web app to a server is easier than distributing thick client 
updates to many recipients, but that's a lucky side-effect. I stand by my claim 
that the web browser is a woefully inadequate host for business applications. I 
even have an example from today ...

A Blazor app version update was published, with some small fixes and UI tweaks 
which required css changes. I get a report that some clients are seeing parts 
of the page squashed or the text is ugly mixed sizes. After some back-and-forth 
with suggested quick fixes, the only fix was to clear the browser cache and 
restart the browser, which is really irritating for non-technical clients. I'm 
sure there are ways around this problem, with special meta tags or similar 
tricks, but it's more hoops to jump through and a good example of just how 
crappy the web browser is for business use.

 -- Greg

On Fri, 8 Sept 2023 at 13:08, David Connors via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:


On Fri, 8 Sept 2023 at 12:06, Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote
I must end on a sad note. ASP.NET<http://ASP.NET>, Blazor, JS, or whatever, all 
finish-up rendering in a web browser. It's tragic that the ancient dumb web 
browser is now the only host for web apps, and that we must attempt to present 
serious business applications using HTML, CSS and JS. The web browser was 
invented so we could have flame wars and look at pictures of cats and porn, 
it's barely evolved since then and it's completely inadequate for rendering 
business applications. Sure it can, but look at the flaming hoops and all the 
weird quirks you have to jump through. Web development is in a lamentable state.

You have a short memory of what it was like deploying apps back when thick 
clients were the only option. Modern web has done more to streamline ops than 
anything else and reduced application deployment to pushing code to an app 
service and end-user deployment to pasting a link in an e-mail or IM.


--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: Blazor popularity and use

[Dr Greg Low via ozdotnet]

It was always about the IT people though, not the users.

Outlook as a web app is a good example. It has had enormous funds spent on 
producing it, likely far more than pretty much any other web app.

But shown the web app and the desktop app, users pick the desktop one pretty 
much every time.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Connors via ozdotnet 
Sent: Friday, September 8, 2023 1:00 PM
To: ozDotNet 
Cc: David Connors 
Subject: Re: Blazor popularity and use



On Fri, 8 Sept 2023 at 12:06, Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote
I must end on a sad note. ASP.NET<http://ASP.NET>, Blazor, JS, or whatever, all 
finish-up rendering in a web browser. It's tragic that the ancient dumb web 
browser is now the only host for web apps, and that we must attempt to present 
serious business applications using HTML, CSS and JS. The web browser was 
invented so we could have flame wars and look at pictures of cats and porn, 
it's barely evolved since then and it's completely inadequate for rendering 
business applications. Sure it can, but look at the flaming hoops and all the 
weird quirks you have to jump through. Web development is in a lamentable state.

You have a short memory of what it was like deploying apps back when thick 
clients were the only option. Modern web has done more to streamline ops than 
anything else and reduced application deployment to pushing code to an app 
service and end-user deployment to pasting a link in an e-mail or IM.


-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

Re: Blazor popularity and use

[Dr Greg Low via ozdotnet]

Yes several clients doing so. Will report back if they need anyone.

Get Outlook for iOS

From: Tom Rutter via ozdotnet 
Sent: Friday, September 8, 2023 11:13:58 AM
To: ozDotNet 
Cc: Tom Rutter 
Subject: Blazor popularity and use

Is anyone here actively using Blazor on a decent sized project? I used it for a 
while on my last contract but am unable to find new work anywhere that uses 
Blazor, not a single one!

Thoughts?

Tom
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: [OT] Junked business registry overhaul blew out by $2.3b

[Dr Greg Low via ozdotnet]

My favourite was Brisbane’s Go Card. Had a friend driving busses in Brisbane, 
and when it was first released, they had the sensitivity wrong. He’d drive past 
a bus stop, and it would charge everyone standing there, even if they weren’t 
getting on.

It fascinates me that we continue to feel the need to develop these things, 
pretty much from scratch.

As for the "I'll get some mates together and do it for half the price, I fondly 
remember the guy that quoted to paint the Sydney Harbour Bridge with his son. 
Their quote was a fraction of the prevailing cost. Yes, “how hard can it be” 

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Wednesday, August 30, 2023 11:15 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Re: [OT] Junked business registry overhaul blew out by $2.3b

Maybe we should set up OzDotNet Consultants specializing in government 
contracts? We could be swimming in cash!

Yeah, when I see news about a planned $4bn IT project going ahead, I think 
"I'll get some mates together and do it for half the price".

A replacement MYKI system, no problems. As Homer Simpsons often says, "How hard 
can it be?"

 -- Greg K
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: [OT] Junked business registry overhaul blew out by $2.3b

[Dr Greg Low via ozdotnet]

The ones swimming in cash seem to be the ones doing the current projects, and 
having them stretch out forever.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Burstin via ozdotnet 
Sent: Wednesday, August 30, 2023 10:45 AM
To: ozDotNet 
Cc: Tom Rutter ; David Burstin 
Subject: Re: [OT] Junked business registry overhaul blew out by $2.3b

Maybe we should set up OzDotNet Consultants specializing in government 
contracts? We could be swimming in cash!

On Wed, 30 Aug 2023 at 10:31, Tom Rutter via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
If you want a project to fail the best thing to do is to allow the govt to run 
it

On Tue, 29 Aug 2023 at 19:30, Dr Greg Low via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
Another one though where the project has many parts, almost all of which were 
to be delivered at the end. The only delivered item is the now orphaned 
Director ID.

Have we learned nothing about delivering projects in the last half century?

Regards

Greg

Get Outlook for iOS<https://aka.ms/o0ukef>

From: DotNet Dude via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Tuesday, August 29, 2023 7:19:34 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: DotNet Dude mailto:adotnetd...@gmail.com>>

Subject: Re: [OT] Junked business registry overhaul blew out by $2.3b

Am hesitant to share much but apparently the sh!t show was due to earlier 
decisions, 2 or so years old. Technically a lot of the work was being delivered 
successfully.

On Tue, 29 Aug 2023 at 17:36, Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
Worse, they were probably drowning in XML schema definitions.
Only one mention of XML in the redacted report, but three mentions of SBR1, so 
that still counts. 

Aha!  That leads to a bit of IT tech talk I can sort-of understand:

The MBR’s starting point for the technology architecture was Foster Moore’s 124 
registry software, Catalyst. Catalyst was selected as the 
commercial-off-the-shelf product for the MBR implementation, following a formal 
approach to market and design validation with Foster Moore. 125 During the 
course of the program, the implementation changed to a later version of 
Catalyst called Verne.

Verne is a cloud-hosted registry product that uses Linux/Unix OS and a document 
database that is suitable for registries. It uses a lesser-known Java-based 
programming language called Groovy. 126 Verne provides out-of-the-box 
functionalities for registration management, client management, content 
management, access management, configuration management, analytics and 
reporting, data provision, account management, communication management, 
document management, API management, and fee and revenue management. The user 
interface framework provides a flexible way to generate XML based APIs.

I've heard of Groovy<https://en.wikipedia.org/wiki/Apache_Groovy>, but now I 
see it's a Java-like static or dynamic language. Foster Moore's 
Verne<https://www.fostermoore.com/verne> software is some gigantic 
off-the-shelf corporate registry software product that claims to be highly 
configurable. There's no mention of what back-end database it uses.

Greg K
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

Re: [OT] Junked business registry overhaul blew out by $2.3b

[Dr Greg Low via ozdotnet]

Another one though where the project has many parts, almost all of which were 
to be delivered at the end. The only delivered item is the now orphaned 
Director ID.

Have we learned nothing about delivering projects in the last half century?

Regards

Greg

Get Outlook for iOS

From: DotNet Dude via ozdotnet 
Sent: Tuesday, August 29, 2023 7:19:34 PM
To: ozDotNet 
Cc: DotNet Dude 
Subject: Re: [OT] Junked business registry overhaul blew out by $2.3b

Am hesitant to share much but apparently the sh!t show was due to earlier 
decisions, 2 or so years old. Technically a lot of the work was being delivered 
successfully.

On Tue, 29 Aug 2023 at 17:36, Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
Worse, they were probably drowning in XML schema definitions.
Only one mention of XML in the redacted report, but three mentions of SBR1, so 
that still counts. 

Aha!  That leads to a bit of IT tech talk I can sort-of understand:

The MBR’s starting point for the technology architecture was Foster Moore’s 124 
registry software, Catalyst. Catalyst was selected as the 
commercial-off-the-shelf product for the MBR implementation, following a formal 
approach to market and design validation with Foster Moore. 125 During the 
course of the program, the implementation changed to a later version of 
Catalyst called Verne.

Verne is a cloud-hosted registry product that uses Linux/Unix OS and a document 
database that is suitable for registries. It uses a lesser-known Java-based 
programming language called Groovy. 126 Verne provides out-of-the-box 
functionalities for registration management, client management, content 
management, access management, configuration management, analytics and 
reporting, data provision, account management, communication management, 
document management, API management, and fee and revenue management. The user 
interface framework provides a flexible way to generate XML based APIs.

I've heard of Groovy, but now I 
see it's a Java-like static or dynamic language. Foster Moore's 
Verne software is some gigantic 
off-the-shelf corporate registry software product that claims to be highly 
configurable. There's no mention of what back-end database it uses.

Greg K
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: [OT] Junked business registry overhaul blew out by $2.3b

[Dr Greg Low via ozdotnet]

You can also read the review. It’s available online. Riveting stuff, and of 
course, with lots redacted because we wouldn’t want to name names.

https://treasury.gov.au/sites/default/files/2023-08/review-modernising-business-registers-program-report-redacted_0.pdf

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: mike smith via ozdotnet 
Sent: Tuesday, August 29, 2023 4:23 PM
To: ozDotNet 
Cc: mike smith 
Subject: Re: [OT] Junked business registry overhaul blew out by $2.3b

Here's a non paywalled one

https://www.innovationaus.com/burning-12m-a-month-govt-scraps-business-register-overhaul/



On Tue, 29 Aug 2023, 14:34 Tom Rutter via ozdotnet, 
mailto:ozdotnet@ozdotnet.com>> wrote:
Another one bites the dust…

https://www.afr.com/politics/federal/bleeding-money-labor-scraps-morrison-business-register-overhaul-20230827-p5dzpa

--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: [OT] Junked business registry overhaul blew out by $2.3b

[Dr Greg Low via ozdotnet]

Sadly true

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Connors via ozdotnet 
Sent: Tuesday, August 29, 2023 4:08 PM
To: ozDotNet 
Cc: David Connors 
Subject: Re: [OT] Junked business registry overhaul blew out by $2.3b

On Tue, 29 Aug 2023 at 16:01, Dr Greg Low via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:

[...]

 We just can’t keep doing this.

Oh, yes we can.

-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: [OT] Junked business registry overhaul blew out by $2.3b

[Dr Greg Low via ozdotnet]

I’ll bet it ends up reminiscent of the local hotel quarantine project. 
Unbelievable amounts spent on it but who authorised it? Apparently, no-one. Yet 
large sums were going out the door, and the “real” details need to remain 
secret.

The Commonwealth Games? A fortune paid to consultants to do the costing, and 
when the price is $6B not $2B, no-one is apparently responsible, and worse, yet 
again, secrecy surrounds most of it.

In Victoria, apparently we spent more on MyKi than NASA spent putting Curiosity 
on Mars, and NASA invented the Sky Crane as part of that project. We got a card 
system that’s already being replaced.

The census debacle looks like a choice of the wrong technology, and wrong 
specifications for testing. But again, no heads roll when it happens.

And so on, and so on.

Apparently for this business register stuff, a primary issue is that the chosen 
platform didn’t go even close to meeting requirements or costs to modify. Yet,  
again, I’ll bet no-one is responsible and wears the cost except the public.

We just can’t keep doing this.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Dr Greg Low
Sent: Tuesday, August 29, 2023 3:51 PM
To: ozDotNet 
Cc: Tom Rutter 
Subject: RE: [OT] Junked business registry overhaul blew out by $2.3b

It’s only public money, right?

In the end, who is getting sacked? Who is being sued? Who is bearing direct 
consequences of this, apart from the public?

My guess? No-one.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tom Rutter via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Tuesday, August 29, 2023 3:02 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Tom Rutter mailto:therut...@gmail.com>>
Subject: [OT] Junked business registry overhaul blew out by $2.3b

Another one bites the dust…

https://www.afr.com/politics/federal/bleeding-money-labor-scraps-morrison-business-register-overhaul-20230827-p5dzpa

-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: [OT] Junked business registry overhaul blew out by $2.3b

[Dr Greg Low via ozdotnet]

It’s only public money, right?

In the end, who is getting sacked? Who is being sued? Who is bearing direct 
consequences of this, apart from the public?

My guess? No-one.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tom Rutter via ozdotnet 
Sent: Tuesday, August 29, 2023 3:02 PM
To: ozDotNet 
Cc: Tom Rutter 
Subject: [OT] Junked business registry overhaul blew out by $2.3b

Another one bites the dust…

https://www.afr.com/politics/federal/bleeding-money-labor-scraps-morrison-business-register-overhaul-20230827-p5dzpa

-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

RE: SQL Server Performance monitoring

[Dr Greg Low via ozdotnet]

Hi Greg,

The performance trace procedures in SDU Tools have duration as one of the 
summaries provided.

Duration is a curious one though. In so many cases, it's meaningless, yet it's 
the one that the Microsoft tooling often worries about most.

For example, if you have a query that executes, and then the client takes 
forever to retrieve the rowset that was produced (e.g. by reading it a row at a 
time and doing other things in between each row), the duration shows the entire 
time. But it could be a very light query.

In your case though, that might well help, particularly if you find queries 
with long durations, but few pages read. That means that the query can't get 
its work done for some reason. Whenever you have that, it's blocked waiting on 
something else.

If you can catch it while it's blocked, even Activity Monitor in SSMS can show 
you what's at the head of a blocking chain. sp_whoisactive (from Adam Machanic) 
will do a better job of that again. But that only helps if you can catch it 
while it's happening. That's why tracing usually helps.

The other thing I've done in the past, if it becomes very hard to find, is to 
just leave a proc running in the background that every 5, 10, or 20 seconds, 
finds any process that's at the head of a blocking chain, and writes details of 
it out to a table. That's more work, but it shows clearly what the regular 
culprits are. The "Show Current Blocking" code in SDU Tools should provide an 
example to help get something like that going.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Monday, July 31, 2023 10:15 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: SQL Server Performance monitoring

Folks,

We have a problem on a live server where web users experience occasional 
unpredictable "stalls". There are a few links in the chain where the problem 
could be, but based on some clues in logs, I suspect that it's the last link at 
the bottom of the chain ... SQL Server that's the source of the problem.

But I need evidence. Is there some feature of SQL Server or perhaps some tool 
that can detect queries that are suspiciously long running? This is SQL Server 
full standard edition. I haven't had to poke deeply into SQL Server's machinery 
before, so I'm in unfamiliar territory.

Cheers,
Greg Keogh
-- 
ozdotnet mailing list 
To manage your subscription, access archives: https://codify.mailman3.com/ 

Postman help please

[Dr Greg Low]

Hi folks,

Anyone a gun on Postman?

I'm trying to debug a file upload.


  *   I create a request that looks like the typical request, including a body 
saying form-data and with a key of file and a value set to File with an 
uploaded file.
  *   I save a 200 response for it.
  *   I choose to mock the collection and create a server.
  *   I start a new request pointing to the mock server, and set the body the 
same way as before.
  *   I send the request.

In the server logs, I see this:

[cid:image001.png@01D95E43.FC7535E0]

The content-length looks about right. The content-type does say 
multipart/form-data, and has a boundary, etc.

But the body is empty.

Is there some trick to getting it to log the body? That's what I'm trying to 
see.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

RE: Replacement for old PictureBox

[Dr Greg Low]

To summarise, I did get the new standard picturebox, etc. working as I needed. 
Thanks to all who tried to help.

Hats off to anyone who finds that current doco useful though. Seems a complete 
mess.

As an example from today, I was super-impressed with the quality of the 
TreeView documentation.

[cid:image001.png@01D95921.AE4412F0]

That’s pretty but pretty much completely useless.

I did click on the ContextMenuStrip link in the middle of the text, and it has 
a bit more but again, it has an auto-generated description, one example that’s 
not great (under a heading of “Examples” – that’s funny), then auto-generated 
lists of properties, methods, and events.

I mean, how could anyone not find that useful? There continues to be a basic 
misconception about the purpose of this documentation. Somewhere it really 
needs to actually be helpful.

What’s concerning is that it’s still at the level that it was in the early 
2000’s.

It’s lucky we have Google and YouTube and helpful souls who describe what 
they’ve learned the hard way.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tony McGee via ozdotnet 
Sent: Thursday, 16 March 2023 12:32 PM
To: ozdotnet@ozdotnet.com
Cc: Tony McGee 
Subject: Re: Replacement for old PictureBox

Hi Greg,

The WinForms PictureBox control is pretty basic, it's mostly designed for 
displaying images, not really for drawing.
In the distant past I've used Leadtools Imaging Pro for a WinForms document 
management project that required annotation, but that can get expensive if your 
needs are basic and looking towards the future I can't quite tell what their 
.NET 7+ story is anymore.
These days it might be worth looking into SkiaSharp canvas drawing, and there 
are also some PDF export samples in the github repository.

cheers,
Tony


On 16/03/2023 09:45, Dr Greg Low via ozdotnet wrote:
Hi Everyone,

I’m migrating an old VB6 app to .NET. It used a PictureBox control and of 
course that had all sorts of options for drawing all over it.

In the end, it was used to generate JPG images that were printed.

I’d really prefer to use PDF as output anyway.

Does anyone have a favourite control that presents a drawable surface that you 
can output as a PDF? (Or ideally as a JPG as well?)

I get the impression that the .NET version of the PictureBox is way different, 
although it does seem to expose a Graphics object that you can then draw on. Is 
it better to stick with the standard .NET control and work out how to migrate 
the code?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

RE: Replacement for old PictureBox

[Dr Greg Low]

Thanks Greg.

I do wonder how I’ll push it into a PDF later but I’m trying the drawing part 
first.

Not sure what I did in a past life to end up doing this at present 

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Thursday, 16 March 2023 1:17 PM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Re: Replacement for old PictureBox

Dr L,

About 15 years ago I recall drawing to Windows Forms Bitmap then drawing 
(blt-ing) it into a PictureBox. A timer would draw many times per second to 
create a primitive but acceptable animation. I can't find the code now.

I'd construct a Bitmap, then g = bmp.CreateGraphics() and use the various 
Graphics methods to set pixels, draw rectangles, etc. Then g.DrawImageUnscaled 
into the PictureBox.

The C# classes are clearly thin wrappers over GDI+ and the C# code looks a bit 
like C++ code from the 1990s. If you have VB6 code that "draws", then maybe a 
translation to GDI calls would be easy (?!).

I haven't used Skia, but some friends like it in Xamarin apps.

Greg K

RE: Replacement for old PictureBox

[Dr Greg Low]

Hi Tony,

Thanks so much for the pointer to SkiaSharp. That certainly looks interesting.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tony McGee via ozdotnet 
Sent: Thursday, 16 March 2023 12:32 PM
To: ozdotnet@ozdotnet.com
Cc: Tony McGee 
Subject: Re: Replacement for old PictureBox

Hi Greg,

The WinForms PictureBox control is pretty basic, it's mostly designed for 
displaying images, not really for drawing.
In the distant past I've used Leadtools Imaging Pro for a WinForms document 
management project that required annotation, but that can get expensive if your 
needs are basic and looking towards the future I can't quite tell what their 
.NET 7+ story is anymore.
These days it might be worth looking into SkiaSharp canvas drawing, and there 
are also some PDF export samples in the github repository.

cheers,
Tony


On 16/03/2023 09:45, Dr Greg Low via ozdotnet wrote:
Hi Everyone,

I’m migrating an old VB6 app to .NET. It used a PictureBox control and of 
course that had all sorts of options for drawing all over it.

In the end, it was used to generate JPG images that were printed.

I’d really prefer to use PDF as output anyway.

Does anyone have a favourite control that presents a drawable surface that you 
can output as a PDF? (Or ideally as a JPG as well?)

I get the impression that the .NET version of the PictureBox is way different, 
although it does seem to expose a Graphics object that you can then draw on. Is 
it better to stick with the standard .NET control and work out how to migrate 
the code?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

Replacement for old PictureBox

[Dr Greg Low]

Hi Everyone,

I'm migrating an old VB6 app to .NET. It used a PictureBox control and of 
course that had all sorts of options for drawing all over it.

In the end, it was used to generate JPG images that were printed.

I'd really prefer to use PDF as output anyway.

Does anyone have a favourite control that presents a drawable surface that you 
can output as a PDF? (Or ideally as a JPG as well?)

I get the impression that the .NET version of the PictureBox is way different, 
although it does seem to expose a Graphics object that you can then draw on. Is 
it better to stick with the standard .NET control and work out how to migrate 
the code?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

RE: [OT] "Shrinking" IDs in SQL Server

[Dr Greg Low]

Hi Tom,

So many questions about what you’re trying to do (sounds really odd), but I 
think the safest for you right now would be to just select the current key and 
the truncated value out into another table while you take a look at them.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tom P via ozdotnet 
Sent: Tuesday, 14 March 2023 9:52 AM
To: ozDotNet 
Cc: Tom P 
Subject: [OT] "Shrinking" IDs in SQL Server

Hello

I was hoping some of the SQL experts here could help with a problem I am 
facing. Currently have covid too so perhaps I'm not thinking clearly...

Long story short, is there a way in SQL Server to convert strings (varchars) of 
any length to exactly 32, keeping uniqueness? It would also be nice if I could 
convert them back to ensure I haven't lost information.

Briefly, the reason I want to do this is my target is varchar(32) but the IDs I 
am dealing with are made up of composite business keys of larger length. I need 
to be able to use the current business keys and generate unique 32 character 
equivalents in a deterministic way.

Appreciate any advice.

Thanks
Tom

RE: [OT] APNIC charges for historical resources

[Dr Greg Low]

Yep, the major ISPs ran out of IPv4 space ages ago. I note that I can no longer 
get an v4 IP when using any mobile service that has Telstra underneath it. And 
of course that’s a world of entertainment for systems that I need to connect to 
that have IP v4 allow lists.

I’m sure they’re mopping up all the class Cs as they can. I’ll bet they did the 
class B and class A ones ages ago.

In the end, whoever owns the routing at the upper levels gets to call the shots.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Connors via ozdotnet 
Sent: Wednesday, 1 March 2023 1:29 PM
To: ozDotNet 
Cc: David Connors 
Subject: Re: [OT] APNIC charges for historical resources

Greg,

Historical objects were always free but they made you bring them into a paid 
basis whenever you needed additional IP space or a new AS number or something. 
That happened to us years ago. Once you're on that train you can't get off.

They must be rounding up the stragglers like you. :)

David.

On Wed, 1 Mar 2023 at 07:41, Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
Folks, It's almost Friday...

I just received an email from APNIC to tell me that a class C IP block I've 
owned for 27 years is now under their control and I will be charged $500/year 
to keep this historical resource that was created before APNIC existed. See 
Maintenance Fee Change<https://help.apnic.net/s/article/historical-fee-change>. 
Has anyone else received a similar notification?

My thoughts were: this is either kidnapping, extortion or a "protection 
racket", or all three.

I'm reminded of the 1990s when Melbourne IT were effectively selling the 
dictionary for a minimum ~$135 per domain name, and special words like 
"realestate" or "sales" etc were up for the highest bidder at eye-watering 
prices. Ah, the days of the Internet boom...!

I'd like to write an official complaint about APNIC's money-grubbing scam to 
someone, but who? The ACCC is a toothless tiger. There is a federal ombudsman, 
but would APNIC be on their radar?

Cheers,
Greg K
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/

RE: [OT] Creating logins/users/roles/permissions in Visual Studio sqlproj projects

[Dr Greg Low]

That’s a pity. But you can, as you mention, have post deploy steps that put 
them in place. Ideally though, they’d still come from something like Key Vault 
instead of being in the scripts or in files somewhere.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tom P 
Sent: Thursday, 8 December 2022 10:53 AM
To: Dr Greg Low 
Cc: ozDotNet 
Subject: Re: [OT] Creating logins/users/roles/permissions in Visual Studio 
sqlproj projects

Thanks for the advice, Greg.

Unfortunately, the setup is "legacy" using SQL logins and AD auth is not an 
option here. Deployment strategies are currently being investigated but it 
looks like they may be going with the old TFS pipelines. I guess the actual 
logins and assignment to roles would need to be managed separately to the DB 
projects it sounds like.

Regards
Tom

On Thu, 8 Dec 2022 at 10:11, Dr Greg Low 
mailto:g...@sqldownunder.com>> wrote:
Hi Tom,

For roles and permissions, they should just go directly in the DB projects. 
Nothing special about them.

Users/logins are different.

Ideally, you’d have AD or AAD based groups that are added to the roles, and 
again they can go right in the project. If you’re looking after the DB or 
deploying it, you really shouldn’t be getting involved in who is in those 
groups, and there’s nothing more for you to do.

If you have to use SQL logins/users (and you really should now be trying to 
avoid those), you can put them in the projects but you don’t want passwords 
there. It then depends how you are deploying the projects. If it’s something 
like Azure Pipelines or GitHub Actions, then you should put the credentials 
that must be there into Azure Key Vault or similar, and retrieve them from 
there during deployment.

If you are in an environment like Azure, then you should be reassessing why you 
need the SQL logins. If it’s an app connecting to a DB, in many cases, a 
user-assigned managed identity would be a better option.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tom P via ozdotnet mailto:ozdotnet@ozdotnet.com>>
Sent: Thursday, 8 December 2022 9:58 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Tom P mailto:tompbi...@gmail.com>>
Subject: [OT] Creating logins/users/roles/permissions in Visual Studio sqlproj 
projects

Hello

I'm fairly new to Visual Studio sqlproj projects and was wondering what the 
normal practice is for managing database security scripts (user logins, users, 
roles, permissions).

I have seen some other projects here where the previous developers had the 
create login SQL code for example in post-deployment scripts, however, I see 
this being a problem since different environments (different publish profiles 
in the project) would require different logins and different security 
altogether. On top of that I'm not even sure how the passwords would be managed 
in this case as they would need to be hardcoded in the scripts.

In the past I'm sure I've only ever seen the security purely managed by the 
DBAs in external scripts (or manually) and not in the Visual Studio project 
itself.

Any thoughts or recommendations would be much appreciated.

Regards
Tom

RE: [OT] Creating logins/users/roles/permissions in Visual Studio sqlproj projects

[Dr Greg Low]

Hi Tom,

For roles and permissions, they should just go directly in the DB projects. 
Nothing special about them.

Users/logins are different.

Ideally, you’d have AD or AAD based groups that are added to the roles, and 
again they can go right in the project. If you’re looking after the DB or 
deploying it, you really shouldn’t be getting involved in who is in those 
groups, and there’s nothing more for you to do.

If you have to use SQL logins/users (and you really should now be trying to 
avoid those), you can put them in the projects but you don’t want passwords 
there. It then depends how you are deploying the projects. If it’s something 
like Azure Pipelines or GitHub Actions, then you should put the credentials 
that must be there into Azure Key Vault or similar, and retrieve them from 
there during deployment.

If you are in an environment like Azure, then you should be reassessing why you 
need the SQL logins. If it’s an app connecting to a DB, in many cases, a 
user-assigned managed identity would be a better option.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tom P via ozdotnet 
Sent: Thursday, 8 December 2022 9:58 AM
To: ozDotNet 
Cc: Tom P 
Subject: [OT] Creating logins/users/roles/permissions in Visual Studio sqlproj 
projects

Hello

I'm fairly new to Visual Studio sqlproj projects and was wondering what the 
normal practice is for managing database security scripts (user logins, users, 
roles, permissions).

I have seen some other projects here where the previous developers had the 
create login SQL code for example in post-deployment scripts, however, I see 
this being a problem since different environments (different publish profiles 
in the project) would require different logins and different security 
altogether. On top of that I'm not even sure how the passwords would be managed 
in this case as they would need to be hardcoded in the scripts.

In the past I'm sure I've only ever seen the security purely managed by the 
DBAs in external scripts (or manually) and not in the Visual Studio project 
itself.

Any thoughts or recommendations would be much appreciated.

Regards
Tom

RE: [OT] Finding duplicate rows in Sql Server

[Dr Greg Low]

Hi Tom,

Possible example:

DROP TABLE IF EXISTS #TestData;
GO

CREATE TABLE #TestData
(
ID int NOT NULL,
[Name] varchar(20) NOT NULL,
[Description] varchar(30) NOT NULL,
SomeDate date NOT NULL,
Etc varchar(20) NOT NULL
);
GO

INSERT #TestData
(
ID, [Name], [Description], SomeDate, Etc
)
SELECT ID, [Name], [Description], SomeDate, Etc
FROM (VALUES
  (1,'abc','abc abc','20221117','a'),
  (2,'abc','abc abc','20221117','a'),
  (5,'def','def def','20221117','a'),
  (4,'abc','abc abc','20221117','a'),
  (3,'def','def def','20221117','a'),
  (6,'xyz','def def','20221117','a')
 ) AS v(ID, [Name], [Description], SomeDate, Etc);
GO

SELECT * FROM #TestData;

WITH OrderedRows
AS
(
SELECT ID, [Name], [Description], SomeDate, Etc,
   ROW_NUMBER() OVER(PARTITION BY [Name], [Description], SomeDate, Etc 
ORDER BY ID DESC) AS CopyNumber
FROM #TestData
)
SELECT ID, [Name], [Description], SomeDate, Etc
FROM OrderedRows
WHERE CopyNumber > 1
ORDER BY ID;

DROP TABLE IF EXISTS #TestData;

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tom P via ozdotnet 
Sent: Thursday, 17 November 2022 5:01 PM
To: ozDotNet 
Cc: Tom P 
Subject: [OT] Finding duplicate rows in Sql Server

Apologies if this is basic for probably most of you but I just can't get my 
head around it.

I have a flat table in sql server which contains lots of duplicates, differing 
only by one column.

Id,Name,Desc,Date,Etc
1,abc,abc abc,2022-11-17,a
2,abc,abc abc,2022-11-17,a
5,def,def def,2022-11-17,a
4,abc,abc abc,2022-11-17,a
3,def,def def,2022-11-17,a
6,xyz,def def,2022-11-17,a

I'm trying to write a query that finds all duplicates excluding the ones with 
the highest Id. So for the above example it would return the following:

Id,Name,Desc,Date,Etc
1,abc,abc abc,2022-11-17,a
2,abc,abc abc,2022-11-17,a
3,def,def def,2022-11-17,a

There are many millions of rows to process so looking for something efficient. 
Any advice would be appreciated.

Regards
Tom

RE: Visual Studio 17.4.0 side effects

[Dr Greg Low]

One of my dreams is to be able to open a VS project that I haven’t touched for 
6 months, and have it still just work. Far too frequently, I spend an eternity 
in dependency hell.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Thursday, 10 November 2022 10:34 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Visual Studio 17.4.0 side effects

Folks, I accepted the major update yesterday, and this morning some odd things 
are happening.

I noticed that .NET SDK 6 was gone and 7 was installed. I had to manually 
reinstall SDK 6 to get going again (this didn't happen to a colleague).

A WebApi project produced a huge slab of NU1106 compile errors. I removed every 
reference of every type and it made no difference. After 2 hours I discovered 
that if I removed one of my own rather innocuous project references then it all 
came good. That reference has been there for the last 6 months.

Now all of my existing Blazor projects stall and produce something like this:

Failed to launch debug adapter.  Additional information may be available in the 
output window.
Unable to launch browser: "Could not open 
ws://localhost:56709/_framework/debug/ws-proxy?browser=wsAFF127.0.0.1A59317FdevtoolsFbrowserF4fe90d5b-f3d4-4f84-950c-2cc9af15b95c"
The program '' has exited with code 4294967295 (0x).

I've now spent 2 hours on this, and it's not looking helpful. A brand new app 
runs okay. I've run out of ideas. I started work at 06:30 but I haven't done 
any real work yet.

Greg Keogh

RE: Platform x64 argument

[Dr Greg Low]

Yes, I was wondering the same thing David. I can’t recall the last time I 
worked on a 32 bit machine.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Kean via ozdotnet 
Sent: Thursday, 13 October 2022 3:13 PM
To: ozDotNet 
Cc: Greg Keogh ; David Kean 
Subject: RE: Platform x64 argument

Do you actually support/ship your app to run on x86-only or ARM environments? 
If not, it probably doesn’t matter and I would probably give this one and save 
the battles for other things.

From: Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Thursday, October 13, 2022 9:46 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Greg Keogh mailto:gfke...@gmail.com>>
Subject: Platform x64 argument

Folks, one of my colleagues insists on compiling everything as platform x64 
mainly because he thinks "it's an x64 world and it creates a better 
impression". For a year I've tried to convince him that for managed code that 
it's a complete waste of time. I've told him that ildasm.exe shows that for x64 
and AnyCPU the generated IL and the manifests are identical, I even told him 
that dumpbin.exe shows the only non trivial difference in the PE headers is a 
couple of flags that show x86/x64 and PE32/PE32+, but they don't affect the 
loading and running of a PE containing IL and metadata.

Does anyone have paradigm-shattering evidence I can give my colleague to break 
his habit? (I'm hoping I'm right of course!!)

Greg

RE: Resolving a SQL server deadlock

[Dr Greg Low]

Hi Tony,

That summary will be pretty close to the mark.

What’s the index that was added though?

Adding an index can lead to deadlocks, as it’s another object that needs to be 
updated when the data is updated.

Few questions though:


  *   What’s the index that was added look like?
  *   Have you considered having RCSI enabled for the database? (Chances are it 
might even fix the issue in this case)
  *   What’s the deal with the “IsLocked” stuff anyway. Smells like a 
roll-your-own locking system. (Which are almost always not a great idea)
  *   Is that DISTINCT really needed? The most important part of resolving 
deadlocks is to start by making sure all the queries involved run as fast as 
possible, to avoid them holding unnecessary locks in the first place, or 
holding them too long.

We often get called in with customers who have “blocking” problems. Invariably 
they have a bunch of deadlocks. 99% of those disappear with appropriate 
indexing to make the queries run fast, and by using RCSI where that makes sense.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tony Wright via ozdotnet 
Sent: Wednesday, 12 October 2022 9:22 AM
To: ozDotNet 
Cc: Tony Wright 
Subject: Resolving a SQL server deadlock

Hi there,

I am currently trying to resolve a sql server deadlock issue. Someone in the 
team is adamant that the deadlock is caused by a new index we've added. I'm not 
sure I've ever heard of an index causing a deadlock, but I'm always interested 
in something new to me, anyway! I have attached a deadlock graph from 
SolarWinds Sql Sentry Plan Explorer and I'm hoping someone else can help me 
understand it.

There are essentially 2 queries. (I've renamed all objects)
The first query is along the lines of:

SELECT DISTINCT *
FROM dbo.Shipping
WHERE StatusID=@StatusID
AND IsLocked=@IsLocked AND TypeID=@TypeID AND ShipDate < @ShipDate.

The field list is expanded and there are lots of fields. It was generated 
inside a third party tool.

The second query is an UPDATE statement in a stored proc, along the lines of:
UPDATE dbo.Shipping
SET IsLocked=@IsLocked,
LockedBy=CASE WHEN @Locked=1 THEN @PersonWhoLocked ELSE NULL END,
LockedDate=CASE WHEN @Locked=1 THEN GetUtcDate() ELSE ModificationDate END
WHERE ShippingID=@ShippingID

Process 1 (126) is the SELECT, which is the deadlock victim
Process 2 (133) is the UPDATE stored proc
Process 3 (139) is the UPDATE stored proc

[cid:image001.png@01D8DE23.62DECD60]
I'm going to take a stab at what might be happening. Hopefully someone can fill 
the gaps in my knowledge.

A deadlock occurs when Process A has a lock on Resource 1 and wants to acquire 
a lock on Resource 2, while Process B has a lock on Resource 2 and wants to 
acquire a lock on Resource 1.

So reading this graph, it looks like:

The 2 resources are the Page Lock on dbo.Shipping, and the Key Lock on the 
shipping Primary Key.

So on the graph it looks to me like Process 1 holds a lock on the Page Lock 
resource and wants a lock on the Key Lock. Process 3 holds a lock on the Key 
lock resource and wants a lock on the Page Lock resource

So:
(1) The SELECT occurs on the shipping table and it takes a Page lock (S)
(2) The first UPDATE occurs (133) and that requires an exclusive lock, but it 
can't get it because there's already a Shared lock, so it puts in an Intent to 
get an Exclusive lock (IX)
(3) The second UPDATE occurs and it acquires an Exclusive lock (X) on the 
Primary Key Index.
(4) Not sure what happens here and how this is relevant
(5) The second UPDATE requests an exclusive lock on the Page of Shipping 
records.
(6) Meanwhile the SELECT tries to get a Shared lock on one of the keys that are 
locked by the second UPDATE statement

Can anyone help me understand what is going on here and how this is going to 
help me prevent further deadlocks?

Kind regards,
Tony

RE: SQL server composite key column order

[Dr Greg Low]

Hi Tony,

Depends upon the most common types of queries.

But yes, 99% of the time, you want to get to the smallest number of rows as 
quickly as possible, so if nothing else is important, I’d go with the higher 
cardinality column.

Of course there are exceptions.

For example, it could be that by using a different order in the keys, you could 
avoid expensive sorts later, etc.

Where are the articles that say differently? Can’t help but think they’d be 
edge cases, or particular types of scans rather than lookups.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Tony Wright via ozdotnet 
Sent: Monday, 10 October 2022 10:27 AM
To: ozDotNet 
Cc: Tony Wright 
Subject: SQL server composite key column order

Hi peeps,

When setting up composite key indexes in SQL server, I have always thought that 
it is best to put the column that has the most variation first in the index. 
I've recently seen articles that claim this is a myth.

So does anyone know the the facts here? Is column order important?

Regards, Tony

RE: Indexed JSON documents (file system)

[Dr Greg Low]

At least in Cosmos, there’s a good story with the indexing policy that’s very 
configurable. (Including fully automated if that’s what you need)

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Friday, 2 September 2022 10:52 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Re: Indexed JSON documents (file system)

I found this: https://github.com/ketanip/dbjson hope it helps.

If I had to do it myself I'd probably do something similar, maybe use SQLite to 
hold an index of the properties of JSON documents. I would have to walk every 
document's tree (fragile) and the hierarchy of properties would have to be 
represented as relational tables (hacky, not meant for that).

Still thinking -- Greg

RE: Blazor deploy error

[Dr Greg Low]

That’s cute.

However, even that doesn’t work now when so many errors returned to UIs only 
include a GUID that’s unique to that instance of the error.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: mike smith via ozdotnet 
Sent: Wednesday, 6 July 2022 2:03 PM
To: ozDotNet 
Cc: mike smith 
Subject: Re: Blazor deploy error

I kinda like .DMP files, especially if I've got a matching set of pdb files to 
match it.

On Wed, 6 July 2022, 12:57 Dr Greg Low via ozdotnet, 
mailto:ozdotnet@ozdotnet.com>> wrote:
https://blog.greglow.com/2018/02/13/opinion-theres-plague-need-stop/


Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Wednesday, 6 July 2022 12:43 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: Greg Keogh mailto:gfke...@gmail.com>>
Subject: Re: Blazor deploy error

After hours of ruling out a mistake on my part, or some change in the compile 
and hosting options, the only thing left is the tooling. Adjusting my searches 
slightly and haphazardly, I finally stumbled upon this 
post<https://github.com/dotnet/sdk/issues/26061> from a few weeks ago.

Some are blaming spaces in paths, maybe, but I'm using SDK 6.0.301 which people 
are blaming for introducing this problem. There are some angry comments.

I downloaded and installed SDK 6.0.5 with 6.0.300, then ran the command dotnet 
new globaljson --force --sdk-version 6.0.300 which creates a global.json file 
as suggested. Clean project, rebuild, now it deploys.

The hours of suffering I wasted on this is apparently caused by some bug in the 
donet command, which someone says will be fixed 6.0.2.

I'm shitting bricks and spitting chips, because here we are in 2022 and we get 
error messages like An error has occured with not the slightest clue anywhere 
about what has gone wrong. In the early 1980s we used to get mainframe messages 
like "JDE833 Program aborted", but even then I could look up the error in a 
manual and do something useful. Is this progress?!

Greg K
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/

RE: Blazor deploy error

[Dr Greg Low]

https://blog.greglow.com/2018/02/13/opinion-theres-plague-need-stop/


Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Wednesday, 6 July 2022 12:43 PM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Re: Blazor deploy error

After hours of ruling out a mistake on my part, or some change in the compile 
and hosting options, the only thing left is the tooling. Adjusting my searches 
slightly and haphazardly, I finally stumbled upon this 
post<https://github.com/dotnet/sdk/issues/26061> from a few weeks ago.

Some are blaming spaces in paths, maybe, but I'm using SDK 6.0.301 which people 
are blaming for introducing this problem. There are some angry comments.

I downloaded and installed SDK 6.0.5 with 6.0.300, then ran the command dotnet 
new globaljson --force --sdk-version 6.0.300 which creates a global.json file 
as suggested. Clean project, rebuild, now it deploys.

The hours of suffering I wasted on this is apparently caused by some bug in the 
donet command, which someone says will be fixed 6.0.2.

I'm shitting bricks and spitting chips, because here we are in 2022 and we get 
error messages like An error has occured with not the slightest clue anywhere 
about what has gone wrong. In the early 1980s we used to get mainframe messages 
like "JDE833 Program aborted", but even then I could look up the error in a 
manual and do something useful. Is this progress?!

Greg K

RE: Blazor deploy error

[Dr Greg Low]

Sorry, perhaps dumb question, but what does it say in the Output window?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Wednesday, 6 July 2022 10:23 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Blazor deploy error

Folks, I've been trying to deploy a Blazor app from Visual Studio 2022 for 
hours without success. I'm doing the usual right-click-publish that I've been 
doing for about a year, but yesterday it stopped working, and even this morning 
with a fresh mind I cannot make any progress. I've changed the pubxml options, 
compile options, etc. Absolutely nothing works. All I get is the generic and 
utterly useless error below. Normally changing an FTP or Deploy settings :wakes 
it up" and it works, but not this time.

I'm about to delete the publish profile and make a new one, but I'm sure it's a 
waste of time. I'm wondering if some hosting versions have changed, or 
something is deprecated, something global I'm not aware of.

Has anyone been through this? -- Greg K

[cid:image001.png@01D89122.D7F20E30]

RE: 53-bit double

[Dr Greg Low]

Hi Greg,

All good. I think you described it fine. The question I had was more on what 
the big picture was. Why do it at all?

And yes, there’d be a way to manipulate the bits to manually construct it, but 
in most languages, that’d be pretty ugly anyway.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh 
Sent: Tuesday, 5 July 2022 8:58 AM
To: Dr Greg Low 
Cc: ozDotNet 
Subject: Re: 53-bit double

I might have missed it earlier Greg but was the actual problem that this helps 
with? I was intrigued by the underlying problem.

I didn't express myself clearly originally. I was trying to convert a 64-bit 
random integer into a double and guarantee that all possible 2^53 floating 
values in the range 0 to 1 could result. Someone suggested that weird bit of 
earlier incomprehensible code, but it turns out a simple shift-and-multiply 
does that trick.

There are lots of modern PRNGs that generate 64-bits, like the xoroshift** that 
is being used in the latest Random class. But how do you convert 64-bits 
"perfectly" into doubles? I finally confirmed a correct way.

I'm still wondering if there is a way of manually constructing an IEEE 754 
number from the raw bits, but it makes my head hurt.

Cheers, GK

RE: 53-bit double

[Dr Greg Low]

I might have missed it earlier Greg but was the actual problem that this helps 
with? I was intrigued by the underlying problem.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh via ozdotnet 
Sent: Tuesday, 5 July 2022 8:37 AM
To: ozDotNet 
Cc: Greg Keogh 
Subject: Re: 53-bit double

uint u1 = [32 random bits];
uint u2 = [32 random bits];
uint a = u1 >> 5, b = u2 >> 6;
return (a * 67108864.0 + b) * (1.0 / 9007199254740992.0);

Can anyone explain this magic? Is this correct?

This bit trick is no longer important to decode. I was trying to figure out how 
to convert a UInt64 of random bits into a normalised double in the range [0,1) 
in such a way that all 2^53 possible floating values could be produced. Some 
web sites suggested simply doing this:

uint u = [64 random bits]
double d = (u >> 11) * 1.11022302462515654e-16   // * 2-53

I was suspicious that subtle rounding problems might produce a defective output 
range, but a quick experiment in LINQPad that fed limit values into the 
calculation demonstrated that a complete set of significand bit patterns was 
generated at the limits. This supplies good evidence that the above 
shift-and-multiply converts 53 of the 64 random bits into a complete possible 
double range.

Greg K

Re: It's that time of year - F#

[Dr Greg Low]

If the requirements for what it needs to integrate with stay stationary then 
no, but they usually don't.

For example, SQL Server Reporting Services is awesome and still has significant 
use cases where it is the most appropriate tool. But you'd be waiting forever 
for an updated report viewer control to place in, say, a new Blazor based app.

It's always up to the owners if they turn tools into abandonware. It's easy to 
kill products through neglect.

Mind you, I spent the day integrating ADF, AAS, and Power BI again with an app 
(still in use) that was written in Progress in 1983.

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me


From: mike smith via ozdotnet 
Sent: Wednesday, June 29, 2022 6:11:46 PM
To: ozDotNet 
Cc: mike smith 
Subject: Re: It's that time of year - F#

Do languages need constant evolution to be seen as successful?

As a recent post said, look at c++

Mike

On Wed, 29 June 2022, 11:06 Dr Greg Low via ozdotnet, 
mailto:ozdotnet@ozdotnet.com>> wrote:

In fact, the messaging changed fairly abruptly.



Compare Kathleen’s article in Nov 2018: 
https://devblogs.microsoft.com/vbteam/visual-basic-in-net-core-3-0/



With the one 15 months later: 
https://devblogs.microsoft.com/vbteam/visual-basic-support-planned-for-net-5-0/



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile

SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low



From: Greg Keogh mailto:gfke...@gmail.com>>
Sent: Wednesday, 29 June 2022 11:21 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Burstin mailto:david.burs...@gmail.com>>; 
David Kean mailto:david.k...@microsoft.com>>; Dr Greg 
Low mailto:g...@sqldownunder.com>>
Subject: Re: It's that time of year - F#



Mind you, there have been many interesting languages over the years. And their 
fate has not always seemed logical.



I think a year ago I said something like ... I was excited about F# when it 
first came out, but never got to write any production software using it. 
Whenever I sat down to write something serious I got bogged down in choices and 
syntax details and "bridging" over to other C# libraries to do the heavy 
lifting. There were lots of other irritations like long searches for good 
samples, less tooling, less (and bewildering) documentation, smaller community, 
lack of T4 templates, etc. If I were writing lots of algorithmic code then F# 
would be a superior choice and all the "bridging" would be pushed to the edges, 
but lots of typical LOB coding is best done in C#.



C# has evolved so far now that it must be the best hybrid language in popular 
use by a long shot, and its functional features are deflating F#'s functional 
fame. The downside is that C# is accumulating so many features that I can't 
remember them all, so I'm thankful when Visual Studio light bulbs appear and 
remind me to replace my force-of-habit clumsy code. I hope they ease off on new 
C# features in the future, I don't want it to turn into C++ 20/23 or 
PL/I<https://en.wikipedia.org/wiki/PL/I> (the language that was going to solve 
every problem in the world).



Cheers, Greg K



P.S. What happened to VB.NET<http://VB.NET>? No sarcasm, it just seems to have 
dropped out of articles and announcements.

--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/

RE: It's that time of year - F#

[Dr Greg Low]

In fact, the messaging changed fairly abruptly.

Compare Kathleen’s article in Nov 2018: 
https://devblogs.microsoft.com/vbteam/visual-basic-in-net-core-3-0/

With the one 15 months later: 
https://devblogs.microsoft.com/vbteam/visual-basic-support-planned-for-net-5-0/

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh 
Sent: Wednesday, 29 June 2022 11:21 AM
To: ozDotNet 
Cc: David Burstin ; David Kean 
; Dr Greg Low 
Subject: Re: It's that time of year - F#

Mind you, there have been many interesting languages over the years. And their 
fate has not always seemed logical.

I think a year ago I said something like ... I was excited about F# when it 
first came out, but never got to write any production software using it. 
Whenever I sat down to write something serious I got bogged down in choices and 
syntax details and "bridging" over to other C# libraries to do the heavy 
lifting. There were lots of other irritations like long searches for good 
samples, less tooling, less (and bewildering) documentation, smaller community, 
lack of T4 templates, etc. If I were writing lots of algorithmic code then F# 
would be a superior choice and all the "bridging" would be pushed to the edges, 
but lots of typical LOB coding is best done in C#.

C# has evolved so far now that it must be the best hybrid language in popular 
use by a long shot, and its functional features are deflating F#'s functional 
fame. The downside is that C# is accumulating so many features that I can't 
remember them all, so I'm thankful when Visual Studio light bulbs appear and 
remind me to replace my force-of-habit clumsy code. I hope they ease off on new 
C# features in the future, I don't want it to turn into C++ 20/23 or 
PL/I<https://en.wikipedia.org/wiki/PL/I> (the language that was going to solve 
every problem in the world).

Cheers, Greg K

P.S. What happened to VB.NET<http://VB.NET>? No sarcasm, it just seems to have 
dropped out of articles and announcements.

RE: It's that time of year - F#

[Dr Greg Low]

Announcements like these were pretty terminal I’d say:

https://visualstudiomagazine.com/articles/2020/03/12/vb-in-net-5.aspx


Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: Greg Keogh 
Sent: Wednesday, 29 June 2022 11:21 AM
To: ozDotNet 
Cc: David Burstin ; David Kean 
; Dr Greg Low 
Subject: Re: It's that time of year - F#

Mind you, there have been many interesting languages over the years. And their 
fate has not always seemed logical.

I think a year ago I said something like ... I was excited about F# when it 
first came out, but never got to write any production software using it. 
Whenever I sat down to write something serious I got bogged down in choices and 
syntax details and "bridging" over to other C# libraries to do the heavy 
lifting. There were lots of other irritations like long searches for good 
samples, less tooling, less (and bewildering) documentation, smaller community, 
lack of T4 templates, etc. If I were writing lots of algorithmic code then F# 
would be a superior choice and all the "bridging" would be pushed to the edges, 
but lots of typical LOB coding is best done in C#.

C# has evolved so far now that it must be the best hybrid language in popular 
use by a long shot, and its functional features are deflating F#'s functional 
fame. The downside is that C# is accumulating so many features that I can't 
remember them all, so I'm thankful when Visual Studio light bulbs appear and 
remind me to replace my force-of-habit clumsy code. I hope they ease off on new 
C# features in the future, I don't want it to turn into C++ 20/23 or 
PL/I<https://en.wikipedia.org/wiki/PL/I> (the language that was going to solve 
every problem in the world).

Cheers, Greg K

P.S. What happened to VB.NET<http://VB.NET>? No sarcasm, it just seems to have 
dropped out of articles and announcements.

RE: It's that time of year - F#

[Dr Greg Low]

Hi David,

The one that’s always fascinated me is the disappearance of simulation 
languages.

In the 80’s I remember looking at Simula 68, and being amazed at what it 
offered. For something written in 68, having concepts like classes, and 
instances of classes, etc. was all pretty awesome. There were later versions of 
it as well.

The idea was that if you wanted to model, say, people coming to a counter to be 
processed, you’d define classes for each actor involved. (They didn’t call them 
actors). Then, the bit that I thought was magic, is that wherever you had a 
decision to be made (i.e. mostly there just an IF type of statement) in the 
code in each actor’s class, you specified not only the logic for the IF, but 
the odds of going in either direction.

Then you started it up, and just sat back and watched what happened. I thought 
that was gold, and certainly for someone doing that back in 68.

And I think about how hard it would be for me to just build that today, using 
current tools. So I’ve always wondered why they disappeared.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Burstin 
Sent: Wednesday, 29 June 2022 11:05 AM
To: Dr Greg Low 
Cc: ozDotNet ; David Kean 
Subject: Re: It's that time of year - F#

Thanks all. Greg, unfortunately you are spot on. The more I use F#, the more I 
see my productivity and quality naturally increase on my home projects, 
especially once they start to get a bit complicated. I have always been firmly 
in the C# camp, but now that I have a good understanding of F# I really 
appreciate the constructs like active pattern matching, pipelining and partial 
application. The compiler really does catch nearly all errors and I haven't had 
to crack out the debugger for quite a while. If I had a choice, F# would 
definitely be my preferred choice.

But, it is true that companies aren't using it. And understandably so - without 
a huge pool of developers the risks are enormous. It's a sad fact that for some 
languages "their fate does not always seem logical".

Has anyone here tried F#? What were your experiences? If not, was it just 
because no one else is using it (totally valid)?

Languages are like social media platforms - if no one is using it then no one 
wants to use it.

Thanks for the responses.



On Wed, 29 Jun 2022 at 09:33, Dr Greg Low 
mailto:g...@sqldownunder.com>> wrote:
It has to be a pretty “brave” or “interesting” choice for a dev team lead 
though doesn’t it ? (depending upon your perspective)

Unless you’re doing something really, really out of the ordinary, choosing to 
use a language where there’s even a possibility of an actual list of companies 
who use it would seem awfully hard to justify. Given there are 4 listed in 
Australia, and on average pretty small, I wonder how many of those did so 
because they wanted to find a place to use it. I’m sure there will be more, but 
even so, that’s quite something.

I certainly remember the hype when it appeared.

Mind you, there have been many interesting languages over the years. And their 
fate has not always seemed logical.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Kean via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Wednesday, 29 June 2022 9:06 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Burstin mailto:david.burs...@gmail.com>>; 
David Kean mailto:david.k...@microsoft.com>>
Subject: RE: It's that time of year - F#

I asked Don and he pointed me to 
https://github.com/fsprojects/fsharp-companies, which lists a few.

From: David Kean via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Wednesday, June 29, 2022 8:11 AM
To: David Burstin via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Cc: David Burstin mailto:david.burs...@gmail.com>>; 
David Kean mailto:david.k...@microsoft.com>>
Subject: Re: It's that time of year - F#

I'll ask around and get back to you.


From: David Burstin via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, June 24, 2022 3:40 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Burstin mailto:david.burs...@gmail.com>>
Subject: It's that time of year - F#

Hi folks,

It's been about a year since I asked, so here it is again. Does anyone know of 
any F# work being done in Melbourne, or anywhere in Australia?

I've managed to do some small F# helper apps for my employer, but 98% of what I 
do is C#. I'd really love to find somewhere that uses F#.

On the plus side - F# has helped improve my C# approach dramatically, and C# is 
constantly introducing more functional ideas (although discriminated unions and 
active patterns would be lovely).

So, anyone know anything?

Cheers
David

RE: It's that time of year - F#

[Dr Greg Low]

It has to be a pretty "brave" or "interesting" choice for a dev team lead 
though doesn't it ? (depending upon your perspective)

Unless you're doing something really, really out of the ordinary, choosing to 
use a language where there's even a possibility of an actual list of companies 
who use it would seem awfully hard to justify. Given there are 4 listed in 
Australia, and on average pretty small, I wonder how many of those did so 
because they wanted to find a place to use it. I'm sure there will be more, but 
even so, that's quite something.

I certainly remember the hype when it appeared.

Mind you, there have been many interesting languages over the years. And their 
fate has not always seemed logical.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> | 
About Greg:  https://about.me/greg.low

From: David Kean via ozdotnet 
Sent: Wednesday, 29 June 2022 9:06 AM
To: ozDotNet 
Cc: David Burstin ; David Kean 

Subject: RE: It's that time of year - F#

I asked Don and he pointed me to 
https://github.com/fsprojects/fsharp-companies, which lists a few.

From: David Kean via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Wednesday, June 29, 2022 8:11 AM
To: David Burstin via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Cc: David Burstin mailto:david.burs...@gmail.com>>; 
David Kean mailto:david.k...@microsoft.com>>
Subject: Re: It's that time of year - F#

I'll ask around and get back to you.


From: David Burstin via ozdotnet 
mailto:ozdotnet@ozdotnet.com>>
Sent: Friday, June 24, 2022 3:40 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Cc: David Burstin mailto:david.burs...@gmail.com>>
Subject: It's that time of year - F#

Hi folks,

It's been about a year since I asked, so here it is again. Does anyone know of 
any F# work being done in Melbourne, or anywhere in Australia?

I've managed to do some small F# helper apps for my employer, but 98% of what I 
do is C#. I'd really love to find somewhere that uses F#.

On the plus side - F# has helped improve my C# approach dramatically, and C# is 
constantly introducing more functional ideas (although discriminated unions and 
active patterns would be lovely).

So, anyone know anything?

Cheers
David

RE: here's a question for the list: NT

[Dr Greg Low]

Awesome thanks.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/>

From: Richard Carde via ozdotnet 
Sent: Thursday, 23 June 2022 2:05 PM
To: ozDotNet 
Cc: Richard Carde 
Subject: Re: here's a question for the list: NT

Greg

You are correct.

C:\>tzutil /l

(UTC+09:30) Adelaide
Cen. Australia Standard Time

(UTC+09:30) Darwin
AUS Central Standard Time


Check with PowerShell:

PS C:\> ([System.TimeZoneInfo]::FindSystemTimeZoneById("Cen. Australia Standard 
Time")).SupportsDaylightSavingTime
True
PS C:\> ([System.TimeZoneInfo]::FindSystemTimeZoneById("AUS Central Standard 
Time")).SupportsDaylightSavingTime
False


Regards,

RC


On Thu, 23 Jun 2022 at 13:07, Dr Greg Low via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
Found one list where it says:

Adelaide = Cen. Australia Standard Time
Darwin = AUS Central Standard Time

Hopefully DST is the difference.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/>

From: Dr Greg Low
Sent: Thursday, 23 June 2022 12:40 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: here's a question for the list: NT

Hi Everyone,

Here’s a question for the brains trust:

When configuring Windows timezones, what gets used for the Northern Territory?

“Cen. Australia Standard Time” I’m sure is for SA, etc. but would also include 
DST changes, where the NT doesn’t have DST. Is there some other timezone that 
works well for NT ?

Or is that the difference between “Cen. Australia Standard time” and “AUS 
Central Standard Time” ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/>

--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/

RE: here's a question for the list: NT

[Dr Greg Low]

Found one list where it says:

Adelaide = Cen. Australia Standard Time
Darwin = AUS Central Standard Time

Hopefully DST is the difference.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/>

From: Dr Greg Low
Sent: Thursday, 23 June 2022 12:40 PM
To: ozDotNet 
Subject: here's a question for the list: NT

Hi Everyone,

Here's a question for the brains trust:

When configuring Windows timezones, what gets used for the Northern Territory?

"Cen. Australia Standard Time" I'm sure is for SA, etc. but would also include 
DST changes, where the NT doesn't have DST. Is there some other timezone that 
works well for NT ?

Or is that the difference between "Cen. Australia Standard time" and "AUS 
Central Standard Time" ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/>

here's a question for the list: NT

[Dr Greg Low]

Hi Everyone,

Here's a question for the brains trust:

When configuring Windows timezones, what gets used for the Northern Territory?

"Cen. Australia Standard Time" I'm sure is for SA, etc. but would also include 
DST changes, where the NT doesn't have DST. Is there some other timezone that 
works well for NT ?

Or is that the difference between "Cen. Australia Standard time" and "AUS 
Central Standard Time" ?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/>

RE: ozdotnet - New List Infrastructure

[Dr Greg Low]

Yep, set up by Dr Pete. (Who, for those who don’t know) is working in the local 
MS sub now.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|About me: https://greglow.me

From: David Richards via ozdotnet 
Sent: Thursday, 23 June 2022 7:23 AM
To: ozDotNet 
Cc: David Richards 
Subject: Re: ozdotnet - New List Infrastructure

Wow, that was a long time ago. Early 2000s I think. I can't believe I've been 
on this list for almost 20 years. There was a lot more discussion going on back 
then. I guess we all just got good and don't need much help anymore :)

David

"If we can hit that bullseye, the rest of the dominoes
 will fall like a house of cards... checkmate!"
 -Zapp Brannigan, Futurama


On Thu, 23 Jun 2022 at 06:55, DotNet Dude via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
I vaguely recall the old days when it was on “stanski” or something like that. 
My memory is not what it used to be

On Wed, 22 Jun 2022 at 14:26, Tony McGee via ozdotnet 
mailto:ozdotnet@ozdotnet.com>> wrote:
Agreed, many thanks to our benevolent list maintainer(s).
Untiring effort, all the way back to when it was called ausDotNet.

PS. That NUC sounds like a champion, it belongs in a museum as Indy would say

-Tony


On 21/06/2022 15:17, David Burstin via ozdotnet wrote:
Thanks David for all the work you do to keep this list going. Really 
appreciated.

On Tue, 21 Jun 2022, 14:34 David Connors via ozdotnet, 
mailto:ozdotnet@ozdotnet.com>> wrote:
Hi All,

I've readded everyone to the new mailman3 hosted environment. There are a few 
changes to how message headers are presented etc as a result of the move to 
mailman3.

If you want to change your subscription etc then head to [X] 
https://codify.mailman3.com.

I am not going to continue keeping the old archives at [X] 
http://prdlxvm0001.codify.net/mailman and will bin that server as soon as I've 
removed the other lists from it that no one uses any more.

David Connors
da...@connors.com<mailto:da...@connors.com> | M +61 417 189 363
Telegram: [X] https://t.me/davidconnors
LinkedIn: [X] http://au.linkedin.com/in/davidjohnconnors
___
ozdotnet mailing list -- ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>
To unsubscribe send an email to 
ozdotnet-le...@ozdotnet.com<mailto:ozdotnet-le...@ozdotnet.com>


___

ozdotnet mailing list -- ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>

To unsubscribe send an email to 
ozdotnet-le...@ozdotnet.com<mailto:ozdotnet-le...@ozdotnet.com>


--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/
--
ozdotnet mailing list
To manage your subscription, access archives: https://codify.mailman3.com/

Re: [OT] Atlassian SourceTree

[Dr Greg Low]

Pretty decent unlimited Git repos, agile/scrum style boards with item/workitem 
tracking, queries, and many visualisations and stakeholder access, build and 
release CI/CD pipelines with integrations for almost anything on-premises or 
cloud-based, and built with your choice of either an intuitive GUI or ugly 
YAML, build and release tracking, package feeds (nom, nuget, and other styles) 
with upstream feeds, versioning, and/or repackaging, manual test tracking, out 
of the box AAD integration, a marketplace with a very wide range of offerings.

And did I mention, free for teams of up to 5 users, and really low cost for 
bigger teams?

Use whatever Git client you want but I find the ones in VS and VS Code adequate 
when combined with Git for Windows.

Then it also directly integrates with other tools like ADF, etc.

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me


From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Greg Keogh 
Sent: Friday, December 31, 2021 5:07:38 PM
To: ozDotNet 
Subject: Re: [OT] Atlassian SourceTree

Serious question: why not just do it all in Azure DevOps and avoid the 
complexity?

Sorry for the late reply, you went into spam for some reason (Google thinks 
you're suspicious!).

What is "all" the stuff I can do in DevOps, how?. In the web portal I can do 
some high-level work, but only a fraction of what I can do client-side in 
Visual Studio (or SourceTree or Gitkraken). Maybe I haven't explored all of the 
available features.

GK

Re: [OT] Atlassian SourceTree

[Dr Greg Low]

Serious question: why not just do it all in Azure DevOps and avoid the 
complexity?

Regards

Greg

Get Outlook for iOS

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Greg Keogh 
Sent: Friday, December 31, 2021 3:02:58 PM
To: ozDotNet 
Subject: Re: [OT] Atlassian SourceTree

Gitkraken is very nice, and I do like the console integration it has now.

I'm trying it out now. I managed to get it integrated with my Bitbucket, GitHub 
and DevOps accounts (DevOps was a struggle as expected).

The "Workspace" feature is what I'm interested in, but the dialog makes no 
sense. I can only select repository locations GitHub and Bitbucket from the 
dropdown. My important stuff is in DevOps which isn't listed to pick. In 
SourceTree I could drop local repo folders into the tree, and I expected some 
similar feature.

Greg

Re: [OT] Atlassian SourceTree

[Dr Greg Low]

The other day I had a half page of unhandled exception from Confluence. 
Apparently I should have realised it meant the password I entered didn't meet 
its complexity rules.

I love to see a local company like Atlassian doing so well but whenever I use 
their software, I keep having "emperor's new clothes" moments.

Regards

Greg

Get Outlook for iOS

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Greg Keogh 
Sent: Friday, December 31, 2021 3:02:58 PM
To: ozDotNet 
Subject: Re: [OT] Atlassian SourceTree

Gitkraken is very nice, and I do like the console integration it has now.

I'm trying it out now. I managed to get it integrated with my Bitbucket, GitHub 
and DevOps accounts (DevOps was a struggle as expected).

The "Workspace" feature is what I'm interested in, but the dialog makes no 
sense. I can only select repository locations GitHub and Bitbucket from the 
dropdown. My important stuff is in DevOps which isn't listed to pick. In 
SourceTree I could drop local repo folders into the tree, and I expected some 
similar feature.

Greg

RE: Sign-in with social accounts

[Dr Greg Low]

And Greg, in the Azure portal, AD doesn't normally appear front and centre, but 
it's on the hamburger menu on the left hand side.

[cid:image001.png@01D7D610.B09B2F60]

But for B2C, you need to first create a resource:

[cid:image002.png@01D7D610.FB9D74A0]

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|About me: https://greglow.me

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of .net noobie
Sent: Wednesday, 10 November 2021 12:02 AM
To: ozDotNet 
Subject: Re: Sign-in with social accounts

AD-B2C allows 50K active monthly users before it costs anything...
so you could have more users than 50K... but the first 50K users per month who 
login to your system are no charge

425show (videos about AD-B2C & MSAL and alot other related security stuff)
https://www.youtube.com/c/425show/videos

Microsoft Authentication Library (MSAL)
https://docs.microsoft.com/en-us/azure/active-directory/develop/msal-overview

Azure Active Directory B2C code samples
https://docs.microsoft.com/en-au/azure/active-directory-b2c/integrate-with-app-code-samples

On Mon, 26 Apr 2021 at 14:35, Greg Keogh 
mailto:gfke...@gmail.com>> wrote:
And before you start paying for alternatives, please check out Azure B2C as I 
mentioned and see if it will do what you need. I’m constantly fascinated by 
projects where I see people buying tools that they already have a usable tool.

Oh yeah! I always like to use pre-supplied stuff before going shopping. I've 
been browsing around the customer's Pay-as-You-Go subscription portal and I 
can't even find any AD related items?! I thought every subscription had an AD 
associated with it. Oh well, I'll just keep reading... GK

RE: SQL Graph databases

[Dr Greg Low]

And for further confirmation on this one, I reached out today to talk to the 
people doing Graph in SQL Server.

Shreya Verma was the lead for the Graph support. 
(https://channel9.msdn.com/Events/Speakers/shreya-verma)

I'm told she's gone. Make of that what you will 

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|About me: https://greglow.me

From: Dr Greg Low 
Sent: Monday, 25 October 2021 8:38 PM
To: ozDotNet 
Subject: Re: SQL Graph databases

Hi Greg,

We try to get devs to avoid using EF in anger at all, let alone for use with 
Graph in SQL Server.

It's also not just EF support that's needed when new datatypes appear, client 
libraries, etc have to be updated too. Anyone using EF is always well behind in 
ability to use current features.

I currently don't see value in their current Graph implementation; I don't love 
the syntax (which is reminiscent of pre ANSI 92 join syntax): and I don't 
really feel it adds anything much that I couldn't easily do without it.

To really add value, it would need to support constructs like polymorphic 
queries (tell me all things related to John, regardless of type), etc. 
Shoe-horning those into T-SQL would be quite a challenge.

I haven't seen a single customer pursuing it beyond their initial tests.

If you want to hear a more detailed discussion on it though, check out the 
podcast I did with Louis Davidson about it a few months ago. It's in the 
podcasts at our https://sqldownunder.com site.

My prediction is that it will become yet another item of abandonware in the 
product. No-one is now talking about it. I wish they'd spend time building 
things we need instead of wasting effort like this.

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me


From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> on behalf 
of Greg Keogh mailto:gfke...@gmail.com>>
Sent: Monday, October 25, 2021 6:25:31 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: SQL Graph databases

Folks, I spent Sunday afternoon playing around with SQL Server Graph databases, 
and as I expected, it all works as advertised. It's pretty neat and the query 
syntax is comprehensible to mortals, unlike my experiments with Cosmos DB and 
the Gremlin API which is as cryptic as abstract algebra.

So it all works, but suddenly I realised that the SQL Graph API is not surfaced 
at the application level for the convenience of .NET developers. Entity 
Framework does not expose any graph features, and it's unclear what the 
official plans are around that issue. I did see that someone has forked EF and 
added graph support, but it looks like a hobby project.

Is anyone using SQL graph databases in anger? Any comments from the developer's 
point of view?

Greg K

RE: DLL Hell

[Dr Greg Low]

Hi Greg,

Every day when I open an older SQL code project, I'm thankful that it's likely 
to just work, unchanged.

By comparison, every single time that I open a VS app project that I haven't 
touched for a few months, I shudder about what I'm likely to have to spend time 
fixing.

It's largely an attitude thing from the dev teams. I know that when someone 
stuffs up in the SQL team, they know that people are going to be still swearing 
at them in 18 years' time, wondering why that made that mistake. They pride 
themselves on not breaking things. I just don't see that in other teams.

The app dev teams seem to work on the basis that anything older than a few 
months should be thrown away and rebuilt.

I used to find it funny going to conferences where people would be telling devs 
to avoid doing something, and yet it was exactly what the same people told them 
to do, just the previous year. Nowadays, I don't find that so amusing.

They say that most apps today are 90% code from other people, usually from open 
source libraries, each of which has no constraints on how it's built or 
versioned, or which versions they have dependencies on. Is it little wonder 
that when you need to use several libraries to get something done, that you can 
then end up in an incompatibility mess?

Now I wouldn't want to be involved in rewriting something like NewtonSoft 
within my own project, but there is something to be said for the development 
tool and language manufacturer providing critical libraries and controlling 
upgradability, etc. rather than outsourcing the development of all of them to 
random external authors.

I keep hearing how the community will steer libraries in the right direction, 
but I keep seeing the outcomes.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|About me: https://greglow.me

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Greg Keogh
Sent: Wednesday, 27 October 2021 12:48 PM
To: ozDotNet 
Subject: DLL Hell

It's not Friday but ... the last few years of being a .NET developer in the 
transition period from full Framework through Standard to Core has been one of 
the worst periods of my career. We've had so many targets, libraries, versions, 
dependencies and releases that I have little trust that anything I write or 
publish will work or have any shelf life. Maybe the full arrival of .NET 6 will 
bring back the simplicity and stability that I last experienced in the 
Framework 4.5 days.

By a long shot, my worst suffering in recent years has been caused by compile 
problems and runtime crashes due to DLL versions and binding. I assume others 
here, like me, have exhausted man-days or weeks trying to solve DLL hell with 
System.Http or Newtonsoft (special mention!!), or many other dreaded names that 
just keep turning up like turds you can't flush. There have been times where 
I've had to update some library reference, and I spend 6 hours trying to make 
it compile and run. I've recently had problems (non-breaking ones) that have 
taken weeks of spare time research to overcome. Sometimes I reach the point of 
tears, so I just go and sit outside and read a book or clean the gutters to 
clear my head. In 40 years of programming, I've never experienced times this 
bad. There are often days where I spend more time Google searching for samples 
and answers than I do actually developing software, seriously!

The reason I'm so morose today is that I've just spent 2 days trying to get 
Python 3.7 to call one of our .NET library suites for data analysis. Using the 
excellent Python.NET package I came so close I could smell victory, but it was 
snatched out of hands by a Threading.Extensions 4.2.0.0 not found DLL Hell 
crash. Normally you would add a config file and redirect, but I'm in the 
goddamn Python runtime environment. More Google searching suggests vague and 
difficult workarounds that will take days of research, with no promise of 
success.

Is anyone else upset that software development is so hard? I know some people 
who are abandoning IT and preparing to retire because the burden of keeping up 
with all the latest technology and tools on different platforms from different 
vendors is just too much for them. One chap said that even taking time to 
become proficient in Git and version control would be worse than a lobotomy.

Greg K

RE: SQL Graph databases

[Dr Greg Low]

Personal preference? Just code-gen appropriate ADO.NET code. A common problem 
with most ORMs is that the people coding them often make decisions that are not 
in your interest. At least when you do some code-gen, you can fix it if you 
don't like it.

Here's one simple example: when I used to teach ADO.NET, I'd always tell 
developers to NEVER use the AddWithValue() method on the Parameters collection 
of the SqlCommand object. Which method did they use in LINQ/EF? You guessed it, 
that one. And when you then have issues, how exactly do you fix them, when it's 
baked into the framework?

These things are never an issue with toy apps, but they matter in anything that 
needs to scale.

Any using any ORM will put you behind in the ability to use modern features of 
the DBs. For example, I'm already writing production-bound code today, that 
uses a feature added to Azure SQL DB yesterday and it will have a profoundly 
positive impact on the performance of the client's system. I don't want to be 
stuck in several years' time, wondering if they'll add support to my ORM for 
the new features. Graph was added to SQL Server in 2017. It's now the end of 
2021. Why exactly isn't it in EF?

But I also still have a strong preference for putting DB logic in stored procs 
rather than auto-generated on the fly in the app, for more reasons than I can 
go into here. But if you don't do that, you generally end up with intensely 
"chatty" applications that have no place in a cloud-first world.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|About me: https://greglow.me

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Greg Keogh
Sent: Tuesday, 26 October 2021 9:44 AM
To: ozDotNet 
Subject: Re: SQL Graph databases

Dr L,

Very interesting! What do you recommend .NET developers to use when talking to 
SQL Server? Another ORM? Plain ADO.NET<http://ADO.NET>? Stored procs?

Using an ORM does keep you at arms length from the DB engine and it abstracts 
away differences, but that's a good thing! I've never suffered from anything 
lagging behind SQL Server's current features before, but I guess it finally 
happened with Graph.

So SQL Graph will go the way of Silverlight, WF, WCF, Cardspace and UWP. I can 
understand they published a Graph DB feature to be competitive, but you can't 
make people like it.

I personally love Graph DBs, so I was keen to have one out-of-the-box, sort of.

Greg K

Re: SQL Graph databases

[Dr Greg Low]

Hi Greg,

We try to get devs to avoid using EF in anger at all, let alone for use with 
Graph in SQL Server.

It's also not just EF support that's needed when new datatypes appear, client 
libraries, etc have to be updated too. Anyone using EF is always well behind in 
ability to use current features.

I currently don't see value in their current Graph implementation; I don't love 
the syntax (which is reminiscent of pre ANSI 92 join syntax): and I don't 
really feel it adds anything much that I couldn't easily do without it.

To really add value, it would need to support constructs like polymorphic 
queries (tell me all things related to John, regardless of type), etc. 
Shoe-horning those into T-SQL would be quite a challenge.

I haven't seen a single customer pursuing it beyond their initial tests.

If you want to hear a more detailed discussion on it though, check out the 
podcast I did with Louis Davidson about it a few months ago. It's in the 
podcasts at our https://sqldownunder.com site.

My prediction is that it will become yet another item of abandonware in the 
product. No-one is now talking about it. I wish they'd spend time building 
things we need instead of wasting effort like this.

Regards

Greg

Dr Greg Low
Director
SQL Down Under Pty Ltd
Office: 1300SQLSQL (1300775775)
Mobile: +61419201410
About me: https://greglow.me


From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Greg Keogh 
Sent: Monday, October 25, 2021 6:25:31 PM
To: ozDotNet 
Subject: SQL Graph databases

Folks, I spent Sunday afternoon playing around with SQL Server Graph databases, 
and as I expected, it all works as advertised. It's pretty neat and the query 
syntax is comprehensible to mortals, unlike my experiments with Cosmos DB and 
the Gremlin API which is as cryptic as abstract algebra.

So it all works, but suddenly I realised that the SQL Graph API is not surfaced 
at the application level for the convenience of .NET developers. Entity 
Framework does not expose any graph features, and it's unclear what the 
official plans are around that issue. I did see that someone has forked EF and 
added graph support, but it looks like a hobby project.

Is anyone using SQL graph databases in anger? Any comments from the developer's 
point of view?

Greg K

Re: Visual Studio 2022

[Dr Greg Low]

Love the AI based Intellisense

Get Outlook for iOS

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Greg Keogh 
Sent: Friday, July 23, 2021 6:54:44 PM
To: ozDotNet 
Subject: Visual Studio 2022

(TGIF a bit late) I've been playing around with VS2022 in a VM for a couple of 
weeks. Superficially it looks and feels similar to 2019, but I haven't poked 
into the depths yet. It compiles and runs all of my personal projects without a 
worry, but I ran into the following issues:

I have to maintain lots of Framework 4.5 projects for a few more months (until 
new live Windows Server 2019 machines are deployed). Unfortunately the earliest 
Framework support is for 4.6.1 (2?), but that's fair enough as 4.5 is OLD. 
Luckily I'll be able to upgrade all those old projects to 4.8 to prepare for 
the new servers. Be aware that old Frameworks are dropped.

The following extensions are not available, but it's early days:

- Installer MSI/vdproj projects. We'll be completely stuffed if they don't 
bring that one up.
- Sandcastle doc (hang on ... as I type ... I installed the extension, but 
there is no project of the SHFB type ... confusing!).
- Tangible T4 free template colour coder (not critical, but really helpful).

Anyone else discovered anything starling about VS2022?

Greg K

RE: Online source code management tools - GIT / Visual Studio / Bit Bucket / Other ???

[Dr Greg Low]

I use VS daily, connected to Azure Repos as part of Azure DevOps. Works great. 
And for up to 5 users, you get all of Azure DevOps free.

You could use GitHub of course, but for most projects that I’m doing in VS, 
that’s just not needed, and AzDO is a better tool right now anyway. (IMHO)

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|About me: https://greglow.me

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of David Gardiner
Sent: Thursday, 10 June 2021 12:13 PM
To: ozDotNet 
Subject: Re: Online source code management tools - GIT / Visual Studio / Bit 
Bucket / Other ???

To be honest I don't really use the Git integration in Visual Studio.

I tend to use a combination of the git command line (with tab completion via 
posh-git), TortoiseGit for some things (like reviewing the commit log history 
and comparing branches), and more recently the GitLens extension for Visual 
Studio Code, which makes interactive rebasing a bit friendlier.

As far as remote Git repositories, Azure DevOps and GitHub both work well for 
me.

David

On Thu, 10 Jun 2021 at 11:32, Greg Harris 
mailto:harris.gre...@gmail.com>> wrote:

Hello Again Community,

I am disappointed with my 
https://MyAccountName.visualstudio.com/_git/MySolutionName<https://myaccountname.visualstudio.com/_git/MySolutionName>
 repository on VisualStudio.com.

It is feeling clunky and just not working for me from within Visual Studio.

What tools are people using for secure private cloud source control with what 
client tools?

I am feeling that Visual Studio is not the tool to use to manage my source 
code, it may be okay as an editor / compiler, but it just does not integrate 
well with the repository, are there better solutions, or am I just failing to 
read the manual properly?

Thanks for your help on this :-)

Groggy Harris

Re: Automated tests

[Dr Greg Low]

It's the main one I see used at different sites.

Regards

Greg

Get Outlook for iOS

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of harris.greg.m 
Sent: Friday, June 4, 2021 8:48:55 PM
To: ozDotNet 
Subject: RE: Automated tests

I did some selenium work a 6/7 years ago and it was a pain only supporting 
selective versions of firefox, just did some work with it again for web 
scraping and it just feels a lot more complete and working well with chrome



Sent on the go with Vodafone


 Original message 
From: djones147 
Date: 4/6/21 20:14 (GMT+10:00)
To: ozDotNet 
Subject: RE: Automated tests

Hey

The last time I did web testing ws using mstest v2 and selenium Web drivers. 
All from a separate test project to the unit tests. Example below.

https://www.lambdatest.com/blog/most-complete-mstest-framework-tutorial-using-net-core-2/


Hth

D.

Sent from my Galaxy


 Original message 
From: Tom Rutter 
Date: 04/06/2021 06:43 (GMT+01:00)
To: ozDotNet 
Subject: Automated tests

Hi folks,

It's been several years since I looked at automated tests for web apps. Is 
Selenium still the go to tool? I dabbled with it years ago but never really 
gave it a good hit. Are there any automation testers here that care to share 
their tools and thoughts?

-- Tom

RE: [OT] Credit check for new contract

[Dr Greg Low]

Best option? Try to get yourself to a point where you don’t need people like 
recruiters. Build a situation where customers find you instead.

That’s easier or harder depending upon your age and how quickly you want to 
achieve that.

It also means that you get to determine the rates, not someone else.

The best day to start working on that was 10 years ago. The next best day is 
today.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|About me: https://greglow.me

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of mike smith
Sent: Wednesday, 2 June 2021 11:25 PM
To: ozDotNet 
Subject: Re: [OT] Credit check for new contract

And the same recruiters with those duplicate ads expect exclusivity from you.

Mike

On Wed, Jun 2, 2021, 21:19 Tony Wright 
mailto:tonyw...@gmail.com>> wrote:
I do start with the job boards. Seek and Linked in first. Most companies these 
days put their own ad up and then recruiters come along and put the same ad up 
with their name on it. Sometimes you see 4 or 5 ads for the same job. Quite 
annoying. And the majority of recruiter jobs otherwise probably don't exist. 
But occasionally you find a recruiter that does find you real work and they're 
the ones you give your time to if you can't find work yourself. Some of them 
are real slime balls though.

On Wed, 2 Jun 2021, 9:40 pm Tom P, 
mailto:tompbi...@gmail.com>> wrote:
If not recruiters, where do you start looking for work? Personally I’ve found 
it very difficult to find work but obviously many factors are involved.

Cheers
Tom


On Wed, 2 Jun 2021 at 21:25, Tony Wright 
mailto:tonyw...@gmail.com>> wrote:
Yea I get that. That's why I said it depends who's at the other end. Tbh I'm 
pretty sick of recruiters. They are a dime a dozen. I think at one stage about 
20% of my linked list was recruiters. My thinking was that I might need them 
one day. But I have culled them significantly, down to a few remaining agents 
that I believe add value. I don't often start with recruiters when I'm looking 
for work, they take too much of a cut for adding very little value.

On Wed, 2 Jun 2021, 9:17 pm DotNet Dude, 
mailto:adotnetd...@gmail.com>> wrote:
Hey Tony,

Tom’s original question was about the recruiter asking for this info which is 
quite different from the bank you’re working for. Financial institutions do ask 
for the things you mention but I’d be suspicious and hesitant to pass info like 
that to a silly old recruiter.

I’ve never been comfortable with systems like WorkPro, particularly with credit 
files, which they let you just download as a PDF so the recruiter can easily 
forward. Not cool at all.

The whole recruitment model and the systems they use really needs a revamp to 
protect user privacy and security. I’m not convinced they are secure.


On Wed, 2 Jun 2021 at 20:33, Tony Wright 
mailto:tonyw...@gmail.com>> wrote:
Really? At the bank I have had sign over a right for them to receive every 
contact note for any shares I buy or sell. I also have to submit requests to 
buy or sell shares. That's an Apra requirement. I'm also not allowed to have 
directorships in more than one company, and it has to be an approved 
directorship. So it really does depend on who it is and what it means to you. A 
credit check to ensure that you aren't susceptible to bribery might be 
reasonable too depending on who it is. If it's some random numpty, sure, tell 
them to get stuffed, but some places really do need extra checks on their staff.

On Wed, 2 Jun 2021, 8:25 pm David Connors, 
mailto:da...@connors.com>> wrote:
Personally, I'd decline given the circumstances you've described. It would be 
like asking for this information from an employee and inappropriate if not 
probably illegal in the context of an FTE.

David Connors
da...@connors.com<mailto:da...@connors.com> | M +61 417 189 363
Telegram: https://t.me/davidconnors
LinkedIn: http://au.linkedin.com/in/davidjohnconnors


On Wed, 2 Jun 2021 at 19:20, Tom P 
mailto:tompbi...@gmail.com>> wrote:
Yes as an individual contractor so I did find it very odd. I’ve asked for a 
reason so let’s see what they come back with.

Cheers
Tom

On Wed, 2 Jun 2021 at 19:06, David Connors 
mailto:da...@connors.com>> wrote:
If you're doing this as an individual contractor on a work for hire / hourly 
basis then this is pretty strange.

Even as a company, we almost always decline disclosure of financial information 
on the basis that we're privately held and send whoever is asking a letter of 
solvency from our tax accountants instead (they just want to know we're not 
going to go bust - but that's a very strange consideration if you're an 
individual contractor).

David Connors
da...@connors.com<mailto:da...@connors.com> | M +61 417 189 363
Telegram: https://t.me/davidconnors
LinkedIn: http://au.linkedin.com/in/davidjohnconnor

RE: Sign-in with social accounts

[Dr Greg Low]

And before you start paying for alternatives, please check out Azure B2C as I 
mentioned and see if it will do what you need. I’m constantly fascinated by 
projects where I see people buying tools that they already have a usable tool.

For each Azure AD user (and I presume you already have some), you can use quite 
a lot of B2C users without additional cost.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|https://greglow.me

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Nick Randolph
Sent: Monday, 26 April 2021 11:33 AM
To: ozDotNet 
Subject: RE: Sign-in with social accounts

Hi Greg,

I’m interested to understand why you think that “geared towards APIs” is a bad 
thing. I understand that the first thing developers typically want to do is 
authenticate users so that they can open the front door and get in the app. 
However, this is meaningless if you don’t then use the issued token when 
connecting to the backend APIs. This is the reason that AuthO focusses on the 
API side of things – they’re attempting to ensure developers build their 
authentication in a way that the issued token can just be presented as part of 
calls to the backend API.

Hope this makes sense?

Nick Randolph | Built to Roam Pty Ltd | Co-Founder, Technical Director | +61 
412 413 425 | 1300 613 140 | 
www.builttoroam.com<https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.builttoroam.com%2F=04%7C01%7Caleader%40microsoft.com%7Ce982eb8653db4ed808cd08d8bb5c83fd%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637465353324748425%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000=5zqg1UrX2OMBH0rP%2BSrOQYlPe6d2Vcbm91%2Fnup6kZuQ%3D=0>
The information contained in this email is confidential. If you are not the 
intended recipient, you may not disclose or use the information in this email 
in any way. Built to Roam Pty Ltd does not guarantee the integrity of any 
emails or attached files. The views or opinions expressed are the author's own 
and may not reflect the views or opinions of Built to Roam Pty Ltd.

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Greg Keogh
Sent: Monday, 26 April 2021 11:29 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: Re: Sign-in with social accounts

Thanks everyone, I'll go off and do the research now. If I make any startling 
discoveries in coming weeks I'll report back in case it helps others attempting 
SSO.

GK

P.S. I did try Auth0 about 4 years ago, but it was so over-featured and geared 
towards "APIs" that I couldn't identify the possibly useful bits of it. And the 
documentation was so full of jargon and assumptions that it would have quicker 
to learn advanced homological algebra.

RE: Sign-in with social accounts

[Dr Greg Low]

Hi Greg,

I’d suggest, for a start, taking a detailed look at Azure AD B2C.

Presuming you already have Azure AD for some other purpose, this might be just 
what you need. Most of these modern auth providers make it easy to use a 
variety of alternate login methods.

Check out some videos on it, but there are also plenty of samples e.g. 
https://github.com/azure-ad-b2c/samples

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: https://sqldownunder.com<https://sqldownunder.com/> 
|https://greglow.me

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Greg Keogh
Sent: Monday, 26 April 2021 8:59 AM
To: ozDotNet 
Subject: Sign-in with social accounts

Folks, we have some old apps with their own simple credentials databases 
containing user, password, login count, permissions, etc. They're classic old 
fashioned systems.

Increasing numbers of apps let you sign-in with your Facebook, Google, 
Microsoft, etc account these days. This is really convenient, and the security 
burden is taken by someone else.

How can our apps participate in a social sign-in option? Has anyone done this? 
I imagine some terrible obstacles...

? Apps would have to be registered with the various various companies.
? The client apps might be WPF, Xamarin, Blazor or ASP.NET<http://ASP.NET>, so 
how would they hook into the sign-in process.
? Each company might return different types of tokens or even follow different 
conventions.

Greg K

RE: Text Analytics

[Greg Low]

Yep, sounds like it.

To give you an example of what I’ve done in the past:


  *   Azure Function set up on a timer every 15 minutes
  *   Function scrapes any tweets related (via a bunch of logic) to our 
client’s organisation and/or any of its primary competitors
  *   For each tweet, first I make a call for language detection. I only keep 
English language ones. (I found one there is a Brazilian supermarket with the 
same name as one of our clients so I need to exclude all the Portuguese 
discussion, etc.)
  *   I also request keyword analysis, and sentiment analysis
  *   I stick all of this in a DB
  *   Analytics is built above that.

Has proved very useful. For example, CEO can now see word clouds of what’s 
being discussed (not just Twitter but including it). Not long back, he was 
about to walk into a press conference where he was talking about their “green” 
investment strategies, and until he saw it in the dashboard, he was unaware he 
was about to be challenged about some of their specific investments.  Very 
happy to have been forewarned.

Similar deal with another client. We now are able to perform really interesting 
monitoring of call centre staff, by adding transcription into the mix. For 
example, in investment areas, they are not allowed to say things like “I 
recommend…”. Now we know if they do, and if so, what on earth did they say 
next? There are a whole bunch of things they aren’t allowed to say. There are 
also things they should say. We check for those as well. Which staff do the 
best job of removing the heat out of calls as they progress, etc.?

The irony in this sort of thing is that if you’d asked the company board 
members (and even the IT management) about whether AI could apply to them, 
they’d have told you no. It’s all a matter of being able to imagine what’s 
possible.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Greg Keogh
Sent: Tuesday, 9 February 2021 1:50 PM
To: ozDotNet 
Subject: Re: Text Analytics

I’ve always included it in the REST based call. I’ve not seen any option for 
giving it a URI from which to retrieve the text.
I’ve been feeding in tweets, and transcriptions of phone calls but haven’t run 
into size limits. We’ve been doing keyword analysis, sentiment, language 
detection, etc.
I’m not sure that feeding in large volumes of text would be all that useful. 
For example, even when doing call transcriptions, I’m looking at sentiment at 
different parts of a call.
Key phrases retrieved from gigabytes of text wouldn’t seem that useful to me.

Hi GL, from what you say, maybe I misunderstand how it's supposed to be used?! 
Or is it the wrong tool?

My colleague has megabytes of collected tweets on subjects like US politics and 
Covid and is looking for trends in sentiment and frequency of keywords like 
'Trump" "impeach" "vaccination" etc. He is generating attractive charts of this 
sort of thing, but by a rather tedious process at the moment and I was hoping 
the Azure Text Analytics could make his task a breeze.

I was going to run an experiment by feeding in the whole text of The War of The 
Worlds<https://www.gutenberg.org/files/36/36-0.txt> and looking for key phrases 
and major names. That's when I realised it didn't accept input the way I 
expected. or it doesn't work the way I expect.

Hmmm... Greg K

RE: Text Analytics

[Greg Low]

Sorry, should have said API call, not really REST-based call.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Greg Low
Sent: Tuesday, 9 February 2021 1:35 PM
To: ozDotNet 
Subject: RE: Text Analytics

Hey Greg,

I’ve always included it in the REST based call. I’ve not seen any option for 
giving it a URI from which to retrieve the text.

I’ve been feeding in tweets, and transcriptions of phone calls but haven’t run 
into size limits. We’ve been doing keyword analysis, sentiment, language 
detection, etc.

I’m not sure that feeding in large volumes of text would be all that useful. 
For example, even when doing call transcriptions, I’m looking at sentiment at 
different parts of a call.

Key phrases retrieved from gigabytes of text wouldn’t seem that useful to me.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Greg Keogh
Sent: Tuesday, 9 February 2021 1:30 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: Text Analytics

(It's not Friday but) Has anyone used Azure Text Analytics?

A colleague is collecting tweets on special subjects and has about 18MB of text 
so far. I suggested using Text Analytics, so I created a free tier account and 
I'm in the Console to try it out and find "Key Phrases". However, the API only 
seems to accept the text to analyse as part of the POST request. This seems 
crazy, as some people may want to analyze gigwatts of text, and you can't POST 
that.

Can I point the analyser at a Blob or some other pre-uploaded data in the 
cloud? None of the samples of documentation I've skimmed over so far discusses 
alternative sources of input.

Thanks, Greg K

RE: Text Analytics

[Greg Low]

Hey Greg,

I’ve always included it in the REST based call. I’ve not seen any option for 
giving it a URI from which to retrieve the text.

I’ve been feeding in tweets, and transcriptions of phone calls but haven’t run 
into size limits. We’ve been doing keyword analysis, sentiment, language 
detection, etc.

I’m not sure that feeding in large volumes of text would be all that useful. 
For example, even when doing call transcriptions, I’m looking at sentiment at 
different parts of a call.

Key phrases retrieved from gigabytes of text wouldn’t seem that useful to me.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Greg Keogh
Sent: Tuesday, 9 February 2021 1:30 PM
To: ozDotNet 
Subject: Text Analytics

(It's not Friday but) Has anyone used Azure Text Analytics?

A colleague is collecting tweets on special subjects and has about 18MB of text 
so far. I suggested using Text Analytics, so I created a free tier account and 
I'm in the Console to try it out and find "Key Phrases". However, the API only 
seems to accept the text to analyse as part of the POST request. This seems 
crazy, as some people may want to analyze gigwatts of text, and you can't POST 
that.

Can I point the analyser at a Blob or some other pre-uploaded data in the 
cloud? None of the samples of documentation I've skimmed over so far discusses 
alternative sources of input.

Thanks, Greg K

RE: [OT] SQL Server indexes

[Greg Low]

Hi David,

Yes, the free one tells you how to work out what needs to be fixed, and how to 
use the system tools to do that.

The main course explains how it all works, and how to design them properly, and 
how to rationalise the ones that are there.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of David Burstin
Sent: Wednesday, 3 February 2021 10:23 AM
To: ozDotNet 
Subject: Re: [OT] SQL Server indexes

Thanks for this Greg. I have enrolled for the free course and am trying to get 
my boss to pay for the SQL Indexing for Developers course.

Really appreciate the free course to start with.

Cheers
David

On Wed, 3 Feb 2021 at 09:00, Tom P 
mailto:tompbi...@gmail.com>> wrote:
Thanks Greg I will check out the course.

Thanks
Tom

On Wed, 3 Feb 2021 at 08:56, Greg Low 
mailto:g...@sqldownunder.com>> wrote:
Hi Tom,

If you’re doing development, you owe it to yourself to get good at indexing.

There’s a bunch of content online.

If you want something more detailed and to really understand it (which 
obviously I’d recommend), we have a good course on indexing here: 
https://training.sqldownunder.com. And you’ll also find a free course (4 Steps) 
there on working out what needs tuning, and how to do basic work.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Tom P
Sent: Wednesday, 3 February 2021 7:52 AM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: [OT] SQL Server indexes

Hi folks

I'm currently working with some stored procedures which were slow but are now 
super fast after I created some missing indexes the execution plan in SSMS told 
me to create. I'm not too familiar with SQL Server concepts but was hoping 
someone could point me in the right direction: are indexes something I can 
create and then forget about or do they need to be maintained long after I am 
gone from this project?  Does a DBA need to be notified so they can look after 
them for example? I've read some things online but don't really understand most 
of it.

Thanks
Tom

Re: [OT] Power BI publishing

[Greg Low]

Hey Tony,

Basically, internal company consumers need a Pro license, or the company needs 
a Premium license.

There are A SKU licenses for SaaS apps but only for other people’s data, not 
your own company.

Regards

Greg

Get Outlook for iOS

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Tony Wright 
Sent: Wednesday, February 3, 2021 10:00:52 AM
To: ozDotNet 
Subject: [OT] Power BI publishing

Hi all,

Just wondering if anyone has had experience with publishing power bi reports 
for more general consumption within an organisation?

I'm trying to figure out if the recipients need to have power bi installed or 
not, whether it's any different in Azure, and what licences are needed.

Kind regards,
Tony

RE: [OT] SQL Server indexes

[Greg Low]

Hi Tom,

If you’re doing development, you owe it to yourself to get good at indexing.

There’s a bunch of content online.

If you want something more detailed and to really understand it (which 
obviously I’d recommend), we have a good course on indexing here: 
https://training.sqldownunder.com. And you’ll also find a free course (4 Steps) 
there on working out what needs tuning, and how to do basic work.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Tom P
Sent: Wednesday, 3 February 2021 7:52 AM
To: ozDotNet 
Subject: [OT] SQL Server indexes

Hi folks

I'm currently working with some stored procedures which were slow but are now 
super fast after I created some missing indexes the execution plan in SSMS told 
me to create. I'm not too familiar with SQL Server concepts but was hoping 
someone could point me in the right direction: are indexes something I can 
create and then forget about or do they need to be maintained long after I am 
gone from this project?  Does a DBA need to be notified so they can look after 
them for example? I've read some things online but don't really understand most 
of it.

Thanks
Tom

RE: [OT] Australian .NET or programming podcasts

[Greg Low]

Depends what you mean by “Mainly”. If it’s the majority, no. But we have about 
a 20% audience out of about 40,000.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Wallace Turner
Sent: Monday, 18 January 2021 6:30 PM
To: ozDotNet 
Subject: [OT] Australian .NET or programming podcasts

Does anyone know a podcaster who discusses tech that has an audience mainly in 
Australia?
Thx
Wal

Re: Blazor influence

[Greg Low]

Yes it’s a pity that the Azure options aren’t great for when you just need a 
small site or two. OK for 10 perhaps but not everyone needs 10.

Get Outlook for iOS

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Stephen Price 
Sent: Friday, November 27, 2020 12:07:21 PM
To: ozDotNet 
Subject: Re: Blazor influence

Hey Greg,

It's definitely a refreshing change indeed!

I took the week off (some training leave as well) to watch as much of the 
DotnetConf event and it was very well organised and presented. Great content. 
Dotnet is going in a single direction again, and Blazor is good.
We're not "there" yet but some excellent movement in a great unified direction.

I've been following along with Carl Franklin's https://blazortrain.com/ which I 
think he's presented very well.  I'm loving how easy its been getting a Blazor 
(server side) app up and running. Very familiar and things are working well. I 
totally agree with your comments on Blazor.
I've got mine deploying on a Linux vm on Vultr in a docker container. $120 a 
year (my personal projects have found Azure too expensive, even if you migrate 
over to Linux based... unfortunately).

I'm happy!

cheers
Stephen


From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Greg Keogh 
Sent: Friday, 27 November 2020 8:24 AM
To: ozDotNet 
Subject: Blazor influence

Folks, just a comment for the old VB sucks Friday discussions.

Earlier in the year I expressed my admiration for Blazor Webassembly and my 
hope that it will put JS frameworks back where they belong in history books 
under the category of "Great IT follies of the 21st century".

Now I've written some large Blazor Wasm apps, I believe I will never write any 
other kind of web app again. Not only would I never consider a JS framework, I 
will never consider any kind of ASP.NET server-side app either 
... they're dead to me. (MVC web services and all their plumbing are dead to me 
too as I'd rather use Azure Functions)

No more of that clumsy request-response pipeline to deal with (which is as dumb 
as a CB radio). No more dealing with statelessness. No more fudging to mix 
JavaScript with server rendered markup to attempt a responsive UI. No more 
configuration files and controllers and all their cryptic secret conventions.

Using familiar tools like Visual Studio, Razor and C# I can write a Blazor app 
10 times faster than an equivalent MVC app with about one tenth the amount of 
code, and the UI is snappy and it's a cinch to deploy.

I hope others are as happy as me.

Greg K

P.S. Maybe there are reasons that ASP.NET server-side web apps 
would continue to be created, but someone else will have to think of them.

RE: [OT] SQL Server job failures when "printing" too much?

[Greg Low]

Hey Tom,

That just sounds like the PRINT statement is messing up the size of the string. 
Two thoughts without seeing it:


  *   LEFT on the thing being printed
  *   Try the option on the Advanced tab for the job (or job step – can’t 
remember which) that lets you put the whole message in, not just the short form 
of the message.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Tom P
Sent: Friday, 27 November 2020 12:05 PM
To: ozDotNet 
Subject: [OT] SQL Server job failures when "printing" too much?

Hi folks - Greg Low in particular :-)

I have a SQL Server agent job that is failing with error "String data, right 
truncation [SQLSTATE 01004]". It seems the reason for this is the stored 
procedure the job calls has a bunch of PRINT statements which I understand find 
their way through to the job history output window in SSMS. If I remove the 
PRINT statements the error goes away. Google hasn't helped me much, any SQL 
Server pros here that have any ideas how to address this?

Thanks
Tom

Re: Blazor influence

[Greg Low]

Super talented guy. Last time I saw him was at a fellow RD's place in San Diego 
and we were sitting outside on a warm summer evening, and Carl started playing 
and singing. Wonderful evening.

Only topped by another evening where after he played in a bar near Fenway Park 
in Boston, Michelle Leroux Bustamante did a rendition of Smelly Cat (like 
Phoebe from Friends). Staggeringly funny.

Regards

Greg

Get Outlook for iOS

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Greg Keogh 
Sent: Friday, November 27, 2020 12:14:22 PM
To: ozDotNet 
Subject: Re: Blazor influence

I've been following along with Carl Franklin's https://blazortrain.com/ which I 
think he's presented very well.

Ah yes, I haven't seen him for ages. He's good.

I was worried when he said "I've been writing software since 1985, which makes 
me OLD". I wrote my first student FORTRAN in high school in 1974, but my first 
"production" code in a business was in 1980! -- GK

RE: [OT] Sql Server job owner

[Greg Low]

Well at least the scripting works right 


Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Tom P
Sent: Thursday, 1 October 2020 1:34 PM
To: ozDotNet 
Subject: Re: [OT] Sql Server job owner

Hey Greg

The job properties in SSMS show the same thing, a tilde.

Cheers
Tom


On Thu, 1 Oct 2020 at 13:19, Greg Low 
mailto:g...@sqldownunder.com>> wrote:
Never seen that one before. If you look at the job owner in SSMS, what does it 
say there? Perhaps it’s someone that doesn’t exist.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Tom P
Sent: Thursday, 1 October 2020 12:22 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: [OT] Sql Server job owner

Hi all

I have scirpted out a Sql Server job and the owner parameter is specified as 
'~' (a tilde character). Does anyone here know what the tilde means?

@owner_login_name=N'~'

My googling skills have let me down.

Cheers
Tom

RE: [OT] Sql Server job owner

[Greg Low]

Never seen that one before. If you look at the job owner in SSMS, what does it 
say there? Perhaps it’s someone that doesn’t exist.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Tom P
Sent: Thursday, 1 October 2020 12:22 PM
To: ozDotNet 
Subject: [OT] Sql Server job owner

Hi all

I have scirpted out a Sql Server job and the owner parameter is specified as 
'~' (a tilde character). Does anyone here know what the tilde means?

@owner_login_name=N'~'

My googling skills have let me down.

Cheers
Tom

RE: Dotfuscating

[Greg Low]

My guess is that for $15700 upfront payment, you’d get a pretty reasonable 
obfuscator written for you at present.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com  On Behalf 
Of Greg Keogh
Sent: Thursday, 1 October 2020 7:54 AM
To: ozDotNet 
Subject: Re: Dotfuscating

Folk, FYI - I finally got a quote from the people who make Dotfuscator Pro, 
after 3 days of inefficient emails back-and-forth between different people. I 
suggested that they put a quote generator on their website to save time.

A "starter" licence for 2 people and 2 apps on 1 build machine is ... (wait for 
it) ... AU$5700 / year. For AU$15700 upfront payment you get a full 3 year 
licence discount.

I actually laughed aloud when I read the quote. And this is the "starter" 
level. I replied and said "Are you kidding? We've purchased huge cross-platform 
suites of components and libraries that are much less than that". And finally, 
in indignation I said "For that much money I could write my own MSBuild Task to 
analyse the call graph and write obfuscated IL". I doubt if it will come to 
that though, as our first release is still months away and I should be able to 
find an alternative by then (fingers crossed!).

I accept that the Pro version has lots of fancy features that are of no 
interest to us (we just want IL scrambling), but this is the most expensive 
product I've ever seen that just has one primary purpose.

Greg K

Re: [OT] What Facebook knows

[Greg Low]

Hi Greg,

 

They seem to apply pretty basic algorithms though. If they have access to your 
contacts on your phone, they can quickly work out who else is on FB. And then 
it gets easy. If you know two people, and they both know another 10, chances 
are high you’ll know some of that 10, and so on, and so on.

 

And it’s sure not just FB. I’ve lost count of the number of OAuth-based apps, 
that want to read your contacts, without giving you any valid reason for doing 
so. You either say yes, or you can’t use the OAuth option to connect. 

 

Regards,

 

Greg

 

On Thu, 23 Jan 2020 at 14:33, Greg Keogh mailto:gfke...@gmail.com> > wrote:

Folks, most of us probably know what I'm about to say, but when you see it 
live, it's really frightening.

 

My wife had to join Facebook for the first time ever to follow her nephew who 
is a firefighter in the ongoing disaster. She joined okay without being asked 
for a phone number. The next day she tried to get in via the Apple App and it 
demanded a mobile number. It was an absolute block until a number was entered, 
so she was compelled to. Now it gets scary...

 

She immediately was offered hundreds of friends that included my friends, 
musicians I have played with, her old work mates in jobs going back 40 years, 
extended family adult and children friends of both sides of our family, old 
workmates of mine going back to the 1980s, etc, and the list goes on to find 
obscure and tenuous links of every imaginable kind.

 

So … given that she has never been on FB before … where did all those 
associations come from? We know they have good algorithms of course, but it 
means that FB could be used to perform a comprehensive and reliable analysis of 
the complete life of someone who isn't even a member. Imagine if the police, or 
criminals, or an oppressive government simply asked FB "what do you know about 
person X?" Even if X isn't a member, they could compile a fantastically 
detailed dossier.

 

How much information does FB hold? Who are they sharing it with? It's worse 
than we think.

 

Greg K

Re: [OT] Fines Victoria crisis deepens

[Greg Low]

ViC basically built their own. NSW also built their own, then trashed it and 
bought Opal. QLD also built their own (GoCard). It's all stunning waste in 
unnecessary redesign.

These were already well known technologies.

Friend of mine was driving buses in Brisbane. He said when they first deployed 
GoCard, they couldn't get things like sensitivities right. He'd drive past a 
bus stop and it would charge everyone standing there.

We did not need to learn all this again.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com on behalf of DotNet Dude 

Sent: Thursday, October 24, 2019 10:53 am
To: ozDotNet
Subject: Re: [OT] Fines Victoria crisis deepens

Myki is another product bought from overseas I heard. From one of the 
Scandinavian countries I think. Managed by NTTData from memory, could be wrong, 
don’t quote me.

On Thu, 24 Oct 2019 at 10:42, David Connors 
mailto:da...@connors.com>> wrote:
Myki in Vic should get a notable mention... ticketing system for trams  and 
trains that was the same price as building sending a couple of Opportunity 
Rovers to Mars.


David Connors
da...@connors.com<mailto:da...@connors.com> | M +61 417 189 363
Telegram: https://t.me/davidconnors
LinkedIn: http://au.linkedin.com/in/davidjohnconnors



On Wed, 23 Oct 2019 at 19:50, Grant Maw 
mailto:grant@gmail.com>> wrote:
It's not just Victoria. The QLD government IT projects 9ver recent years have 
also been rolled gold catastrophes

On Wed, 23 Oct. 2019, 11:24 am Greg Keogh, 
mailto:gfke...@gmail.com>> wrote:
Interesting front page article in The Age newspaper 
today<https://www.theage.com.au/politics/victoria/fines-victoria-system-collapses-leaving-massive-hole-in-state-budget-20191022-p5333d.html>
 about a Victorian government IT disaster. IT disasters are routine (I'm sure 
we've all caused a few!) but it's interesting that they actually name the 
software as VIEW from a company called Civica. The article is a bit vague about 
what's actually wrong, it just says "[it] doesn't work", "the system was 
absolute chaos" and systems are not "talking to" their computers. Does anyone 
have inside gossip about what really happened?

There was another vast IT disaster a few years ago related to the education 
system I think, where dodgy contracts were being awarded to mates, and I think 
the loss ran into the hundreds of millions. That story vanished from the news 
and I never found out what happened.

Greg K

Re: [OT] Fines Victoria crisis deepens

[Greg Low]

Yep MyKi chewed up $2.6B locally, and yep we note that NASA put Curiosity on 
Mars for $2B, but worth also noting was that within that budget, NASA invented 
and deployed the Sky Crane.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com on behalf of David Connors 

Sent: Thursday, October 24, 2019 11:02 am
To: ozDotNet
Subject: Re: [OT] Fines Victoria crisis deepens

Dunno how you spend 1.5 bln on an 'off the shelf' solution.

Speaking of IT stuff ups, they just installed NBN in our building in Spring 
Hill (CBD Brisbane) last week.

The fibre comes into the building probably 5-6 metres max from the pit. They 
pulled the fibre into the MDF which is at the front of the building. Then they 
ran the fibre all the way to the back of the building to put the DSLAM in a 
store room that is the maximum possible distance from where all of the copper 
in the building terminates. Then they ran a bunch of pairs of copper from the 
back store room to the front of the building to the MDF so you can jumper FTTB 
off that and into the MDF frame. The tray they used to run the copper from the 
back of the building to the front has MASSIVE three phase cables in it that 
power 6 A/C units. The copper runs exactly parallel to this for almost entire 
length of its run. Should be nice for drop outs when the various compressors 
kick in / turn off.

There were two guys here for three days doing the job. The FTTB DSLAM is about 
the size of a fridge. There are only 8 tenancies in the building.

Everyone in the building already has fibre except for us as we use microwave 
that's faster than anything NBN sell anyway - so they should get zero 
subscribers.

Your tax dollars hard at work.

David Connors
da...@connors.com<mailto:da...@connors.com> | M +61 417 189 363
Telegram: https://t.me/davidconnors
LinkedIn: http://au.linkedin.com/in/davidjohnconnors



On Thu, 24 Oct 2019 at 09:53, DotNet Dude 
mailto:adotnetd...@gmail.com>> wrote:
Myki is another product bought from overseas I heard. From one of the 
Scandinavian countries I think. Managed by NTTData from memory, could be wrong, 
don’t quote me.

On Thu, 24 Oct 2019 at 10:42, David Connors 
mailto:da...@connors.com>> wrote:
Myki in Vic should get a notable mention... ticketing system for trams  and 
trains that was the same price as building sending a couple of Opportunity 
Rovers to Mars.


David Connors
da...@connors.com<mailto:da...@connors.com> | M +61 417 189 363
Telegram: https://t.me/davidconnors
LinkedIn: http://au.linkedin.com/in/davidjohnconnors



On Wed, 23 Oct 2019 at 19:50, Grant Maw 
mailto:grant@gmail.com>> wrote:
It's not just Victoria. The QLD government IT projects 9ver recent years have 
also been rolled gold catastrophes

On Wed, 23 Oct. 2019, 11:24 am Greg Keogh, 
mailto:gfke...@gmail.com>> wrote:
Interesting front page article in The Age newspaper 
today<https://www.theage.com.au/politics/victoria/fines-victoria-system-collapses-leaving-massive-hole-in-state-budget-20191022-p5333d.html>
 about a Victorian government IT disaster. IT disasters are routine (I'm sure 
we've all caused a few!) but it's interesting that they actually name the 
software as VIEW from a company called Civica. The article is a bit vague about 
what's actually wrong, it just says "[it] doesn't work", "the system was 
absolute chaos" and systems are not "talking to" their computers. Does anyone 
have inside gossip about what really happened?

There was another vast IT disaster a few years ago related to the education 
system I think, where dodgy contracts were being awarded to mates, and I think 
the loss ran into the hundreds of millions. That story vanished from the news 
and I never found out what happened.

Greg K

Re: [OT] Contracting advice for payroll

[Greg Low]

But you claim the 30% back as franking credits, so no issue.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com on behalf of DotNet Dude 

Sent: Sunday, June 23, 2019 1:24 pm
To: ozDotNet
Subject: Re: [OT] Contracting advice for payroll

Companies also pay 30% tax so keep that in mind. Set up costs are around 
$2500+gst if I recall correctly and you get an ABN and ACN.

Several agents in Melbourne only deal with companies from our experience.

Sole traders don’t have to pay super which can be a good or bad thing.

On Sun, 23 Jun 2019 at 13:13, Greg Low 
mailto:g...@greglow.com>> wrote:
I’ve always had a company and have to say I can’t imagine not doing so, but 
YMMV.

I think it’s the most flexible by far.

Mind you, I don’t look for long term gigs, otherwise the 80% rule, etc. around 
personal services starts to be an issue. As soon as you want other employees, 
etc, I would only use a company.

10M for both prof and prod liability isn’t too expensive. So many of our 
customers want it so it’s a no brainer. Someone recommended BizCover a long 
time back, we’ve used them, and they’ve been ok to deal with so far. Gets 
cheaper the longer you have it without any claims.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> on 
behalf of Stephen Price 
mailto:step...@lythixdesigns.com>>
Sent: Sunday, June 23, 2019 12:32 pm
To: ozDotNet
Subject: Re: [OT] Contracting advice for payroll

I might also add, that the easiest option is to just go with the PAYG option. 
You pay tax as you go, so don't have to pay the ATO at some later date (and 
realise you didn't keep any aside...) and there is also GST you would have to 
collect and submit either annually or quarterly (but if the amount is under a 
certain amount per year then you don't have to collect GST)... forget what that 
amount is currently. I'm registered currently (for side gigs) but the amount is 
less than their threshold... if its under, its up to you if you do collect it 
or not but if its over it, then you have to.
Its less to think about if you go PAYG with your first contract.
Oh, as a sole trader you get an ABN (also as a company) which is the main 
requirement. I think if you go the PAYG route then all of the tax stuff is done 
as yourself using your tax file number. Get a good accountant, it's worth it. 
Might spend extra money on the accountant, but they know the stuff you can 
claim etc and you end up saving way more in taxes, plus they keep up to date on 
the regular rule changes... crazy not to, unless you like giving your money 
away. if so, I'll send you my bank account details... hehe

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> on behalf 
of Tom P mailto:tompbi...@gmail.com>>
Sent: Sunday, 23 June 2019 8:28 AM
To: ozDotNet
Subject: [OT] Contracting advice for payroll

Hi folks

This is the first time I will be in a contracting role. I've done some digging 
around payroll options but wanted to check with any contractors here about 
their experiences and recommendations.

There seems to be three options: (1) PAYG where the recruitment agent does it 
all, (2) set up my own company, or (3) use a management company.

Any advice from the contracting pros?

Thanks
Tom

Re: [OT] Contracting advice for payroll

[Greg Low]

I’ve always had a company and have to say I can’t imagine not doing so, but 
YMMV.

I think it’s the most flexible by far.

Mind you, I don’t look for long term gigs, otherwise the 80% rule, etc. around 
personal services starts to be an issue. As soon as you want other employees, 
etc, I would only use a company.

10M for both prof and prod liability isn’t too expensive. So many of our 
customers want it so it’s a no brainer. Someone recommended BizCover a long 
time back, we’ve used them, and they’ve been ok to deal with so far. Gets 
cheaper the longer you have it without any claims.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com on behalf of Stephen Price 

Sent: Sunday, June 23, 2019 12:32 pm
To: ozDotNet
Subject: Re: [OT] Contracting advice for payroll

I might also add, that the easiest option is to just go with the PAYG option. 
You pay tax as you go, so don't have to pay the ATO at some later date (and 
realise you didn't keep any aside...) and there is also GST you would have to 
collect and submit either annually or quarterly (but if the amount is under a 
certain amount per year then you don't have to collect GST)... forget what that 
amount is currently. I'm registered currently (for side gigs) but the amount is 
less than their threshold... if its under, its up to you if you do collect it 
or not but if its over it, then you have to.
Its less to think about if you go PAYG with your first contract.
Oh, as a sole trader you get an ABN (also as a company) which is the main 
requirement. I think if you go the PAYG route then all of the tax stuff is done 
as yourself using your tax file number. Get a good accountant, it's worth it. 
Might spend extra money on the accountant, but they know the stuff you can 
claim etc and you end up saving way more in taxes, plus they keep up to date on 
the regular rule changes... crazy not to, unless you like giving your money 
away. if so, I'll send you my bank account details... hehe

From: ozdotnet-boun...@ozdotnet.com  on behalf 
of Tom P 
Sent: Sunday, 23 June 2019 8:28 AM
To: ozDotNet
Subject: [OT] Contracting advice for payroll

Hi folks

This is the first time I will be in a contracting role. I've done some digging 
around payroll options but wanted to check with any contractors here about 
their experiences and recommendations.

There seems to be three options: (1) PAYG where the recruitment agent does it 
all, (2) set up my own company, or (3) use a management company.

Any advice from the contracting pros?

Thanks
Tom

Re: [OT] New job

[Greg Low]

Further north is even more awesomeness. Sapphire Beach (just north of Coffs) 
has fibre to the premises as well as awesome beaches, nearby rainforests, 
mountains, etc.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com on behalf of DotNet Dude 

Sent: Thursday, May 9, 2019 6:09 am
To: ozDotNet
Subject: Re: [OT] New job

Here we go again with someone from Newcastle bragging how awesome Newcastle 
is... Yes, we know it’s awesome. Stop rubbing it in.

On Wed, 8 May 2019 at 19:21, Steven Parish 
mailto:ste...@businesscraft.com.au>> wrote:
Hi Tom,

Any chance you're interested in moving to Newcastle? Its a great place to live 
- great surf beaches, close to the vineyards :)

Kind Regards,

Steven Parish
Managing Director

BusinessCraft Pty Ltd | 
www.businesscraft.com.au<http://www.businesscraft.com.au/> | M: 0417 688 599| 
T:02 4965  | Level 1, 418-422 Hunter Street, Newcastle, 
NSW<https://maps.google.com/?q=418-422+Hunter+Street,+Newcastle,+NSW=gmail=g>
 2300


On Wed, 8 May 2019 at 14:29, Tom P 
mailto:tompbi...@gmail.com>> wrote:
Hi folks

Anyone’s Melbourne based workplace looking for a .NET developer?

Cheers
Tom
--
Thanks
Tom

Re: [OT] Sql Server writes causing contention

[Greg Low]

Will be home in a few hours and will try it.

Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com


From: ozdotnet-boun...@ozdotnet.com on behalf of Tom P 
Sent: Monday, March 25, 2019 2:48 pm
To: ozDotNet
Subject: Re: [OT] Sql Server writes causing contention

Thanks, but tried that and still the same

Cheers

On Mon, 25 Mar 2019 at 13:37, Greg Low 
mailto:g...@greglow.com>> wrote:
Am traveling so can’t test but try removing the TEXTIMAGE ON clause

Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com>


From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> on 
behalf of Tom P mailto:tompbi...@gmail.com>>
Sent: Monday, March 25, 2019 1:04 pm
To: ozDotNet
Subject: Re: [OT] Sql Server writes causing contention

I only changed the data type from text to varchar(max) in the table and removed 
the FILLFACTOR 90. I then selected all the rows from the old table and inserted 
into the new one.

CREATE TABLE [dbo].[Log_New](
[LogID] [bigint] IDENTITY(1,1) NOT NULL,
[DateTime] [datetime] NOT NULL,
[Type] [varchar](30) NOT NULL,
[Message] [varchar](max) NULL,
 CONSTRAINT [PK_Log_New] PRIMARY KEY CLUSTERED
(
[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Log_New] ADD CONSTRAINT [DF_Log_New_DateTime] DEFAULT 
(getdate()) FOR [DateTime]
GO

Cheers

On Mon, 25 Mar 2019 at 12:49, Greg Low 
mailto:g...@greglow.com>> wrote:
The number of rows is unrelated. Can you show the script you used? In 
particular, how you recreated the table. I presume you didn’t have the LOB 
options in that? If you just create the table with the new data types and don’t 
specify anything else, it defaults to in-row storage.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> on 
behalf of Tom P mailto:tompbi...@gmail.com>>
Sent: Monday, March 25, 2019 10:47 am
To: ozDotNet
Subject: Re: [OT] Sql Server writes causing contention

Hi Greg

I have done as you suggested below but it seems the new table also has LOB_DATA 
and not only in row data after moving all the data.

There are 5mil records which I suspect is the issue. Any thoughts?

Cheers


On Thu, 7 Mar 2019 at 14:10, mailto:g...@greglow.com>> wrote:
It’s easy to see. Try executing this:

USE tempdb;
GO

DROP TABLE IF EXISTS dbo.TomText;
GO
DROP TABLE IF EXISTS dbo.TomVarCharMax;
GO

CREATE TABLE dbo.TomText
(
TomTextID bigint identity(1,1) NOT NULL,
[Message] text NOT NULL
);
GO

CREATE TABLE dbo.TomVarCharMax
(
TomVarCharMaxID bigint identity(1,1) NOT NULL,
[Message] varchar(max) NOT NULL
);
GO

INSERT dbo.TomText ([Message])
SELECT TOP(1) [name]
FROM sys.all_columns;
GO

INSERT dbo.TomVarCharMax ([Message])
SELECT TOP(1) [name]
FROM sys.all_columns;
GO

SELECT OBJECT_NAME(object_id),
   alloc_unit_type_desc,
   page_count
FROM sys.dm_db_index_physical_stats
   (DB_ID(), NULL, NULL, NULL, 'DETAILED')
WHERE OBJECT_NAME(object_id) IN (N'TomText', N'TomVarCharMax');

It’ll return something like this:

[cid:169b2f5dcb54cff311]

Note the difference.

Also note that you can’t fix it by just changing the datatype. Rename the 
table, create a new one, and move the data over.

Another question: why 90 as a FILLFACTOR if you’re only writing to it in order?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Tom P
Sent: Thursday, 7 March 2019 1:20 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: Re: [OT] Sql Server writes causing contention

Very interesting about the storage of the text type. Do you have a Microsoft 
link by any chance which says this?

Create script:

CREATE TABLE [dbo].[Log](

Re: [OT] Sql Server writes causing contention

[Greg Low]

Am traveling so can’t test but try removing the TEXTIMAGE ON clause

Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com


From: ozdotnet-boun...@ozdotnet.com on behalf of Tom P 
Sent: Monday, March 25, 2019 1:04 pm
To: ozDotNet
Subject: Re: [OT] Sql Server writes causing contention

I only changed the data type from text to varchar(max) in the table and removed 
the FILLFACTOR 90. I then selected all the rows from the old table and inserted 
into the new one.

CREATE TABLE [dbo].[Log_New](
[LogID] [bigint] IDENTITY(1,1) NOT NULL,
[DateTime] [datetime] NOT NULL,
[Type] [varchar](30) NOT NULL,
[Message] [varchar](max) NULL,
 CONSTRAINT [PK_Log_New] PRIMARY KEY CLUSTERED
(
[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Log_New] ADD CONSTRAINT [DF_Log_New_DateTime] DEFAULT 
(getdate()) FOR [DateTime]
GO

Cheers

On Mon, 25 Mar 2019 at 12:49, Greg Low 
mailto:g...@greglow.com>> wrote:
The number of rows is unrelated. Can you show the script you used? In 
particular, how you recreated the table. I presume you didn’t have the LOB 
options in that? If you just create the table with the new data types and don’t 
specify anything else, it defaults to in-row storage.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> on 
behalf of Tom P mailto:tompbi...@gmail.com>>
Sent: Monday, March 25, 2019 10:47 am
To: ozDotNet
Subject: Re: [OT] Sql Server writes causing contention

Hi Greg

I have done as you suggested below but it seems the new table also has LOB_DATA 
and not only in row data after moving all the data.

There are 5mil records which I suspect is the issue. Any thoughts?

Cheers


On Thu, 7 Mar 2019 at 14:10, mailto:g...@greglow.com>> wrote:
It’s easy to see. Try executing this:

USE tempdb;
GO

DROP TABLE IF EXISTS dbo.TomText;
GO
DROP TABLE IF EXISTS dbo.TomVarCharMax;
GO

CREATE TABLE dbo.TomText
(
TomTextID bigint identity(1,1) NOT NULL,
[Message] text NOT NULL
);
GO

CREATE TABLE dbo.TomVarCharMax
(
TomVarCharMaxID bigint identity(1,1) NOT NULL,
[Message] varchar(max) NOT NULL
);
GO

INSERT dbo.TomText ([Message])
SELECT TOP(1) [name]
FROM sys.all_columns;
GO

INSERT dbo.TomVarCharMax ([Message])
SELECT TOP(1) [name]
FROM sys.all_columns;
GO

SELECT OBJECT_NAME(object_id),
   alloc_unit_type_desc,
   page_count
FROM sys.dm_db_index_physical_stats
   (DB_ID(), NULL, NULL, NULL, 'DETAILED')
WHERE OBJECT_NAME(object_id) IN (N'TomText', N'TomVarCharMax');

It’ll return something like this:

[cid:169b29461494cff311]

Note the difference.

Also note that you can’t fix it by just changing the datatype. Rename the 
table, create a new one, and move the data over.

Another question: why 90 as a FILLFACTOR if you’re only writing to it in order?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Tom P
Sent: Thursday, 7 March 2019 1:20 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: Re: [OT] Sql Server writes causing contention

Very interesting about the storage of the text type. Do you have a Microsoft 
link by any chance which says this?

Create script:

CREATE TABLE [dbo].[Log](
[LogID] [bigint] IDENTITY(1,1) NOT NULL,
[DateTime] [datetime] NOT NULL,
[Type] [varchar](30) NOT NULL,
[Message] [text] NULL,
 CONSTRAINT [PK_Log] PRIMARY KEY CLUSTERED
(
[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Log] ADD CONSTRAINT [DF_Log_DateTime] DEFAULT (getdate()) 
FOR [DateTime]
GO

Cheers
Tom

On Thu, 7 Mar 2019 at 11:58, mailto:g...@greglow.com>> wrote:
Might get

Re: [OT] Sql Server writes causing contention

[Greg Low]

The number of rows is unrelated. Can you show the script you used? In 
particular, how you recreated the table. I presume you didn’t have the LOB 
options in that? If you just create the table with the new data types and don’t 
specify anything else, it defaults to in-row storage.

Regards,

Greg

Dr Greg Low
SQL Down Under Pty Ltd
Mobile: +61419201410 Office: 1300775775


From: ozdotnet-boun...@ozdotnet.com on behalf of Tom P 
Sent: Monday, March 25, 2019 10:47 am
To: ozDotNet
Subject: Re: [OT] Sql Server writes causing contention

Hi Greg

I have done as you suggested below but it seems the new table also has LOB_DATA 
and not only in row data after moving all the data.

There are 5mil records which I suspect is the issue. Any thoughts?

Cheers


On Thu, 7 Mar 2019 at 14:10, mailto:g...@greglow.com>> wrote:
It’s easy to see. Try executing this:

USE tempdb;
GO

DROP TABLE IF EXISTS dbo.TomText;
GO
DROP TABLE IF EXISTS dbo.TomVarCharMax;
GO

CREATE TABLE dbo.TomText
(
TomTextID bigint identity(1,1) NOT NULL,
[Message] text NOT NULL
);
GO

CREATE TABLE dbo.TomVarCharMax
(
TomVarCharMaxID bigint identity(1,1) NOT NULL,
[Message] varchar(max) NOT NULL
);
GO

INSERT dbo.TomText ([Message])
SELECT TOP(1) [name]
FROM sys.all_columns;
GO

INSERT dbo.TomVarCharMax ([Message])
SELECT TOP(1) [name]
FROM sys.all_columns;
GO

SELECT OBJECT_NAME(object_id),
   alloc_unit_type_desc,
   page_count
FROM sys.dm_db_index_physical_stats
   (DB_ID(), NULL, NULL, NULL, 'DETAILED')
WHERE OBJECT_NAME(object_id) IN (N'TomText', N'TomVarCharMax');

It’ll return something like this:

[cid:169b1f501a6ad7999131]

Note the difference.

Also note that you can’t fix it by just changing the datatype. Rename the 
table, create a new one, and move the data over.

Another question: why 90 as a FILLFACTOR if you’re only writing to it in order?

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Tom P
Sent: Thursday, 7 March 2019 1:20 PM
To: ozDotNet mailto:ozdotnet@ozdotnet.com>>
Subject: Re: [OT] Sql Server writes causing contention

Very interesting about the storage of the text type. Do you have a Microsoft 
link by any chance which says this?

Create script:

CREATE TABLE [dbo].[Log](
[LogID] [bigint] IDENTITY(1,1) NOT NULL,
[DateTime] [datetime] NOT NULL,
[Type] [varchar](30) NOT NULL,
[Message] [text] NULL,
 CONSTRAINT [PK_Log] PRIMARY KEY CLUSTERED
(
[LogID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, 
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Log] ADD CONSTRAINT [DF_Log_DateTime] DEFAULT (getdate()) 
FOR [DateTime]
GO

Cheers
Tom

On Thu, 7 Mar 2019 at 11:58, mailto:g...@greglow.com>> wrote:
Might get you to post the actual table schema though, so we can check it. Just 
script the whole table, indexes, etc.

First comment is that you shouldn’t be using text at all. Apart from the fact 
that it was deprecated back in 2005, the data for that is (by default) stored 
out of row, not with the rest of the data. That’s never quick.

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: 
www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0>
 
|http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0>

From: ozdotnet-boun...@ozdotnet.com<mailto:ozdotnet-boun...@ozdotnet.com> 
mailto:ozdotnet-boun...@ozdotnet.com>> On Behalf 
Of Tom P
Sent: Thursday, 7 March 2019 11:53 AM
To: ozDotNet mailto:ozdotnet@ozd

Re: Blazor comments

[Greg Low]

I note with interest that they’re hiring people to migrate winforms to core.

Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com


From: ozdotnet-boun...@ozdotnet.com on behalf of David Rhys Jones 

Sent: Wednesday, January 30, 2019 5:59 pm
To: ozDotNet
Subject: Re: Blazor comments

Flash died because it was bug ridden and provided a huge amount of backdoors 
into pc's. Silverlight was only there to take flash's market share. When flash 
died so did silverlight it's mission accomplished. Microsoft's goal for many 
years is to be web based only. The keep trying to push developers towards web 
based architecture.

.02c



On Wed, 30 Jan 2019, 07:53 Arjang Assadi 
mailto:arjang.ass...@gmail.com> wrote:
until a rendering engine is included I can not see any benefit to using blazer 
or any other WASM equivalents. Flash as bad as it was , was a better solution , 
no idea what the big idea was to kill it off , or for that matter ms 
unilaterally killing silver light.


On Wed, 30 Jan 2019 at 5:26 pm Greg Keogh 
mailto:gfke...@gmail.com>> wrote:
Folks, has anyone else in here given Blazor a good bash and got comments? I've 
run some sanity tests on 0.7 and it's looking pretty good. You can reference 
packages and projects, there's basic binding (which I hope they improve), you 
can break things up into "components" and nest them, separate code-behind if 
you want, register and inject services, define routing, make async web calls, 
deploy to Azure web apps, etc. All this stuff I mentioned is in the docs, but I 
had to try it myself to see if it really works. The only thing I haven't tried 
yet is rendering a large complex page to see how it performs and responds to 
DOM changes.

So finally it looks like there's a real chance in the .NET ecosystem that the 
crazy zoo of JS frameworks to make SPAs will be displaced by a familiar and 
respected languages and frameworks. Great, but suddenly I was slapped hard by a 
shocking realisation … we're still stuck using the web browser and HTML (and 
some JS glue) for rendering the UI.

The web browser cannot render complex business app UIs. Where are the rich 
controls and layout features we are used to on the desktop, or in Silverlight, 
or Flash or Java Applets for that matter? HTML was created to render simple 
text and pictures and now 27 years later it's completely effing stupid that 
we're still trying to create apps with it. We're changing how those apps are 
written, but we're still stuck with the damn browser and HTML for rendering.

I have an example … a few weeks ago I wondered by a web page was taking 40s to 
load. It turned out I was loading a tree (a fake one, as there is no tree 
control) with 4000 nodes, each one in a div and 3880 of them were hidden. So 
the page looked small and tidy, but there were thousands of hidden divs. I 
spent hours of suffering inventing a click-demand-load technique. There is no 
virtualisation in HTML, which is taken for granted in real UI frameworks.

There endeth the good news and the bad news.

Greg K

RE: [Possibly OT] Job scheduler from Sql Server

[Greg Low]

It's trivial to do directly in SQL Server as well.



Just add a job that starts when Agent starts (there's an option for that),
and which sleeps for 1 minute (WAITFOR DELAY '00:00:01'; ) and checks,
sending an email if a row is present. Have it run forever ie: WHILE 1 = 1
blah blah



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* ozdotnet-boun...@ozdotnet.com  *On
Behalf Of *Tony Wright
*Sent:* Friday, 4 January 2019 12:47 PM
*To:* ozDotNet 
*Subject:* Re: [Possibly OT] Job scheduler from Sql Server



I've also used hangfire and it's a great product.



On Fri., 4 Jan. 2019, 8:20 am Tony McGee https://www.hangfire.io) to greatly
reduce that burden.



On Fri, 4 Jan 2019, 08:39 Tom P 

RE: Anyone out there?

[Greg Low]

And after all the drama we've had with the NBN, we finally had confirmation
that they were coming out last Thursday to upgrade the tap in our pit. (Had
3 separate people call to announce they were doing it). And of course,
no-one actually came 



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> *On
Behalf Of *Tony Wright
*Sent:* Thursday, 24 May 2018 12:06 PM
*To:* ozDotNet <ozdotnet@ozdotnet.com>
*Subject:* Re: Anyone out there?



Yep, it sure does suck (the NBN I mean)



On Thu., 24 May 2018, 11:51 am David Connors, <da...@connors.com> wrote:

Mention the nbn - that should increase the number of posts.





On Thu, 24 May 2018 at 11:45 Greg Harris <harris.gre...@gmail.com> wrote:

If you look at https://www.mail-archive.com/ozdotnet@ozdotnet.com/ you can
see a dump of activity...

Yes we do seem to have less activity these days.


*Greg Harris*

harris.gre...@gmail.com

phone: 0407 942 982


*Baulkham HillsNSW 2153*





On Wed, May 23, 2018 at 6:37 AM, kirsten greed <kirsten.gr...@gmail.com>
wrote:

Hello

I sent a post yesterday but nothing has come through on the list

KIrsten



-- 

David Connors
da...@connors.com | @davidconnors | https://t.me/davidconnors
| LinkedIn | +61 417 189 363

RE: Select while insert on another transaction gives unexpected results

[Greg Low]

And yep, wondering if it was an issue on some particular version. Which
build number?



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> *On
Behalf Of *Wallace Turner
*Sent:* Thursday, 15 March 2018 1:23 PM
*To:* ozDotNet <ozdotnet@ozdotnet.com>
*Subject:* Select while insert on another transaction gives unexpected
results



The crux of the problem:



1) you batch insert into a table using a transaction (say 1000 rows)

2) another query simultaneously reads from same table

3) sometimes the query returns partial results - e.g. instead of 1000 rows
being returned you get 600



My understanding was a query should return either all 1000 rows or none. I
am not using anything other than the default settings (no read uncommitted)





This question has already been asked:



https://dba.stackexchange.com/questions/75848/sql-server-select-while-insert-on-another-transaction-gives-unexpected-results



However I'm asking here to get some more feedback 







This kind of behaviour strikes at the core of my (apparent) understanding!



I've been able to recreate this easily on sql 2012 SP3 but not yet on 2014
or 2016.

RE: Select while insert on another transaction gives unexpected results

[Greg Low]

That does seem odd. I presume that RCSI isn't enabled?



Do you have a sample bit of code to repo?



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> *On
Behalf Of *Wallace Turner
*Sent:* Thursday, 15 March 2018 1:23 PM
*To:* ozDotNet <ozdotnet@ozdotnet.com>
*Subject:* Select while insert on another transaction gives unexpected
results



The crux of the problem:



1) you batch insert into a table using a transaction (say 1000 rows)

2) another query simultaneously reads from same table

3) sometimes the query returns partial results - e.g. instead of 1000 rows
being returned you get 600



My understanding was a query should return either all 1000 rows or none. I
am not using anything other than the default settings (no read uncommitted)





This question has already been asked:



https://dba.stackexchange.com/questions/75848/sql-server-select-while-insert-on-another-transaction-gives-unexpected-results



However I'm asking here to get some more feedback 







This kind of behaviour strikes at the core of my (apparent) understanding!



I've been able to recreate this easily on sql 2012 SP3 but not yet on 2014
or 2016.

Re: Log filter / display dashboard - Looking for recommendation [Slightly off topic]

[Greg Low]

Have you looked at Azure Log Analytics ?

Easy to ingest bunches of logs, good query language, basic dashboards, easy to 
integrate with things like Power BI, has a REST based interface, cheap, etc

Regards,

Greg

Dr Greg Low
1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax
SQL Down Under | Web: www.sqldownunder.com

From: ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> on behalf 
of Greg Harris <harris.gre...@gmail.com>
Sent: Tuesday, March 13, 2018 10:52:43 AM
To: ozDotNet
Subject: Log filter / display dashboard - Looking for recommendation [Slightly 
off topic]

Hi All,
Question: Can you recommend a standard dashboard app that takes multiple logs, 
filters out the 99% that is not relevant, works out a status, displays a panel 
of Green, Amber, Red blobs with hyperlinks to detailed log info?
Details:
I am doing an architecture consulting gig for a client (a mostly MS Windows / 
Azure site, but there are some Unix servers out there as well).
They have about a dozen core applications that the business is highly dependent 
on and another 100 or so that they are less dependent on.
The problem being that when something goes wrong, vendor A says “the problem is 
with vendor B’s system” and you know what vendor B says.  What makes this worse 
is that the chain goes through multiple vendors and systems with long inter 
system data flows.
I want to make the recommendation to them that they implement logging and a top 
level log display dashboard for the systems they are highly dependent on.  The 
dashboard would show:

1.   Dataflow around the systems

2.   Work backlog at each sub system

3.   Status at each sub system

4.   Time since last ping at each sub system
This feels to me to be a standard sort of system that every major site needs!
I am not sure what to recommend???
Question: Can you recommend a standard dashboard app that takes multiple logs, 
filters out the 99% that is not relevant, works out a status, displays a panel 
of Green, Amber, Red blobs with hyperlinks to detailed log info?
I am thinking of Nicholas Blumhardt’s Seq application (https://getseq.net/) or 
Datadog (https://www.datadoghq.com/) but neither of these feel quite complete 
to me.
We will need a hierarchy solution:

1.   App logging (has to be baked into existing and new apps)

2.   Forwarded to Site Logger (maybe baked into the app, or as an add on)

3.   Site Logger

4.   Filter

5.   Analysis

6.   Dashboard display
At level 1 if logging needs to be added to an existing or new system, I am 
thinking that the recommendation will be to use Serilog 
(https://github.com/serilog) or Datadog (https://www.datadoghq.com/).
If the app already has logging, I am thinking that some form of log forwarder 
is needed, I want to avoid paying for apps to be modified to meet this need if 
they already have logging.
Levels 2-6 could be should be a standard off the shelf app.
Any advice would be greatly appreciated.
Best Regards
Greg Harris

Greg Harris
harris.gre...@gmail.com<mailto:harris.gre...@gmail.com>

RE: C# SqlConnection Nested Stored Proc Deadlock

[Greg Low]

Problem is that when the deadlock occurs and control is transferred to the
catch block, the transaction becomes a zombie (referred to as doomed). You
have to roll it back there. Once you do that, your transaction is gone.



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
*On Behalf Of *David Burstin
*Sent:* Thursday, 1 February 2018 1:23 PM
*To:* ozDotNet <ozdotnet@ozdotnet.com>
*Subject:* Re: C# SqlConnection Nested Stored Proc Deadlock



Thanks Preet and Greg. Unfortunately I am working with legacy code so can
only make minor changes.



I have some more questions :)



The article referenced in Preet's answer has a while loop to retry three
times. The transaction is wholly contained within that loop:



Structure without the noise:

WHILE

BEGIN

  BEGIN TRANSACTION

   Do some stuff that should be rolled back if transaction fails

  BEGIN TRY

Do something that causes deadlock

COMMIT

BREAK

  END TRY

  BEGIN CATCH

ROLLBACK

CONTINUE

  END CATCH;

END

Say that there is a deadlock on the first iteration => the transaction
rolls back (including [ Do some stuff that should be rolled back if
transaction fails] and also [ Do something that causes deadlock ] ), loop
continues, new transaction is started, all good





But, what if the loop is inside the transaction?



BEGIN TRANSACTION

Do some stuff that should be rolled back if transaction
fails

WHILE

BEGIN

  BEGIN TRY

Do something that causes deadlock

BREAK

  END TRY

  BEGIN CATCH

CONTINUE

  END CATCH;

END

COMMIT







>From what I understand, when the deadlock occurs and this sp is the victim,
the transaction rolls back as before. But now the loop continues, only
doing  [ Do something that causes deadlock ]. This time that bit of code
succeeds, but what happens when COMMIT is hit? The original transaction is
gone. I assume the effect of  [ Do something that causes
deadlock ]  remains. I'm not really clear about this.



And back in the real world, what if the transaction was started in C# code
on the connection, before calling:





Do some stuff that should be rolled back if transaction fails

WHILE

BEGIN

  BEGIN TRY

Do something that causes deadlock

BREAK

  END TRY

  BEGIN CATCH

CONTINUE

  END CATCH;

END



Now there is no transaction code at all in the SQL - the transaction is
supplied on the connection. The deadlock kills that transaction, but then
the SQL loops and tries again. Now there is no transaction? Or is there a
new implicit transaction on the connection? What happens when the commit is
attempted in the C# code?



I know this is a long question and appreciate any answers received.



Regards

David



On 1 February 2018 at 15:52, Greg Low <g...@greglow.com> wrote:

Sorry, error 3960, not 3760



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 <+61%20419%20201%20410>
mobile│ +61 3 8676 4913 <+61%203%208676%204913> fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* Greg Low [mailto:g...@greglow.com]
*Sent:* Thursday, 1 February 2018 12:40 PM
*To:* 'ozDotNet' <ozdotnet@ozdotnet.com>
*Subject:* RE: C# SqlConnection Nested Stored Proc Deadlock



Hi Dave,



Deadlocks are batch terminating errors and unwind your whole transaction
stack, unrelated to inner or outer, unless you add explicit try/catch logic
as Preet mentioned.



Generally, I prefer to catch them in client code rather than in T-SQL, as
there are other types of errors that should be retried at the client level
anyway.



Client code should cope with things like:



   - Deadlock (error 1205)
   - Snapshot concurrency violations (error 3760)
   - Server disconnection (can be due to network issues, failover of
   HA-based systems, etc.)
   - Various resource issues on the server



I often see client organisations who've spent a fortune on highly-available
systems and when they fail over, just like they're designed to do, all the
apps in the building break. That's not reasonable.



It's important to get into the habit of assuming that a transaction that
you need to apply to the DB **might** work, rather than assuming that it *
*will** work. Always apply it via logic like: while we haven't slipped the
transaction into the server, and while the retry time/count hasn't expired,
let's try to make it happen. If it doesn't, depending upon the error, we
migh

RE: C# SqlConnection Nested Stored Proc Deadlock

[Greg Low]

Sorry, error 3960, not 3760



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* Greg Low [mailto:g...@greglow.com]
*Sent:* Thursday, 1 February 2018 12:40 PM
*To:* 'ozDotNet' <ozdotnet@ozdotnet.com>
*Subject:* RE: C# SqlConnection Nested Stored Proc Deadlock



Hi Dave,



Deadlocks are batch terminating errors and unwind your whole transaction
stack, unrelated to inner or outer, unless you add explicit try/catch logic
as Preet mentioned.



Generally, I prefer to catch them in client code rather than in T-SQL, as
there are other types of errors that should be retried at the client level
anyway.



Client code should cope with things like:



   - Deadlock (error 1205)
   - Snapshot concurrency violations (error 3760)
   - Server disconnection (can be due to network issues, failover of
   HA-based systems, etc.)
   - Various resource issues on the server



I often see client organisations who've spent a fortune on highly-available
systems and when they fail over, just like they're designed to do, all the
apps in the building break. That's not reasonable.



It's important to get into the habit of assuming that a transaction that
you need to apply to the DB **might** work, rather than assuming that it *
*will** work. Always apply it via logic like: while we haven't slipped the
transaction into the server, and while the retry time/count hasn't expired,
let's try to make it happen. If it doesn't, depending upon the error, we
might back off for a while and try again. For things like deadlocks, it's
good to have some sort of exponential back-off with a random component.
Some errors are pointless to retry (ie: a primary key violation probably
isn't ever going to work)



Once you build it that way, things become much more robust and resilient.
The user should be unaware of this stuff, apart from a possible delay.



Regards,



Greg



Dr Greg Low



1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com |http://greglow.me



*From:* ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com
<ozdotnet-boun...@ozdotnet.com>] *On Behalf Of *Preet Sangha
*Sent:* Thursday, 1 February 2018 12:20 PM
*To:* ozDotNet <ozdotnet@ozdotnet.com>
*Subject:* Re: C# SqlConnection Nested Stored Proc Deadlock



Can you use a try catch in the outewr proc and get the error number such as
in this page?
https://technet.microsoft.com/en-us/library/aa175791(v=sql.80).aspx ( *SQL
Essentials: Using TRY/CATCH to Resolve Deadlocks in SQL Server 2005)*




regards,
Preet, in Auckland NZ





On 1 February 2018 at 14:42, David Burstin <david.burs...@gmail.com> wrote:

Hi folks,



Hope everyone is having a great day and enjoyed the super blue blood moon
last night.



Quick question:



Given a stored procedure "OuterProc" that calls another stored procedure
internally "InnerProc"

When I call "OuterProc" from C# using a connection with a started
transaction, and "InnerProc" becomes a deadlock victim

Is there a way that I can identify in my C# code that "InnerProc" was the
deadlock victim, given that my C# code only knows about "OuterProc"?



Cheers

Dave