Viewing 15 posts - 5,536 through 5,550 (of 39,870 total)
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
May 4, 2018 at 10:06 am
I'm not quite clear what you mean. Are you saying that you have image files and some name/login associated with them. You want to use SSIS to import these thumbnail...
May 4, 2018 at 10:02 am
One thing to keep in mind is that this changes data inline, so copy your db (restore in dev), then mask.
The tool is a little non-intuitive. I'm working...
May 4, 2018 at 9:59 am
Make sure you click the use RegEx, the little square + asterisk button.
May 4, 2018 at 9:48 am
I would lean towards putting the PK and the email in the #NoEMail list. Then I'd put a token in the main list, as mentioned previously, because someone or a...
May 4, 2018 at 9:44 am
Here's a post on dates: https://voiceofthedba.com/2018/05/04/moving-birthdays-with-data-masker/
May 4, 2018 at 9:41 am
The master database contains server level objects like logins, linked servers, certificates, a few other things. There isn't a need to restore this if you don't necessarily need those items....
May 4, 2018 at 9:39 am
Work to live, don't live to work.
Definitely need time off, away from work things. Most of our tasks don't need to be done ASAWeSeeThem
May 4, 2018 at 9:13 am
May 4, 2018 at 9:12 am
I'll say this. Tracking changes in db development has worked very well for me. There can be collisions, but in small teams, we can usually work things out. However, I...
May 3, 2018 at 9:40 pm
There is definitely a lot more to this. Lots of the specifics for using scripting requires cultural/communication changes as well as thinking forward to how you will deploy changes.
May 3, 2018 at 9:53 am
It depends. If they edit the same object, it's just as things are in SSMS, the latest item is scripted out. If they edit different objects, when you script things,...
May 3, 2018 at 7:58 am
Viewing 15 posts - 5,536 through 5,550 (of 39,870 total)