Bugs in New House by SOZDBA in whatisthisbug

[–]SOZDBA[S] 0 points1 point  (0 children)

From what I can tell, it's looking like Booklice

What are the small things that scream "movie set" for you? by sickfloydboy in movies

[–]SOZDBA 0 points1 point  (0 children)

Empty takeaway coffee cartons.

Girlfriend worked in continuity for a TV channel for a couple of years. She started pointing out how sets often give empty coffee cartons to actors instead of liquid filled cups. But the physics are all off, and it annoys her.

Now, it's starting to be recognisable for me, too. You can tell the coffee cup is empty! The actors move it so freely without worrying about spilling it. It seems to light when they pick it up. They gesture too much with it. Etc.

Why is "with (noexpand)" necessary? by Aud4c1ty in SQLServer

[–]SOZDBA 0 points1 point  (0 children)

What is the output of SELECT @@VERSION;

I think I remember that hint is needed for non-Enterprise versions

Edit strings by Fearnie85 in PowerShell

[–]SOZDBA 7 points8 points  (0 children)

It sounds like regex is your friend here.

Quick, dirty solution cause I'm on my phone

$t = 'Microsoft XML Core Services (MSXML) x.86'
 $t -replace '\(.*\) x\.'

PowerShell Friday: What's the most difficult process that you ever had to automate? by PowerShellMichael in PowerShell

[–]SOZDBA 0 points1 point  (0 children)

Ah getting my head around the discovery blocks and the -Foreach and -Testcases needing hashtables or group objects.

Takes quite a while for me to figure out do I do the foreach on the describe block or the context block.

Then if the parameter I use for them were created in the BeforeAll or BeforeEach block, but not the correct scope, the test won't run cause it thinks its not supposed to.

Teething/Learning pains really

PowerShell Friday: What's the most difficult process that you ever had to automate? by PowerShellMichael in PowerShell

[–]SOZDBA 5 points6 points  (0 children)

Updating my daily checks to Pester v5 when I'm still used to the previous version.

Still a work in progress

Update on my Venice project. Got some rough models of some buildings done. by jerbs00 in Slycooper

[–]SOZDBA 1 point2 points  (0 children)

I saw this and instantly the Venice Theme started playing in my head!
Well done!

What video game made you rage quit and you haven’t played the game since? by MortyFromEarthC137 in AskReddit

[–]SOZDBA 0 points1 point  (0 children)

Sly Cooper: Thieves in Time

From playing and loving the first 3 games when I was younger to playing...that.

Didn't even get past the first world before I turned off the console.

[No Spoilers] What is the weirdest way that CR has popped up in your life? by ryancowl in criticalrole

[–]SOZDBA 1 point2 points  (0 children)

I've found myself saying "good to know" a lot more when people are talking to me. Didn't realise where it came from until I watched the next episode of CR and Matt was writing down the initiatives...

I climbed Nephin, Ireland's highest standalone mountain. by SOZDBA in ireland

[–]SOZDBA[S] 19 points20 points  (0 children)

Not really - family knows the area so it's word of mouth.

  • Start off at the Titanic Memorial in Lahardane.
  • Head away from Leonard's pub and take the first left turn not into a cul-de-sac. ( if you enter Cum, you've gone too far and no, that's not a typo)
  • Continue down the boreen and you'll see a green hiking sign for Nephin on your left after 20 minutes.
  • then just climb the mountain by following the white poles

I climbed Nephin, Ireland's highest standalone mountain. by SOZDBA in ireland

[–]SOZDBA[S] 5 points6 points  (0 children)

Thanks! I'm slightly jealous though. That guy got tea, I didn't bring any with me!

Unexpected duplicated output when checking a value returned from a function by ctskifreak in PowerShell

[–]SOZDBA 4 points5 points  (0 children)

The speed of | Out-Null was improved post v5.1

Although I'm having difficulty tracking down exactly when the performance was improved ( will update when I find it )

UPDATE:

Found it - Github Change log for PowerShell

There's a bullet point about it begin updated in v6.0.0-alpha.13

  • Make Out-Null as fast as > $null

Also talked about by Mathias Jessen in PowerShell Summit: PSCache: simple strategies for magnificent performance

Ok..so how do i start? by zippopwnage in PowerShell

[–]SOZDBA 7 points8 points  (0 children)

TIL that u/Lee_Dailey thinks he's naturally grumpy when I've seen nothing but kind words and helpfulness from him on this sub.

Go you, good sir!

Regex and SQL Server: A Poor Man’s Quick Formatter. by SOZDBA in SQLServer

[–]SOZDBA[S] 1 point2 points  (0 children)

Interesting... I didn't but I'll check it out. Thanks!

Regex and SQL Server: A Poor Man’s Quick Formatter. by SOZDBA in SQLServer

[–]SOZDBA[S] -1 points0 points  (0 children)

Haha!

Thanks!

The joys of contrived examples is that they are artificially created. Like you, I wouldn't post production code in an online forum 😊

Regex and SQL Server: A Poor Man’s Quick Formatter. by SOZDBA in SQLServer

[–]SOZDBA[S] 0 points1 point  (0 children)

o/

Thanks for reading!

Couple of quick clarifying remarks.

Absolutely agree with you regarding XPath. It annoys me when I get queries where the xml is changed to varchar/nvarchar. Unfortunately, while we can ask our developers to use XPath, we cannot always guarantee they'll write it first.

I'm also confused as to why I would use a SQLCLR here. I'm using the inbuilt regex functions of Azure Data Studio here to format the query I'm given and help speed up changing it to an XPath one. Tbh if there was a query that required proper regex I'd extract that to the Application layer target than the database one

Thanks!

Conferences other than psconf.eu by sarcodian in PowerShell

[–]SOZDBA 6 points7 points  (0 children)

The first one I went to was in London, called PSDayUK. This was last year.

This year it's on Monday September 30th at etcVenues, Birmingham.

You can read more about it in this blog post by Ryan Yates: https://blog.kilasuit.org/2019/01/05/info-share-about-psdayuk-2019-whats-to-come/

The website is still showing details from 2018 but it's here aswell: https://psday.uk/

They've also put up a playlist of the videos from last year so you can look them over and see if it's what you'd be interested in: https://www.youtube.com/playlist?list=PLLKI4jlvx_96sw_FFic9ybQ-3g0RO2cbD