Viewing 15 posts - 5,416 through 5,430 (of 39,749 total)
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
I'm going to throw something more into this. Recently our CIO informed...
May 2, 2018 at 12:23 pm
But from my experience and test on SQL2017... In the end of the...
May 2, 2018 at 12:17 pm
Viewing 15 posts - 5,416 through 5,430 (of 39,749 total)