Viewing 15 posts - 5,401 through 5,415 (of 39,749 total)
There's no real "best". The way that different auditors or authorities might examine your architecture will vary.
TDE gives you encryption at rest, and lots of auditors like...
May 7, 2018 at 11:33 am
May 7, 2018 at 9:10 am
May 7, 2018 at 9:02 am
There is a file target. That's the point in the question. It asks about persisting data in the file target, not the ring buffer.
May 7, 2018 at 8:52 am
I'm not sure what the last few posts are meant to mean. If the question or answer wrong? The question asks about the data in the file target, not the...
May 7, 2018 at 8:25 am
All objects should be in the SMO model somewhere. Dig through the classes to add what you need:
https://msdn.microsoft.com/en-us/library/mt571730.aspx
May 5, 2018 at 12:30 pm
I'd agree with Sergiy here. We always used a generation process to produce a list here, so that changes, exceptions, etc. could be applied. We never used the original table...
May 5, 2018 at 12:29 pm
amitelman - Friday, May 4, 2018 2:24 PMCan I download scriptdatabase.ps1 file? I do not see link to it.
Added
May 4, 2018 at 2:56 pm
That article shows how. If you are getting errors, we can't see them. However, this is really a PoSh/AD issues. if you are having issues, get that working from the...
May 4, 2018 at 12:16 pm
A couple things to check:
Are the services running? Check the service applet for SQL Server. You ought to find a few services there. If you have both...
May 4, 2018 at 11:28 am
A couple links to help you. Updating pictures is likely through PoSh or C#
https://blogs.msdn.microsoft.com/rakhiguha/2015/09/27/active-directory-how-to-update-user-thumbnail-photo-using-service-account/
Creating accounts could be done like this:
https://social.technet.microsoft.com/wiki/contents/articles/1293.processing-active-directory-information-in-ssis.aspx
May 4, 2018 at 11:11 am
You'll have to look through these: http://www.sqlservercentral.com/search/?q=user+login+permissions&t=s&sort=relevance
May 4, 2018 at 10:12 am
Not sure. The jobs should have been built. I'd drop it and run through the steps again. Ensure you completed everything correctly.
May 4, 2018 at 10:10 am
Single drives are always worse, since you lose everything with a failure. However, in Azure, you should have multiple copies from the infrastructure. You won't get less I/O from multiple...
May 4, 2018 at 10:09 am
Viewing 15 posts - 5,401 through 5,415 (of 39,749 total)