User Charlieface | chat.stackexchange.com

Charlieface

yst 23:20

@J.Mini I recall a while back reading an article on testing the failover setup for LINX (London Internet Exchange) which covers 16 data centres, they tested by literally flipping the main circuit breakers to see how long it took for failover, I think it was in the milliseconds.

Charlieface

yst 14:06

Perhaps if someone else complained we might get somewhere. Especially someone who has contacts in the MS team that handles these, which I don't.

Charlieface

yst 14:05

> I'm not sure what else you could possibly want, a full repro script has already been given, containing DDL and data.

Charlieface

yst 14:05

There, I responded

Charlieface

yst 13:50

@ErikReasonableRatesDarling Yeah not sure what more they want

Charlieface

yst 13:34

@PaulWhite But apparently they can't fix an egregious MERGE bug tracked for at least 7 years feedback.azure.com/d365community/idea/…

Charlieface

Thu 21:32

@J.Mini My grandma told me a loaf of bread used to cost six-pence, or 2.5 New Pence, back in the early 30's

Charlieface

Thu 21:28

@J.Mini Not hard nowadays, considering we don't produce any.

Charlieface

Thu 21:28

@J.Mini Dunno, I think it's overrated. Certainly if you go worldwide there are far nicer towns. Even in northern England, places like Durham, Harrogate, Barnard Castle and Appleby are probably nicer.

Charlieface

Thu 17:14

I would hesitate to even call it cheese at all

Charlieface

Thu 17:14

Good cheese != American over-processed plastic

Charlieface

Thu 16:55

In a relative manner of speaking. Bit like people in USA think they know what good cheese, wine, chocolate or whisky is, you judge based on what's in your market...

Charlieface

Thu 16:21

Yeah, nearly as good as Northumberland. It's got a good beach, but that's about it. I spent 2 weeks there one summer as a kid and was completely bored

Charlieface

Thu 16:18

Yeah been down there and not changed my opinion. Few trees they call it New Forest, some undulations they call it the Downs. Come up here I'll show you hills

Charlieface

Thu 16:17

Sutton?

Charlieface

Thu 13:37

South England is a dump. They see a field they call it a National Park

Charlieface

Thu 13:36

Northumberland Coast is absolutely gorgeous, cliffs almost the whole way

Charlieface

Thu 13:33

Ellington Colliery

Ellington Colliery (also known as The Big E), was a coal mine situated to the south of the village of Ellington in Northumberland, England. The colliery was the last deep coal mine in the north east of England (also known as the Great Northern Coalfield). At one time, the deepest part of the mine was 800 metres (2,600 ft) and it extended 15 miles (24 km) under the North Sea. During the 1980s, the pit (along with Lynemouth Colliery) was known as the biggest undersea mine in the world and produced 69% of the mined coal in Northumberland. Ellington had several faces for mining and was known for winning...

Charlieface

Thu 13:33

The last mine in that area was closed in 2005

Charlieface

Thu 13:32

So many of these things got invented in England: steam engines, railways, "shotcrete", tunnel boring machines.

Charlieface

Thu 13:31

Or maybe it's not strong, or it's expensive, dunno, I just work in IT

Charlieface

Thu 13:30

Cement is very stiff and doesn't flow well, even standard concrete is no good.

Charlieface

Thu 13:30

Some kind of runny concrete according to the builder who did the houses. It flows into the crevices and expands and sets

Charlieface

Thu 13:29

And a shaft opened up in the middle of one of the more major residential streets, took them a few weeks and hundreds of trucks to grout the whole thing up.

Charlieface

Thu 13:28

There was a whole strip of houses near me that had to be pulled down and rebuilt because of a mine underneath, the houses sunk about two feet before that.

Charlieface

Thu 13:27

Apparently there are some areas with seams near the surface, but pretty sure most mines are quite deep. Plus they'd been mining for centuries, it was one of the first areas in the world to be mined for coal.

Charlieface

Thu 13:17

Powershell might actually be a good suggestion. Pass the whole script via Invoke-DbaQuery and pass the password in via -SqlParameter. Presto, no password in the script.

Charlieface

Thu 13:16

@Zikato But why? Why isn't it being passed all the way through as a parameter?

Charlieface

Thu 11:51

@Zikato sp_addlinkedsrvlogin is parameterizable, why do you need the raw password in the batch in the first place?

Charlieface

Jul 24 00:35

@HannahVernon Interesting, would that be the classic electric stove (metal plate) or halogen on glass? Gas works better in the UK because of the ridiculous way the "green" taxes are applied only to electricity. At one point it was cheaper to run your own gas electricity generator.

Charlieface

Jul 24 00:33

@SeanGallardy Growing up in NE England basically means nearly every house had some kind of coal mine underneath it. But I never saw coal seams on the surface.

Charlieface

Jul 23 16:55

Coal was long gone, although some of the back alleys where I grew up still had bricked-up coal slots in the walls.

Charlieface

Jul 23 16:55

@SeanGallardy Which decade was that? I'm a 90s boy

Charlieface

Jul 23 16:11

💩

Charlieface

Jul 23 16:00

It's probably about the same proportions as have gas, heat-pump and oil boilers respectively.

Charlieface

Jul 23 16:00

@SeanGallardy Vast majority have gas stoves, although induction and gas on glass are starting to become more common. Rural or really old places that never bothered to get gas laid on at all sometimes have old fashioned electric.

Charlieface

Jul 23 15:29

@SeanGallardy How common are natural gas stoves in your part of the world?

Charlieface

Jul 23 15:03

That's about 14 minutes too long

Charlieface

Jul 23 15:03

got better things to do than corrupt my system for Database Administrators research purposes...

Charlieface

Jul 23 15:00

Was just wondering what exactly it would check if you use PHYSICAL_ONLY

Charlieface

Jul 23 14:59

@PeterVandivier meaning it's not transactional anyway? I suppose so, it's not like it does file hashing or something

Charlieface

Jul 23 14:51

I guess it just checks the file exists.

Charlieface

Jul 23 14:51

> Validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM.

Charlieface

Jul 23 14:51

@HannahVernon Docs say:

Charlieface

Jul 23 14:23

Does anyone know if CHECKDB PHYSICAL_ONLY does any checks on FILESTREAM data?

Charlieface

Jul 23 13:18

Corkonians will not be impressed by your clearly genocidal tendencies. What's wrong with County Cork?

Charlieface

Jul 23 12:26

Was just being more precise about the statement, no need to attack

Charlieface

Jul 23 12:25

And SQL Server accepts binary/varbinary for a number of string functions

Charlieface

Jul 23 12:24

See also x86 instructions felixcloutier.com/x86/rep:repe:repz:repne:repnz where "string" is a byte string

Charlieface

Jul 23 12:22

405

Q: What is the difference between a string and a byte string?

I am working with a library which returns a "byte string" (bytes) and I need to convert this to a string. Is there actually a difference between those two things? How are they related, and how can I do the conversion?

Charlieface

The Heap™ – Consultancy ©®