Yeah, the schedule was generated by reporting services when I created the subscriptions, I've decided to just delete these and instead create a schedule that runs every 3 months on...

• This reply was modified 2 weeks ago by  oogibah.

Sorry Jeff, I did a sneak edit above... rundate/time doesnt make any sense either.   Job is enabled schedules are enabled.  None of this makes any sense.

• This reply was modified 2 weeks, 1 day ago by  oogibah.
• This reply was modified 2 weeks, 1 day ago by  oogibah.

Job history is blank, and the "Last run" on SSRS is december 2nd

also when querying for next run date

name                       ...

• This reply was modified 2 weeks, 1 day ago by  oogibah.

Good Evening,

I've run into this in the past and there is a couple things you can try.  First check to make sure there isnt any corruption in the database by...

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...