I like your suggesting we experiment with the various tools, looking to see which will work for us in a given situation. I think there's a tendency to choose one...

My recommendation would be to try it out.  You are licensed for it; give it a shot.

Build up a proof of concept data migration and compare it to the...

Over the years as both a Database Developer and DBA, I've found SSIS to be a good tool.  As others have said, not necessarily the best tool, but it...

Security is important. I do what I can and know how to do, in order to improve security. But I'll admit that I'm no security expert. I've been fortunate enough...

I've gotten some great feedback here. Thank you, all who have responded. My conclusion is that even among DBAs, you're not all enamored with SSIS, for various reasons. Some do...

Good points here, Steve. Although I'm finding Stack Overflow (SO) to be less helpful. I've been on it for almost 10 years. The last 3 years I've been insulted and...

Using initials for column names and then having a document at your desk for reference - that is so retro '80s RPG/COBOL.

I too would recommend implementing the database using...

Eric, your comment made me realize I hadn't even thought of column naming conventions! WOW, how could I have forgotten that!! I'm fairly flexible, although I prefer to use Pascal...

I don't know what to think of this editorial. I do agree that reading others code can be taxing and hard to do. But heck, when I go back to...

Until I came to this job, all my other IT jobs were for small companies. Or at least small IT shops. So knowing where to find something was easy. In...

I completely agree with you 100%. I know that for my own part it's hard to receive criticism. And most of it is just me. Even when criticism is blameless,...

Thank you to all the volunteers!

I hope it doesn't switch to virtual.  There are enough virtual "classes" online.   Not only do you learn things at these events, you get...

I'm happy, but not really, that you say it's confusing. A couple weeks ago I was doing some "pre-retirement" searching using my phone's browser and within minutes I...

Gilbert and Jeffrey,

You can change the target folder for shared data sources and (presumably) shared datasets? Really? How?

Jeffrey, to answer your questions, for development I test it on my workstation....

I agree with you Grant, but only to a point. Both George and Jeffery have excellent points. Many years ago I worked in state government where samples were measured for...