SSMS all the way... we have Visual Studio and use that for source control (used to be TFS, now git) but I do all the work in SSMS and copy...

The transaction log records what happens in the database (the changes since a certain point - when the last full backup took place), whereas a full backup records the current...

I fell into this game as a youngster, but pretty quickly discovered that there's no reward, the extra hours rarely earn you pay, appreciation or even get noticed.

Recent years have...

I came up with a DB deployment strategy years ago when we were a 3-person team, and we still use it now that the team has grown to about 15...

165GB in 10 min 24 sec, which would mean just over an hour for 1TB (63 minutes).

DB files on SAN disk, SQL 2008 standard, Red Gate SQL Backup with level...

At the risk of outing myself as a pale imitation of a database professional, I work to live, not the other way around.

Apart from being on call (which now I've...

Thanks Gail,

I can see where I was getting confused, it all makes sense now.

I've not spent any time digging into deadlocks before, so thanks for your help. I'll do better...

xsevensinzx (9/12/2016)Can't you just do that in code documentation? I think that's the biggest hurdle for me on justification. In all my stored procs for example, you have a boilerplate...

A quick update:

By reducing the compression on those backups, I dropped the CPU spikes from 95%-ish down to 90% or less most of the time, and that has had the...

User connections is 0, but that wouldn't make any difference to the trigger operation - if the users were being rejected bit that would...

I had done much the same (the logic is a little different, but separating out the username test)... and removing the logging completely - the rejected logins get written to...

Thanks for the guidance Sergiy, I looked into what you suggested and implemented most of your ideas.

CREATE TRIGGER [<the trigger>]

ON ALL SERVER

WITH

EXECUTE...

It's still happening - clearly related to the 90%+ CPU on the server (not the instance, that isn't reporting CPU pressure, just the server).

Do you have any idea what mechanism...

Thanks for looking at this for me.

I guess connection is possible by other means, but for ordinary users, they would still pass the trigger, and the restricted user would be...

I would have thought a logic error would be a logic error all the time, not just for 4 minute bursts? That's why I am looking at outside factors.

This is...