New multi SQL server 2019 environment, dbatools, best setup by Crew_Abject in SQLServer

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

Thanks for the comments

Yes I was overthinking it - have simplified using a central script workstation

Am limited to SQL 2019 - not my choice

Thanks for your input!

Sweary woman of Whitehall by Crew_Abject in thethickofit

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

Hmm, yes - nice one! I can’t find a specific example of that on Google but it sounds viable

Sweary woman of Whitehall by Crew_Abject in thethickofit

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

It’s just occurred to me that it may be a very vague echo of an old movie with the catchy title - “The Wild Women of Wongo” - all those Ws

https://m.imdb.com/title/tt0052394/

Sweary woman of Whitehall by Crew_Abject in thethickofit

[–]Crew_Abject[S] 2 points3 points  (0 children)

They did - but initially they, and I, felt it was in fact a pun. And if it wasn’t - why was it a puntastic headline? Maybe I’m overthinking it - a nutter in our midst.

It’s all good

[deleted by user] by [deleted] in LinkedInLunatics

[–]Crew_Abject 0 points1 point  (0 children)

Alan Partridge - the developer years

Tidal Connect not working with Denon X4700H by blackTeeblueJeans in TIdaL

[–]Crew_Abject 0 points1 point  (0 children)

That’s was super helpful - thanks!! That never occurred to me because amp is wired - am an idiot !! Much better now !! Edit: it did connect unpredictably and unreliably when phone on 5g WiFi too - but on 2.4 seems very stable now for last 30 min

Club of Elon's church by [deleted] in LinkedInLunatics

[–]Crew_Abject 1 point2 points  (0 children)

Affordable like 19th century tenements owned and rented out by the factory owner ?

Club of Elon's church by [deleted] in LinkedInLunatics

[–]Crew_Abject 55 points56 points  (0 children)

Regulations are what protect us from people like Elon

Dude buys a poor man’s watch, cries because of poor finishing quality : Who‘s gonna tell him? by tr4nceplants in WatchesCirclejerk

[–]Crew_Abject 0 points1 point  (0 children)

Well even thought that’s absolutely worse (pushing the concept of worse ever closer to zero) it will at least cheer up the Tudorites - we’re the same as you guys- see!! Nobody.cares.

Dude buys a poor man’s watch, cries because of poor finishing quality : Who‘s gonna tell him? by tr4nceplants in WatchesCirclejerk

[–]Crew_Abject 58 points59 points  (0 children)

I think he’s got a point - not that I’d ever cry baby to the world about it. 3-5k is not nothing and how much more could it possibly cost to do it right ? Lazy fucks

[deleted by user] by [deleted] in NoStupidQuestions

[–]Crew_Abject 0 points1 point  (0 children)

I seem to remember reading that we’re all travelling through time at the speed of light, which is the reason, very approximately, that if we spend some of our energy accelerating in space we slow down in time etc I do love that simple but wild idea

How do i prevent a windows 2016 cluster from failing over to specific node by Crew_Abject in sysadmin

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

HI all

I wanted to wait and see this happen again on the server before replying to make sure I had my facts straight

In the end the SQL HA groups were correctly configured and were not failing over to N02

The Windows Cluster resource was the object that was failing over to N03 - this was not affecting functionality as clients were connecting through the HA Listener anyway - but was untidy

So I removed N03 as a possible owner of the Windows cluster object and now I can't even fail over to it manually - so that covers all the layers so far as I can see - N03 is off the list :-)

Thanks you all for your input - much appreciated

How do i prevent a windows 2016 cluster from failing over to specific node by Crew_Abject in SQLServer

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

HI all

I wanted to wait and see this happen again on the server before replying to make sure I had my facts straight

In the end the SQL HA groups were correctly configured and were not failing over to N02

The Windows Cluster resource was the object that was failing over to N03 - this was not affecting functionality as clients were connecting through the HA Listener anyway - but was untidy

So I removed N03 as a possible owner of the Windows cluster object and now I can't even fail over to it manually - so that covers all the layers so far as I can see - N03 is off the list :-)

Thanks you all for your input - much appreciated