There's no good way to size the log and tempdb for a database. The amount required isn't based on the data size, but rather the workload. How much activity can...

Try connecting with the dedicated administration connection (DAC). This has reserved resources if the server is too busy to respond to normal user requests.

If that's all that's in the trigger, I wouldn't expect a failure, but I always worry about lots of AND/ORs and something slipping through I didn't expect.

Do you...

In terms of things like termination date, I see both sides. I use NULL here, because the data is unknown. As for why it's unknown, as Roger points out is...

sorry. I really pushed on this, but what works well in Chrome/FF/Edge is broken in IE. Looking at some other editors (like for articles), they spend a massive time dealing...

On a related note with the AWS outage, this made me think of Jeff Moden (and this thread).

In the comments from : https://tech.slashdot.org/story/17/03/03/158209/amazon-outage-cost-sp-500-companies-150m
"Most IT "engineers"...

I went back and forth with Argenis Fernandez of Pure Storage. He was the one that said you want to try and calculate the rough amount  you write and compare...

First, you have to worry about all drives failing. Period. If you think you can get 6-7 years with 10 drives, you're gambling. You might, you might not.
Second, most...

What's the trigger code? I thought the trigger fire for all logins, just it's actions depended on the code inside.

I've had instances set like this in production. Often these were older (SQL 2000/2005) instances with little load.
Size to your workload. If this is the default new VM from...

direct from SSMS to IE 11.

IE has seriously broken clipboard  issues.  We started working on fixes, but they're substantial, and a project in and of themselves. We abandoned...