Viewing 15 posts - 406 through 420 (of 9,725 total)
I have a quickie informational question over here (https://www.sqlservercentral.com/forums/topic/question-on-encrypted-database-keys-passwords) if y'all could pop in and let me know Yes or No on the issue.
May 15, 2019 at 12:49 pm
Well I just updated my Windows 10 laptop (which has Pro on it) to the latest, so I'll test it there and on my work PC.
You said you had Windows...
May 15, 2019 at 10:11 am
ARGH. The issue is back. I rebooted my PC first thing this morning, logged into the site and am seeing that right edge cutoff without any horizontal scroll bar to...
May 15, 2019 at 10:09 am
I would love to, but as a U.S. citizen, I'm not sure my feedback would be accepted.
May 14, 2019 at 5:55 pm
Andrey, regarding your second point... this isn't really a restore solution. The backups are getting stored on a non-prod NAS for redundancy DR. Long story short, we needed a workaround...
May 14, 2019 at 9:55 am
OUCH!
I see the need for synonyms in that case. And you have my intense sympathies for your situation.
May 13, 2019 at 4:49 pm
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...
May 13, 2019 at 4:27 pm
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...
May 13, 2019 at 4:09 pm
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...
May 13, 2019 at 4:04 pm
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...
May 13, 2019 at 3:09 pm
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
Viewing 15 posts - 406 through 420 (of 9,725 total)