Yeah absolutely, if you have some kind of drive failure, then you're screwed if you havent backed it up.

From my understanding Scott, the only way that would happen is if you dropped the certificate.. which I don't think you can even do if the database is still encrypted. ...

At my work we have a hybrid schedule, I work from home two days a week and the teams thing is something I do constantly try to keep on top...

I can't answer question 3 but for

#1.  Its not a big deal, it will warn you that your certificate is expired and you can update the certificate like this

            
March 16, 2020 at 5:34 pm
            
#3734811

            
            
                                                
        

I do have separate queries I use for things that are more memory related; I don't currently have anything built for monitoring networking though.  I plan to use the last...

The only comment I have offhand is that I'm not sure if trying to summarize an entire day would be very useful.

For the kinds of OS level things you're...

I've kind of settled on this... any thoughts?

DECLARE @ms_ticks bigint
SELECT @ms_ticks = ms_ticks
  FROM sys.dm_os_sys_info

  DECLARE @IdleTime FLOAT
  DECLARE @UserModeTime FLOAT
  DECLARE @KernalModeTime...

You can get SQL Server specific information from sys.dm_os_performance_counters, but that doesn't include general information like the CPU queue length.  I've found with some poking around you can get...

http://assets.red-gate.com/community/books/troubleshooting-sql-server-accidental-dba.pdf%5B/quote%5D

Legitimate question, this book was written for 2008 and 2008 R2, how much of the information in there is still relevant, even in the introduction to the...

Fair enough 🙂

Yeah, the "biztalk developer" here lasted less than two weeks. Any chance you could shoot me a message with the kind of questions you ask in an interview, I'm kind...

I've done a lot of interviewing recently for roughly mid-level DBAs, and the quality of the applicants has been so varied. 90% of them failed even the  most basic...

oogibah You have GOT to be kidding me.

Are you saying that you ran into a SQL dev that could not produce the current date/time let alone datepart?

#Scary

AND A DBA...

"if it's 1000 servers" -> No, it's only round about 300 servers.

"so script up a job and deploy it everywhere that sends you all the info you need...

Maybe you are right but I think there is also a cultural issue. A good default pose for a developer might be as a collaborator who wants data to be...