So I haven't played with taking this to T-SQL yet, but my boss set up variables in a C# SSIS script task, using System.Management.Automation.Runspaces and adding the reference to the...

RE: Synonyms and 3 / 4 part naming conventions, is this just a preference or are you noticing performance issues?

And in the end, why does it matter? If the linked...

Resolution is 1920 x 1080. The scale is set to change the size of text, apps and other items to 125%. The browser is maximized.

But, I think this might be...

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

• This reply was modified 6 years, 10 months ago by Brandie Tarvin.

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

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

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

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

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

• This reply was modified 6 years, 10 months ago by Brandie Tarvin.
• This reply was modified 6 years, 10 months ago by Brandie Tarvin. Reason: adding info

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

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

• This reply was modified 6 years, 10 months ago by Brandie Tarvin.

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

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

Danke!

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