Viewing 15 posts - 406 through 420 (of 9,715 total)
I don't think he was talking about using linked servers to update the AG jobs, logins and whatnot. I think he was about to go off on a rant about...
May 13, 2019 at 2:59 pm
So I've changed my math to be just a DateDiff because, yay simple!
SELECT dt.Subdirectory, DATEDIFF(hh,GETDATE(),bus.backup_finish_date) AS HrsAged
INTO #PurgeBackups
FROM #DirTree dt
INNER JOIN LinkedSvr.msdb.dbo.backupmediafamily bmf
ON dt.Subdirectory = REPLACE(bmf.physical_device_name,@PurgeFolder,'')
INNER JOIN...
May 13, 2019 at 12:28 pm
So I attended the PASS High Availability webinar last week on "Your AG might not be as "available" as you think" and it was pretty interesting. But one odd thing...
May 13, 2019 at 11:58 am
Yeah. I had so many things going on when that got posted I must have missed it. I was scanning the code responses and missed a lot of the rest...
May 13, 2019 at 11:53 am
No problem with the hijacking.
FYI: My boss just figured out a way to pass PoSH parameters into a SQL job. So, it is a thing. Let me look into it...
May 13, 2019 at 11:36 am
IIRC, the file paths and the fact that they're "COPY ONLY" are stored in the MSDB database. I think it would be a simple, very quick, and very accurate...
May 13, 2019 at 11:33 am
Darn - didn't noticed that they were removing the ISE from version 6 - rather annoying as it will force many to install Visual Studio on a server...
May 13, 2019 at 10:08 am
Oh, and this:
https://kc.mcafee.com/corporate/index?page=content&id=KB91467
“With the Windows April 2019 updates, the Client Server Runtime Subsystem (CSRSS) operating system process CSRSS.EXE performs file I/O more frequently while fulfilling LoadLibrary requests from other processes....
May 10, 2019 at 2:11 pm
GAAAAHHHH.
So apparently those wonderful April updates affect McAfee as well as the others. We've been chasing issues for the past few weeks and it wasn't until we started looking at...
May 10, 2019 at 2:10 pm
Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query...
May 8, 2019 at 1:28 pm
Sorry I didn't have a chance to respond yesterday. It was very busy at work.
But yes, that's exactly my problem. What Sue said and what you posted.
May 8, 2019 at 12:25 pm
Yeah, I saw someone post about that one several months ago and I've been using it ever since.
Previously we'd been doing that in UltraEdit. It was nice to know I...
May 8, 2019 at 10:56 am
Wow. So apparently I learn something new every day with SQL Server. Yesterday, I accidentally learned that if you highlight a section of code in a SSMS query window and...
May 8, 2019 at 10:16 am
Thank you all for your responses. I'm choosing not to go with either of the additional solutions because I'm trying to cut down the code I have rather than add...
May 7, 2019 at 3:31 pm
Viewing 15 posts - 406 through 420 (of 9,715 total)