Strangely, during the first lockdown, when I (a DBA, mind) was furloughed (but not for long - they realised their mistake quickly enough) I went looking for things to do:...

Dev Ops here is being used for our infrastructure team: Development is still silo'd as development. Nothing else has changed, mind: Infrastructure just do infrastructure, so there's no cross over...

does a car do a full emergency stop for a pigeon ? potentially injuring  the people in car behind who were (at their own risk) travelling too closely. cars can't...

Scenario: Someone steps out in front of your car. It stops as it's programmed to. An Ambulance approaches from behind with sirens going. Your car is obstructing the way. The...

Strangely, I tried the code and it reported a syntax error... the only thing that didn't was the Convert statement, which didn't give the right time. A niggle, I know,...

I agree with Jeff:

I worked with Access way back when. I've used it as a database, as a front end to a SQL database, and as a quick development/modelling tool.

Put...

Specifically, this behaviour can indicate issues with parameter sniffing.

There are a number of approaches to address this if it is the case, so here's a handy link to understand more...

Powershell scripting could be the answer here.

You can use : <Variable> = Get-Service -Name <service name>

Then : <Variable>.Status

This will tell you if the service is running or not. You can...

Three laptops, four desktops, two tablets, plans to add some Raspberry Pi's and access to VM's as/when needed.

Just need the space to plug them all in and solar/wind power generation...

To simplify what you've said: You are performing a union on several large views and it's timing out.

This sound like SQL is paging out memory to disk so it can...

• This reply was modified 5 years, 6 months ago by  steve.powell 14027.

Just to clarify: You use a local admin user account to run SQL under and things work. You use a Domain account to run SQL under and it doesn't.

If I've...

One node connects but another doesn't? I note you're not limiting the firewall port to specific IP addresses/address ranges - better practice is to implement that, but it does eliminate...

Can you ping the target server at all?

It may be you need to set a firewall rule to allow the connection (firewall rules can open ports, but may limit them...

I've an AG with replication for this purpose, but I do wonder why you'd want a third node for it as you'd not get AG awareness.

Rather, look at using the...

Eric M Russell (10/16/2015)

---

As for the option of sticking around and "fixing" your current job, unless you're in a position of influence, I find that ideal outcome to...