Viewing 15 posts - 1 through 15 (of 124 total)
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...
January 8, 2021 at 6:23 pm
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.
January 7, 2021 at 10:49 pm
Job history is blank, and the "Last run" on SSRS is december 2nd
also when querying for next run date
January 7, 2021 at 10:42 pm
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...
December 23, 2020 at 10:07 pm
Yeah absolutely, if you have some kind of drive failure, then you're screwed if you havent backed it up.
March 16, 2020 at 8:47 pm
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. ...
March 16, 2020 at 7:13 pm
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...
March 16, 2020 at 5:50 pm
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
March 16, 2020 at 5:34 pm
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...
February 27, 2020 at 4:14 pm
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...
February 27, 2020 at 3:05 pm
I've kind of settled on this... any thoughts?
DECLARE @ms_ticks bigintSELECT @ms_ticks = ms_ticks FROM sys.dm_os_sys_info DECLARE @IdleTime FLOAT DECLARE @UserModeTime FLOAT DECLARE @KernalModeTime...
February 26, 2020 at 4:42 pm
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...
February 25, 2020 at 3:35 pm
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...
February 10, 2020 at 3:59 pm
Fair enough 🙂
February 4, 2020 at 9:41 pm
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...
February 4, 2020 at 7:05 pm